## CPSC 111 - Computer Science and Information Technology

This course provides an introduction to computer systems and programming. Concepts in computer architecture include central processing units, buses, memory units, input /output and communication devices.

Credits:  3

Hours: 45 (Lecture Hours: 1.5; Laboratory Hours: 1.5)

Total Weeks:  15

Prerequisites:

CPSC 101 or Principles of Math 12or Math 12

Non-Course Prerequisites:
None

Co-requisites:
None

Course Content:
Theory Part:
- Your future and Computer Competency
- Application Software
- The System Unit
- Browsers, Information Managers, Operating Systems
- Input and Output
- Secondary Storage
- Communication
- The Internet and the Web
- Multimedia, Web Authorship and More
Application Part:
- Excel:
Manipulating Data in a Worksheet
Formatting Worksheet Elements
Inserting Objects and Charts
Exploring Formulas and Functions
- Access:
Creating and Arranging a Database
Creating Forms
Creating Reports
- Programming:
Basic Structure
Formatting Output/More Escape Sequences
Variables, Arithmetic Operations, Math Functions, and Input
Naming, Declaring, Assigning, and Printing values
Constant Macros and More about Printing Variable Values
Arithmetic Operations and Expressions
Mixed Type Arithmetic, Compound Assignment, Operator Precedence, Type Casting
Math Library Functions
Writing Output To a File
Single Character Data
Beginning Decision Making and Looping
IF Control Structure and Relational Expressions
Simple IF-ELSE Control Structures/Nested IF-ELSE Control Structures
Logical Expressions/Precedence of Logical Operators
Switch and IF-ELSE-IF Control Structures
WHILE Loop (1)/WHILE Loop (2)
DO-WHILE Loops/Simple FOR Loop/Nested FOR Loops

Learning Outcomes:

- Use Access to manage data and establish relationships between different dbm-files;
- Problem analysis;
- Program design, coding and testing;
- Language elements such as data types, variables and assignment statements;
- Mixed-mode arithmetic;
- Input/output operations;
- Basic data structures and control structures;
- Procedures and abstract data types;
- Basic database management concepts.