| Originator: | Goldberg, Andra Status: Approved Department: CIS Computer Information Systems |
| Date Created: | 04/11/2016 Submitted: 04/25/2016 Completed: 12/19/2016 |
| Effective Semester: | Fall |
| Catalog Year: | 2017-18 |
| Course Prefix: | CIS |
| Course Number: | 110 |
| Course Full Title: | Introduction to Computer Information Systems |
| Reason for Evaluation: | Prerequisite Change Goals, Competencies and/or Objectives Change |
| Current Credit: | 3 |
| Lecture Hours: | 3 |
| Lab Hours: | |
| Clinical Hours: | |
| New Credit Hours: | |
| Lecture Hours: | |
| If the credit hour change box has been marked, please provide the new credit hour: | |
| New Lecture Hours: | |
| New Lab Hours: | |
| New Clinical Hours: | |
| New Internship Hours: | |
| New Externship Hours: | |
| SUN Course?: | Yes |
| AGEC Course?: | Yes |
| Articulated?: | Yes |
| Transfer: | ASU NAU UA |
| Prerequisite(s): | Appropriate score on placement exam or completion of PCS 021 and TRE 089 with an 'S'. |
| Corequisite(s): | None |
| Catalog Course Description: | An introduction to hardware, software, data structures, information systems analysis and other topics regarding computer information systems. Content covers historical and contemporary topics with emphasis on database and spreadsheet packages for problem solving from a business perspective. |
| Course Learning Outcomes: | 1. Analyze the principal concepts and roles of mainframe, personal computers, and programming in a business environment.(5,6)
2. Summarize the application of business information systems concepts including information systems analysis, design, and database management.(3,6) 3. Identify various computer hardware components by their appropriate use and identify the purpose of software applications including operating systems, word processing, graphic presentation, spreadsheets, and databases.(6) 4. Construct problem solving projects in spreadsheet and database software applications by using formulas, functions, creating charts, queries, tables, importing data from external sources, and sorting procedures.(3,5,6) 5. Compose a writing assignment in a word processing program which includes formatting styles, tables, headers, and footers. (2,5) 6. Compare common network topologies, classifications, connection options, and media for speed, costs, and security features.(5,6) 7. Identify security protocols necessary to protect information from viruses and malware such as firewalls, anti-virus software, and system updates.(3,5,6) 8. Appraise digital information for credibility and accuracy when using Internet browsers and search engines for problem solving.(5,6) |
| Course Competencies: | Competency 1 Identify the main concepts of computers including how they are used in business organizations to solve problems and automate tasks.
Objective 1.1 Define computer terminology, including hardware, software, data processing, input/output, storage, communications,and networks Objective 1.2 Use features of standard applications packages (word processing, database, and spreadsheets) to produce documents, spreadsheets, and database projects Objective 1.3 Define the roles of operating systems functions and the relationship between the operating systems and hardware compatibility Objective 1.4 Define the rights granted by copyright law to use software and the comparison of shareware, freeware, public domain, and commercial licenses Competency 2 Analyze file management procedures to organize and secure data Objective 2.1 Identify the process by which anti-virus software detects and eliminates viruses Objective 2.2 Evaluate risk management techniques to prevent data loss and destruction through back-up procedures and security policies Objective 2.3 Categorize files into appropriate folders Competency 3 Manage web and Internet resources for research and information dissemination Objective 3.1 Utilize web browsers and search engines to research a topic using search parameters to narrow topic listings Objective 3.2 Create e-mail messages with attachments following appropriate etiquette for corresponding electronically Objective 3.3 Generate web site files in various formats including html, rtf, and picture formats Objective 3.4 Differentiate various digital media formats and their corresponding applications to web based communication Competency 4 Construct a business document using word processing Objective 4.1 Insert a formatted table into a document using Table Styles Objective 4.2 Modify font, paragraph, and page formats using styles Objective 4.3 Construct automated footnotes and endnotes in a document for clarity and citations Objective 4.4 Create custom headers and footers which include automated page numbering formats Competency 5 Investigate key components and terms regarding information management and information systems development including data file structure and data management concepts Objective 5.1 Define the roles of information systems in professional and/or business use Objective 5.2 Differentiate the terms direct conversion, parallel conversion, phased conversion, and pilot conversion including the advantages and disadvantages of each conversion method Objective 5.3 Define transaction processing systems, management information systems, and decision support systems Competency 6 Examine database concepts and terminology Objective 6.1 Manage a data file structure Objective 6.2 Create linked database tables to perform basic data queries Objective 6.3 Compare the properties of hierarchical, network, relational and object-oriented databases Objective 6.4 Create a report with grouping levels using the Report Wizard to display in Print Preview Objective 6.5 Construct queries based in SQL (Structured Query Language) to find records in a table Objective 6.6 Design filters to sort data in a table with one or more fields Objective 6.7 Create a form utilizing fields from a table Objective 6.8 List the advantages of using a database over a spreadsheet when managing records Competency 7 Create spreadsheets for solving business problems Objective 7.1 Identify worksheet components Objective 7.2 Create a spreadsheet that calculates totals, averages, and IF functions with relative and absolute references Objective 7.3 Freeze rows in a spreadsheet to aid in viewing large projects Objective 7.4 Summarize the reasons for conditional formatting to highlight data in a spreadsheet Objective 7.5 Filter data in a spreadsheet using multiple data fields Objective 7.6 Appraise the use of Excel templates to create custom amortization tables, invoices, budgets, and expense reports. Objective 7.7 Construct charts including pie, line, column, and stacked column charts Competency 8 Examine program development and programming languages Objective 8.1 Define basic program structure and content Objective 8.2 Define program development including planning, coding, and testing options Objective 8.3 Summarize the use of algorithms in procedural programming Objective 8.4 Create programming code using an online application Competency 9 Evaluate key developments in the history of computer devices Objective 9.1 Define the life cycle of typical hardware and software products Objective 9.2 Differentiate between computer engineering, computer science, and information systems professions in the industry Objective 9.3 Appraise the use of prototypes in computer development Competency 10 Examine Information Systems and their role in organizations Objective 10.1 Compare the different conversion methods used in upgrading hardware and software Objective 10.2 Appraise the characteristics of transaction processing, management information, and decision support systems Objective 10.3 Analyze information system data vulnerabilities such as natural disasters, hardware breakdowns, security breaches, and viruses Objective 10.4 Summarize a plan to protect information from a variety of events, attack or failures |