Session 19

Decision Support Systems 150:127 -- D. Power

Today's Agenda -- Tuesday, March 20, 2007

  • Presentation of Eric Vollmer "Anderson Clayton Corp. Delivers Real-Time Business Intelligence to U.S. Cotton Growers" Grade Recap report
  • Presentation of Documentum Staff, "Optimizing Aircraft Maintenance Operations using a Document-driven DSS"
  • Excel review: Functions (ISNA, VLookup, IF), data validation, types of formula errors, macros, VBA
    1. Nine IS functions check the type of value and return TRUE or FALSE depending on the outcome. For example, the ISBLANK function returns the logical value TRUE if value refers to an empty cell; otherwise it returns FALSE. ISNA refers to the #N/A (value not available) error value.
    2. VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match.
    3. IF(logical_test,value_if_true,value_if_false) Up to seven IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. SUMIF, COUNTIF.
    4. Example nested IF. =IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F"))))
  • Chapters 5-8 review

To Do and Upcoming

  • March 22, 2007, Exam #2. Format is 28 2 pt. multiple choice questions on DSS Book Ch. 5-8; 10 2 pt. multiple choice and short answer questions on Excel Tutorials 1,2 & 3; Choose 4 of 5 short answer questions (3 pts. each, can get 3 bonus pts. by answering all questions); and choose two of three 6 pt. questions (12 pts. total) about assigned DSS cases (open book/notes). Total 100 points. No Excel hands-on.
  • Due Thursday, March 29. Project Deliverable #2. Model specification and project plan (25 points)
  • Read Ch. 9. Building Knowledge-driven DSS and Mining Data