Central Arizona College Back
CIS 120 Survey of Computer Information Systems
Credit Hours:  3
Effective Term: Fall 2015
SUN#: CIS 1120
AGEC: Computer Competency  
Credit Breakdown: 2 Lectures, 3 Labs
Times for Credit: 1
Grading Option: A/F Only

Description: Survey of computer information systems, fundamental computer concepts, programming techniques, networking and emerging technologies. Hands-on experience with Microsoft Office application software with an emphasis on database and spreadsheets for problem solving.

Prerequisites: RDG094

Corequisites: None

Recommendations: None

Measurable Student Learning Outcomes
1. (Knowledge Level) Define basic terminology related to computer hardware, software, operating systems, networks, and programming.
2. (Comprehension Level) Describe hardware components and their function in a computer system.
3. (Analysis Level) Compare different operating systems used in industry and identify their components.
4. (Knowledge Level) Identify ASCII, EBCIDEC and Unicode codes, and binary, hexadecimal, and decimal bases used in a computer system.
5. (Comprehension Level) Discuss the basic input, processing, and output functions used in data processing.
6. (Comprehension Level) Discuss computer usages in student's specific program of study and identify an application that applies.
7. (Comprehension Level) Identify programming languages, their importance, and recognize the use of flowcharts and/or pseudo code to define algorithms for simple computer programs.
8. (Comprehension Level) Review the steps in the system development process.
9. (Application Level) Examine the components of a Management Information System.
10. (Comprehension Level) Review issues related to: the digital divide, security & privacy, the web, computer ethics, ergonomics, and computer careers.
11. (Comprehension Level) Report on issues associated with building an electronic storefront, accepting payment, and managing product delivery, designing a Web site, managing the Web site, and promoting the Web site.
12. (Application Level) Produce reports and documents containing title pages, headers, footers, tables, tabs, columns, bullets, graphics, paragraph formats, and styles and use operating system file management capabilities.
13. (Synthesis Level) Create, format, edit, save, and print spreadsheet workbooks containing formulas, functions, and charts; use relative and absolute cell references and use operating system file management capabilities.
14. (Application Level) Use advanced features of Excel such as data tables, PivotTables, conditional formatting, IF, VLOOKUP, and PMT functions; create Web pages and queries; use logical functions; database functions; create macros; understand the basics of Visual Basic for Applications (VBA).
15. (Synthesis Level) Design, create, modify and manage data, relationships, forms and reports using a database application and use operating system file management capabilities.
16. (Application Level) Use advanced features of Access to query multiple tables; add grouping and sorting levels to forms and reports; use calculated fields, work with data aggregates; create macros; use SQL; understand Visual Basic for Applications (VBA).
Internal/External Standards Accreditation