Courses/Computer Science/CPSC 203/CPSC 203 2007Summer L60/CPSC 203 2007Summer L60 Assignments

From wiki.ucalgary.ca
Jump to: navigation, search

CPSC 203 Summer Session 2007 Assignments

Assignment 1 is to create a dashboard in Excel

Steps:

  1. Use the template spreadsheet: ClassSurveySample_20070711.xls found on blackboard
  2. Fill in the following tabs: Introduction, Model, Data Dictionary. The model tab must include a rationale for the calculated fields you create, summary statistics, and dashboard design.
  3. Add to the Data Tab: New calculated fields and new summary statistics calculations. For top marks you must create a new calculated field using either an “If” or a “Lookup” function. Make sure it is clear what is “Raw Data”, what are “Calculated Variables” and what are “Summary Calculations”.
  4. Add to the Dashboard tab: 3 charts you have designed to summarize the data with appropriate titles, legends, and annotations. Include on the Dashboard tab a section where in a few sentences you interpret each chart. Make your information dashboard as clear, concise, and informative as possible, using good visual design principles.

Resources

  • Information Dashboard Design by Stephen Few
  • Visual Display of Qualitative Information by Edward Tufte
  • The elements of Graphing Data by William Cleveland
Retrieved from "http://wiki.ucalgary.ca/index.php?title=Courses/Computer_Science/CPSC_203/CPSC_203_2007Summer_L60/CPSC_203_2007Summer_L60_Assignments&oldid=9362"