Exploring the Number pi with Google Sheets & Forms

What better way to celebrate Pi Day than with a hands-on, tech-on exploration activity that helps students build their own understanding of what pi really is?  Well, probably a good piece of pie, but this is awesome nonetheless.

Here’s what you do:

  1. Get a bunch of fabric tape measures (using string and then measuring lengths on the string works too).
  2. Get a bunch of circular objects.
  3. Have kids measure the circumference and diameter of different circular objects.
  4. Instruct the kids to submit their measurements to a Google Form
    (note: my form doesn’t collect names, but it would be best to collect them so you can help kids who have measurement errors).
  5. Setup a QUERY formula to find the circumference/diameter for each entry.
    =QUERY(B2:C1000, “select B/C”)
  6. Fix that pesky 2 in the Query formula after the first submission – when the first entry inserts a row, it changes B2 to B3.  Change it after the first entry and you’re good to go.
  7. Setup an AVERAGE formula to find the mean of the circumference/diameter calculations.
  8. Project the spreadsheet as entries are recorded.  See what your kiddos notice about the numbers they see on their screen!

Duplicating Google Forms Tabs

The Duplicate Tabs button is probably an under-used option for most people.  However, it can really come in handy.  Every now and then, I need to keep a specific email open, but get back to my inbox.  Duplicate Tab.  Sometimes, I need to have a course in Schoology open, but open another.  Duplicate Tab.  One of my favorite uses, though, is when I have more than one Google Form submission that I have to fill out and they all have some similar entries (i.e., multiple session proposals for a conference, discipline referrals for the same incident with different students).  Dup-li-cate Tab! Check out how that looks in the GIF below: