Session 5

MBA Management Information Systems 150:249 -- D. Power

Today's Agenda -- Wednesday, December 6, 2006

  • Quiz #3 Ch. 5, 6 and 7 (15 pts.)
  • Return case analyses, quiz, etc.
  • Excel review questions with answers.
  • Identify case studies for presentation and analysis
  • Lecture Ch. 8. Building Data and Document-driven DSS
    1. How does a data-driven DSS differ from a document-driven DSS?
    2. What are the two database technologies used to store DSS data?
    3. On which dimensions do DSS and operating data differ?
  • Lecture Ch. 9. Building Knowledge-driven DSS and Mining Data
    1. In choosing a Knowledge-Driven DSS project, what "test" can be used to help determine if a problem is appropriate?
    2. How does a Knowledge-Driven DSS differ from data mining?
  • What is the "true story" about using data mining to identify a relation between sales of beer and diapers?
  • American Express Authorizer's Assistant - Interview with AMEX Director Marilyn Stark, by Rolando Hernandez, August 2001.
  • In small groups discuss Vollmer “Anderson Clayton”, Documentum "Optimizing Aircraft Maintenance”, Pontz & Power
  • Show and discuss Pontz & Power slide show of EASE
  • Lecture Ch. 10 "Building Model-driven DSS"
  • Review Decision Support Tutorial "Enhancing a Spreadsheet DSS".
  • Finish and submit LAB: Tutorial 7. "Developing an Excel Application". Print a hard copy of the 401k Report Figure 7-45 (Print Area A1:K18) for "Your Name" with a salary of $35,000 and print the formula sheet (with grid lines and row/column labels). Add a spinner in cell B11 for the Annual Return value in cell B10. You'll need a seed cell and you'll probably want to hide the seed cell value. Make sure that cell protection is turned on, then save your application so that I can see that data validation is operating, the spinner works, and cell protection is enabled. Make sure the buttons and spinner print. You'll need to show me the application works. (10 points)

To Do and Upcoming

For Class Session 6 -- Saturday, December 9

  1. Read Ask Dan, "Who are the major vendors of Excel add-in programs for building model-driven DSS?"
  2. Tutorial 9. Data Tables and Scenario Management. On page 9.25 print the sheets in the workbook and appropriate formulas (with gridlines, row & column headings). 4 pages. Add a new "Low Cost 2" scenario (with units sold: 1500, price per unit=$160; material cost=44; advertising=5000; and administrative=$4000) to the Scenario Report workbook you completed in Tutorial 9. Print the completed scenario summary report (Fig. 9-36) with Low Cost 2. 1 page. (10 points)
  3. Tutorial 10. Using Solver for Complex Problems (10 points)

For Class Session 7 -- Wednesday, December 13

  1. Quiz #4: Ch. 8, 9 and 10 (15 pts.)
  2. Read Ch. 11. Building Web-Based and Inter-organizational DSS; Ch. 12. Evaluating DSS Projects; and Cases: SunTrust, WEBSDSS and Liberty Brass
  3. Finish and submit Tutorial 10. Using Solver for Complex Problems. Complete the tutorial and review assignments. In the tutorial print the formula sheet for Figure 10-6 when cell B11=17 (show grid lines and row and column headings). In the directory data/tutorial10/Review use the Dryers.xls workbook for the review assignments. On pages 10.30-1 print the documentation sheet for Dryer Order, the Orders worksheet (like Figure 10-25 with Dryers added in column E) and Solver answer report, and the formulas for the worksheet (show grid lines and row and column headings). The total profit for all appliances including dryers should equal $20,580. (10 points)