Canonical Syllabus: CS 110, Introduction to Computers

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: Basic Formatting
    Lab:
    • Windows Explorer
    • Using the World Wide Web & Search Engines
    • Sending & Receiving of E-Mail
  5. Lecture:
    • Microsoft Word: Advanced Formatting
    • 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
    • Excel: Functions
    Lab:
    • Microsoft FrontPage: Web Page Development
    • Microsoft PowerPoint
  9. Lecture:
    • Excel: Relative & Absolute Cell Addressing
    • 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: Charting, Intergration, & Excel Database
  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, Reports