Session 9

Decision Support Systems 150:127 -- D. Power

Today's Agenda -- Tuesday, Feb. 6

  • TUT 9: Examining Variables. On p. 502 print the NewSubs module. Also, on p. 518 steps 9 and 10. Make sure your name is included as a comment in the VBA code. Complete the Review assignments on p. 519-520. Print the Sheet1 worksheet (step 14). Print GOLFFEE function with comments (step 15). 5 pages total. (5 pts.)

    • To do and upcoming

    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