Lesson 3
Design Assignment
Assignment 3.1 – Creative Bivariate Representation Assignment 3.2 – Representation – what they want to know? Assignment 3.3 – Representation
Assignment 3.4 – Tableau Exercises (9)
Prepare in a Google Drive Folder/File for each of the Assignment 3.1, 3.2, and 3.3
Prepare Prepare a slide packet (e.g., powerpoint, keynote, etc.) and submit in Canvas for 3.4.
Even in the single ppt slide, take consider “Information Visualization” to present your idea Clearly put your name on each slide (except 3.4)
1
Assignment 3.1 – Creative Bivariate Representation
Using the data set below – create either a bivariate representation of some or all of the data.
You can create your diagram in Excel or by hand or by any other method. You can paste it as a photo or screen capture. Explain why you chose the representation that you chose. (in a single ppt slide).
Prepare in
https://docs.google.com/presentation/d/1_PVypCeFDPVxPiEABxK-HCXPlI3TWpVeHaH0vj1lf30/edit?usp=sharing
Temperature (Celsius)
Ice Cream Sales (US Dollars)
14
170
18
230
11
150
22
350
25
480
17
190
30
540
12
150
26
425
19
150
21
355
28
535
2
Assignment 3.2 – Representation – what they want to know?
Five students have taken exams in eight subjects and for each subject a mark out of ten has been assigned.
Make a list of the questions that might be asked of this data by
a student,a parent, anda subject teacher.
Aim for a total of at least six questions (at least two questions for each group).
Prepare in
https://docs.google.com/presentation/d/1pf8Tp-FJpzkaBdPZ7ChvVFgigOphKzfcVaBsIfF4sSc/edit?usp=sharing at Assignment 3.2 page.
3
Assignment 3.3 – Representation
The performance of the students mentioned in Assignment 3.2 is as follows:
Student
A
B
C
D
E
Art
10
Science
10
History
Sport
10
Physics
English
Chemistry
Mathematics
10
Using any kind of media (hand drawing is also welcome), sketch one static representation of this data: no interaction with the representation is to be considered. Then see whether it answers any of the questions identified in the Assignment 3.2.For the questions identified in the Assignment 3.2, and whose answer cannot easily be found, see whether you can make a useful modification to the representation, still without employing interaction.
Please complete both (a) and (b) in a single ppt slide.
Prepare in https://docs.google.com/presentation/d/1pf8Tp-FJpzkaBdPZ7ChvVFgigOphKzfcVaBsIfF4sSc/edit?usp=sharing at Assignment 3.3 page.
4
Assignment 3.4 – Tableau Exercises
Using the dataset that we have used during class (“Sample – Superstore2020.xls”), replicate the chart in next slides (Assignment 3.4.1~3.4.9)
May vary format (color, size, etc.) but contents in the chart (e.g., axis, unit, type of chart) must be same to the sample.Use of Tableau is recommended. But you may use any application to replicate it.Put your name on the chart and past it on each ppt slide.Please prepare a ppt slide packet and submit in Canvas (only for this 3.4)
5
Assignment 3.4.1- Bar Chart 1
Bar Chart- Sum of Sales for States in Central Region
St a t e
Texas Illinois Michigan
Indiana Wisconsin Minnesot a Missouri
Oklahoma Nebraska
Iow a
Kansas South Dakot a North
Dakota
0K 10K 20K 30K 40K 50K 60K 70K 80K 90K 100K 110K 120K 130K 140K 150K 160K 170K
Sa le s
Sum of Sales for each State. The data is filtered on Region, which keeps Central.
6
Assignment 3.4.2- Column Chart
HCDE 530: Information Visualiz
Sales
7
Assignment 3.4.3- Table with Embedded Chart
Profit
Profit
Profit
Table with Embeded Chart
Order Date / Category Pr ofi t
-1 ,281 22 ,121
Sum of Profit for each Category broken down by Order Date Year vs. Region. Color shows sum of Profit.
Profit
8
Assignment 3.4.4- Single Line Chart
Single Line Chart-Sum of Quantity for Months (across year)
6000
5500
5000
4500
4000
3500
Quantity
3000
2500
2000
1500
1000
500
0 January February March April
Order Date
May June July August Septemb.. October November December
The trend of sum of Quantity for Order Date Month. 9
Assignment 3.4.4- Multiple Line Chart
Multiple Line Chart- Sum of Categories
250K
Order Date
Category
Furniture
Offi ce Supplies Technology
200K
150K
Sales
100K
50K
0K
2014 2015 2016 2017
The trend of sum of Sales for Order Date Year. Color shows details about Category. 10
Assignment 3.4.5- Scatter Plot
Scatter Plot-Sum of Sales vs. Profits for Sub-categories
50K
40K
30K
20K
Profit
10K
0K
-10K
-20K
0K 50K 100K 150K 200K 250K 300K
Sales
Sum of Sales vs. sum of Profit. Details are shown for Sub-Category. 11
Assignment 3.4.6 – Bubble Chart
Scatter Plot-Sum of Sales vs. Profits for Sub-categories
60K
50K
40K
Avg. Discount
0.0687
0.2000
0.3000
0.3723
Category
Furniture Office Supplies Technology
30K
20K
Profit
10K
0K
-10K
-20K
0K 50K 100K 150K 200K 250K 300K 350K
Sales
Sum of Sales vs. sum of Profit. Color shows details about Category. Size shows average of Discount. 12
Details are shown for Sub-Category.
Assignment 3.4.7 – Stacked Columned Chart
Stacked Column Chart- Sum of Yearly Sales for Product
Category
700K
Order Date Category
Furniture
Office Supplies Technology
600K
500K
400K
Sales
300K
200K
100K
0K
2014
2015
2016
2017
Sum of Sales for each Order Date Year. Color shows details about Category. 13
Assignment 3.4.8 – Stacked Area Chart
Stacked Area Chart- Sum of Yearly Profit for Product Category
700K
Category
Furniture Office Supplies
Technology
600K
500K
400K
Sales
300K
200K
100K
0K
2014 2015 2016 2017
Year of Order Date
The plot of sum of Sales for Order Date Year. Color shows details about Category.
14
Assignment 3.4.9 – Spatial map
Spatial Map-Proportion of Category (Pie chart) to Sum of Sales for Eastern States
Sales
1,210
100,000
200,000
310,876
Category
Furniture Office Supplies
Technology
Map based on Longitude (generated) and Latitude (generated). Color shows details about Category. Size
shows sum of Sales. The marks are labeled by State. The data is filtered on Region, which keeps East. 15
