Due September 6 CS 7450 - Information Visualization Fall 2011

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 (attributes) that are combinations of the given ones, but you cannot make up totally new variables and values.

You should simply turn in your table and your graph.

Grading: We will evaluate the effectiveness and design aspects of your creations. Of course this is subjective, but we will look for tables and 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)