22 February 2017

Sphero Olympics 4 - Mile Run Google Sheets

Doing the Sphero Olympics has allowed us to use a Google Suite for Education App that we don't normally use very often in elementary school. Google Sheets allows us to look at numerical data to compare sets of numbers. For the Sphero Games, we used a spreadsheet to keep track of each group's time for the Mile Run - four times around our 10' by 6' track.

We also talked about conditional formatting - how we can highlight the fastest time (smallest number) in green, the slowest time (largest number) in red, and then have the middle time (median) in yellow.

Finally, we talked about how we could use a formula to find the fastest time and put it in a row by itself at the bottom so we could easily find out who was the fastest in all of 3-6th grade!

Check out our spreadsheet of results below!

   

No comments:

Post a Comment