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

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