Computer Science and Computer Engineering 120
Computer Information Systems
Tentative Schedule
Sections 01 and 03, Fall 2006
| Week | Topic | Reading | Due |
|---|---|---|---|
| Sept 5 & 7 | Introduction and Welcome,
Excel Basics |
Grauer & Barber, ch 1
(Optional)Walkenbach (Formulas), ch 1 |
|
| Sept 12 & 14 | Formulas, Functions & Names | Grauer & Barber, ch 2 and p. 186,
(Optional)Walkenbach (Formulas), ch 2 - 4, 21 Online Readings on Problem Solving |
Lab #1 |
| Sept 19 & 21 | Text and Date Functions
Statistical Functions |
Grauer & Barber, pp. 88 and 185 - 186,
(Optional)Walkenbach (Formulas), ch 5 - 7 |
Lab #2 |
| Sept 26 & 28 | Charts & Graphs | Grauer & Barber, ch 3,
(Optional)Walkenbach (Charts), ch 1 - 6, 10 - 11 |
Lab #3 |
| Oct 3 & 5 | Financial Functions, Problem Solving, and more Excel |
Grauer & Barber, ch 4 (pp. 159 - 183),
(Optional)Walkenbach (Formulas), ch 11 |
Lab #4 |
| Oct 10 & 12 | Logical Functions, Problem Solving, and more Excel |
Grauer & Barber,
ch 4 (pp. 187 - 202) (Optional)Walkenbach (Formulas), ch 8, ch 14 (pp. 521 - 538) |
Lab #5 |
| Oct 17 | Logical Functions, Problem Solving, and more Excel |
Grauer & Barber,
ch 4 (pp. 187 - 202) |
Lab #6 |
| Oct. 19 | MID-TERM EXAM | Covers material up to Oct. 12 | |
| Oct 24 & 26 | Web & XHTML Fundamentals |
XHTML, ch 1 & 2, (pp. 1 - 37),
Excel, Appendix A (pp. 928 - 935), Web Servers, Networks |
Lab #7 |
| Oct 31, Nov 2 | Lists & Hyperlinks Computer Security, Viruses and Firewalls |
XHTML, ch 2, (pp. 38 - 46),
Excel, Appendix A (pp. 854 - 856), Viruses & Firewalls |
Lab #8 |
| Nov 7 & 9 | Cascading Style Sheets Debugging |
XHTML, ch 3,
Debugging |
|
| Nov 14 & 16 | Images & Multimedia Computer Representation of Numbers |
XHTML, ch 4,
Excel, Appendix A (p. 844), Bits & Bytes, Representing Colors |
Lab #9 Due Wed. |
| Nov 21 | Table Basics Posting your Webpages to Sage, |
XHTML, ch 5 (pp. 88 - 92) | Lab #10 Due Wed. |
| Nov. 23 | Thanksgiving Break! | ||
| Nov 28 & 30 | PowerPoint
Researching on the Web |
PowerPoint Basics Tutorial (2.2 MB)
Search Engines, Evaluating Sources |
Lab #11 Due Wed. |
| Dec 5 & 7 | Student Presentations | ||
| Dec. 14 | Final Exam | (Comprehensive) |
Revised: Nov. 28, 2006