List of Topics (By Week):
1. Lecture:
Introduction
The History & Future of Computers
Lab:
Labs do not meet
2. Lecture:
The Computer System & Windows 98 Basics
Windows Explorer (File Management)
Lab:
Locating Course Resources
3. Lecture:
The Purdue Network & Introduction to the Internet
Netscape Navigator
Lab:
Windows Explorer
4. Lecture:
Netscape Messenger
Microsoft Word: Advanced Formatting
Lab:
Windows Explorer
Using the World Wide Web & Search Engines
Sending & Receiving of E-Mail
5. Lecture:
Microsoft Word: Mail Merges
Integration: Word and the Internet
Exam 1 Review
Lab:
Microsoft Word: Document Formatting
Lab Quiz #1 - Windows Explorer & Netscape Messenger
6. Lecture:
Microsoft FrontPage: Web Page Development
Lab:
Mail Merges
Integration: Word & the Internet
7. Lecture:
PowerPoint: Introduction / Entering Presentation Text
PowerPoint: Formattting & Excel Introduction
Lab:
Microsoft FrontPage: Web Page Development
Lab Quiz #2 - Formatting a Word Document & Mail Merges
8. Lecture:
Excel: Formulas & Functions
Excel: Relative & Absolute Cell Addressing
Lab:
Microsoft FrontPage: Web Page Development
Microsoft PowerPoint
9. Lecture:
Excel: Goal Seek & Macros
Excel: Charting
Integration: Excel, Word, & PowerPoint
Lab:
Microsoft Excel: Formulas & Functions
Lab Quiz #3 - Microsoft PowerPoint: Presentation Creation
10. Lecture:
Excel Databases: Introduction, Creation & Sorting
Excel Databases: Auto & Advanced Filters
Lab:
Microsoft Excel: Formulas & Functions
11. Lecture:
Excel Database Functions & Access: Introduction
Exam 2 Review
Access: Database & Table Creation
Lab:
Microsoft Excel: Formulas, Functions & Charting
Integration: Word, Excel, and PowerPoint
Microsoft Excel Databases: Creating & Sorting
Lab Quiz #4 - Microsoft Excel: Formulas, Functions, Charting & Intergration
12. Lecture:
Access: Entering Data (Forms) & Extracting Data (Queries)
Access: Extracting Data
Lab:
Microsoft Excel: Filters
Microsoft Access: Table Creation & Forms
13. Lecture:
Access: Printing Data (Reports)
Access: Advanced Queries
Lab:
Microsoft Access: Queries & Reports
Lab Quiz #5 - Microsoft Excel Databases:
Microsoft Access: Tables, Forms, & Queries
14. Lecture:
Access: Multiple Table Relationships
Final Exam Review
Lab:
Microsoft Access: Statistical Queries & Multiple Tables
15. Lecture:
No Lecture (compensation for Exam 1 & 2)
Lab:
Lab Quiz #6 - Microsoft Access: Tables, Forms, & Queries