Part I: Introduction to Information Systems

1. (8/24) Lecture 1: Overview of Information Systems
   Power Point Format
   Lecture 1 Notes
   
   PDF Files
   Lecture 1 Notes
   
   
2. (8/26) Lecture 2: IS Architecture and Applications
   Power Point Format
   Lecture 2 Notes
   
   PDF Files
   Lecture 2 Notes
   
   
3. (8/27) No Workshop (Heinz School IS orientation sessions)

Part II: Database Design and Implementation

4.    (8/31) Lecture 3: Overview of the Relational Database Model
   Power Point Format
   Lecture 3 Notes
   
   PDF Files
   Lecture 3 Notes
   
   
5.    (9/2) Lab : Entering and Viewing Data in Access
6.    (9/3) No Workshop (Heinz School IS orientation sessions)
7.    (9/7) Lecture 4: More on the Relational Database Model
   Power Point Format
   Lecture 4 Notes
   
   PDF Files
   Lecture 4 Notes
   
   
8.    (9/9) Lab: Building Access Database Tables and Controlling Data Quality and External Data
9.    (9/10) Workshop: Access tutorial, homework assignment
10.    (9/14) Lecture 5: Complex Databases & Entity Relationship Model
    Power Point Format
    Lecture 5 Notes
    
    PDF Files
    Lecture 5 Notes
    
    
11.    (9/16) Lab: Access Forms
12.    (9/17) Workshop: Access tutorial, homework assignment
13.    (9/21) Lecture 6: Database Case Study
    Power Point Format
    Lecture 6 Notes
    
    PDF Files
    Lecture 6 Notes
    
    
14.    (9/23) Lab: Case Study Database Implementation
15.    (9/24) Workshop: Case Study Database Implementation
16.    (9/28) Lecture 7: Query Logic and Design
    Power Point Format
    Lecture 7 Notes
    
    PDF Files
    Lecture 7 Notes
    
    
17.    (9/30) Lab: Query By Example (QBE)
18.    (10/1) Workshop: Continuation of Query By Example, Review for Midterm
19.    (10/5) Exam 1: IS fundamentals, Database Design, Queries
20.    (10/7) Lab: Access Macros
21.    (10/8) Workshop: Macros Homework Assignment
22.    (10/12) Lecture 8: Designing Reports
    Power Point Format
    Lecture 8 Notes
    
    PDF Files
    Lecture 8 Notes
    
    
23.    (10/14) No Lab (Heinz Mid-semester Break/Network New York)
24.    (10/15) No Workshop (Heinz Mid-semester Break/Network New York)

Part III: Project Management, Application Development and the Web

25.     (10/19) Lecture 9: Project Introduction & Project Management
    Power Point Format
    Lecture 9 Notes
    
    PDF Files
    Lecture 9 Notes
    
    
26.     (10/21) Lab: Access Reports
27.     (10/22) Workshop: Project98
28.     (10/26) Lecture 10: Systems Analysis and Design
    Power Point Format
    Lecture 10 Notes
    
    PDF Files
    Lecture 10 Notes
    
    
29.     (10/28) Lab: Creating a Web Site
30.     (10/29) Workshop: Continuation of Building a Web Site
31.     (11/2) Lecture 11: Web Design How-To's and Web-Enabled Access
    Power Point Format
    Lecture 11 Notes
    
    PDF Files
    Lecture 11 Notes
    
    
32.     (11/4) Lab: Exam 2 (using computers)
33.     (11/5) No Workshop
34.     (11/9) Project Meeting
35.     (11/11) Lab: Internet-Enabled Access
36.     (11/12) Workshop: Project Work
37.     (11/16) Project Meeting: HBH 1000
38.     (11/18) Lab: Project Work
39.     (11/19) Workshop: Project Work
40.     (11/23) Project Meeting: 1000 HBH
41.     (11/25) No Lab: Thanksgiving Break
42.     (11/26) No Workshop: Thanksgiving Break
43.     (11/30) Lecture 12: IT Implementation and Management
    Power Point Format
    Lecture 12 Notes
    
    PDF Files
    Lecture 12 Notes
    
    
44.     (12/2) Lecture 13: IT in the Public Domain
    Power Point Format
    Lecture 13 Notes
    
    PDF Files
    Lecture 13 Notes
    
    
45.     (12/4) No Workshop

Back to the Top