## 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: