Q4 Visualizing the Clues: Slice of Evidence
Starting to Visualize the Data
Your investigative mind is thinking about the other spreadsheets in the folder that you saw earlier. What is the connection?! There has to be something in the Squishmallows spreadsheet. You take another look at the note, there’s a website hidden at the bottom. Grab your magnifying glass and check out where it takes you.
<need to update url add in image of the website in the magnifying glass.>
It is a video about changing the spreadsheet so that a pie chart can be created. Great, play the video below and think about the steps that need to be taken to create a pie chart.
Direct link (1:29 min.)
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
5. Computational Thinker
b. collect data or identify relevant data sets
6. Creative Communicator
c. communicate complex ideas clearly and effectively by creating or using a variety of digital objects such as visualizations, models or simulations
d. publish or present content that customizes the message and medium for a variety of audiences