Session 7

MBA MIS 150:249

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

  • Quiz #4 Ch. 8, 9 and 10
  • Exam Review
  • Submit Tutorial 9
  • Finish 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)

To Do and Upcoming

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).

For Class Sessions 9 & 10 -- Assigned cases in presentation order. 15 minute presentations (PPT max 15 slides -- case summary, analysis of major issues, and lessons learned). Written analysis 5-7 pages due Jan. 24.

Wed., January 17, 2007

  1. Brandi Glasnapp Case #15 "George Washington University Data-Driven Decision Support Project"
  2. Linda Kobliska Case #23 "SunTrust 'Banks' on Crystal Ball"
  3. Helen Miao Case #8 "University of Alberta increases timely access to policies and procedures"
  4. Karolina Rosty Case #26 "Naval Medicine CIOs use collaboration and knowledge-sharing decision support application"
  5. Tori Stafford Case #26 "University of Northern Iowa Dining Services uses FoodProŽ"
  6. Shintawati Case #14 "Bayer's unique planning wizard system cures budgeting headaches"
  7. Brenda Barth Case #43 "Understanding customers' preferences at Applebee's International"
  8. Ryan Pautsch Case #6 "Briggs & Stratton harnesses operational data"
  9. Steve Forest Case #10 "PADAL helps US Navy aircraft land aboard carriers"
  10. Rachel Jackson Case #1(new) "From Information to Answers: Transferring Expertise at the SBA"
  11. Bjork Sigurgisladottir Case #32 "Business Intelligence = $$$ for ShopKo Stores"

Wed., January 24, 2007

  1. Melinda Jackson Case #44 "Closing the Tax Gap in Iowa"
  2. Jacob Jackson Case #13 "Pfizer uses Alphablox Web-based platform"
  3. Raghunath Aerabati #12 "E-Docs Asset GIS: Washington County, Iowa"
  4. Emre Ozdogan Case #28 "Merck Deploys Web-Based Drug Discovery Visualization System"
  5. Manoj Bhandari Case #47 "Developing a Portfolio Approach to Capital Investment: U.S. Department of Veteran's Affairs"
  6. Emmanuel Rivera Case #46 "Rebuilding an Emergency Operations Center for NYC following 9/11"
  7. Curt Hudnutt Case #45 "Anderson Clayton Corp. Delivers Real-Time Business Intelligence to U.S. Cotton Growers"
  8. Dallas Vit Case #42 "Estimating software yields higher profits at Liberty Brass"
  9. Jared Kremer Case #20 "BMW Manufacturing operation in South Carolina"
  10. Cory Anderson Case #30 "Decision Support for Mayfield, NY Fire and Emergency Medical Services"
  11. Eric Ponto Case #18 "Shell Delivers the New Face of Fuel Retailing with Business Objects"
  12. Dan Ring Case #7 "Decisions at the touch of a button"