Q4 Visualizing the Clues: Slice of Evidence
Starting to Visualize the Data
Your investigative mind is thinking about the other spreadsheets in the folder you saw earlier. What is the connection?! There has to be something in the Squishmallows spreadsheet. The note had two specific questions about Zanda in the Squishmallows data. It must be something visual!
The video below shows how to update the spreadsheet data to create a pie chart. Great, play the video below and think about the steps needed to create a pie chart.
Direct link (1:29 min.) | T13.Q4 Pie Chart Video Script
Creating Your Pie Chart Visual
Now that you have seen how to create a pie chart, let's give it a try. You know there is something meaningful to be found in the Squishmallows 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 Squishmallows 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 pie chart of the Squad data (column C).
- You may have to play the T13.Q4 Pie Chart video again and pause it as you complete the steps needed to create your own pie chart of the Squad data.
Step 3. Go to your 13. Data Detective Notebook that you have saved in your Thing 13 Data Detectives folder. On slide 7, Q4 Visualizing the Clues: Slide of Evidence:
- Record your answers to the following questions:
- What Squad does Zanda belong to?
- What percentage of the Squishmallows are in that Squad (round up!)?
- Copy the pie chart that you created and paste it at the bottom of slide 7.
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.