Q4 Visualizing the Clues: Stacking the Evidence

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 Chart 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.