Computer Information Systems Course Outcomes

CIS 120 Computer Concepts

1. Course outcomes for Unit 1 correspond to IC³ Computing Fundamentals
2. Course outcomes for Unit 2 correspond to IC³ Key Applications
3. Course outcomes for Unit 3 correspond to IC³ Living Online

CIS 131 Software Applications

1. Course outcomes for CIS 131 Word correspond to the Microsoft Word certifcation exam 77-881
2. Course outcomes for CIS 131 Excel correspond to the Microsoft Excel certifcation exam 77-882

CIS 178 Internet in Depth

1. Understand the history and infrastructure of the Internet and Web.
2. Understand the use of various web tools and online applications.
3. Understand web page development and the use of web design software.

CIS 140 A+ Essentials

1. Course outcomes for CIS 140 correspond to the CompTIA A+ Essentials Objectives for exam 220-701

CIS 145 PC Technician

1. Course outcomes for CIS 145 correspond to the CompTIA A+ Practical Application Objectives for exam 220-702
2. Describe the most common field replaceable units and identify examples of their functions and most common failures.
3. Show, by example, different connectors, ports, devices and define their basic functions.
4. Identify logical steps in a microcomputer repair process for hardware problems.
5. Perform common preventive maintenance procedures/routines for microcomputer systems.
6. Define possible environmental hazards to a computer system.

CIS 179 Networking Essentials

1. Course outcomes for CIS 179 correspond to the CompTIA Network+ Objectives for exam N10-004

CIS 135DB

1. State the reasons for using a database.
2. State how using related tables helps avoid problems
3. Know the components & elements of a database & associated database management systems.
4. Design and produce relational database models using ER diagrams, integrity rules and normalization.
5. Transform ER diagrams into relational designs and apply normalization processes.
6. Use SQL to create, and modify tables as well as retrieve data from one or more tables databases.
7. Learn the reasons for database administration and associated functions.
8. Understand the classifications of applications, specifically web-based, that access databases.
9. Understand the concepts of data-mining, -warehouses & -marts and how they pertain to business systems.

CIS 122 Introduction to Programming

CIS 244 Information Systems Analysis

CIS 280 College Work Experience

1. Apply academic knowledge in a professional setting.
2. Develop professionally relevant competencies and relationships in a professional setting.
3. Gain exposure to a professional field and an understanding of professional etiquette.
4. Observe and begin to understand a professional organization culture.

CIS 125DW Introduction to Dreamweaver

1. Set project requirements for a web site.
2. Plan site designs and page layouts.
3. Understand the Adobe Dreamweaver interface.
4. Add different types of content to a web page using Adobe Dreamweaver.
5. Organize content using Adobe Dreamweaver.
6. Maintain a web site using Adobe Dreamweaver.

CIS 125FL Introduction to Flash

1. Set project requirements for an animation.
2. Identify rich media design elements.
3. Understand the Adobe Flash interface.
4. Build rich media elements using Flash.
5. Evaluate rich media elements using Flash.

CIS 125A Introduction to Access

1. Course outcomes for CIS 125A correspond to the Microsoft certification for Access (#77-885)
2. Manage the Access Environment: organize objects, filter data, find and replace data.
3. Build tables for a database: import data, create fields, set data types, and establish relationships.
4. Build forms to manage data entry and editing.
5. Create and manage queries.
6. Design database reports.

CIS 125E Introduction to Excel

1. Enter different types of data into Excel and use appropriate formatting features to create a professional looking spreadsheets.
2. Appropriately use basic formulas and functions in Excel to solve common business problems.
3. Evaluate data in Excel using logical and lookup functions.
4. Present business related information in an easy to understand format using the Excel charting tools.
5. Use advanced functions to develop sophisticated spreadsheets for making business decisions.
6. Manage large volumes of data using filters and pivot tables.
7. Conduct "What if" analysis using various features of Excel and conduct advanced statistical computations.
8. Import external data form text files and databases.

CIS 133JS Introduction to JavaScript

1. Understand what JavaScript is and how it is used.
2. Use data types and operators.
3. Use functions, events, and control structures.
4. Validate form data.
5. Manipulate data in strings and arrays.
6. Create and manipulate objects.

CIS 151C

1. Define the OSI model by listing the seven layers in sequential order, providing a definition of encapsulation of data and protocols used at each layer.
2. Explain the difference between routed and routing protocols.
3. Name different routing protocols and describe their fundamental differences.
4. Draw illustrations of different topologies used in LANs, including the different networking device's symbols used for communication within LANs.
5. Illustrate logical locations for intermediate and main distribution closets and appropriate location of jacks given a floor plan of a company/school. Wiring diagram must meet industry standards.
6. Given a Private Class B IP address, borrow bits, determine network numbers and assign IP host addresses to all nodes of a LAN.

CIS 152C

1. Describe the overall purpose and identify the major components of a router.
2. List the key internetworking functions of the OSI network layer and how they pertain to a router.
3. List problems that each routing type encounters dealing with topology changes and describe techniques to reduce the number of problems.
4. Demonstrate procedures used to examine router elements, how to remotely access a router and testing network connectivity, having access to a multiple router configuration.
5. Perform the initial configuration of a router and enable IP.
6. Perform the necessary steps to implement routing information protocol (RIP), interior gateway routing protocol (IGRP), enhanced interior gateway routing protocol (EIGRP) and open shortest path first (OSPF) routing protocols.

CIS 154C

1. Describe the functions of each of the three levels of the hierarchical network design model, the principles of hierarchical network design, and the concept of a converged network.
2. Configure a switch for operation in a network designed to support voice, video, and data transmissions.
3. Configure VLANs on the switches in a network topology.
4. Configure inter-VLAN routing on a router to enable communication between end-user devices on separate VLANs.
5. Configure point to point protocol (PPP) encapsulation.
6. Configure a basic Frame Relay permanent virtual circuit (PVC), including configuring and troubleshooting Frame Relay on a router serial interface and configuring a static Frame Relay map.
7. Configure extended access control lists (ACL) in a medium-size enterprise branch office network, including configuring extended ACLs and named ACLs, configuring filters, verifying and monitoring ACLs, and troubleshooting extended ACL issues.

CIS 195 Introduction to Web Development

1. Know the role of web servers and file management within the Internet infrastructure.
2. Know the basic structural elements of valid HTML5 web pages.
3. Effectively and efficiently use images on web pages.
4. Manage internal and external hyperlinks as part of a site's navigation system.
5. Use CSS to manage web page design/usability.
6. Use block elements such as divs, sections, tables, and lists.
7. Embed audio and video on a web page.
8. Create web forms for data collection.

CIS 235 IT for Business

1. Use Office suite software for communication, sharing/promoting ideas, and documenting procedures.
2. Create and manage a database for efficient and effective decision-making.
3. Demonstrate problem-solving with software.
4. Use software to improve productivity, time management, and project management.

CIS 275 Introduction to Database Management & Design

1. Describe and explain the importance of database processing and database development.
2. Communicate effectively with database professionals using relational database terminology
3. Model a moderately complex data set using an Entity-Relationship diagram
4. Recognize functional dependencies and third normal form schema
5. Remove third normal form violations by decomposition
6. Design and implement basic SQL statements for data definition and data manipulation.
   • Includes using relational set operators
   • Correlated subqueries
7. Understand the basics of performance tuning a database.
8. Describe the basic concepts of business intelligence ( BI) systems

CIS 276 Advanced SQL

1. Design and implement complex SQL statements for data definition and data manipulation that answer typical business related questions.
   • Includes using relational set operators
   • Correlated subqueries
   • Aggregate functions
   • Write SQL statements to retrieve data to answer typical business related questions.
2. Create and use SQL scripts, stored procedures, triggers and user defined functions.
3. Use a cursor to process a result set one row at a time
4. Employ error handling in procedures

CIS 279SE Security+

1. Course outcomes for CIS 279SE correspond to the CompTIA Security+ Objectives for exam SY0-201

CIS 295 Advanced Web Development

1. Create a professional portfolio of web development skills.
2. Identify web site characteristics that promote web usability.
3. Design web pages for mobile devices.
4. Use the newest HTML elements and CSS3 properties in web development.
5. Create multi-tiered (cascading) navigation menus using HTML and CSS.
6. Use PHP for contact forms and server-side includes.
7. Identify characteristics that promote search engine optimization.
8. Set up a content management system.