Announcements
Lecture Schedule
Course Outline
Homework
Grades
|
Course Topics
The course content has been organised into modules, or topics. Several lectures are devoted to each topic. The Lecture Schedule specifies the weeks during which each will be considered. Descriptions and readings for the topics are available below.
Topic A: Introduction to Computer Systems |
Lecture Topics: |
Introduction to the course
- practical/homework
- assignments
- tests
Computing Systems
- Layers of a computing system
- Ancient and modern history of computing
|
Assigned Reading: |
Dale & Lewis
|
Homework: |
Glade Manual - Chapter 0
- manipulating the graphical user interface
- basic data storage - files and file systems
|
Topic B: Representing Data |
Lecture Topics: |
- Number Systems
- Positional Notation
- Number System Bases:
- decimal
- binary
- octal
- hexadecimal
- Binary Representation of Data:
- numeric
- text
- audio
- images & graphics
- video
|
Assigned Reading: |
|
Homework: |
Glade Manual - Chapter 1
- data in a spreadsheet (Excel)
- simple calculations in a spreadsheet
- visual organization and layout of spreadsheet data
Glade Manual - Chapter 2
- simple formulas
- multiple worksheets
|
Other Reading: |
|
Topic C: Processing Data |
Lecture Topics: |
...at the machine level
Hardware
- gates & circuits
- memory circuits
- stored program concept
- computer system components
- CPU cycle
- multi-processor machines
|
Assigned Reading: |
|
Homework: |
Glade Manual - Chapter 3
- IF Function
- LOOKUP function
Glade Manual - Chapter 4
- Logical functions
- Information functions
- Text functions
|
Other Reading: |
|
Topic D: Processing Data |
Lecture Topics: |
...at the machine level
Software
- Operating Systems
- memory management
- process management
- CPU scheduling
|
Assigned Reading: |
|
Homework: |
Glade Manual - Chapter 5
- Simulation: Recurrence calculations
|
Other Reading: |
|
Topic E: Data Bases |
Lecture Topics: |
Database Management Systems
- the Relational Model
- Relationships
- Structured Query Language (SQL)
- Database Design
|
Assigned Reading: |
|
Homework: |
Glade Manual - Chapter 6
Database Features of a Spreadsheet
- LOOKUP/COUNTIF functions
- VLOOKUP function
- MATCH function
- INDEX function
Glade Manual - Chapter 7
Glade Manual - Chapter 8
Introduction of Microsoft Access
- Adding a new field to a table
- Adding and deleting records
- Creating a Form
- Creating a Report
- Creating a Query
|
Topic F: Computer Networks |
Lecture Topics: |
Computer Networks
- types and communication protocols
The Internet
- network protocols
- network addresses
World Wide Web
- web sites
- search engines
- HTML and beyond
|
Assigned Reading: |
Dale & Lewis
|
Homework: |
Glade Manual - Chapter 9
|
|