As I put together the Google Form for the student mock presidential election, I began to think to myself, "How can I display these results?" Even better, I began to think, "How can I display these LIVE results?!" And there came the challenge for the day. . . . .
So the government and econ teachers approached me to help with putting together their mock presidential election, which is done only with the senior class. Of course, my first thought was to use Google Forms! Perfect for this situation.
If you are thinking about using Google Forms in this kind of capacity, there are a few settings you should know about first.
Next, I knew that from the Google Form I could see a summary of the responses, but only those I shared the form with could see these responses. What if I wanted the entire staff to be able to view it. Or all of the students? And what if I wanted them to be able to see LIVE updates? I didn't just want to screenshot this. I wanted to have something dynamic. . . .and that's where my Google Sheets skills had to come into play!
First, I opened up my form results in Google Sheets, and I made a new Sheet. In this new sheet, I compiled the responses from the form responses onto Sheet2. To start, I renamed the sheet "Form Responses 1" to just "Sheet1." It simply made my functions easier.
Next, I used the COUNTIF function in sheets. What this function does is count the number of times a certain answer occurs in a cell range area. Take a look at my example below:
You can see that it is exactly the same as the Clinton function, only I changed the response it was looking for. The result was that it found this text 88 times in that row. So I went through and used this same function for ALL of the results, adjusting along the way as needed. For example, when I was figuring out the results from the US Senate race, the function looked like this:
You can see that I changed not only the text it was looking for, but I changed the ROW it was looking in as well. We are no longer looking in row B for this result. We're looking in row C because this is the next question on the Google Form.
After I was done creating all of the tables for everything the students were voting on, I created pie charts from those tables.
I copied this embed code into my website (I won't explain how because every website builder works a little different). By doing it this way, the results of the Google Form are refreshed every 5 minutes to give up-to-date results!
This took a LONG time to process in my brain, but I was excited to try out some new Google Sheets skills of mine! This was MUCH better than just doing some screenshots throughout the day.
Take a look at the video below for how it turned out! This was a great experiment that had a BIG learning curve! But I'm proud of the results.
Jennifer Zimny has been a teacher librarian at Ponderosa High School for the past five years and previous to that, she was the drama teacher for 9 years. She holds a BA in Theatre from CSUS, a teaching credential in English, and a teaching credential in Library Media Services from Azusa Pacific University
Follow me on Twitter, Instagram, and Pinterest