Courses

 

CIS 104 (1 credit) 


MS PowerPoint and Publisher Bootcamp

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.

CIS 105 (1 credit)


MS Excel Bootcamp

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.

CIS 106 (1 credit
)

MS Word 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.

CIS 107 (1 credit) 


MS Access 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.

CIS 114 (3 credits) 


Microcomputer Applications: Word Processing, Spreadsheeting and Database


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.

CIS 115 (3 credits)


Technology for the Workplace


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.

CIS 151 (3 credits
)

Intro to Computer Info Systems I
 (Paired with CIS 152)

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.

CIS 152 (3 credits) 


Intro to Programming I

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.

CIS 202 (3 credits) 


Projects in Computer Applications

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.

CIS 205 (3 credits) 


Scripting Languages

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.

CIS 225 (3 credits) 


C++ Programming


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.

CIS 226 (3 credits) 


Programming II

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.

CIS 235 (3 credits
)

Networking and Communications

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.

CIS 240 (3 credits) 


Computer Organization


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.

CIS 302 (3 credits) 


Advanced Projects in Computer Applications

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.

CIS 311 (3 credits)


Principles of Management Information Systems


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.

CIS 314 (3 credits) 


FORTRAN


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.

CIS 315 (3 credits) 


E-Commerce

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.

CIS 322 (3 credits) 


COBOL


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.

CIS 324 (3 credits) 


Advanced COBOL 


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.

CIS 328 (3 credits) 


Programming for Rapid Application Development


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.

CIS 330 (3 credits) 


Operating Systems


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.

CIS 332 (3 credits)


Multimedia Design and Editing

Examines the processes and theories involved in planning, designing, creating and copy-editing multimedia projects. Topics include design and layout principles for a variety of print and electronic publications, image and text manipulations, and editing for consistency and clarity. Cross-listed with COM 332.

CIS 334 (3 credits)


Java


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.

CIS 338 (3 credits)


Advanced Rapid Application Development


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.

CIS 351 (3 credits) 


Advanced C# and Data Structures II


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.

CIS 362 (3 credits) 


New Media


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.

CIS 405 (3 credits) 


New Technologies Research Seminar

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.

CIS 410 (3 credits) 


Systems Analysis and Project Management

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.

CIS 420 (3 credits) 


Database Management Systems


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.

CIS 481 (3 credits)


Internship


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.