## 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

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

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

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

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 ﬁltered 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

Proﬁt

Proﬁt

Proﬁt

Table with Embeded Chart

Order Date / Category Pr oﬁ t

-1 ,281 22 ,121

Sum of Proﬁt for each Category broken down by Order Date Year vs. Region. Color shows sum of Proﬁt.

Proﬁt

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

Oﬃ 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. Proﬁts for Sub-categories

50K

40K

30K

20K

Proﬁt

10K

0K

-10K

-20K

0K 50K 100K 150K 200K 250K 300K

Sales

Sum of Sales vs. sum of Proﬁt. Details are shown for Sub-Category. 11

Assignment 3.4.6 – Bubble Chart

Scatter Plot-Sum of Sales vs. Proﬁts for Sub-categories

60K

50K

40K

Avg. Discount

0.0687

0.2000

0.3000

0.3723

Category

Furniture Oﬃce Supplies Technology

30K

20K

Proﬁt

10K

0K

-10K

-20K

0K 50K 100K 150K 200K 250K 300K 350K

Sales

Sum of Sales vs. sum of Proﬁt. 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

Oﬃce 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 Proﬁt for Product Category

700K

Category

Furniture Oﬃce 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 Oﬃce 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 ﬁltered on Region, which keeps East. 15

##### Reference no: EM132069492

Generated by Feedzy

Get Homework Help Online From Expert Tutors

X