Q5 Case Cracking Formulas: Learning Sum-thing

Sum & Average are the Key!

After playing the video, you recall the spreadsheets you found earlier.  Ah-ha, there was a minifig spreadsheet!

Step 1. Go to your Thing 13 Data Detectives folder, where you have the Funko Pop Spreadsheet saved.  Use the copy that you already have saved.

• Answer the question from the overhead in the classroom.
  • What is the value of "All the Funko Pops?"
  • You may want to play the video on the Clue Calculations page again, starting at timestamp 2:27 min.

Step 2. Now, you need to deal with the basketball clue, and it must do with one last spreadsheet. From the 13. DD Spreadsheet Folder, select the Sports Cards 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 3. Find the average of Points per Game (Column D).  

• Again, the video will provide the steps on how to find the average in a spreadsheet.

Step 4. Go to your 13. Data Detective Notebook that you have saved in your Thing 13 Data Detectives  Folder. On slide 11, Q5 Case Cracking Formulas: Learning Sum-thing:

• Record your answers to the posted questions and prompts.