|
Department of Electrical Engineering and Computer Science
EECS 1520 main site
Home
Topics
Lectures
Course Grading
Reading Materials
Resources
Glade Manual
Homework
|
Topics
| Topic A: Introduction to Computer Systems |
Description |
- Introduction to the course
- Computing Systems: Ancient and modern history of computing
- Layers of a Computing System
|
Homework |
Glade Manual: Chapter 0
- manipulating the graphical user interface
- basic data storage - files and file systems
|
Reading |
Dale & Lewis: Chapter 1, Chapter 11.1, 11.2
|
| Topic B: Representating Data |
Description |
- number systems
- positional notation
- bases of a number systems
- binary representations of data
- data compression
|
Homework |
Glade Manual: Chapter 1
- data in a spreadsheet (Excel)
- simple calculations in a spreadsheet
- visual organisation and layout of spreadsheet data
Glade Manual: Chapter 2
- simple formulas
- multiple worksheets
|
Reading |
Dale & Lewis: Chapter 2, Chapter 3, Chapters 12.1, 12.2
|
| Topic C: Processing Data |
Description |
- gates & circuits, memory circuits
- stored program concept
- computer system components
- CPU cycle
- multi-processor machines
|
Homework |
Glade Manual: Chapter 3
- IF function
- LOOKUP function
Glade Manual: Chapter 4
- Logical functions
- Information functions
- Text functions
|
Reading |
Dale & Lewis: Chapter 4, Chapter 5
|
| Topic D: Processing Data |
Description |
- operating systems
- memory management
- process management
- CPU scheduling
|
Homework |
Glade Manual: Chapter 5
|
Reading |
Dale & Lewis: Chapter 10, Chapter 14.1
|
| Topic E: Data Bases |
Description |
Database Management Systems
- the Relational Model
- Relationships
- Structured Query Language (SQL)
- Database Design
|
Homework |
Glade Manual: Chapter 6
- LOOKUP/COUNTIF functions
- VLOOKUP function
- MATCH and INDEX functions
Glade Manual: Chapter 7, Chapter 8
Introduction to Microsoft Access
- Adding a new field to a table
- Adding and deleting records
- Creating a Form, Query or Report
|
Reading |
Dale & Lewis: Chapter 12.3
|
| Topic F: Computer Networks |
Description |
Computer Networks
- types and communication protocols
The Internet
- network protocols
- network addresses
World Wide Web
- web sites
- search engines
- HTML and beyond
|
Homework |
Glade Manual: Chapter 9
|
Reading |
Dale & Lewis: Chapter 15, Chapters 16.1 and 16.2
|
|
