Part of the Alvernia Basic Training Series. Hands-on experience in Microsoft PowerPoint and Publisher. PowerPoint lessons will include using themes; tables and graphics; transitions and animations; printing notes, handouts and slides; customizing presentations, embedding and linking files; saving, managing and delivering presentations. Publisher lessons will include using templates; text boxes and frames; creating and customizing templates.
Part of the Alvernia Basic Training Series. Hands-on experience in Microsoft Excel including data manipulation, formulas, filters, formatting and conditional formatting, charting, use of ranges and multiple spreadsheets, and pivot tables. Cannot get credit for both CIS 115 and Excel Bootcamp.
Part of the Alvernia Basic Training Series. Hands-on experience in Microsoft Word including APA and MLA document formatting, page formatting, tabs, columns, mail merge, footnotes, endnotes, comments, and document sharing. Cannot get credit for both CIS 115 and Word Bootcamp.
Part of the Alvernia Basic Training Series. Hands-on experience in Microsoft Access including database design and organization, tables, compound and foreign keys, queries, forms and reports.
Study value of microcomputer as a tool in business, school and home through projects involving use of currently popular word processing, database, and spreadsheet packages. Students may audit course only with instructor’s permission.
Essential workplace computer knowledge and skills. Provides requisite fundamental knowledge expected for most professional disciplines. Topics include computer system components, peripherals, media formats, communications and networks, computer security, office productivity software, specialized software, hardware, societal implications, and finer points of using the Internet. Prerequisite: Basic familiarity with word processing, spreadsheets and presentations.
Constitutes the first year of the required sequence in CIS. First semester is heavily concept-oriented. Topics discussed: input and output hardware; secondary storage; memory; parts and functions of the CPU; systems development life cycle; intro to programming logic; steps from source to executable code; the relationship between the program and the operating system.
Primarily logic development and structured programming, although concepts of systems analysis and design are reviewed. Programming features standard input and output, data types, declarations, and functions (including pass by value and pass by reference), as well as introduction to object orientation and the .NET framework. Importance of planning and documentation is stressed.
This is a hands-on-course, which introduces the student to concepts in microcomputer hardware, operating systems, application software through business examples, and the Internet.
Developing proficiency in general purpose scripting languages. Scripting languages form the basis for a variety of computer applications, from hardware and software configuration, to rendering images and graphics on web pages.The student will become familiar with a variety of terminal emulators and examine assorted shells, security issues, editors, mechanisms for handling user input, and structured commands along with basic scripting methods. Differences in standalone, networked and web-based computers will be discussed. Specific scripting software will be selected from languages commonly used in business applications. Pre-requisites: CIS 152 or permission of the instructor.
Topics include data types; standard I/O; public, private and hidden declarations; functions; the interface between C and the operating system; and systems-level coding. Prerequisite: one previous programming language; CIS 240 and CIS 351 recommended.
Examines communications: data representation, media, equipment, transmissions and protocols. Topics include the OSI model, LANs WANs distributed networks, and the Internet. Prerequisites CIS 151 or permission of CIS faculty.
Basic digital circuits, data representation and transfer, processor organization, digital arithmetic, assembly language programming, interplay of hardware, software, and firmware. Prerequisite: one previous programming course.
This is a hands-on course, which assumes prior experience in microcomputer concepts through CIS 202 Projects in Computer Applications or its equivalent. This course is designed primarily for the student majoring in Business Information Systems Secondary Education. As such, it emphasizes advanced techniques in business applications as well as exposure to web and multimedia applications and the use of new classroom technologies.
Examines the hardware and software components of information systems and the strategic uses of information. Topics include DSS (decision support systems), Executive Information Systems, AI (artificial intelligence), Expert System, and information ethics. The focus is on the Internet as an information tool and on E-Commerce. Prerequisites: BUS 101; BUS 206 and evidence of computer information literacy.
Designed for those upper-level students focusing on programming problems in the sciences and mathematics. This course concentrates on mathematical algorithms, in addition to discussing I/O techniques, sort algorithms, functions, subroutines, table handling, and advanced data structures. Course is project-oriented, ending in a major project of the student’s design. Prerequisite: One previous programming course. Recommended: CIS 152 and CIS 226.
The study of how business is conducted over the Internet. Hands-on simulation of a commercial website over which products are bought, sold, and supported. Topics include good design of an e-commerce site, database connection, thirdparty payment, and customer support. Other topics include commercial use of social networking, site security and viral marketing. Pre-requisites: One programming or scripting language, CIS 235. BUS/CIS 311 is recommended.
Designed for upper-level students concentrating in the business field, this course features the still-dominant business programming language. Topics include the mainframe programming environment, structured programming, COBOL program structure, documentation, report formatting, sequential file processing, batch vs. online processing, file updating, and array processing. Prerequisite: one programming language. Recommended: CIS 152 and CIS 226.
Continues CIS 322. Include random access file handling, internal sorts, interactive programming; COBOL as host language for database management systems, external subroutines, and object-oriented programming. Prerequisite: CIS 322.
Introduces the upper-level student to object-oriented application development using graphical user interface. Topics include: events and triggers; design-time and run-time changes to properties; functions and function calls; conditions and selection control; loops; built-in and user-defined data types; access to files and databases; and graphics. Course can be taken multiple times for different topics. Prerequisites: at least one programming language or permission of instructor.
Basic principles of operating systems. Structure and implementation of multiprogrammed and time-shared computer systems. Sequential, interac-ting, and shared processes. Memory management, synchronization, protection, virtual memory, input-output, buffering, interrupt processing. Prerequisite: CIS 240.
Examines the Virtual Machine concept and the use of the Java programming language to develop portable applications for web, server, and the PC-based applications, Projects use Java applications and Java stored procedures to communicate with server or host-based relational database management systems. Prerequisites: at least one programming language course.
Students explore advanced programming concepts for RAD: graphics and animation, 3D simulation, DDE (dynamic data exchange), OLE (object linking and embedding), ActiveX controls, and accessing a relational database, including SQL and Data Access Objects. Prerequisite: CIS 328 or permission of the CIS faculty.
Topics include strings and arrays, dynamic arrays, dynamic vs. static reference types, polymorphism, inheritance, private and public classes, lists, trees, binary trees, bonary search tress, and multilinked structures. Programs featuring these structures and algorithms are written in C#. Prerequisite: CIS 226 or permission of the instructor. Recommended: CIS 240.
This course provides understanding and application of current interactive multimedia, exploring the use and integration of visual, textual, and aural components of digital environments. The challenges of writing for nonlinear and interactive texts are explored through online exercises, electronic presentations and publications, and web design. Cross-listed with COM 362. Prerequisite: permission of instructor.
Through journal readings, speakers, site visits, webinars and significant research, students will learn about, analyze, and present current and leading edge
technologies related to Information Technology. Pre-requisites: at least 3 CIS classes 200-level or higher and junior or senior status.
Advanced study of structured systems development. Emphasis on strategies and techniques of structured analysis and structured design for producing logical systems specifications and deriving physical system designs. This course includes a project management dimension as a fourth credit that will complement and reinforce analysis and design strategy. Pre-requisite: at least one programming course or Bus 311/CIS 311.
Architecture of a database system; physical and logical data organization; relational, network and hierarchical data model; query languages and optimization; integrity, security and concurrency. Prerequisite: CIS 351 or permission of instructor.
By special arrangement, a student may be granted up to 12 credits for an extended assignment involving in-depth work in some phase of computer science. Such assignments might include an apprenticeship for an information technology firm, or work as a team member engaged in an information technology project for a local business. Prerequisite: 2.5 GPA or permission of department chair.