Session 6

MBA MIS 150:249

Today's Agenda -- Saturday, December 9, 2006

  • Excel review questions with answers.
  • Who are the major vendors of Excel add-in programs for building model-driven DSS?
  • Lecture Ch. 11. Building Web-Based and Inter-organizational DSS
    1. How does a web-based DSS differ from a web-enabled DSS?
    2. What are 2 major advantages of building and deploying a web-based DSS?
    3. What is an example of a thin client-executed, model-driven decision aid program?
    4. What is HTML? Is it a programming language?
  • Demonstrate PlanningDSS.com. Check About PlanningDSS.com
    1. Needs more Alpha testing
    2. Needs divergent phases for situation analysis
    3. Create a more specific template for corporate strategic planning with prescribed steps
  • Demonstrate CollectingResources.com.
  • Ask Dan "What software tools should be used to build Web-based DSS?"
    1. Linux, the operating system
    2. Apache, the Web server
    3. MySQL, the database management system and server
    4. PHP, the scripting/programming language
  • JavaScript Decision Aid Exercise


    • Fahrenheit Temperature:

    Centigrade Temperature:

  • Lecture Ch. 12. Evaluating DSS Projects
  • Discuss Case: WEBSDSS
  • Quiz #4 Ch. 8, 9 and 10
  • LAB: Submit Tutorial 7; start Tutorial 9
  • 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. (due 12/13, 10 points)

To Do and Upcoming

For Class Session 7 -- Wednesday, December 13, 2006

  • Complete and submit Tutorials 9 and 10. Assignment for 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)

For Class Session 8 -- Wednesday, January 10, 2007

  • Exam (100 points) covers the content in Power Decision Support Systems: Concepts and Resources for Managers. The exam will include 40 multiple choice questions (60 points), 10 short answer questions (20 points), and 10 Excel multiple choice questions (20 points).