2013-2014 Catalog

May 06, 2024

HELP

2013-2014 Catalog [ARCHIVED CATALOG]

Computer Information Systems Course List

Contract All Courses | Print this page.

Print this Page

Computer Information Systems

Courses

CIS 100 - Introduction to Business Computing

5.0 Credits
An introduction to business computing concepts and applications using Windows and MS Office. Includes introduction 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 102 - Intermediate Business Computing

5.0 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 (IS), database/IS management, IS development, security, privacy and ethics.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 114 - Math and Problem Solving

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Apply different strategies to solve problems, including brainstorming, flowcharting, estimating, inductive and deductive reasoning, and instant insight. [REASON]
Apply computational methods to solve problems using basic arithmetic, signed numbers, scientific notation, order of operation, fractions, and percentages. [REASON]
Apply elementary algebra to problem solving, using variables, algebraic notation, basic algebraic operations, and linear equations. [REASON]
Solve computer programming problems using Boolean Algebra. [REASON]
Convert between various number systems, including decimal, binary, and hexadecimal. [REASON]
Describe structured programming constructs and develop algorithms for Top Down techniques and Bottom Up techniques. [REASON]

CIS 125 - Network Workstation

5.0 Credits
Windows DOS with emphasis on command line functions. Topics include: Installation and Windows XP features, OS navigation, and administrative tools.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 155 - Special Topics

Maximum of 5.0 possible 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Explore current topics of interest in Information Technology. [REASON]

CIS 161 - A+ Hardware Support I

5.0 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 100 with a minimum grade of 2.5, or concurrent enrollment or equivalent experience.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Describe how hardware components function together to make a computer work. [COMMUNICATE]
Describe how software interacts with hardware. [COMMUNICATE]
List several ways to protect hardware and software. [COMMUNICATE]
Advise a user on upgrading their PC. [COMMUNICATE]
Describe the boot process. [COMMUNICATE]
Isolate computer problems using varied analytic and creative approaches. [REASON]
Identify PC hardware components and assemble and disassemble PCs. [REASON]
Install hardware components, upgrades and peripheral devices. [REASON]
Work successfully in a group environment. [COMMUNICATE]

CIS 162 - PC Desktop Support

5.0 Credits
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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Set up defaults for and troubleshoot the installation of several Microsoft operating systems and MS Office. [REASON]
Effectively utilize a knowledge base to solve a computer problem. [REASON]
Create and implement maintenance and backup plans. [REASON]
Install and configure hardware and amp; software for devices such as a hard disk, CD-ROM, scanner, printer, sound card, digital camera, etc. [REASON]
Set up and run a mock help desk, working in a team environment. [COMMUNICATE]
Educate and train others on various operating systems and applications. [COMMUNICATE]
Facilitate customer service and support. [COMMUNICATE]
Effectively communicate with customers and fellow team members. [COMMUNICATE]
Research, create and give an oral presentation. [COMMUNICATE]

CIS 163 - A+ Hardware Support II

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Evaluate and classify systems and determine appropriate configuration and repair actions. [REASON]
Create and follow work orders and tracking documentation. [COMMUNICATE]
Assist customers in making decisions regarding their computer needs and equipment. [COMMUNICATE]
Assist a small business customer to evaluate, design and implement a small business/home office to meet their computing needs. [COMMUNICATE]
Test various PC components and sub-systems. [REASON]
Describe typical shop virus control and licensing policies. [REASON]
Repair and upgrade computer equipment in a simulated commercial environment. [REASON]
Load and configure a typical installation of various operating systems. [REASON]
Develop and analyze a site survey. [REASON]
Act responsibly, both individually and collaboratively, within changing environments. [ACT]
Explain the ethics involved handling customer’s computer equipment. [REASON]
Work in a team environment to achieve a successful outcome. [ACT]

CIS 171 - Cisco Networking I

5.0 Credits
First in a series of four courses preparing students for the Cisco Certified Network Associate Exam. Topics include protocols and services of the OSI and TCP layered models, principles and structure of IP addressing and subnetting, fundamentals of Ethernet concepts, media, and operations, and configuration of network devices. Prerequisite: CIS 125 with a minimum GPA of at least 2.5 or equivalent experience.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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. [COMMUNICATE]
Explain fundamental Ethernet concepts such as media, services, and operation. [COMMUNICATE]
Identify and describe the protocols and services presented in the OSI learning model, as well as the industry-standard TCP/IP networking model. [REASON]
Demonstrate the troubleshooting techniques necessary to verify small network operations and analyze data traffic utilizing common network utilities. [REASON]
Design and implement a hierarchical IP Addressing scheme using subnetting in order to meet the needs of a medium size business. [REASON]

CIS 172 - Cisco Networking II

5.0 Credits
Second in a series of four courses preparing students for the Cisco Certified Network Associate Exam. Topics include Static and Dynamic routing, the RIPv1, RIPv2, EIGRP, and OSPF routing protocols, Variable Length Subnet Masking (VLSM) and Classless Inter-Domain Routing (CIDR), and routing table structure and behavior. Prerequisite: CIS 171 with a minimum grade of 2.5 or equivalent experience.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Describe the purpose and nature of routing tables and the route lookup process to determine the path packets will take in a network. [COMMUNICATE]
Describe the purpose of static routes and configure and verify static and default routing. [COMMUNICATE]
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). [REASON]
Describe the functions, characteristics, main features, and operations of the following of link-state routing protocols: Open Shortest Path First (OSPF). [REASON]
Describe the role of dynamic routing protocols and place these protocols in the context of modern network design. [REASON]
Configure and verify basic and intermediate operations of a router. [REASON]
Use router show and debug commands to troubleshoot common errors that occur in small routed networks. [REASON]

CIS 173 - Cisco Networking III

5.0 Credits
Third in a series of four courses preparing students for the Cisco Certified Network Associate Exam. Topics include the design and implementation of a converged (VoIP, Video, Data) switched network using Virtual LANs (VLANs), Wireless LANs (WLANs), VLAN Trunking Protocol (VTP), Spanning Tree Protocol, and Inter-VLAN routing. Prerequisite: CIS 171 with a minimum grade of 2.5 or equivalent experience.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Describe enhanced switching technologies and explain how VLANs create logically separate networks, and how routing occurs between them. [REASON]
Describe standards associated with wireless media. [COMMUNICATE]
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. [COMMUNICATE]
Identify and resolve common switched network media issues, configuration issues, auto-negotiation, and switch hardware failures. [REASON]
Manage Cisco IOS configuration files including save, edit, upgrade, and restore. [REASON]
Configure, verify, and troubleshoot VLANs, trunking on Cisco switches, interVLAN routing, VTP, and RSTP using basic utilities, the show and debug commands. [REASON]

CIS 174 - Cisco Networking IV

5.0 Credits
Fourth in a series of four courses preparing students for the Cisco Certified Network Associate Exam. Topics include PPP and Frame-Relay WAN technologies, Virtual Private Networks (VPNs), Access Control Lists (ACLs), Network Address Translation (NAT), IPv6, application of WAN security concepts, principles of traffic manipulation, and enterprise network troubleshooting. Prerequisite: CIS 172 with a minimum grade of 2.5 or equivalent experience.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Describe current network security threats and explain how to implement a comprehensive security policy to mitigate common threats to network devices, hosts, and applications. [COMMUNICATE]
Describe the importance, benefits, role, impact, and components of VPN technology. [COMMUNICATE]
Describe ACLs, and verify, monitor and troubleshoot ACLs in a network environment. [REASON]
Explain the basic operation of Network Address Translation (NAT) and Port Address Translation (PAT), and identify, and resolve common NAT and PAT issues. [REASON]
Configure and verify a basic WAN serial connection, a Point-to-Point Protocol (PPP) connection between Cisco routers, and Frame Relay on Cisco routers. [REASON]
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. [REASON]

CIS 180 - Wireless Networking

5.0 Credits
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: CIS 125 or instructor permission.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Install and configure common Wireless Access Points. [REASON]
Use a WiFi scanner to observe the Radio Frequency Environment. [REASON]
Identify the data rates and spread spectrum technologies for the various 802.11 standards. [COMMUNICATE]
Calculate basic Radio Frequency math. [REASON]
Identify the purpose and function of RF antennas and wireless accessories. [COMMUNICATE]
Identify the numerous security threats and provide the appropriate solutions. [REASON]
Perform a simple RF site survey with documentation. [REASON]

CIS 185 - Introduction to Windows Servers

2.0 Credits
Introduction to networking and network virtualization. Students configure virtual machine settings, hardware and software, install network operating systems and manage network system settings within a virtual environment. Prerequisite: CIS 125 or instructor permission.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Install and configure virtualization software and hardware settings on a host system. [REASON]
Configure network settings on host systems running in a virtual state. [REASON]
Describe basic networking concepts. [COMMUNICATE]
Install and configure Windows Server in a virtual environment. [REASON]
Configure basic shares and NTFS security settings. [REASON]
Demonstrate the application of Windows server roles, active directory, domains, and user accounts. [REASON]

CIS 201 - Digital Forensics and the Law

5.0 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 and other legislation.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Describe how electronic discovery differs from digital forensics. [REASON]
List and describe the common legal issues related to electronic evidence. [REASON]
Explain and list the various legislation and regulations that impact technology. [REASON]
Explain how the Fourth Amendment pertains to computer privacy. [REASON]
Summarize in writing the Washington state laws that pertain to Cyber Crime. [COMMUNICATE]
Critique an acceptable use policy. [REASON]
List and describe the generally accepted computer forensic procedures and the importance/impact of each. [REASON]
Analyze and critique forensic analysis reports. [REASON]
Analyze and critique search warrants, affidavits, and subpoenas. [REASON]

CIS 220 - Enterprise Architecture

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 233 - Systems Analysis

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 234 - Systems Design and Development

5.0 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 with a minimum grade of 2.5 or equivalent experience.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Work in teams to define a project plan and perform systems lifecycle (SDLC) activities. [EXPLORE]
Prepare and deliver formal written and oral status reports. [COMMUNICATE]
Create a system design document, including database design, input and output design, process specifications, and user interface design standards. [COMMUNICATE]
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. [REASON]
Develop a database application (prototype) that meets documented data and process specifications. [REASON]
Write and implement a test plan for validating system functionality against requirements. [COMMUNICATE]
Write a user manual and training plan. [COMMUNICATE]
Prepare a roll-out and maintenance plan for project implementation. [REASON]
Perform a structured walk-through and demonstration of a complete working system. [COMMUNICATE]
Perform final project wrap-up activities and compile documentation for all aspects of the systems design, development, and implementation phases of the SDLC. [EXPLORE]

CIS 235 - Requirements Modeling

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 241 - Web Development I

5.0 Credits
Internet and intranet website 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 websites.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Perform content and technical analysis on Web applications and websites. [REASON]
Use XHTML to develop, debug, maintain and document Web applications and websites. [REASON]
Implement standardized application/site design. [REASON]
Compare and contrast different browsers’ effects on XHTML documents. [REASON]
Use the basic principles of Web documents. [REASON]
Control the appearance of a Web page through the use of XHTML tables. [REASON]
Create a website with frames. [REASON]
Use XHTML forms. [REASON]
Create XHTML style through inline, embedded and Cascading Style Sheets. [REASON]

CIS 242 - Web Development II: JavaScript

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 243 - Web Development III: Introduction to PHP

5.0 Credits
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 Web sites.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 244 - Web Development IV: Introduction to Search Engine Optimization

5.0 Credits
An introduction to Search Engine Optimization and content management for the Web. A step-by-step approach to organic and paid search engine optimization. Learn about free statistic collectors and what makes a website move up in placement.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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. [REASON]
Compare and contrast how different search engines work. [COMMUNICATE]
Develop and implement an SEO plan. [COMMUNICATE]
Create a baseline and keyword strategy for a website. [REASON]
Create an ongoing plan to establish good SEO practices. [COMMUNICATE]

CIS 245 - Web Development V Introduction to Cascading Style Sheets

5.0 Credits
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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Make clear decisions about the advantages-disadvantages of using CSS over other Web technologies. [REASON]
Create basic, intermediate websites using CSS for page layout. [REASON]
Use CSS incorporated within HTML/XHTML. [REASON]
Create and use CSS selectors to affect the elements of a Web page. [REASON]
Apply advanced techniques of CSS within Web pages and sites. [REASON]
Communicate assumptions and choices made in the techniques used to create websites. [COMMUNICATE]
Engage in conversations about the different development tools and technologies used to create websites. [COMMUNICATE] Communicate the advantages and disadvantages of Web page layout using CSS. [COMMUNICATE]
Demonstrate the ability to create Web pages or sites, which acknowledges the differences in access capabilities across cultures. [EXPLORE]
Demonstrate the ability to work collaboratively within groups. [ACT]
Apply the appropriate tools and technology to facilitate sustainable websites. [ACT]

CIS 246 - Web Development VI JavaScript Frameworks

5.0 Credits
Students will investigate and use the advanced techniques available in JavaScript Frameworks (libraries) such as JQuery, AJAX, MooTools and Prototype.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 250 - Database Theory and Design

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Describe fundamental principals of database theory and design. [COMMUNICATE]
Research and analyze business data requirements. [REASON]
Identify high-level business rules for data modeling. [REASON]
Document high-level business rules for data modeling. [COMMUNICATE]
Create and refine conceptual and logical data models. [REASON]
Validate conceptual and logical data models. [COMMUNICATE]
Select unique identifiers and normalize the data model. [REASON]
Understand the role of SQL in the business and database contexts. [REASON]
Recognize the basic components and issues of database application design. [REASON]

CIS 251 - Structured Query Language (SQL)

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 253 - Application Development Tools

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Explain the fundamental principles of application design [COMMUNICATE]
Use MS Access to build a student designed application. [REASON]
Describe how Access integrates with enterprise systems. [COMMUNICATE]
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. [REASON]

CIS 254 - Database Procedures and Functions

5.0 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 minimum grade of 2.5.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Explain the concept of a scalable relational database management system RDBMS. [COMMUNICATE]
Explain the difference between client/server RDBMS and client RDBMS. [REASON]
Explain the uses of networked RDBMS. [COMMUNICATE]
Explain and use data manipulation language (DML) within procedures and functions. [REASON]
Make use of save points and roll back within procedural programming. [REASON]
Use of conditional control within procedures and functions (if statements). [REASON]
Create exceptions and errors within DML and handle them within procedural programming. [REASON]
Understand the use of and create iterative control structures within procedural programming (loops). [REASON]
Create record sets through the use of SQL and procedural programming. [REASON]
Develop and use stored procedures and functions. [REASON]
Use the advanced features of stored procedural programming. [REASON]

CIS 255 - Special Topics

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Explore current topics of interest in Information Technology. [REASON]

CIS 260 - Introduction to XML

5.0 Credits
Topics include how XML is used in websites and data storage applications, XSL, incorporating style with XSL and CSS, Namespaces, DTDs, and schemas.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Create, structure, and script XML documents. [REASON]
Demonstrate proper XML syntax. [REASON]
Explain element hierarchies in an XML document. [COMMUNICATE]
Write well formed XML documents. [REASON]
Use Namespaces in XML. [REASON]
Add style to XML using CSS and XSL. [REASON]
Transform XML into other formats using XSLT. [REASON]
Use XPath and XPointer for locating specific XML data. [REASON]
Use XLink for linking XML and non-XML resources. [REASON]
Manipulate XML documents using DOM. [REASON]
Validate XML using DTDs and schemas. [REASON]
Incorporate XML into traditional databases. [REASON]

CIS 264 - Active Directory Administration

5.0 Credits
Introduction to installing, managing and maintaining a network operating system. Topics include: Install Windows Server, overview of Active Directory, Active Directory sites, FSMO roles, Active Directory administration and group policies.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Install, troubleshoot, and configure Windows Server Forests and Domains using Active Directory. [REASON]
Configure and troubleshoot Windows server FSMO Roles and Global catalog. [REASON]
Plan a Group Policy Management and Implementation Policy. [REASON]
Use Group Policies to configure and troubleshoot a user environment. [REASON]
Configure Active Directory certificate services. [REASON]

CIS 265 - Network Administration

5.0 Credits
Focuses on implementation, management and maintenance of Windows Server. Topics include: managing and maintaining DNS and DHCP server roles, remote access services (RRAS) and wireless, file and print services, updating Windows Server, securing data transmission and authentication.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Install, troubleshoot, and configure Windows Server software. [REASON]
Configure basic network settings. [REASON]
Identify and configure server roles. [REASON]
Configure and monitor print services. [REASON]
Maintain and Update Windows Servers. [REASON]
Maintain network health with Network Access Protection and IPSec. [REASON]
Secure data transmission and authentication. [REASON]

CIS 266 - Server Administration

5.0 Credits
Managing and maintaining Windows Server. Topics include: Deploy an Application and a File Server, and use the File Services Roles. Deploy Print and Fax services, Deploy IIS Services, Secure IIS Service, and configure Terminal Service clients. Prerequisite: CIS 180 (was CEN 280), CIS 185 (was CEN 216), or instructor permission.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Deploy a Windows Application Server. [REASON]
Deploy File, Fax, and Print Servers. [REASON]
Deploy Media, IIS Services, and Web Applications Servers. [REASON]
Secure Web Services. [REASON]
Configure and troubleshoot Terminal Services. [REASON]
Configure Terminal Services Clients. [REASON]
Configure a Terminal Services Gateway. [REASON]
Manage and Monitor Application Servers. [REASON]

CIS 267 - Exchange Server

5.0 Credits
Configure and administer the current version of Exchange Server. Topics include: installing and configuring Exchange Server; creating address lists, public folders and virtual servers; implementing SMTP and security, including Exchange database backup and restore.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Install Windows Exchange on a Windows Server. [REASON]
Configure and test email for recipients, and groups on Exchange Server. [REASON]
Configure email on client computers to receive and send email to and from Exchange Server. [REASON]
Configure security settings on an Exchange Server. [REASON]
Configure backup and restore policies on an Exchange Server database. [REASON]

CIS 268 - ISA Server

5.0 Credits
Introduction to implementation and maintenance of an ISA server. Topics include: firewall policies, Internet Web caching, configuring systems in a complex router environment, setting up point to point VPNS and securing remote client connections.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Install Internet Security Acceleration server in a Windows Server environment. [REASON]
Configure Internet Security Acceleration server to cache Web content and act as a proxy for workstations in a local area network. [REASON]
Configure Internet Security Acceleration server as a firewall allowing access from the LAN to the Internet. [REASON]
Configure Internet Security Acceleration server publishing so that a client can access email from the Internet. [REASON]
Configure client computers to use the Internet Security Acceleration server for caching and gateway services. [REASON]

CIS 272 - Digital Forensics I

5.0 Credits
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, working as an expert witness. Maps to the ACE and CSFA certifications.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Describe the origins of computer forensics. [COMMUNICATE]
Describe the relationship between law enforcement and industry. [REASON]
Discuss ethics and its impact on computer forensics. [REASON]
Describe the computing investigation process. [REASON]
Describe disk structures. [REASON]
Describe the Microsoft boot process. [REASON]
Identify where data can be hidden on different platforms. [REASON]
Build a forensic bootable CD/DVD. [REASON]
Describe how to build a forensic workstation. [REASON]
Describe the profession of computer forensics. [REASON]
Use current forensics tools. [REASON]
Perform graphic image recovery. [REASON]
Perform email recovery and investigations. [REASON]
Discuss a code of ethics and conduct related to the information security and digital forensics professions. [REASON]
Identify standards of professionalism and ethical behavior for information security and digital forensics professionals, and apply these standards successfully to ethical dilemmas. [ACT]
Describe issues related to privacy and determine how to address them technically and ethically. [REASON]

CIS 273 - Digital Forensics II

5.0 Credits
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: CIS 272 with a GPA of at least 2.5 or equivalent experience.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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. [REASON]
Employ various techniques to overcome encryption and passwords using a variety of commercial and open source tools. [REASON]
Describe the differences between the FAT16 and FAT32 file systems and boot records. [COMMUNICATE]
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. [COMMUNICATE]
Identify and describe the Windows registry keys that would be examined relevant to a computer forensics investigation. [REASON]
Forensically examine an image from a NTFS system. [REASON]
Recover deleted files and file fragments using both manual and automated methods. [REASON]
Conduct a forensic analysis involving email and other Internet activity. [REASON]
Forensically process thumb drives and memory sticks. [REASON]
Create a Curriculum Vita and properly document experience and education for work in the field of computer forensics. [REASON]
Analyze a code of ethics and conduct related to the information security and digital forensics professions. [REASON]
Identify standards of professionalism and ethical behavior for information security and digital forensics professionals, and apply these standards successfully to ethical dilemmas. [ACT]
Describe issues related to privacy and determine how to address them technically and ethically. [REASON]

CIS 274 - Introduction to Network Security

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 275 - Host System Security I

5.0 Credits
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: CIS 264 and CIS 274 or concurrent enrollment, each with minimum grades of 2.5 or equivalent experience.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 277 - Security Implementation I

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 278 - Security Implementation II

5.0 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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 279 - Managing Network Security

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

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Describe the types of resources that need to be protected in a networked environment. [COMMUNICATE].
Create a security policy. [REASON]
Write procedures for forming a security organization/department. [REASON]
Describe the functions of a security team. [COMMUNICATE]
Describe the procedures for selecting appropriate security components. [REASON]
Describe the major types of DOS attacks and how to protect against them. [REASON]
Describe how to conduct security audits. [COMMUNICATE]
Discuss the process of auditing logs and how the audit process should be implemented. [REASON]
Describe how to conduct a postmortem analysis of an attack. [REASON]

CIS 280 - Career Planning

1.0 Credits
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.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

List job titles available as a graduate of the CIS program. [COMMUNICATE]
Develop job search and interviewing skills. [REASON]
Register on the CAC’s (www.collegecentral.com) website. [REASON]
Create a resume and various cover letters. [COMMUNICATE ]
Participate in activities such as: online job search, reading trade journals/want ads, the interview process. [COMMUNICATE]
Be aware of the internship application process. [COMMUNICATE]
List and describe resources on campus and online for job search/placement. [COMMUNICATE]
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. [COMMUNICATE]

CIS 293 - Digital Forensics III

5.0 Credits
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: CIS 273 with a GPA of a least 2.5, or instructor approval.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 294 - Advanced Data Recovery and Clean Room Operations

5.0 Credits
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: CIS 293 with a grade of at least 2.5 or instructor permission.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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

CIS 295 - Malware Analysis

5.0 Credits
This course prepares forensic analysts, information security professionals and incident responders to reverse-engineer malicious software using practical tools and techniques. Prerequisite: CIS 293 with a grade of at least 3.0 or instructor permission.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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