Decision Support Systems 150:127

Course Schedule Spring 2007 

Last revised 01/09/2007

Dates 
Year 2006

Assigned Content/Readings

 

Labs

 

Tues., Jan. 9

Course Overview

Visit DSSResources.COM and take the DSS Web Tour 

 

Thurs., Jan. 11

Discuss Ch. 1. Supporting Business Decision Making

Ask Dan! What type of DSS is X?

Ask Dan! What is a Spreadsheet-based DSS?

 

 

Tues., Jan. 16

Discuss Ch. 2. Gaining Competitive Advantage with DSS; Ask Dan! What is the job of a decision support analyst? How does it differ from a DSS analyst?

 

Thurs , Jan. 18

Ask Dan! What is a cost estimation DSS?

TUT 6: : Introduction to VBA 

Tues., Jan. 23

Discuss Ch. 3. Analyzing Business Decision Processes Ask Dan! What is an example of a decision process? 

Excel Flow Charts

Thurs., Jan. 25

 

 TUT 7:  Creating Custom Functions

Tues., Jan. 30

 Ch. 4. Designing and Developing DSS Ask Dan! What kind of DSS does Mr. X need? Cases: Power & Roth “Ertl's Decision Support Journey”; Stevens "Redland Genstar Data Mart"

 

Thurs., Feb. 1

 

TUT 8:  Creating Custom Forms 

Tues., Feb. 6

Review

TUT 9: Examining Variables 

 

Thurs, Feb. 8

Exam #1: DSS Ch. 1-4 and Excel concepts (100 pts.) 

 

 

Tues., Feb. 13

Discuss Ch. 5. Designing and Evaluating DSS User Interfaces;

Deliverable #1 due

 

Thurs., Feb. 15

 

TUT: Developing an Excel application; data validation; conditional formulas; add spinners

Tues., Feb. 20

Ch. 6. Evaluating DSS Architecture, Networking and Security Issues 

 

Thurs., Feb. 22

 

TUT 1: Excel as a Decision Support Tool

Tues., Feb 27

Ch. 7. Implementing Communications-driven and Group DSS; Cases: eRoom "Naval Medicine" and Wasyluk "Veteran's Affairs"

 

Thurs., March 1

 

TUT 2:  List management and Pivot Tables

Tues., March 6

Ch. 8. Building Data and Document-driven DSS

 

Thurs., March 8

 

TUT 3 and 4:  Charts

Tues., March 20

Cases: Vollmer "Anderson Clayton", Documentum "Optimizing Aircraft Maintenance"; Review for Exam #2

 

Thurs., March 22

Exam #2: DSS Ch. 5-8 and Excel concepts (100 pts.) 

 

Tues., March 27

Ch. 9. Building Knowledge-driven DSS and Mining Data; Pontz & Power “EASE” case study;Ask Dan! What is the \"true story\" about using data mining to identify a relation between sales of beer and diapers?

Deliverable #2 due

 

Thurs., March 29

 

TUT: Using Solver 

Tues., April 3

Ch. 10. Building Model-driven DSS;

 

Thurs., April 5

 

TUT 5: Trouble Formulas 

Tues. April 10

 

TUT 10: Sharing Excel Data/more forms

Thurs., April 12

Ch. 11. Building Web-Based and Inter-organizational DSS 

 

Tues., April 17

No class, project work day

 

 

Thurs., April 19

Ch. 12. Evaluating DSS Projects 

 

 

Tues., April 24

In class project work day 

 

Thurs., April 26

Spreadsheet-based DSS Project presentations

 Deliverable #3&4 due 

 

 

Tuesday, May 1, 3-4:50 p.m.

Exam #3, Ch. 9-12 and Excel (100 points)

 

This schedule is subject to change and when possible changes will be announced in advance.