CIS 100    Introduction to Business Computing (5 Credits)

An introduction to business computing concepts and applications using Windows and MS Office. Includes intro to HTML, hardware components, info processing cycle in business, how networks work, etc. Students may receive credit for either CIS 100 or BSTEC 130, but not both.
Prerequisite: Placement into EAP 121 or BRDGE 93 or equivalent.

CIS 102    Intermediate Business Computing (5 Credits)

Extends the concepts and software learned in CIS 100. Intermediate expertise of word-processing, spreadsheets, and database software is attained. Concepts include trends/careers in Information Systems, database/IS management, IS development, security, privacy and ethics.
Prerequisite: CIS 100 or BSTEC 130 with a gpa of at least 2.5 or equivalent experience.

CIS 114    Math and Problem Solving (5 Credits)

Builds problem solving skills needed by computer students. Skills covered: logical reasoning, problem analysis and computation. This course prepares students for the first course in programming.
Prerequisite: Placement into MATH 080.

CIS 116    IT Prior Learning Assessment (1-5 Credits)

Class serves various student needs. They will either create an "exit portfolio" for their ATA graduation requirement or create an "entrance portfolio" for placement into upper level CIS programs. Registration by special entry code only; obtain code from instructor.

CIS 125    Network Workstation (5 Credits)

Windows XP with emphasis on command line functions. Topics include: Installation and Windows XP features, OS navigation, and administrative tools.
Prerequisite: CIS 100 or BSTEC 130 or concurrent enrollment or equivalent.

CIS 155    Special Topics (5 Credits)

New topics and technologies in computer information systems are presented. Topics will change from quarter to quarter, but sample topics might include: Operating systems, Networks, Application Development, and Web Development.

CIS 161    A+ Hardware Support I (5 Credits)

An introductory course in computer hardware. Students will install, upgrade, maintain and troubleshoot hardware components. Students learn to identify error messages and symptoms of hardware failures and take the appropriate action.
Prerequisite: CIS 125 with a minimum grade of 2.5 or equivalent experience.

CIS 162    PC Software Support (5 Credits)

Advanced topics in software support. Development of problem-solving skills used in supporting the desktop user. Students work in teams to create and manage their own help desk. Emphasis on troubleshooting, problem-solving, and customer support.
Prerequisite: CIS 125 with a minimum grade of 2.5 or equivalent experience.

CIS 163    A+ Hardware Support II (5 Credits)

Students will repair/build computer systems and peripherals in a simulated shop environment. Topics include: system evaluation, classification, software installation, configuration and peer-to-peer networking. Preparation in A+ certification is included.
Prerequisite: CIS 161 with a grade of 2.5 or higher or equivalent experience.

CIS 171    Cisco Networking I (5 Credits)

First in a series of four courses preparing students for the Cisco Certified Network Associate Exam. Topics include functions of each layer of the OSI reference model, classes of IP addresses and subnetting, network design, topologies and protocols.
Prerequisite: CIS 125 with a minimum GPA of at least 2.5 or equivalent experience.

CIS 172    Cisco Networking II (5 Credits)

Second in a series of four courses that will prepare students for the Cisco Certified Network Associate Exam. Topics include beginning router configurations, routed and routing protocols, TCP/IP and ACLs.
Prerequisite: CIS 171 with a minimum grade of 2.5 or equivalent experience.

CIS 173    Cisco Networking III (5 Credits)

Third in a series of four courses that will prepare students for the Cisco Certified Network Associate Exam. Topics include advanced router configurations, switch configuration, VLANS, OSPF and EIGRP. Emphasis is on network design projects.
Prerequisite: CIS 172 with a minimum grade of 2.5.

CIS 174    Cisco Networking IV (5 Credits)

Fourth in a series of four courses that will prepare students for the Cisco Certified Network Associate Exam. Topics include: WAN protocols, WAN router and switch configurations including ISDN and Frame Relay, and intro to network administration.
Prerequisite: CIS 173 with a minimum grade of 2.5.

CIS 175    Cisco Networking V (5 Credits)

Includes setting up and troubleshooting complex network configurations. Overview of scalable internet works, managing IP traffic and access, configuring queuing, VLSM's OSPF, Enhanced IGRP and BGP. The first prep course for CCNP certification.
Prerequisite: CIS 174 with a minimum grade of 3.0 or equivalent.

CIS 176    CISCO Networking VI (5 Credits)

Students will learn to setup, diagnose and troubleshoot complex network WAN configurations. Topics include modems and asynchronous dialup, PPP, ISDN, Frame backup, IP NAT addressing, and Dialer profiles. The second of a 4 course series designed to teach CCNP.
Prerequisite: CIS 174 with a grade of at least 2.5 or equivalent.

CIS 198    Individual Project (1-5 Credits)

Independent projects under the direction and supervision of a CIS instructor.
Prerequisite: Instructor's permission.

CIS 199    Special Projects (5 Credits)

Note: Credit for a design project is available with approval. For more information, please contact the CIS department at (425)640-1902.

CIS 200    Intro to Info Security (5 Credits)

Includes managerial and technical aspects of Information Security and its role in business, including legal and ethical issues, risk management, security technologies, physical security and security maintenance.
Prerequisite: CIS 100 or BSTEC 130 with a minimum grad of 2.5 or equivalent experience.

CIS 201    Digital Forensics and the Law (5 Credits)

Covers legal issues relevant to information security and digital forensics professionals. Topics: Electronic discovery, expert testimony, electronic surveillance, evidence retention, preservation and spoliation, privacy issues, Sarbanes Oxley & other legislation.
Prerequisite: CIS 125 with a GPA of at least 2.8 or equivalent.

CIS 220    Enterprise Architecture (5 Credits)

Introduction to enterprise systems architectures from various perspectives; covers conceptual frameworks and considerations for managing enterprise application integration projects, relationships between components of systems, and research of emerging technologies.
Prerequisite: Completion of one of the following courses with a grade of 2.5: CIS 116 or CIS 125.

CIS 225    Web Server Technology and Security (5 Credits)

Technology of Web Servers; client/server architecture of a Web Server, create and document server specifications including business considerations, build a Web Server, implement security plans, create disaster support plans, attack patterns and security issues of the WWW.
Prerequisite: CIS 125 with a GPA of a least 2.5 or equivalent experience.

CIS 233    Systems Analysis (5 Credits)

A practical approach to real world systems analysis and design. Includes the systems development life cycle, structured methodologies and project planning. A case study project is analyzed, requirements are written and a systems design specification document is prepared.
Prerequisite: Completion of at least 45 Credits toward an ATA degree or CIS 116 and completion of at least one writing requirement or equivalent experience.

CIS 234    Systems Design and Development (5 Credits)

Provides hands-on experience in systems design and implementation using a prototype approach. The case study is designed and tested using application development software. User manuals are written.
Prerequisite: CIS 233 and 253 with minimum grades of 2.5 or equivalent experience.

CIS 235    Comparative Modeling (5 Credits)

Advanced course in business modeling methods which will provide students an understanding of various tools and techniques used by analysts. Topics include UML, CASE tools, conceptual design, and physical implementation. Enterprise Systems Analysis will be introduced.
Prerequisite: CIS 250 and 233 with minimum grades of 2.5 or equivalent experience.

CIS 241    Web Development I (5 Credits)

Internet and intranet Web site development using XHTML approached from a source code perspective. Covers tags, forms, linked objects, CSS, frames, tables, and introduction to the use of scripting. Students build multi-page Web sites.
Prerequisite: CIS 100 and CS 115 (was CMPSC 115) or concurrent enrollment with minimum grades of 2.5 or equivalent.

CIS 242    Web Development II (5 Credits)

Continuation of concepts and practice introduced in CIS 241. Topics include: embedding, inline and external scripts, functions, form validation, loops, conditional statements, strings, numbers, and DHTML.
Prerequisite: CIS 241 with a minimum grade of 3.0.

CIS 243    Web Development III (5 Credits)

Continuation of CIS 242. Students build interactive websites. Covers database interactivity and new topics as technologies change.
Prerequisite: CIS 242 with a minimum grade of 3.0 or equivalent.

CIS 244    Web Development IV (5 Credits)

Content/information management for the World Wide Web. Topics include: researching, developing, controlling access to and organizing content, and creating meta data information for websites.
Prerequisite: CIS 243, CIS 234, MGMT 270, all with GPA's of at least 2.5 or equivalent experience.

CIS 250    Database Theory and Design (5 Credits)

Designed to recognize data as a business resource. Database models are discussed from both a programmer's and a user's viewpoint. Roles of database designer and administrator will be examined.
Prerequisite: Twenty Credits towards an ATA degree or certificate or CIS 116, or equivalent experience.

CIS 251    Structured Query Language (SQL) (5 Credits)

Covers topics in Structure Query Language (SQL) including statements such as select, update, insert, delete, create. Emphasis on the ability to extract, update and maintain databases using SQL.
Prerequisite: CIS 250 with a minimum grade of 2.5 or equivalent.

CIS 252    Database Implementation and Administration (5 Credits)

Overview of database management systems, implementation and administration of databases, logical and physical schemas, data security, database architectures and the roles of database administrators.
Prerequisite: CIS 251 with a grade of at least 2.5 or instructor's permission.

CIS 253    Application Development Tools (5 Credits)

An introduction to application development using MS-Access. Includes development of tables, forms, queries, reports, macros, and menus needed to support the application. This course is a prerequisite for CIS 234.
Prerequisite: CIS 250 and CS 115 (was CMPSC 115) or concurrent enrollment in both, with minimum grades of 3.0 or equivalent.

CIS 255    Special Topics (5 Credits)

New topics and technologies in computer information systems are presented. Topics will change from quarter to quarter, but sample topics might include: Operating systems, Networks, Application Development, and Web Development.

CIS 256    Data Warehousing Fund (5 Credits)

Introduction to data warehousing concepts for business and IT professionals. Covers design, development and use of data warehouses for business decisions. Addresses terminology, architectural and management considerations related to data warehouse projects.
Prerequisite: CIS 250 with a minimum grade of 3.0 or equivalent experience.

CIS 260    Introduction to XML (5 Credits)

Topics include how XML is used in Web sites and data storage applications, XSL, incorporating style with XSL and CSS, Namespaces, DTDs and Schemas.
Prerequisite: CIS 100 and CIS 114 with minimum grades of 3.0 or equivalent.

CIS 265    DB Procedures/Functions (5 Credits)

Students learn to create functions using procedural programming languages, store functions, and call functions. Includes creating using, modifying stored procedures and functions within a RDBMS. Students learn control structures of a database programming language.
Prerequisite: CIS 251 with a minimum grade of 3.0.

CIS 270    LAN Administration (5 Credits)

Covers hardware and software requirements for Local Area Networks in business. Students plan for and implement a Windows 2003 Server and several applications. LAN admin tasks covered include permissions, security, operation, management, maintenance and troubleshooting.
Prerequisite: CIS 125 and CIS 171 with minimum grades of 2.5 or equivalent experience.

CIS 271    Linux + (5 Credits)

Provides hands on training in installation, and configuration, operation, management, basic networking, security and troubleshooting in the Linux operating system. Maps to and provides prep in CompTIA's Linux + Certification Exam.
Prerequisite: CS 125 (was CMPSC 132) with a GPA of at least 2.5 or equivalent experience.

CIS 272    Digital Forensics I (5 Credits)

Covers: Basic procedures and methodologies for digital forensics that must be mastered. Acquisition, identification and analysis of evidence, documentation strategies, FAT file system, manual and automated analysis tools, working as an expert witness. Maps to the CSFA certification.
Prerequisite: CIS 116 or CIS 125 or equivalent experience.

CIS 273    Digital Forensics II (5 Credits)

Covers advanced topics. NTFS, registry, event logs, internet history, and creating analysis reports. Students will be introduced to processes for conducting testing and verification. Each student will process multiple cases from start to finish. Maps to the CSFA certificate.
Prerequisite: CIS 272 with a GPA of at least 2.5 or equivalent experience.

CIS 274    Intro to Network Security (5 Credits)

Topics include: Communication, infrastructure, operational and organizational security, underlying principles used to secure networks, security technologies, intrusion detection, authentication, and cryptography basics. Maps to Security+ exam.
Prerequisite: CIS 171 and CIS 200, with minimum grades of 2.5 or equivalent experience.

CIS 275    Host System Security I (5 Credits)

In-depth coverage of the following Win 2K security features: Active Directory, Kerberos 5, smartcards, IPSec and PKI. Students will learn how to plug security holes, authenticate users, defend against attacks and add security practices into administrative tasks.
Prerequisite: CEN 264 & CIS 274 or concurrent enrollment, each with minimum grades of 2.5 or equivalent experience.

CIS 276    Host System Security II (5 Credits)

Covers Linux Host security including extended attributes and Access Control Lists, limiting access to services and preventing DOS attacks, secure authentication, auditing servers, detecting hacking and recovery.
Prerequisite: CIS 271 with a GPA of at least 2.5 or equivalent experience.

CIS 277    Security Implementation I (5 Credits)

Topics include: Analyzing network traffic and vulnerability of various protocols, responding to attacks on FTP, HTTP, DNS, HTTPS and SSH. Advanced attack detection using network and host based intrusion detection systems.
Prerequisite: CIS 274 with a minimum grade of 2.5 or equivalent experience.

CIS 278    Security Implementation II (5 Credits)

Topics include: planning, configuring and implementing firewalls, proxy servers and Web filtering. The use of log consolidation tools will also be covered.
Prerequisite: CIS 277 or concurrent enrollment, with a minimum grade of 2.5 or equivalent experience.

CIS 279    Designing Network Security (5 Credits)

Projects include: Analyzing various networks and business needs and designing and defending appropriate corporate security policies, designing secure networks.
Prerequisite: Completion of at least 20 Credits in Networking or IT Security topics, with minimum grades of 2.5 or equivalent experience.

CIS 280    Career Planning (1 Credit)

Description of the various jobs available to CIS graduates and the development of job hunting skills are covered in this course. Resume, cover letter writing, and interviewing techniques are also covered. Internship applications are made in this course.
Prerequisite: Students must have attained 45 Credits toward a CIS ATA degree.

CIS 282    Virtual Private Networks (5 Credits)

Covers: Enable encrypted transfer of data across a public network, study VPN Theory and types, implement VPN technologies, IPSec, PPTP, AAA, and perform cost evaluations and analysis.
Prerequisite: CIS 277 with a GPA of at least 2.5 or equivalent experience.

CIS 283    Linux Server Security (5 Credits)

Focuses on securing network services such as Apache, BIND, ProFTP, and securing mail, NTP and DHCP servers. Students will learn to protect networks/data with IPSec, OpenSSL, OpenSSH and GPG Encryption.
Prerequisite: CIS 276 with a GPA of at least 2.5 or equivalent experience.

CIS 291    Technology Internship (1-10 Credits)

Students working toward the CIS degree, who are in the second year of their course work, receive on-the-job training in information systems. One credit for each 30 hours worked.
Prerequisite: CIS 280 concurrent enrollment.

CIS 292    Cell Phone/PDA Forensics (5 Credits)

Proper methods to acquire and process evidence from cellular phones and personal digital assistants. Acquisition and analysis of evidence from GSM, CDMA and IDEN mobile phones and SIM cards, as well as various types of PDA's.
Prerequisite: CIS 272 with a GPA of at least 3.0 or equivalent.

CIS 293    Digital Forensics III (5 Credits)

Detecting/documenting root kits, the Trojan horse theory, & other advanced topics. Creation of hash sets of hacker tools and illicit programs to be made available to digital forensic professionals throughout the world. Topics may vary based on current trends.
Prerequisite: CIS 273 with a GPA of a least 2.5, or instructor approval.

CIS 298    Advanced Individual Project (1-5 Credits)

Advanced independent projects under the direction and supervision of a CIS instructor.
Prerequisite: Instructor's permission.

CIS 299    Special Projects (5 Credits)

Note: Credit for a credit designed project is available with approval. For information please contact the CIS department at (425)640-1902.