Q4 Visualizing the Clues: Stacking the Evidence
More Ways to Visualize the Data
Your investigative mind is still thinking about the other spreadsheets in the folder that you saw earlier. What are some more connections? There has to be something in the Harvest Dance spreadsheet. You recall that the words in the magnifying glass were "Slice" and "Stack". You now know that the slice was referring to a slice of the pie chart. So, what about the stack?!
Let's play the video below to see if it provides any meaningful information about what the stack could be.
Direct link (0:56 min.) | T13.Q4 Column Charts Video Script
Creating Your Column Chart Visual
Now that you have seen how to create a column chart, let's give it a try. You know there is something meaningful to be found in the Harvest Dance spreadsheet that you saw earlier. Let's see if you can find out what it is.
Step 1. From the 13. DD Spreadsheet Folder, select the Harvest Dance spreadsheet (or use this direct link).
- If you are a Google User, make a copy and save it in your Thing 13 Data Detectives folder.
- If you are a Microsoft User, download a copy and then upload it into your Thing 13 Data Detectives folder.
Step 2. Create a column chart of the Song data (column B).
- You may have to play the T13.Q4 Column Charts video again and pause it as you complete the steps needed to create your own column chart of the Song data.
Step 3. Go to your 13. Data Detective Notebook that you have saved in your Thing 13 Data Detectives folder. On slide 8, Q4 Visualizing the Clues: Stack of Evidence:
- Record your answers to the following questions:
- Which song should be played first?
- Why did you choose that song?
- Copy the column chart that you created and paste it at the bottom of slide 8.
Competencies & Standards
MITECS Michigan Integrated Technology Competencies for Students, and
1. Empowered Learner
d. Understand fundamental concepts of how technology works, demonstrate the ability to choose and use current technologies effectively, and are adept at thoughtfully exploring emerging technologies.
5. Computational Thinker
a. Formulate problem definitions suited for technology-assisted methods such as data analysis, abstract models, and algorithmic thinking in exploring and finding solutions.
b. Collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.
c. Break problems into component parts, extract key information, and develop descriptive models to understand complex systems or facilitate problem-solving.
6. Creative Communicator
c. Use digital tools to visually communicate complex ideas to others.
d. Publish or present content that customizes the message and medium for their intended audiences.