COMPUTER & INFORMATION STUDIES

See also Digital Media Minor

C

D

MS PowerPoint and Beyond: Ways to Present

Part of the Alvernia Basic Training Series. Hands-on experience in MS

PowerPoint, GoogleDocs, and other cloud-based presentation packages. Lessons in PowerPoint and the other packages will include themes; tables and graphs;

transitions and animations; printing notes, handouts and slides; customizing presentations; embedding and linking files; saving, managing and delivering presentations; collaboration on a presentation; presenting at a distance.

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.

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.

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 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 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 226 3 credits Programming II

Continued development of programming skills. Emphasis on object-oriented concepts; introduction of data structures and logic development. Topics include classes and abstract data types; arrays, searching and sorting, strings, data storage options, memory allocation and management; and operator overloading.

Programming assignments feature increasing size and complexity. Prerequisites:

CIS 152 or permission of instructor.

CIS 235 3 credits

Networking and Communications

Examines communications: data representation, media, equipment,

transmissions and protocols. Topics include the open systems interconnection model, local area networks, wide area networks, distributed networks, and the Internet. Prerequisites CIS 115 or 3 CIS boot camps from CIS 104, 105, 106, and 107.

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 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 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, third-party 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 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 multi-programmed and time-shared computer systems. Sequential, interacting, 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 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 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 three CIS classes 200-level or higher and junior or senior status.

CIS 410 4 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.