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:
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:
Textbooks are subject to change. Please contact the bookstore at your local campus for current book lists.