Due January 27 CS 4460/7450 - Information Visualization Spring 2009

Homework 2: Table and Graph Design

The purpose of this assignment is to provide you with practice and experience designing the appearance of data tables and graphs. Below are two Excel spreadsheets. For the first, you should create a table that presents its information as clearly and informatively as possible. For the second, design a graph that does the same. Think about the data in each spreadsheet and what an analyst looking at that data would care about. You are allowed to derive new variables too. Do not just make up new attributes, however.

You should simply turn in your table and your graph. Remember to turn in two copies of each.

Grading: We will evaluate the effectiveness and design aspects of your creations. Of course this is subjective, but we will look for tables & graphs that apply the design recommendations discussed in class and in our readings.

Performance of sales representatives (xls format)
Performance of different company departments over year (xls format)