Course Schedule Spring 2003
|
Dates |
Content/Readings
|
Labs
|
|
Jan. 14 and 16 |
Course Overview; Ch. 1 Supporting Business Decision
Making; What is a DSS? |
DSS Web Tour |
|
Jan. 21 and 23 |
Ch. 2 Gaining Competitive Advantage with DSS |
TUT 1: Model-driven decision analysis |
|
Jan. 28 and 30 |
Ch. 3 Analyzing Business Decision Processes |
TUT 2: Sales analysis report TUT 3:
Enhancing Decision Support reports |
|
Feb. 4 and 6 |
Ch. 4 Designing and Developing DSS Ertl's Decision Support Journey |
TUT 4: Creating Charts Access/Excel Exercise |
|
Feb. 11 |
Exam #1: Ch. 1-4 and Excel concepts
(100 pts.) |
|
|
Feb. 13 |
|
TUT 5: Lists and Pivot tables |
|
Feb. 18 and 20 |
Ch. 5 Designing and Evaluating DSS User Interfaces Ch. 6 Evaluating DSS Architecture, Networking and
Security Issues |
TUT 6: OLE; Integrating Excel with MS Word; Excel web
pages |
|
Feb. 25 and 27 |
Ch. 7 Implementing Communications-driven and Group DSS;
eRoom case study; Veteran's Affairs case study |
TUT 7: Developing an Excel Application; data validation;
conditional formulas; add spinners |
|
March 4 and 6 |
Ch. 8 Building Data and Document-driven DSS: Pfizer uses Alphablox case study;
Anderson Clayton case study |
TUT 8: Multiple Workbooks, Lookup |
|
March 11 |
Review; more on cases |
|
|
March 13 |
Exam #2: Ch. 5-8 and Excel concepts
(100 pts.) |
|
|
March 25 and 27 |
Ch. 9 Building Knowledge-driven DSS and Mining Data; EASE
case study |
TUT 9: Data Tables and Scenario Management |
|
April 1 and 3 |
Ch. 10 Building Model-driven DSS |
TUT 10: Using Solver |
|
April 8 and 10 |
Ch. 10 Building Model-driven DSS continued; SunTrust and Liberty Brass case studies |
TUT 11: Importing Data into Excel |
|
April 15 and 17 |
Ch. 11 Building Web-Based and Interorganizational DSS |
TUT 12: Enhancing Spreadsheet-based DSS |
|
April 22 and 24 |
Ch. 12 Evaluating DSS Projects; Review |
Auditing
Spreadsheets |
|
April 29 and May 1 |
|
Spreadsheet-based DSS Project presentations |
|
Week of May 5 |
Exam #3, Ch. 9-12 and Excel (100
points) |
|
|
This
schedule will be used in both 150:127 and 150:145. Some adjustments may be
made during the semester to account for the different audiences in these two
courses. Also, the emphasis on
managerial versus technical materials will vary between the two courses. This
schedule is subject to change and when possible changes will be announced in
advance. Last revised 04/07/2003. |
||