Accessibility and the PCC web site.
Pasadena City College
Classes/Academics | Apply & Register | Student Services | Library | Athletics | About PCC | Community | Alumni | Staff Services
Pasadena City College logo Photo Montage of Computer Information Systems
Computer Information Systems  

CIS Course Information

COMPUTER INFORMATION SYSTEMS

(Business and Computer Technology Division)

CIS  1   INTRODUCTION TO COMPUTERS

3 units

Use of integrated software: word processing, spreadsheets and databases. Computer hardware and software, data representation and programming languages. The computer as a problem-solving tool: algorithms, flowcharts and documentation. History of the computer, social issues and future trends. No credit if taken after CIS 10. Total of 54 hours lecture.

Transfer Credit: CSU; UC credit limitations. See counselor.

CIS  2   INTRODUCTION TO INFO SYSTEMS AND PROGRAMMING

5 units

The history of computing, basic computer operation, the notion of an algorithm, and programming constructs such as variables, expressions, input/output, branches, loops, functions, parameters, arrays, and strings.  Basic manipulation of data via scripting languages or high-level programming languages.  Alternative entry for CIS majors who have had previous computer courses in high school.  No credit if taken after CIS 10, CS 1, or CS 2.  Total of 72 hours lecture and 54 hours laboratory.

Transfer Credit: CSU; UC credit limitations. See counselor.

CIS  10   INTRODUCTION TO INFORMATION SYSTEMS

5 units

Foundation course for business/computer information systems majors. Information and computer literacy concepts that include: hardware and components, system and application software, programming principles, applications of information technology and ethics. Exposure to word processing, presentation, and database software. Use of spreadsheets. Information systems development. Usage of the Internet, especially as a research tool. Total of 90 hours lecture.

Transfer Credit: CSU: UC credit limitations. See counselor.

CIS  11   OPERATING SYSTEMS THEORY AND PRACTICE

3 units

Prerequisite: CIS 10.

Operating systems such as Windows XP, Linux, UNIX; memory management; concurrent processing and multi-programming; backup and recovery; data and physical security; software installation; ethics. Total of 90 hours lecture.

Transfer Credit: CSU

CIS  14   C++ PROGRAMMING

3 units

Prerequisite: CS 2; or CIS 10 and one of the following: CS 10, CS 12,  CS 43, CIS 36, CIS 64, CIS 66, CIS 134.

Foundations of C and C++. Operators, functions, arrays, pointers, structures, unions, classes, C++ data types, polymorphism, inheritance, encapsulation, virtual functions, templates, file processing, control structures, and an emphasis on object oriented program design. Total of 54 hours lecture and 36 hours laboratory.

Transfer Credit: CSU; UC

CIS  16   JAVA PROGRAMMING

3 units

Prerequisite: CS 2; or CIS 10 and one of the following: CS 10, CS 12, CS 43, CIS 14, CIS 34, CIS 36, CIS 64, CIS 66.

Foundations of the Java language: Classes, methods, operators, encapsulation, polymorphism, inheritance, dynamic binding, file processing, control structures, function overloading, use of AWT, creation and use of applets in Internet applications, and an emphasis on object oriented program design. Total of 54 hours lecture and 36 hours laboratory.

Transfer Credit: CSU; UC

CIS  20   INDEPENDENT STUDY

1 unit

Prerequisites: Minimum grades of C in 12 units of computer science or  computer information systems courses.

Individual projects; problem formulation, design, documenting, programming and testing. Maximum credit 3 units, 1 unit each semester. Total of 54 hours laboratory.

Transfer Credit: CSU; UC credit limitations. See counselor.

CIS  22   INTRODUCTION TO THE INTERNET

3 units

Prerequisite: CIS 10.

General overview of computer systems, networking, and the Internet. World Wide Web, email, telnet, ftp, newsgroups, finding information on the Internet, and basic Web page creation. Legal, ethical, privacy and security issues on the Internet. Total of 90 hours lecture.

Transfer Credit: CSU

CIS  30   NETWORKS AND COMMUNICATIONS

3 units

Prerequisite: CIS 10.

Introduction to network applications; fundamental communication concepts; data communication hardware; protocols and software; microcomputers and communications; network configurations, management and security. Total of 90 hours lecture.

Transfer Credit: CSU

CIS  31   DATABASE SYSTEMS

3 units

Prerequisite: Enrollment in or completion of CIS 10.

Concepts of a database management system with emphasis on the relational model. Data independence, data security, data integrity, access control, database architecture, database sublanguages, data dictionary; future technology and trends. Total of 54 hours lecture.

Transfer Credit: CSU

CIS  36   INTRODUCTION TO VISUAL BASIC

3 units

Prerequisite:  CIS 10.

An introduction to programming using Visual Basic.  Coverage will include: programming design tools, use of variables and constants, selection, looping, data validation, sub and function procedures, manipulating strings, and creating and accessing arrays. Also presented will be guidelines for application and user interface design and data file manipulation. Total of 54 hours lecture and 36 hours laboratory. 

Transfer Credit: CSU; UC

CIS  38   Advanced Visual Basic

3 units

Prerequisite: One of the following: CIS 14, CIS 36, CIS 64, CIS 66, CS 2, CS 10, CS 12, CS 43.

Applications of advanced techniques in the use of VISUAL BASIC, such as user-friendly menus, internal program documentation and program structure.  Subroutines, file manipulation, special functions, problem solving and graphics. Total of 54 hours lecture.

Transfer Credit: CSU; UC

CIS  40   UNIX ADMINISTRATION

3 units

Prerequisite: CIS 11.

Understanding the UNIX operating system.  Coverage of common installation and configuration issues in networking environments. Coverage of the UNIX architecture including the use of utilities, file handling, text editors, job control, and printing. Coverage of Telnet, FTP, Gopher, and other UNIX tools. Prepares students for Industry-level certification. Total of 54 hours lecture and 36 hours laboratory.

Transfer Credit: CSU

CIS  50   SURVEY OF E-COMMERCE/E-BUSINESS TECHNOLOGY

3 units

Prerequisite: CIS 10.

Fundamentals of E-commerce technologies which will build student skills and knowledge in developing, designing and managing a business on the internet. Topics include, but are not limited to, current technical issues, such as internet, intranet, extranet, tools, and technology; and business issues such as the application of business concepts, current practice, and strategic opportunities that surround the emergence of E-Commerce. Students will develop an understanding of technology infrastructure that enables e-commerce and the impact to e-commerce on business and the economy. Total of 90 hours lecture.

Transfer Credit: CSU

CIS  55   Introduction to E-Business Practices

3 units

Prerequisite: CIS 10.

Plan, design, build, tune, troubleshoot, secure, and manage a fully operational e-commerce site; client-server configuration, website evaluation strategies, electronic data interchange, revenue models, encryption, and security. Total of 90 hours lecture.

Transfer Credit: CSU

CIS  60   E-Commerce Fundamentals

3 units

Prerequisite: CIS 10.

Basic rules of business, law, and marketing will be expanded, contracted, and applied for E-commerce, as well as an investigation of rules created specifically for internet business. Total of 90 hours lecture.

Transfer Credit: CSU

CIS  62   INTRODUCTION TO SYSTEMS ANALYSIS

3 units

Case studies of solutions to a variety of realistic problem situations; identifying and applying constraints to determine feasibility; applying criteria to select the best solution from alternatives. Total of 54 hours lecture.

Transfer Credit: CSU

CIS  64   STRUCTURED PROGRAMMING I WITH COBOL

4 units

Prerequisite: CIS 10.

Principles of problem solving using structured techniques. Top-down design of problem solutions using structure charts, flowcharts, pseudocode and other forms of documentation. Typical business applications implemented using COBOL. Total of 90 hours lecture.

Transfer Credit: CSU

CIS  66   ASSEMBLY LANGUAGE PROGRAMMING

3 units

Prerequisites: CS 2 or CIS 10; and one of the following: CS 10, CS 12, CS 43, CIS 36, CIS 64, CIS 134.

Computer organization and data structures; machine instruction sets; macros; subroutines; input/output control system; binary, octal and hexidecimal numbers systems; 8088 assembly mnemonics. Total of 90 hours lecture.

Transfer Credit: CSU; UC

CIS  70   STRUCTURED PROGRAMMING II WITH COBOL

4 units

Prerequisite: CIS 64.

Advanced structured techniques of applications program design using multi-level control breaks, multi-dimensional tables, sort, search, library, subprogram linkage files, merging and updating of files. Typical business applications. Total of 90 hours lecture.

Transfer Credit: CSU

CIS  74   INTRODUCTION TO OBJECT ORIENTED SYSTEMS ANALYSIS AND DESIGN

3 units

Prerequisite: CIS 16.

Introduction to object-oriented systems analysis and design using an object-oriented case tool. Determination of user system requirements. User/computer interface design. Class hierarchies, structures, and collaborations of objects. Class and interaction diagrams. Four lectures/

problem-solving. Total of 90 hours lecture.

Transfer Credit:  CSU

CIS  80   MICROCOMPUTER APPLICATIONS

3 units

IC3 Certification training and preparation. Includes an overview of computers as well as introduction to Microsoft Word, Excel, PowerPoint, Access, Internet and E-mail. Total of 54 hours lecture.

Transfer Credit: CSU

CIS  81   ADVANCED MICROCOMPUTER APPLICATIONS

3 units

Prerequisite: CIS 10 or CIS 80.

The study and analysis of integrated software, multi-function software and advantages in using one of these over a single application program. Experience with two database application programs and how to create user-friendly software programs with menus, prompts and screens. Total of 54 hours lecture.

Transfer Credit: CSU

CIS  114   MICROCOMPUTER HARDWARE/ SOFTWARE EVALUATION

3 units

Prerequisite: CIS 111.

Performance evaluation of computer systems based on both hardware and software measurements. Total of 36 hours lecture and 54 hours laboratory.

CIS  115   MICROCOMPUTER FIELD PRACTICE

2 units

Prerequisites: CIS 30 and maintain enrollment of 7 units or more, including field practice.

Work in industry installing hardware and software; training users on uses of the microcomputer. Pass/no pass grading. Total of 180 hours field practice.

CIS  132   FOURTH GENERATION LANGUAGES

3 units

Prerequisite: Any other CIS course.

An introduction to common non-procedural languages with emphasis on SQL. Table creation, queries, reporting from files, building systems, accessing a database. Total of 54 hours lecture.

CIS  133   LOCAL AREA NETWORKS (LANs)

3 units

Prerequisite: CIS 10.

A comprehensive overview of LANs. Analysis of transmission media, systems architectures, and cost/benefit tradeoffs. Interconnectivity issues. Prepares students for Industry-level certification. Total of 54 hours lecture and 36 hours laboratory.

CIS  135   CLIENT/SERVER DEVELOPMENT

1 unit

Systems development guidelines and principles that govern the client/server environment, what they are, and how they are implemented. Practical solutions to building sound and stable client/server applications. Hardware and software components relevant to a client/server architecture and application implementation. Total of 18 hours lecture and 36 hours laboratory.

CIS  136   TRANSMISSION CONTROL PROTOCOL INTERNET PROTOCOL (TCP/IP)

5 units

Prerequisite: CIS 137 or CIS 139.

Understanding the TCP/IP protocol suite. Coverage of common installation and configuration issues in networking environments. Coverage of the protocol’s architecture including the use of utilities, addressing, bridging, routing and other topics. Discussion of common networking operating systems. Identification and evaluation of common network operating system resources. Prepares students for Industry-level certification. Total of 90 hours lecture.

CIS  137   WINDOWS WORKSTATION

3 units

Recommended preparation: CIS 10.

Understanding the Windows Workstation operating system. Coverage of Windows Workstation architecture and features. Installation and configuration of Windows Workstation. Security, administration, and implementation in a networking environment. Prepares students for industry-level certification. Total of 54 hours lecture and 36 hours laboratory.

CIS  138   ADMINISTERING WINDOWS DIRECTORY SERVICES

3 units

Prerequisite: CIS 139.

Install, configure, administer, monitor and troubleshoot Windows 2000 Active Directory. Configure Domain Name System to manage name resolution. Use of Active Directory to centrally manage users, groups, shared folders, and network resources and administer the user environment and software with group policy.  Implement and troubleshoot security in a directory services infrastructure.  Monitor and optimize Active Directory performance. Deploying Windows 2000 using RIS.  Prepares students for industry-level certification. Total of 54 hours lecture and 36 hours laboratory.

CIS  139   WINDOWS SERVER

3 units

Prerequisite: CIS 137.

Understanding the Windows Server operating system. Coverage of Windows Server architecture and features. Installation and configuration of Windows Server. Security, administration, and implementation in a networking environment. Managing groups, folders, files, and object security. Remote access and virtual private networks. Managing internet and network interoperability. Prepares students for industry-level certification. Total of 54 hours lecture and 36 hours laboratory.

CIS  141   EXCHANGE SERVER

3 units

Prerequisite: CIS 137 or CIS 139.

Install, configure, and administer Exchange Server. Installation and integration of clients. Develop an infrastructure for Exchange Server. Develop long-term administration strategies. Configure connectivity to a mail system other than Exchange Server. Configure synchronization of directory information between Exchange Server and other mail systems. Configure directory replication. Manage site security, users, distribution lists, and the directory.  Backup and restore the Exchange Server organization. Prepares students for Industry-level certification.  Total of 54 hours lecture and 36 hours laboratory.

CIS  142   ADMINISTERING MICROSOFT SQL SERVER DATABASES

3 units

Prerequisite: CIS 139.

Install, configure, and support Microsoft SQL Server and database including, managing storage, setting up user accounts, assigning permissions, securing SQL Server, backing up and restoring databases, performing other administrative tasks, transferring data in and out of SQL Server databases, diagnosing system problems, and ensuring high-availability. Total of 54 hours lecture and 36 hours laboratory.

CIS  161   NETWORK DESIGN AND INTERNETWORKING FUNDAMENTALS

3 units

Interdisciplinary course: Electronics, CIS

Prerequisite: CIS 10.

Basic network design and internetworking fundamental concepts with an emphasis on CISCO technology. The OSI model, industry protocol standards, use of IP addressing, subnet masks, and basic networking components. May not be taken concurrently with or after Eltrn 161. Total of 54 hours lecture and 36 hours laboratory.

CIS  162   ROUTER FUNDAMENTALS

3 units

Interdisciplinary course: Electronics, CIS

Prerequisite: CIS 161 or Eltrn 161.

Basic router installation and configuration with an emphasis on CISCO technology. Network standards, dynamic routing, safety and regulatory issues, the use of networking software, and the care of networking hardware and software. May not be taken concurrently with or after Eltrn 162. Total of 36 hours lecture and 54 hours laboratory.

CIS  163   NETWORK DESIGN AND CONFIGURATION

3 units

Interdisciplinary course: Electronics, CIS

Prerequisite: CIS 162 or Eltrn 162.

Advanced knowledge and experience with switches, bridges and routers; local area networks (LAN); introduction of virtual local area networks (VLAN) design  including configuration and operation maintenance. Novell networks, Internetwork Packet Exchange (IPX), routing and Interior Gateway Routing Protocol (IGRP), network management, security and troubleshooting with emphasis toward preparing for the Cisco Certified Network Associate (CCNA) examination.  May not be taken concurrently with or after Eltrn 163. Total of 54 hours lecture and 36 hours laboratory.

CIS  164   WIDE AREA NETWORK FUNDAMENTALS

3 units

Interdisciplinary course: Electronics, CIS

Prerequisite: CIS 163 or Eltrn 163.

Instruction and experience with wide area networks (WAN), integrated services data networks (ISDN), point-to-point protocols (PPP) and frame relay design, configuration and operational maintenance on routers. Network management and security. Emphasis toward preparing for the Cisco Certified Network Associate (CCNA) examination. May not be taken concurrently with or after Eltrn 164. Total of 54 hours lecture and 36 hours laboratory.

CIS  165   CCNP: BUILDING SCALABLE CISCO INTERNETWORKS

4 units

Prerequisite: CCNA Certificate or equivalent.

Recommended preparation:  CCNA Certificate.

Authorized Cisco Networking Academy semester course with lecture and hands-on lab. Advanced topic in Cisco routing including how to design, configure, maintain and scale routed networks that are growing in size and complexity. Using Cisco routers connected in LANs and WANs typically found at medium to large network sites. Emphasis toward preparing for the Cisco Certified Network Professional (CCNP) examination. Maximum credit: 8 units, 4 units each semester. Total of 54 hours lecture and 72 hours laboratory.

CIS  166   CCNP: BUILDING CISCO REMOTE ACCESS NETWORKS

4 units

Prerequisite: CIS 165.

How to design, configure, maintain, and scale a remote access network using Cisco routers and switches. Build and configure a remote access network to interconnect central sites to branch offices and home office/telecommuters, control access to the central site, and maximize bandwidth utilization over the remote links. Emphasis toward preparing for the Cisco Certified Network Professional (CCNP) examination. Maximum credit: 8 units, 4 units each semester. Total of 54 hours lecture and 72 hours laboratory.

CIS  167   BUILDING CISCO MULTILAYER SWITCHED NETWORKS

4 units

Prerequisite: CIS 166.

How to build and manage campus networks using multilayer switching technologies. Covers campus network design, VLANs, Spanning-Tree Protocol (STP), inter-VLAN routing, Multilayer Switching (MLS), Cisco Express Forwarding (CEF), Hot Standby Router Protocol (HSRP). Securing the switched network model, including setting passwords, local and remote login, modifying default privilege levels, and applying Layer 3 traffic management techniques to the campus network. Very detailed information regarding the role of switches in multicasting. Emphasis toward preparing for the Cisco Certified Network professional (CCNP) examination. Maximum credit: 8 units, 4 units each semester. Total of 54 hours lecture and 72 hours laboratory.

CIS  168   CISCO INTERNETWORK TROUBLESHOOTING

4 units

Prerequisite: CIS 167.

Diagnose, isolate, and correct network failures and performance problems. How to identify troubleshooting targets, use troubleshooting tools, and manage IP, IPX, AppleTalk, Catalyst, Frame Relay, and ISDN BRI connections. Emphasis toward preparing for the Cisco Certified Network Professional (CCNP) examination. Maximum credit: 8 units, 4 units each semester. Total of 54 hours lecture and 72 hours of laboratory.

CIS  169A   NETWORK SECURITY 1

4 units

Prerequisite:  CIS 166.

Design and implement security solutions that will protect the network from outside attacks. Emphasis on security policy design and management, security technologies, products, and solutions, firewall and secure router design, installation, configuration, and maintenance, implementation of AAA and VPN using routers and firewalls. A part of Cisco Networking Academy Program preparing students for CCSP (Cisco Certified Security Professional) certificate. Maximum credit 12 units, 4 units each semester. Total of 72 hours of lecture and 54 hours of laboratory.

CIS  169B   NETWORK SECURITY 2

4 units

Prerequisite:  CIS 169A.

Focuses on the overall security process in a network including security policy design and management, security technologies, products, and solutions.  Firewall and secure router design, installation, configuration, and maintenance along with intrusion prevention system implementation using routers and firewall will be covered.  VPN implementation using routers and firewalls will be covered.  A part of Cisco Networking Academy Program preparing students for CCSP (Cisco Certified Security Professional) certificate. Maximum credit 12 units, 4 units each semester.  Total of 72 hours lecture and 54 hours laboratory.

CIS 170  CISCO IP TELEPHONY

4 units

Prerequisite:  CIS 166.

Introduction to converged voice and data networks as well as the challenges faced by its various technologies.  Presents Cisco solutions and implementation considerations to address those challenges.  Maximum credit 8 units, 4 units each semester.  Total of 72 hours lecture and 54 hours laboratory.

CIS  180   ORACLE DATABASE FUNDAMENTALS

3 units

Recommended preparation:  CIS 31.

Oracle database architectural components including: configuring an Oracle server, managing an Oracle instance, creating an Oracle database, and defining the data dictionary’s content and usage. Course also covers Oracle database security with an emphasis on roles and privileges. Total of 54 hours of lecture and 36 hours laboratory.

CIS  181   ORACLE SQL

3 units

Recommended preparation:  CIS 31.

Programming with Oracle SQL for defining, maintaining, and managing an Oracle database environment. Use of Oracle SQL to query databases, define tables, join tables, and manipulate table data. Creation of users, roles, and appropriate system and object database privileges. Total of 54 hours of lecture and 36 hours of laboratory.

CIS  182   ORACLE PL/SQL

3 units

Recommended preparation:  CIS 181.

Programming using the Oracle procedural language (PL) extension in conjunction with SQL. Handling data in Oracle PL/SQL blocks. Creating PL/SQL processes and procedures. Utilizing Oracle PL/SQL functions, packages, and database triggers. Oracle database performance tuning. Total of 54 hours of lecture and 36 hours of laboratory.

CIS  183   ORACLE FORMS DEVELOPMENT

3 units

Recommended preparation:  CIS 181.

The Oracle Forms development environment. Programming techniques for developing data entry and query screens utilizing Oracle databases. Coverage of Oracle Forms objects, Forms Wizards. Form Builder, and Layout Editor. Application design using database triggers, menus, and multiple forms. Total of 54 hours lecture and 36 hours laboratory.

CIS  190   WEB SERVER DEVELOPMENT

3 units

Prerequisite: CIS 111 or CIS 136.

Foundations of the Internet and the World Wide Web: Intranets, technical aspects of the Web, Internet and Web Servers, hypermedia, HTML, scripting languages, Web page development, basic data communication and networking, Web browsers, search engines, file transferring, email, FTP, HTTP, POP, SMTP, TCP/IP, URL’s, Web Security, and emphasis on the development of a Web site. Total of 54 hours lecture and 36 hours laboratory.

CIS  192   INTRODUCTION TO WEB AUTHORING

3 units

Interdisciplinary course: CIS, Graphic Communications Technology

Prerequisite: CIS 10.

The development guidelines and principles that govern the Web Designing and Publishing environment, what they are, and how they are implemented. Practical solutions to building multimedia-based Web pages/site and related topics. The main concepts of Internet and applications of telecommunication. An introduction to JavaScript and its application in HTML and emerging technologies. May not be taken concurrently with or after GRCOM 192. Total of 54 hours lecture and 36 hours laboratory.

CIS  194   INTERACTIVE SOFTWARE PRODUCTION

3 units

Prerequisite: CIS 10 or CIS 192.

Object oriented programming for interactive software using an authoring language. Integration of images, video, text, and audio for multimedia applications. Includes discussion of compression and streaming strategies and creative problem-solving. Total of 54 hours lecture and 36 hours laboratory.

CIS  195   TEAM APPLICATIONS PROJECTS

3 units

Prerequisites: CIS 70 or 178; and enrollment in or completion of CIS 74.

Designing, documentary programming, testing and implementing computer-based solutions to actual problem situations. Maximum credit 6 units, 3 units each semester. Total of 54 hours lecture.

 

CIS  196   INTERACTIVE SOFTWARE PRINCIPLES

3 units

Prerequisite: CIS 194.

Design of interactive software emphasizing principles of interactivity, human factors, user testing, human-computer interface concerns and the development of prototypes and specifications. Includes discussion of innovative and successful interactive products such as CD-ROMs, DVDs, games, and web sites. Total of 54 hours lecture and 36 hours laboratory.

CIS  198   INTERACTIVE SOFTWARE MANAGEMENT

3 units

Prerequisite: CIS 194.

Managing the interactive software design and development process from analysis through evaluation. Includes discussions of process models, needs analysis, task management, teamwork skills, digital asset management, cost engineering, documentation, and performance technology concerns. Includes case studies of software projects such as CD-ROMs, DVDs, games, and web sites. Total of 54 hours lecture and 36 hours laboratory.

 

 

 
 
 
 

Revised April 9, 2012 by slgaskin@pasadena.edu