ETM 3310 Excel Charts & Data Visualization

What does “strive for clarity and simplicity” in data visualization mean?

a) Maximize impact while minimizing noise

b) Include as much data as possible for completeness

c) Use complicated designs to impress the audience

a) Maximize impact while minimizing noise

If an element in a chart doesn’t add value or serve a purpose, what should you do?

a) Keep it to show thoroughness

b) Remove it to reduce clutter

c) Highlight it with bright colors

b) Remove it to reduce clutter

What is the purpose of creating a narrative in data visualization?

a) To make charts visually appealing

b) To tell a story and communicate key insights clearly, quickly, and powerfully

c) To include every data point available

b) To tell a story and communicate key insights clearly, quickly, and powerfully

What is the key consideration when striking a balance between design and function?

a) Making the chart as colorful and artistic as possible

b) Using multiple chart types to make the chart complex

c) Selecting the right type of chart to effectively communicate data

c) Selecting the right type of chart to effectively communicate data

Which statement best captures the ideal approach to design and function?

a) Beautiful is good, functional is better, and both is ideal

b) Function is not important if the chart looks attractive

c) Only beauty matters, not clarity or impact

a) Beautiful is good, functional is better, and both is ideal

“Dynamic formatting helps to strengthen the story”

“Clean, simple visualization with animation over time”

“Simple, intuitive custom chart design”

What do these qualities represent?

a) The good

b) The bad

c) The ugly

a) The good

“All design, no function”

“Busy, no clear narrative”

“Misleading chart type”

What do these qualities represent?

a) The good

b) The bad

c) The ugly

b) The bad

“Misleading y-axis scale

“Too many elements, distracting 3D design”

“Improper use of percentages & inconsistent scaling”

What do these qualities represent?

a) The good

b) The bad

c) The ugly

c) The ugly

What is the first key question to ask when creating a data visualization?

a) Who is the end user consuming this information?

b) What type of data are you working with?

c) What colors should be used in the chart?

b) What type of data are you working with?

Which of the following is an example of a data type you might consider?

a) Integer, real, categorical, time-series, geo-spatial

b) Analyst, CEO, client, intern

c) Relationship, comparison, composition

a) Integer, real, categorical, time-series, geo-spatial

What is the second key question to ask when creating a data visualization?

a) What type of data are you working with?

b) Who is the end user consuming this information?

c) What are you trying to communicate?

c) What are you trying to communicate?

Which of the following is an example of something you might want to communicate in a visualization?

a) Relationship, comparison, composition, distribution, trending

b) Integer, real, categorical

c) Analyst, CEO, client, intern

a) Relationship, comparison, composition, distribution, trending

Why is it important to consider who the end user is?

a) It decides what colors to use in the chart

b) It determines the chart type and how information is presented

c) It tells you which data types to remove

b) It determines the chart type and how information is presented

Which type of chart is best for showing numerical data across categories, such as total revenue by region?

a) Bar & Column Charts

b) Line Charts

c) Pie Charts

a) Bar & Column Charts

Which chart type is specifically used to show the distribution of a continuous data set?

a) Radar charts

b) Histograms & Pareto Charts

c) Area Charts

b) Histograms & Pareto Charts

What is the main purpose of a Line Chart?

a) Compare values totaling 100%

b) Show how values change over time

c) Show change in data composition over time

b) Show how values change over time

Which chart type would you use to show change in data composition over time, like yearly sales of a product?

a) Pie Charts

b) Heat Maps

c) Area Charts

c) Area Charts

Which chart is ideal for comparing parts of a whole, like the percentage of employees by department?

a) Pie Charts

b) Bar & Column Charts

c) Radar Charts

a) Pie Charts

What is a common use of Radar Charts?

a) Showing trends over time

b) Plotting three or more quantitative variables relative to a central point

c) Comparing values totaling 100%

b) Plotting three or more quantitative variables relative to a central point

Which chart type uses color scales to visualize trends or relationships, such as accident rates by time of day?

a) Line Charts

b) Bar Charts

c) Heat Maps

c) Heat Maps