Information Systems (INDE499B) - Autumn 2000

In this course, you will develop an understanding of information systems that will permit you to understand, use, and even design such systems in your future career as an industrial engineer.  Because industrial engineering activities (e.g., plant layout, procurement, inventory mgmt,) typically require the management of large quantities of information, a working knowledge of information systems issues will enable you to more effectively accomplish your job as an Industrial Engineer and an engineering professional.

Instructor:  Dr. Jennifer Turns
Contact Info: jturns@engr.washington.edu, 206-221-3650
Office: 225 Engineering Annex
Office Hours:  Tuesday, 4:00-5:00; Wednesday, 12:30-1:30

Teaching Assistant:  Lixin Chen
Contact Info:  lxchen@u.washington.edu
Office:  MEB 153
Office Hours: Monday 9:10-10:10, Thursday, 9:10-10:10

General Information

Syllabus:  This document covers the following topics -- general course overview, learning objectives, course topics, instructor's teaching philosophy and style, learning activities, grading, and calendar of main events.
Revised Calendar (updated on 10/30/00)new2.gif (111 bytes):  Highlights of the revised calendar include the move of midterm to 11/6 and the move of the project deliverable #3 to 11/16.
Highlights of Course

Midterm/Exam Information

Solutions to Midterm #2
Review for Final Exam

Project Materials

Project Deliverable #1 (Due 10/2/00) -
* the database (project1-Access97.mdb or project1-Access2000.mdb)
* the store information (storeInformation.txt)

 

General Project Information Sheet
Project Deliverable #2 (Due 10/18/00)
Project Deliverable #3
Project Deliverable #4

Class Preparation Materials

Week 1 (9/25, 9/27, 9/29)
Class Preparation Guide
Classroom Preparation Survey for 9/27 - Due at 8:00AM, Results from Questions 1 and 2
Reading for 9/29 - Explanation of IE
Reading for 9/29 - What Employers Want
Lecture Notes from 9/29 - Includes Pie Diagram for Exploring Class Scope
Week 2 (10/2,10/4, 10/6)
Class Preparation Guide
Lecture Notes for 10/2
Classroom Preparation Survey for 10/4 (due at 8:00AM), Results
Lecture Notes for 10/4
Lecture Notes for 10/6
Week 3 (10/9, 10/11, 10/13)
Class Preparation Guide
Classroom Preparation Survey for 10/9 (due at 8:00AM),  Results
Lecture Notes for 10/9 (into 10/11)
Lecture Notes for 10/11
Week 4 (10/16, 10/18, 10/20)
Class Preparation Guide
Classroom Preparation Survey for 10/16 (due at 8:00AM), Results
Classroom Preparation Survey for 10/20 (due at 8:00AM)
Week 5 (10/23, 10/25, 10/27)
Class Preparation Guide
Classroom Preparation Survey for 10/25 (due at 8:00AM), Results 
Lecture Notes for 10/23
Lecture Notes for 10/25
Week 6 (10/30, 11/1, 11/3)
Class Preparation Guide
Classroom Preparation Survey for 10/30 (due at 8:00AM), Results 
Classroom Preparation Survey for 11/3 (due at 8:00AM), Results
Week 7 (11/6, 11/8, 11/10)
Class Preparation Guide (M: midterm;  W: data warehouses,pp. 531-537, class prep survey; F: holiday!)
Classroom Preparation Survey for 11/8 (due at 8:00AM), Results
Week 8 (11/13, 11/15, 11/17)
Class Preparation Guide
Lecture Notes for 11/13 (Intro to SQL)
Classroom Preparation Survey for 11/15 (due at 8:00AM), Results
Lecture Notes for 11/15 (Single Table Queries)
--- Logfile Data (logfileAnalysis-oneWeek-Access97.mdb or logfileAnalysis-oneWeek-Access2000.mdb)
Classroom Preparation Survey for 11/17 (due at 8:00AM), Results
Lecture Notes for 11/17 (Multiple Table Queries - "Joins")
Week 9 (11/20, 11/22, 11/24)
Class Preparation Guide (note: Same as for week 8)
Classroom Preparation Survey for 11/20 (due at 8:00AM), Results
Lecture Notes for 11/20 (Manipulation Queries - Insert, Update, Delete)
Classroom Preparation Survey for 11/22 (due at 8:00AM), Results
Lecture Notes for 11/22
Happy Thanksgiving!!!
Week 10 (11/27, 11/29, 12/1)
Class Preparation Guide
Lecture Notes for 11/29 (Introduction to Information System Architectures)
Classroom Preparation Survey for 11/29 (due at 8:00AM), Results
Classroom Preparation Survey for 12/1 (due at 8:00AM),  Results
Week 11 (12/4, 12/6)
Class Preparation Guide (note: Same as for week 10)
Review for Final Exam / Highlights of Course