Session 8

Decision Support Systems 150:127 -- D. Power

Today's Agenda -- Thursday, February 1

  1. TUT 8: Creating Custom Forms. Print 4 pages. On p. 441 print code and user form. Also, on p. 464 print code and user form. Document your code. Include name and tutorial number. Also, printouts from Case 2 p. 472-474. I'll check your Case 2 application in class. (5 pts.)
  2. Check Spreadsheet Tips on Spreadsheet-Based DSS page
  3. Discuss reducing Spreadsheet application errors 1. Plan it!, 2. Avoid complex formulas, 3. Test it!

To do and upcoming

For Class Session 9 -- Tuesday, Feb. 6, TUT 9: Examining Variables

For Class Session 10 -- Thursday, Feb. 8 Exam #1: DSS Ch. 1-4 and Excel concepts (100 pts.)

  1. The exam will consist of 30 Multiple Choice questions (2 pts. each) over Ch. 1-4 (60 pts. total); 10 Multiple Choice Excel questions (1 pts. each, 10 pts. total); 5 of 6 short answer questions (2 pts. each) over DSS book/Ask Dan (10 pts. total); an open book case analysis essay question (10 pts.) prepared as a 1 page memo using MS Word; hands-on Excel exercise (10 pts.). Total 100 points.
  2. The open book essay question will be something like: You just received the following email from your boss. Please send her a detailed reply explaining your assessment of the issues she raises and making one or more recommendations on how to proceed. You'll want to be diplomatic in your answer, but try to fill her in on what you've learned. Assume you are a first year employee in a firm with 500-700 employees in Des Moines, Iowa. The email reads: "At the recent industry conference, I attended a presentation on computerized decision support and heard about DSS at Ertl and Redland Genstar. I think we need a data warehouse and a DSS and I heard you took a class in DSS. You can read the cases at DSSResources.com. How should we proceed? What do you recommend so we can gain a competitive advantage with a DSS?" You'll want to build on the material in the DSS book Chapters 1-4 and on our discussions of the cases.

For Class Session 11 -- Tues., Feb. 13 Read Ch. 5. Designing and Evaluating DSS User Interfaces and Ask Dan! What DSS interface design is "best" for eliciting values? Deliverable #1 due