Module 4: Milestone 2
The objective of this milestone is to analyze data using aggregate functions, calculated fields, parameters, and table calculations, and create effective data visualizations.
Prompt
In the first milestone, you came up with 10 questions that you could answer using the dataset you chose. You also identified 10 chart types to answer those questions. For this assignment, you will first answer the following questions:
Next, you will construct charts using Tableau. It is expected that you have one chart for each question. Thus, if you have 10 questions, you should have 10 charts minimum. As you construct your charts, address the following:
- Use one of the following in one of your charts: aggregate functions or calculated fields.
- Use one of the following in one of your charts: parameters or table calculations.
Next, you will write a short paper on the data analysis process by addressing the following questions:
- How did you use an aggregate function or calculated field in your data analysis?
- How did you use parameters or table calculations in your data analysis?
To successfully complete this assignment, view the following:
Milestone 2 Rubric | ||
---|---|---|
Criteria | Ratings | Pts |
Aggregate Functions or Calculated Fields |
10 pts Proficient Demonstrates a sophisticated knowledge of aggregate functions or calculated fields through the correct use of aggregate functions or calculated fields on the charts; and explains in detail how to use aggregate functions or calculated fields in data analysis. 8.5 pts Satisfactory Uses aggregate functions or calculated fields on the charts correctly; and explains how to use aggregate functions or calculated fields in data analysis. 5.5 pts Needs Improvement Uses aggregate functions or calculated fields on the charts; but the explanation how may be unclear, or the use of aggregate function or calculated field may be incorrect. 0 pts Not Evident Does not use aggregate functions or calculated fields. |
/ 10 pts |
Parameters or Table Calculations |
10 pts Proficient Demonstrates a sophisticated knowledge of parameters or table calculations through the correct use of parameters or table calculations on the charts; and explains in detail how to use parameters or table calculations in data analysis. 8.5 pts Satisfactory Uses parameters or table calculations on the charts correctly; and explains how to use parameters or table calculations in data analysis. 5.5 pts Needs Improvement Uses parameters or table calculations on the charts; but the explanation how may be unclear, or the use of parameters or table calculations may be incorrect. 0 pts Not Evident Does not use parameters or table calculations |
/ 10 pts |
Gestalt Principles |
5 pts Proficient Demonstrates a sophisticated knowledge of Gestalt Principles through the appropriate and correct application of two of the three principles to make at least two charts more effective and explains in detail how these principles improve the charts. 4.25 pts Satisfactory Applies two of the three Gestalt principles to make at least two charts more effective and explains how these principles improve the charts. 2.75 pts Needs Improvement Applies one or two Gestalt principles to one or more charts, and the explanation how may be unclear, or the application of Gestalt principles may be incorrect. 0 pts Not Evident Does not apply Gestalt principles. |
/ 5 pts |
Preattentive Attributes |
5 pts Proficient Demonstrates a sophisticated knowledge of Preattentive Attributes through the appropriate and correct application of one of the attributes to make at least two charts more effective and explains in detail how this attribute improves the charts. 4.25 pts Satisfactory Applies one of the Preattentive Attributes to make at least two charts more effective and explains how this attribute improves the charts. 2.75 pts Needs Improvement Applies one Preattentive Attributes to one or more charts, and the explanation how may be unclear, or the application of Preattentive Attributes may be incorrect. 0 pts Not Evident Does not apply Preattentive Attributes. |
/ 5 pts |
Traditional Design Concepts |
5 pts Proficient Demonstrates a sophisticated knowledge of traditional design concepts through the appropriate and correct application of one of the design concepts to make at least two charts more effective and explains in detail how this concept improves the charts. 4.25 pts Satisfactory Applies one of the traditional design concepts to make at least two charts more effective and explains how this concept improves the charts. 2.75 pts Needs Improvement Applies one traditional design concept to one or more charts, and the explanation how may be unclear, or the application of design concept may be incorrect. 0 pts Not Evident Does not apply traditional design concept. |
/ 5 pts |
Mechanics |
5 pts Proficient No grammar or spelling errors that distract the reader from the content. Required tables are clearly labeled 4.25 pts Satisfactory Minor errors in grammar or spelling that distract the reader from the content. Required tables may be missing or not clearly labeled. 2.75 pts Needs Improvement Major errors in grammar or spelling that distract the reader from the content. Tables are not included. 0 pts Not Evident Critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas. |
/ 5 pts |
Visuals and Storytelling |
5 pts Proficient The choice of all visuals is excellent given the data and the story derived from the data. 4.25 pts Satisfactory Most of the visuals that are chosen are appropriate given the data and the story derived from the data. 2.75 pts Needs Improvement Some of the visuals that are chosen are appropriate given the data and the story derived from the data. 0 pts Not Evident None of the visuals that are chosen are appropriate given the data and the story derived from the data. |
/ 5 pts |
Content of Report |
5 pts Proficient The content of the written submission is well-presented and argued; ideas are detailed, developed and supported with evidence, data analysis, tables and figures. A non-technical audience can easily understand the content. 4.25 pts Satisfactory The content of the written submission is sound and solid; ideas are present. Most ideas are developed or supported with evidence, data analysis, tables, and figures. It may include some content that a non-technical audience may find difficult to understand. 2.75 pts Needs Improvement The content of the written submission is not sound. Few ideas are presented, and most of the ideas are not developed or supported with evidence, data analysis, tables, and figures. The report is too technical. 0 pts Not Evident The content of the written submission is inaccurate, unsupported, or very technical. |
/ 5 pts |
Total Points: 0 |