BE SURE TO WATCH THE VIDEOS ATTACHED TO HELP WITH THE ASSIGNMENT.
PART 1
Conduct your own online research to find data on a topic you find interesting. While you are not required to use these specific data sources, here are a few to reference:
- United States Census Bureau: A source with a wide variety of data about the U.S. population
- ESPN: This website contains a wide variety of sports data
- Nielsen Top 10: Provides current top 10 data for streaming, TV, advertising, and video games
5. Collect one piece of data for at least ten items and type those into an Excel spreadsheet. The data can cover any topic that you choose. As an example, here is what this assignment would look like if the selected data was about passing stats for NFL quarterbacks in 2020:
NOTE: You are not allowed to use this exact example for your assignment. You are, however, welcome to collect NFL passing stats for 2021 (or any year besides 2020).
6. Download this worksheet:
PART 2
Watch the following video on the importance of data visualization and the different ways that data can be presented:
The Value of Data Visualization
2. Visit this site to see examples of visualized data:
3. Open your 2.2 Excel table you created and watch this video on how to create graphs and charts in Excel:
Create your four data visualizations and then save your Excel document when finished.
5. TEMPLATE ATTACHED BELOW
2.2 Data Table Assignment Worksheet
Name: (insert your name here)
1. What did you collect data on?
2. Copy and paste your data table below. You can do this by selecting only those cells in the spreadsheet that have data and then doing a copy and paste.
(insert data table here)
3. What is something important that the data table shows? (3–5 sentences)
4. What surprised you most about the data you found for this assignment? (3–5 sentences)
5. Describe your experience completing this assignment? (Was it good, bad, hard, easy, interesting, etc.?) (3–5 sentences)
,
Data Visualization Reflection
· Write a brief reflection (150-200 words) on which graph/chart is most effective in visually presenting the data from your 2.2 Excel table.