Computer Information Systems

Course Descriptions

CIS 100: Introduction to Business Computing

Credits: 5.0

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

Course Level Objectives

  1. Recognize and identify basic concepts and terminology of introductory-level business computing technology.
  2. Describe the various components within information systems and identify their functions.
  3. Demonstrate entry-level proficiency in using microcomputer applications including spreadsheets, database, word processing, HTML, and presentation.
  4. Observe, analyze, synthesize, apply, and evaluate information related to computer technology.

CIS 102: Intermediate Business Computing

Credits: 5.0

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 (IS), database/IS management, IS development, security, privacy and ethics. Prerequisite(s): CIS 100 or BSTEC 130 with a GPA of at least 2.5 or equivalent experience.

Course Level Objectives

  1. Demonstrate intermediate level proficiency in microcomputer applications, including word processing, spreadsheets, and databases.
  2. Demonstrate quantitative skills and critical thinking through the analysis of data and information.
  3. Describe the issues of computer ethics, security risks, information privacy, disaster recovery planning, and backup strategies.
  4. Identify techniques used to stay current with IT applications and career choices.

CIS 116: IT Prior Learning Assessment

Credits: 1.0 to 5.0

Students will either create an exit portfolio for their ATA requirement or an entrance portfolio for placement into upper level CIS programs. Class can also be used to challenge or waive program requirements. Registration by entry code only; obtain code from instructor. Registration permitted first seven weeks (six in summer) as space is available.

Course Level Objectives

  1. Explain the role of skill standards within the IT industry.
  2. Demonstrate achieved skills standards as learned in industry.
  3. Create an entrance portfolio which demonstrates their degree of mastery of skills for proper placement into upper-level CIS programs.
  4. For course challenges, demonstrate achieved skill sets in CIS objectives for a given course (at 75 percent or better).
  5. For exit from CIS ATA degrees, create an exit portfolio, which features a resume and examples of work from previous courses.

CIS 125: Network Workstation

Credits: 5.0

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

Course Level Objectives

  1. Determine and execute appropriate beginning and intermediate Windows command line commands, including their proper usage and syntax.
  2. Demonstrate basic operating system and command line concepts.
  3. Use and configure the Windows graphical user interface (GUI).
  4. Perform basic and intermediate Windows OS configurations.
  5. Create and manage basic batch files using basic batch file commands.

CIS 141: Introduction to Web Development

Credits: 5.0

A foundational course intended to familiarize students with the history, organization, technologies, development cycles, and ethical standards of Web development. Prerequisite(s): CIS 100 with a minimum grade of 2.5 or equivalent.

Course Level Objectives

  1. Identify valid emerging trends in website development technologies.
  2. Create supporting documents for websites, such as wireframes and site structure.
  3. Identify e-commerce, social media, cultural, and marketing trends of the World Wide Web.
  4. Demonstrate knowledge of basic Internet communication principles and protocols.
  5. Identify and use appropriate authoring tools, Web languages, scripting languages, content and management creation tools.
  6. Explain the ethical standards on the use of copyrighted materials and intellectual property rights.
  7. Demonstrate the knowledge of IEEE-CS/ACM Software Engineering Ethics and Professional Practices.
  8. Develop websites to industry standards.
  9. Design a Web page/site using a graphic designer's concept.
  10. Document website technologies and standards.
  11. Back up and restore websites.
  12. Identify team/personnel requirements needed to successfully complete a website based upon website technical specifications.

CIS 151: A+ Hardware Support

Credits: 5.0

A comprehensive course in computer hardware. Students will build, analyze, and diagnose PC hardware components and peripherals. Emphasis is placed on PC Hardware, networking, mobile devices, and troubleshooting using industry standard test equipment. Hands-on training in the use of a digital multimeter and USB voltage analyzer is included. Preparation for the current CompTIA A+ Hardware certification exam is included. Prerequisite(s): CIS 100 with a minimum grade of 2.5 or equivalent.

Course Level Objectives

  1. Describe how hardware components function together to make a computer work.
  2. Describe how software interacts with hardware.
  3. Describe the boot process.
  4. Isolate computer problems using varied analytic and creative approaches.
  5. Identify PC hardware components and assemble and disassemble PCs.
  6. Demonstrate effective team working skills.

CIS 152: A+ Software Support

Credits: 5.0

A comprehensive course in computer software. Students will install, maintain, and troubleshoot PC operating systems and associated software packages. Emphasis is placed on Windows operating systems, MAC/LINUX operating systems and technologies, industry standard OS maintenance, and troubleshooting/best practice operational procedures. Preparation for the current CompTIA A+ Software certification exam is included. Prerequisite(s): CIS 100 with a minimum grade of 2.5 or equivalent.

Course Level Objectives

  1. Describe how software interacts with hardware.
  2. Describe troubleshooting procedures for software.
  3. Install operating systems.
  4. Maintain and troubleshoot software.
  5. Demonstrate effective team working skills.

CIS 153: IT Desktop Support

Credits: 5.0

Advanced topics in desktop support. Development of problem solving skills used in supporting the desktop user. Students work in teams to create and manage their own helpdesk. Emphasis on troubleshooting, problem solving, and customer support. Prerequisite(s): CIS 151 and CIS 152 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Set up defaults for and troubleshoot the installation of several Microsoft operating systems and MS Office.
  2. Effectively utilize a knowledge base to solve a computer problem.
  3. Set up and run a mock help desk, working in a team environment.
  4. Facilitate customer service and support.
  5. Effectively communicate with customers and fellow team members.

CIS 155: Special Topics: Computer Information Systems

Credits: 5.0

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.

Course Level Objectives

  1. Explore current topics of interest in Information Technology.

CIS 171: Cisco Networking I

Credits: 5.0

First of four courses mapping to the CCNA exam. Topics include functions, components and models of computer networks, and the Internet; structure and implementation of IPv4 and IPv6; ethernet concepts, media, and operations. Students build simple LANs and perform command line configuration for routers and switches. Prerequisite(s): CIS 125 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Explain the fundamental concepts of routing and switching using the OSI layers and the Protocol Data Units (PDU) to explain each step of the process.
  2. Explain fundamental Ethernet concepts such as media, services, and operation.
  3. Identify and describe the protocols and services presented in the OSI learning model, as well as the industry-standard TCP/IP networking model.
  4. Demonstrate the troubleshooting techniques necessary to verify small network operations and analyze data traffic utilizing common network utilities.
  5. Design and implement a hierarchical IP Addressing scheme using subnetting in order to meet the needs of a medium size business.

CIS 172: Cisco Networking II

Credits: 5.0

Second of four courses mapping to the CCNA exam. Topics include basic operation, configuration, and troubleshooting of routers and switches; students will configure router and switch operations and protocols such as RIPv1, RIPv2, single-area/multi-area OSPF, virtual LANs, inter-VLAN routing, and ACLs. Prerequisite(s): CIS 171 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Describe the purpose and nature of routing tables and the route lookup process to determine the path packets will take in a network.
  2. Describe the purpose of static routes and configure and verify static and default routing.
  3. Describe the functions, characteristics, main features, and operations of the following distance vector routing protocols: Routing Information Protocol (RIPv1 and RIPv2), and Enhanced Interior Gateway Routing Protocol (EIGRP).
  4. Describe the functions, characteristics, main features, and operations of the following of link-state routing protocols: Open Shortest Path First (OSPF).
  5. Describe the role of dynamic routing protocols and place these protocols in the context of modern network design.
  6. Configure and verify basic and intermediate operations of a router.
  7. Use router show and debug commands to troubleshoot common errors that occur in small routed networks.

CIS 173: Cisco Networking III

Credits: 5.0

Third of four courses mapping to the CCNA exam. Topics include architecture, components, and operations of routers and switches in larger complex networks. Students will implement DHCP and DNS, and perform advanced configuration and troubleshooting with OSPF/EIGRP/STP/VTP, and NAT in both IPv4/IPv6 networks. Prerequisite(s): CIS 172 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Describe enhanced switching technologies and explain how VLANs create logically separate networks, and how routing occurs between them.
  2. Describe standards associated with wireless media.
  3. Identify and describe the purpose of the components in a small wireless network, and identify basic configuration parameters on a wireless network to ensure that devices are secure and connect to the correct access points.
  4. Identify and resolve common switched network media issues, configuration issues, auto-negotiation, and switch hardware failures.
  5. Manage Cisco IOS configuration files including save, edit, upgrade, and restore.
  6. Configure, verify, and troubleshoot VLANs, trunking on Cisco switches, interVLAN routing, VTP, and RSTP using basic utilities, the show and debug commands.

CIS 174: Cisco Networking IV

Credits: 5.0

Final course mapping to the CCNA exam. Topics include hierarchical network design, PPP and frame-relay, WAN technologies, broadband solutions, IPSec and VPNs, network monitoring, enterprise network troubleshooting, borderless networking, virtualization, and collaboration in network architectures. Prerequisite(s): CIS 173 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Describe current network security threats and explain how to implement a comprehensive security policy to mitigate common threats to network devices, hosts, and applications.
  2. Describe the importance, benefits, role, impact, and components of VPN technology.
  3. Describe ACLs, and verify, monitor and troubleshoot ACLs in a network environment.
  4. Explain the basic operation of Network Address Translation (NAT) and Port Address Translation (PAT), and identify, and resolve common NAT and PAT issues.
  5. Configure and verify a basic WAN serial connection, a Point-to-Point Protocol (PPP) connection between Cisco routers, and Frame Relay on Cisco routers.
  6. Explain the operation and benefits of the Dynamic Host Configuration Protocol (DHCP) and the Domain Name System (DNS), and configure, verify, and troubleshoot DHCP and DNS operations on a router.

CIS 180: Wireless Networking

Credits: 5.0

Provides the material and the experience needed for the Certified Wireless Network Administrator (CWNA) exam. Topics include RF Technologies, Wireless LAN Implementation and Management, Wireless LAN Security, and Wireless LAN Standards. Prerequisite(s): CIS 100 or CIS 125 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Install, configure, and deploy common wireless routers using appropriate settings.
  2. Install, configure, and secure a wireless network, including client settings.
  3. Identify data rates and spread spectrum technologies for the various 802.11 standards.
  4. identify and understand numerous security threats and their solutions.
  5. Use a WiFi scanner to observe the radio frequency environment and troubleshoot common wireless problems.
  6. Calculate basic Radio Frequency math.
  7. Compare and contrast wireless encryption protocols.

CIS 198: Individual Project in Computer Information Systems

Credits: 1.0 to 5.0

Independent projects under the direction and supervision of a CIS instructor. Registration permitted first seven weeks (six in summer) as space is available. Prerequisite(s): Instructor permission.

Course Level Objectives

  1. Present evidence of completion of all aspects of a project as specified in a contract created and agreed upon by the student and instructor.

CIS 199: Special Projects in Computer Information Systems

Credits: 5.0

Credit for a design project is available with approval. For more information, please contact the CIS department at 425.640.1902. Registration permitted first seven weeks (six in summer) as space is available.

Course Level Objectives

  1. Explore current topics of interest in Information Technology.

CIS 201: Digital Forensics and the Law

Credits: 5.0

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 and other legislation. Prerequisite(s): CIS 100 and CIS 102 with a minimum grade of 2.5 or concurrent enrollment or instructor permission.

Course Level Objectives

  1. Describe how electronic discovery differs from digital forensics.
  2. List and describe the common legal issues related to electronic evidence.
  3. Explain and list the various legislation and regulations that impact technology.
  4. Explain how the Fourth Amendment pertains to computer privacy.
  5. Summarize in writing the Washington state laws that pertain to cyber crime.
  6. Critique an acceptable use policy.
  7. List and describe the generally accepted computer forensic procedures and the importance/impact of each.
  8. Analyze and critique forensic analysis reports.
  9. Analyze and critique search warrants, affidavits, and subpoenas.

CIS 210: Win Server Pro Install and Configure

Credits: 5.0

Focuses on installation and configuration of services on Windows Server 2012r2. Topics include managing and maintaining Active Directory, DNS, File Sharing, Printing Services, Group Policy, Networking, IPV4 and IPV6, and DHCP server roles. Prerequisite(s): CIS 125 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Install, troubleshoot, and configure Windows Server software.
  2. Configure basic network settings.
  3. Identify and configure server roles.
  4. Configure and monitor print services.
  5. Configure DNS service.
  6. Configure DHCP.
  7. Use Group Policies to deploy system changes.

CIS 211: Win Server Pro Management and Administration

Credits: 5.0

Managing and maintaining Windows Server. Topics include: Active Directory, Group Policies, File Services, DNS, Remote Access, Server Management, and Maintenance. Prerequisite(s): CIS 125 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Configure a complex network environment.
  2. Work with Virtual Machines and Virtual Machine templates.
  3. Configure Active Directory.
  4. Use Group Policies to deploy system changes.
  5. Configure VPNs.
  6. Manage and monitor servers.

CIS 212: Windows Server Pro Advanced Services

Credits: 5.0

Topics include advanced training in Active Directory, file and storage, DHCP, DNS, Hyper-V, failover clustering, and certificate services. Students will configure and manage Active Directory, group policies, permissions, and certificate services in a Windows environment. Prerequisite(s): CIS 210 or CIS 211 with a minimum GPA of 2.5 or equivalent experience.

Course Level Objectives

  1. Install and configure Active Directory.
  2. Configure file storage.
  3. Configure DHCP.
  4. Configure DNS in a multi domain environment.
  5. Setup and configure certificate services.

CIS 220: Enterprise Architecture

Credits: 5.0

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(s): CIS 116 or CIS 125 with a minimum grade of 2.5 and 45 credits toward an ATA degree.

Course Level Objectives

  1. Recognize and describe a variety of common industry frameworks and models for enterprise architecture analysis and decision-making.
  2. Understand and describe the role of business architectures, motivations and goals in determining appropriate information systems architectures and solutions.
  3. Research and describe the core concepts, benefits and risks of data/information architectures and evaluate existing data/information architecture designs.
  4. Research and describe the core components, benefits and risks of various application architectures and evaluate existing application architecture designs.
  5. Research and describe the core concepts, benefits and risks of various technology solution architectures and evaluate existing architecture designs.
  6. Research and describe the core concepts, benefits and risks of various network architectures and evaluate existing architecture designs.
  7. Understand and describe the concepts, benefits and risks of various architectural approaches such as multi-tier and service-oriented architectures.
  8. Evaluate and plan for the integration of emerging technologies.
  9. Evaluate the total cost of ownership and return on investment for architecture alternatives.

CIS 233: Systems Analysis

Credits: 5.0

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(s): CIS 102 or CIS 116 and completion of at least one writing requirement or equivalent experience.

Course Level Objectives

  1. Describe the phases of a systems development lifecycle.
  2. Use root-cause analysis techniques to define the scope of a system problem.
  3. Use industry-standard modeling methods to examine and diagram the components of a system.
  4. Identify and write functional requirements for a system.
  5. Research and compare possible solution options to meet system requirements.
  6. Evaluate and rate feasibility of potential options.
  7. Propose a solution that would meet defined requirements.

CIS 234: Systems Design and Development

Credits: 5.0

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(s): CIS 233 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Work in teams to define a project plan and perform systems lifecycle (SDLC) activities.
  2. Prepare and deliver formal written and oral status reports.
  3. Create a system design document, including database design, input and output design, process specifications, and user interface design standards.
  4. Apply user-centered design principles to create a prototype of the user interface design that meets documented requirements; prepare a formal demonstrate of this prototype.
  5. Develop a database application (prototype) that meets documented data and process specifications.
  6. Write and implement a test plan for validating system functionality against requirements.
  7. Write a user manual and training plan.
  8. Prepare a roll-out and maintenance plan for project implementation.
  9. Perform a structured walk-through and demonstration of a complete working system.
  10. Perform final project wrap-up activities and compile documentation for all aspects of the systems design, development, and implementation phases of the SDLC.

CIS 235: Requirements Modeling

Credits: 5.0

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(s): CIS 250 and 233 with minimum grades of 2.5 or equivalent experience.

Course Level Objectives

  1. Describe the roles of formal data and process modeling approaches for discovering and validating business information systems requirements.
  2. Discuss the various perspectives and aspects of an enterprise's information systems architecture that need to be considered when analyzing business requirements.
  3. Recognize and describe the components of various types of models used by systems analysts.
  4. Choose appropriate modeling methods and tools for specific analysis situations.
  5. Use models to recognize common data design patterns and process archetypes.
  6. Use computer assisted systems engineering (CASE) and/or other diagramming tools to create models.
  7. Recognize and employ industry-standard diagramming notations when creating models.
  8. Plan and lead a facilitated joint application design (JAD) session, demonstrating the use of a modeling method.

CIS 241: Web Development I

Credits: 5.0

Website development using HTML5, approached from a source code perspective. Covers tags, forms, linked objects, CSS3, frames, tables, and introduction to the use of scripting. Students build multi-page websites. Prerequisite(s): CIS 100 and CIS 141 or instructor permission.

Course Level Objectives

  1. Perform content and technical analysis on Web applications and websites.
  2. Use XHTML to develop, debug, maintain and document Web applications and websites.
  3. Implement standardized application and site design.
  4. Compare and contrast different browsers' effects on XHTML documents.
  5. Use the basic principles of Web documents.
  6. Control the appearance of a Web page through the use of XHTML tables.
  7. Create a website with frames.
  8. Use XHTML forms.
  9. Create XHTML style through inline, embedded and Cascading Style Sheets.

CIS 242: Web Development II: JavaScript and jQuery

Credits: 5.0

Students will explore the topics of embedding, inline and external scripts, functions, form validation, loops, conditional statements, strings, numbers, DHTML, and an introduction to JavaScript Frameworks. Students build multi-page Web sites using these technologies. Prerequisite(s): CIS 241 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Use client-side scripting with well-formed Web pages.
  2. Recognize client-side variables and data types and the operations that can be performed on them.
  3. Write client-side functions, event handlers and control structures.
  4. Use the browser object-model to create scripts that control browser functionality.
  5. Verify form data through scripting validation.
  6. Create and implement client-side Web applications.
  7. Use object-oriented programming within client-side scripting.
  8. Save state information through the use of hidden form fields, query-strings and cookies.
  9. Add interactivity to Web pages through the Document Object Model and Dynamic HTML.
  10. List the concepts of server-side programming.
  11. Introduce database connectivity (time allowed).

CIS 243: Web Development III: Introduction to PHP

Credits: 5.0

Topics include server-side scripting for Web pages using PHP. Students will learn fundamentals of PHP scripting including functions, logical structure, and database connectivity used in creating websites. Prerequisite(s): CIS 242 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Review Internet protocols and the use of Internet protocols on the World Wide Web.
  2. Identify and understand the differences between client-side and server-side scripting.
  3. Use the appropriate script, client-side or server-side, to complete an interactive website.
  4. Use the Document Object Model to interact with a Web page.
  5. Use properties, methods and event handlers associated with the Document Object.
  6. Create and use scripting variables and data types using appropriate naming conventions.
  7. Use arithmetic, comparison and logical operators in a scripting language.
  8. Create procedures and re-usable functions in a scripting language.
  9. Describe how server-side scripting is processed by a Web server and create pages which include server-side scripting.
  10. Use the request object to retrieve information supplied by a Web user to a form.
  11. Create an interactive website using a database.

CIS 244: Web Development IV: Intro to Joomla! and SEO

Credits: 5.0

Students will learn to work with open-source content management systems (CMSs) and search engine optimization (SEO). Topics include Joomla!, installation of Joomla!, creating and updating content, and SEO concepts and techniques. Students will apply these topics while building multi-page websites. Prerequisite(s): CIS 241 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Determine the business model of a website such as business-to-business, business-to-consumer, large organization, small organization, brick-and-mortar vs. E-commerce, social networking, blog.
  2. Compare and contrast how different search engines work.
  3. Develop and implement an SEO plan.
  4. Create a baseline and keyword strategy for a website.
  5. Create an ongoing plan to establish good SEO practices.

CIS 245: Web Development V: Introduction to CSS

Credits: 5.0

Students will learn the details required to combine CSS (Cascading Style Sheets) with HTML, XHTML, or XML to create rich, powerful websites. Topics include: selectors, cascade and inheritance, text and font manipulation, layout, and positioning. Prerequisite(s): CIS 241 with a minimum grade of 2.5 or instructor permission based on equivalent experience.

Course Level Objectives

  1. Make clear decisions about the advantages-disadvantages of using CSS over other Web technologies.
  2. Create basic, intermediate websites using CSS for page layout.
  3. Use CSS incorporated within HTML/XHTML.
  4. Create and use CSS selectors to affect the elements of a Web page.
  5. Apply advanced techniques of CSS within Web pages and sites.
  6. Communicate assumptions and choices made in the techniques used to create websites.
  7. Engage in conversations about the different development tools and technologies used to create websites.
  8. Communicate the advantages and disadvantages of web page layout using CSS.
  9. Demonstrate the ability to create Web pages or sites, which acknowledges the differences in access capabilities across cultures.
  10. Demonstrate the ability to work collaboratively within groups.
  11. Apply the appropriate tools and technology to facilitate sustainable websites.

CIS 246: Web Dev VI: JavaScript Frameworks

Credits: 5.0

Students will investigate and use the advanced techniques available in JavaScript frameworks (libraries) such as JQuery, AJAX, MooTools, and Prototype. Prerequisite(s): CIS 242 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Make clear decisions about the advantages-disadvantages of using advanced scripting techniques over other Web technologies.
  2. Create intermediate websites using JQuery, AJAX, MooTools, and other JavaScript framework libraries.
  3. Read, modify, and create XML documents through AJAX libraries.
  4. Create advanced user interface using MooTools, JQuery, and Prototype.
  5. Incorporate advanced scripting techniques into Web pages and websites.
  6. Make clear decisions and use the appropriate JavaScript framework technology as needed within a Web page or site.
  7. Create clear and useful documentation of technologies to create a Web page or site.
  8. Communicate assumptions and choices made in the techniques used to create websites.
  9. Engage in conversations about the different development tools and technologies used to create websites.
  10. Communicate the advantages and disadvantages of each of the different JavaScript framework technologies.
  11. Demonstrate the ability to work collaboratively within groups.
  12. Apply the appropriate tools and technology to facilitate sustainable websites.

CIS 250: Database Theory and Design

Credits: 5.0

Designed to recognize data as a business resource. Database models are discussed from both a developer's and a user's viewpoint. Topics include: Conceptual and logical models, and data normalization through case studies. Prerequisite(s): CIS 116 or twenty credits towards an ATA degree or certificate or equivalent experience.

Course Level Objectives

  1. Describe fundamental principals of database theory and design.
  2. Research and analyze business data requirements.
  3. Identify high-level business rules for data modeling.
  4. Document high-level business rules for data modeling.
  5. Create and refine conceptual and logical data models.
  6. Validate conceptual and logical data models.
  7. Select unique identifiers and normalize the data model.
  8. Understand the role of SQL in the business and database contexts.
  9. Recognize the basic components and issues of database application design.

CIS 251: Structured Query Language (SQL)

Credits: 5.0

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(s): CIS 250 with a minimum grade of 2.5 or equivalent.

Course Level Objectives

  1. Explain what SQL is.
  2. Identify the major data types.
  3. Describe why SQL is such a powerful tool.
  4. Create relational databases using SQL.
  5. Perform basic database maintenance and administration such as: insert, update and delete data, create, drop and modify tables.
  6. Create various types of select statements including: table, multi-table and joins, and be proficient with functions and expressions.
  7. Explain the significance of and create indexes.

CIS 253: Application and Cloud Development Tools

Credits: 5.0

An introduction to application development using MS-Access. Includes development of tables, forms, queries, reports, macros, and menus needed to support the application. Includes application development in the Cloud platforms, such as Microsoft Azure or Amazon Web Services (AWS). Prerequisite(s): CIS 250 and CS 115 with minimum grades of 2.5 or concurrent enrollment or equivalent.

Course Level Objectives

  1. Explain the fundamental principles of application design
  2. Use MS Access to build a student designed application.
  3. Describe how Access integrates with enterprise systems.
  4. Given a database design and a few pre-built entities, build the following components of an Access application: tables to store data; forms and sub-forms for data entry into tables; reports that display data in appropriate groups and formatting; queries that assemble data from several tables for use with forms and reports; HTML documents created from custom queries and exported to the Web; modules and event procedures with VBA code to accomplish specific tasks; menus for easy access to the various parts of the application.
  5. Develop application and implement database design in the Cloud platforms, such as Microsoft Azure or Amazon Web Services (AWS).

CIS 255: Special Topics: Computer Information Systems

Credits: 5.0

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.

Course Level Objectives

  1. Explore current topics of interest in Information Technology.

CIS 260: Introduction to XML and Cloud Database Computing

Credits: 5.0

Topics include how XML is used in websites, data storage applications and Cloud storage applications, XSL, incorporating style with XSL and CSS, namespaces, DTDs and schemas. Prerequisite(s): CIS 100 and ETEC 150 with minimum grades of 3.0 or equivalent.

Course Level Objectives

  1. Create, structure, and script XML documents.
  2. Demonstrate proper XML syntax.
  3. Explain element hierarchies in an XML document.
  4. Write well formed XML documents.
  5. Use namespaces in XML.
  6. Add style to XML using CSS and XSL.
  7. Transform XML into other formats using XSLT.
  8. Use XPath and XPointer for locating specific XML data.
  9. Use XLink for linking XML and non-XML resources.
  10. Manipulate XML documents using DOM.
  11. Validate XML using DTDs and schemas.
  12. Incorporate XML into traditional databases.
  13. Incorporate XML into Cloud databases, MySQL Server, Oracle, Microsoft SQL Server in Microsoft Azure or Amazon Web Services (AWS).

CIS 267: Exchange Server

Credits: 5.0

Administering and configuring Exchange Server; creating address lists, public folders and virtual servers; implementing SMTP and security, including Exchange database backup and restore. Prerequisite(s): CIS 125 or CIS 185 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Install Windows Exchange on a Windows Server.
  2. Configure and test email for recipients, and groups on Exchange Server.
  3. Configure email on client computers to receive and send email to and from Exchange Server.
  4. Configure security settings on an Exchange Server.
  5. Configure backup and restore policies on an Exchange Server database.

CIS 268: CISCO CCNA Security

Credits: 5.0

Capstone course covering introductory and intermediate network security principles and implementation using vendor specific equipment. Topics include Device Hardening, Layer 2 Network Security, Zone-Based Firewalls, IPS/IDS, and IPSec VPNs. Prerequisite(s): CIS 172 with a minimum GPA of 2.5 or equivalent experience.

Course Level Objectives

  1. Identify and mitigate common network security attacks.
  2. Harden network devices to prevent intrusion.
  3. Properly plan and place ACL configurations within a networked environment.
  4. Secure administrative access using AAA and RADIUS.
  5. Configure and implement zone based firewalls.
  6. Configure and implement a VPN between a router and firewall.

CIS 272: Digital Forensics I

Credits: 5.0

Covers basic procedures and methodologies for digital forensics that must be mastered. Acquisition, identification, and analysis of evidence; documentation strategies; manual and automated analysis tools; and working as an expert witness. Maps to the ACE and CSFA certifications. Prerequisite(s): CIS 161 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Describe the origins of computer forensics.
  2. Describe the relationship between law enforcement and industry.
  3. Discuss ethics and its impact on computer forensics.
  4. Describe the computing investigation process.
  5. Describe disk structures.
  6. Describe the Microsoft boot process.
  7. Identify where data can be hidden on different platforms.
  8. Build a forensic bootable CD/DVD.
  9. Describe how to build a forensic workstation.
  10. Describe the profession of computer forensics.
  11. Use current forensics tools.
  12. Perform graphic image recovery.
  13. Perform email recovery and investigations.
  14. Discuss a code of ethics and conduct related to the information security and digital forensics professions.
  15. Identify standards of professionalism and ethical behavior for information security and digital forensics professionals, and apply these standards successfully to ethical dilemmas.
  16. Describe issues related to privacy and determine how to address them technically and ethically.

CIS 273: Digital Forensics II

Credits: 5.0

Covers advanced topics. Registry, event logs, internet history, and creating analysis reports. Students will be introduced to processes for conducting testing and verification. Each student will process a forensic case. Maps to the ACE and CSFA certifications. Prerequisite(s): CIS 272 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Create forensically sound image files and working copies of drives from both live and at rest computer systems using a variety of commercial and open source tools.
  2. Employ various techniques to overcome encryption and passwords using a variety of commercial and open source tools.
  3. Describe the differences between the FAT16 and FAT32 file systems and boot records.
  4. Describe the function and layout of: master boot records, partition tables and how they can be hidden and restored, and the NTFS Master File Table.
  5. Identify and describe the Windows registry keys that would be examined relevant to a computer forensics investigation.
  6. Forensically examine an image from a NTFS system.
  7. Recover deleted files and file fragments using both manual and automated methods.
  8. Conduct a forensic analysis involving email and other Internet activity.
  9. Forensically process thumb drives and memory sticks.
  10. Create a Curriculum Vita and properly document experience and education for work in the field of computer forensics.
  11. Analyze a code of ethics and conduct related to the information security and digital forensics professions.
  12. Identify standards of professionalism and ethical behavior for information security and digital forensics professionals, and apply these standards successfully to ethical dilemmas.
  13. Describe issues related to privacy and determine how to address them technically and ethically.

CIS 274: Introduction to Network Security

Credits: 5.0

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(s): CIS 171 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Compare and contrast the three basic cryptographic functions.
  2. Describe how cryptographic functions can be used to enable security services.
  3. Describe authentication, integrity and confidentiality and how they relate to security systems.
  4. Describe the use of public key technology in networks.
  5. Compare and contrast the various mechanisms that provide authentication services.
  6. Given a network security scenario, decide on the proper authentication technology.
  7. Compare and contrast several security technologies that provide solutions for securing network access.
  8. Compare and contrast authentication and authorization and access control.
  9. Describe security technologies used for establishing identity.
  10. Describe how security technologies are implemented in corporate networks.
  11. Identify the strengths and weaknesses associated with protocols designed to authenticate users.
  12. Describe the technologies that exist at the different TCP/IP layers.
  13. Discuss how digital signatures are used for secure transactions.
  14. Identify and describe the three categories of network security threats.
  15. Describe infrastructure security concepts.

CIS 275: Host System Security I

Credits: 5.0

Topics include: Operating system hardening, malware prevention and detection, IPSec and PKI. Students will learn how to plug security holes, authenticate users, defend against attacks and add security practices into administrative tasks. Prerequisite(s): CIS 264 and CIS 274 with a minimum grade of 2.5 or concurrent enrollment or equivalent experience.

Course Level Objectives

  1. List and describe the elements of a computer deployment plan that covers security issues.
  2. Summarize practices for configuring workstations, maintaining workstation integrity, and improving user awareness.
  3. Describe and employ various tools to analyze and implement security measures on a Windows system.
  4. Configure security policies for Windows systems.
  5. Perform a security audit of a Windows system using industry standards and guidelines.
  6. Configure Windows XP's TCP/IP settings that allow for enhanced security.
  7. Compare and contrast types of malware and describe their respective preventative/reactive measures.
  8. Describe the incident response process and how computer security incidents are managed.

CIS 277: Security Implementation I

Credits: 5.0

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(s): CIS 274 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Describe Ethernet operation.
  2. Compare and contrast the tools and utilities available for frame capture/creation.
  3. Perform frame level analysis.
  4. Detect ARP spoofing and IP address spoofing.
  5. Recognize and analyze ARP and ICMP traffic.
  6. Describe TCP/IP vulnerabilities and how to minimize attacks.
  7. Describe TCP/IP stack fingerprinting.
  8. Examine system logs and statistics for signs of attack.
  9. Setup and use a variety of tools to detect and decode attacks.

CIS 278: Security Implementation II

Credits: 5.0

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

Course Level Objectives

  1. Identify and configure security commands in internetworking devices such as routers, switches and firewalls.
  2. Design firewall configuration strategies given a business scenario.
  3. Authenticate users.
  4. Implement appropriate packet filtering.
  5. Plan, develop, design and document a firewall strategy.
  6. Compare and contrast Bastion Hosts.
  7. Implement a secure VPN.
  8. Isolate, contain, document and recover from a security breach.
  9. Implement appropriate firewall troubleshooting procedure used to fix a given problem.

CIS 279: Managing Network Security

Credits: 5.0

Projects include: Conducting vulnerability assessments, penetration tests, and organizational security audits driven by policy. Course maps to the CEH certification. Prerequisite(s): CIS 173 and CIS 277 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Describe the types of resources that need to be protected in a networked environment.
  2. Create a security policy.
  3. Write procedures for forming a security organization/department.
  4. Describe the functions of a security team.
  5. Describe the procedures for selecting appropriate security components.
  6. Describe the major types of DOS attacks and how to protect against them.
  7. Describe how to conduct security audits.
  8. Discuss the process of auditing logs and how the audit process should be implemented.
  9. Describe how to conduct a postmortem analysis of an attack.

CIS 280: Career Planning

Credits: 1.0

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(s): Students must have attained 45 credits toward a CIS ATA degree or instructor permission.

Course Level Objectives

  1. List job titles available as a graduate of the CIS program.
  2. Develop job search and interviewing skills.
  3. Register on the CAC's (www.collegecentral.com) website.
  4. Create a resume and various cover letters.
  5. Participate in activities such as: online job search, reading trade journals/want ads, and the interview process.
  6. Be aware of the internship application process.
  7. List and describe resources on campus and online for job search and placement.
  8. Create a list of at least 10 companies you would apply to and research and document the main features of each that would be important for your cover letter and/or interview.

CIS 291: Technology Internship

Credits: 1.0 to 10.0

Students must be enrolled in their second year of CIS program coursework to enroll in this class. This variable credit course (one to ten credits) provides on-the-job training in information technology. One credit is awarded for each 30 hours worked. Registration by permit code only; obtain code from instructor. Registration permitted first seven weeks as space is available (six in summer). Prerequisite(s): Instructor permission.

Course Level Objectives

  1. Document and acquire IT skill set; goals and work schedule set by the student and coordinator in the internship agreement and learning objectives pages of the internship paperwork.

CIS 293: Digital Forensics III

Credits: 5.0

Forensic triage and other advanced topics. Conducting forensic analysis from start to finish, dealing with live systems and malware. Topics may vary based on current developments and trends. Prerequisite(s): CIS 273 with a minimum grade of 2.5 or instructor permission.

Course Level Objectives

  1. Demonstrate methods to use VMware/Virtual PC as a forensic analysis tool.
  2. Utilize common forensic tools to process a case from start to finish.
  3. Create a comprehensive forensic analysis report.
  4. Develop and use regular expressions to increase search effectiveness.
  5. Create and verify hash sets of various formats, including Hashkeeper, NSRL, and FTK.
  6. Describe a code of ethics and conduct related to the information security and digital forensics professions.
  7. Identify standards of professionalism and ethical behavior for information security and digital forensics professionals, and apply these standards successfully to ethical dilemmas.
  8. Create a list of issues related to computer privacy and document how to address them technically and ethically.

CIS 294: Advanced Data Recovery and Clean Room Operations

Credits: 5.0

Covers the technical and administrative aspects of using clean room equipment to facilitate data recovery from various media, as well as advanced digital forensics and data recovery techniques. Prerequisite(s): CIS 293 with a grade of at least 2.5 or instructor permission.

Course Level Objectives

  1. Recover data from a variety of computer media.
  2. Appropriately use data recovery tools and equipment such as: write blockers, micro-tweezers, dental picks, anti-static gloves and finger cots.
  3. Setup and utilize a data recovery workstation with associated drive connectors and BIOS bypass tools.
  4. Describe the processes used for logical and physical recovery of disabled hard drives.
  5. Swap single and multiple hard drive platters.
  6. Replace a hard drive head assembly.
  7. Describe the processes used to facilitate RAID 0 and RAID 5 recovery.
  8. List and describe the environmental and technical requirements for operating clean room equipment to facilitate the recovery of data from various media.
  9. Work as a team to analyze, design and implement a data recovery project.

CIS 295: Malware Analysis

Credits: 5.0

This course prepares forensic analysts, information security professionals and incident responders to reverse-engineer malicious software using practical tools and techniques. Prerequisite(s): CIS 275 with a minimum grade of 2.5 or equivalent experience.

Course Level Objectives

  1. Use tools and their respective functions for the various stages of the malware analysis process.
  2. Deconstruct common root kit components and functions to include resident malicious code, VB Macros, Java-Script executables and Shellcode executables.
  3. Apply procedures used to intercept and analyze network traffic generated by malware.
  4. Using virtual computing technologies, implement tools and processes used to create a lab environment for reverse-engineering malware.
  5. Modify malicious code to defeat anti-forensic measures contained in self-defending malware.
  6. Examine various formats used to pack malicious executable code, and use and select the appropriate tools for unpacking the code.
  7. De-obfuscate malicious code packages within executables.
  8. Perform static memory malware analysis from artifacts resident in Random Access Memory.
  9. Describe how malware utilizes Windows Operating System API functions for propagation and concealment.
  10. Describe how processes are translated between memory registers, memory stack, and instructions contained in software code.

CIS 298: Individual Project in Computer Information Systems

Credits: 1.0 to 5.0

Advanced independent projects under the direction and supervision of a CIS instructor. Registration permitted first seven weeks as space is available (six in summer). Prerequisite(s): Instructor permission.

Course Level Objectives

  1. Present evidence of completion of all aspects of a second year project as specified in a contract created and agreed upon by the student and instructor.

CIS 299: Special Projects in Computer Information Systems

Credits: 5.0

Credit for a credit designed project is available with approval. For information, please contact the CIS department at 425.640.1902. Registration permitted first seven weeks as space is available (six in summer).

Course Level Objectives

  1. Present evidence of completion of all aspects of a second year project as specified in a contract created and agreed upon by the student and instructor.