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)