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



CPSC 101 or Principles of Math 12or Math 12


Non-Course Prerequisites:




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:
   Introduction to Spreadsheet Software
   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:
   Program Structure, Printing, and Comments
     Basic Structure
     Writing Comments
     Formatting Output/More Escape Sequences
     Review of Topics and Comments about Errors and Debugging
   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
     Reading Data from the Keyboard/Reading Data From a File
     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 Excel to analyze scientific/business data including object linking/embedding (OLE);
- 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.


Grading System:  Letters


Textbooks are subject to change. Please contact the bookstore at your local campus for current book lists.