Computer Information Systems (cis) Course Descriptions Introduction to Computer Science – cis 101

An introductory course in computer science and programming, with emphasis on the logical analysis of a problem and the formulation of a computer program leading to its solution. Topics include basic concepts of computer systems, computer types, cloud computing, and computer programming languages.

In addition to computing concepts, CIS 101 uses a variant of Java based language for coding exercises. Students will not be learning or using the whole language. Instead, students will explore coding in a few well carved-out areas, by completing examples and exercises within those areas.

1. Analyze the local and global impact of computing on individuals and society.

2. Identify fundamental of social, professional, ethical, legal, and security issues in computing.

3. Construct programs to solve problems

4. Apply core object-oriented concepts and write applications using a programming language.

By the end of this course, students will be able to:

1. Describe the components of a computer system.

2. Understand how different data types are represented.

3. Identify common programming concepts, including objects properties and methods.

4. Understand the functions of an operating system

5. Know concepts of data communication, network components and Internet protocols

6. Describe acceptable coding practices, including appropriate use of comment tags.

7. Write a basic computer program to solve specified problems.

Introduction to Microcomputer – CIS 120

Fundamental concepts of computer information systems as applied to microcomputers. Introduction to Microsoft Office (Internet concept, Window, Word 2016, Access 2016, Excel 2016, PowerPoint 2016, and Outlook 2016).

1. Describe types of concepts, input devices, storage devices, and networks commonly found in businesses

2. Describe the functions of application software and systems software

3. Format fonts, paragraphs, bullets, and tables

4. Use tables for forms and webpage designs

5. Use various templates to create business documents

6. Create formulas with the function Wizard or manually

7. Audit equations and troubleshoot errors

8. Create charts and graph, format spreadsheets, graphs and lists for printing

Student Learning Outcomes

Upon completion of this course, the students will be able to:

1. Demonstrate an understanding of the components of a computer

2. Analyze results of processed data and evaluate the method used and results obtained.

3. Enable students to describe advantages and disadvantages of various types of computers, and data storage and peripheral devices.

4. Identify features of Computer Information Systems and basic concepts of computer operations

5. Utilization of the Internet related technology education

6. Work with software program in the business world

7. Demonstrate proper techniques and skills in using microcomputer and typical business application software including word processing, electronic spreadsheet, database management and presentation software

8. Produce professional looking office productivity documents

In-depth concepts of database as they apply to micro computers in business and personal use to build information management systems. The network, hierarchical, and relational models are discussed. DBMS on microcomputers are used for lab assignments to implement the relational models. Writing assignments, as appropriate to the discipline, are part of the course. Allowed Repeatable Course: Not more than three hours will count towards the CIS/IT degree requirements.

By the end of the course, students will be able to:

1. Define Office and Windows essential concepts

2. Understand File Management System

3. Identify all components of Relational Database Model

4. Understand fundamentals of SQL to manipulate Relational Database

5. Understand components of Database Management System (DBMS)

6. Maintain database structure, content and appearance

7. Define data hierarchy and database structure

8. Design a Database File

Measurable Student Learning Outcomes:

Students who complete the course will be able to perform the following functions:

1 Understand fundamentals of Microsoft Office 365

2 Maintain file structure

3 Create a database and database objects

4 Defining Table Relationship

5 Maintaining and Querying a Database

6 Create Forms and Reports

7 Build Queries and enhance table design

8 Generate customize reports and forms

9 Analyze data for easy integration and sharing

10 Automate tasks with Macros

11 Use SQL (Structured Query Language) to manipulate database

12 Database design (Entities, Attributes, and Relationships)