How to use Google Docs for Live Polls and Quizzes

Add to iTunes | Add to YouTube | Add to Google | RSS Feed

Did you know you can create a live poll using Google Docs and Spreadsheets? It’s quite simple, really. I stumbled across this recently when I needed to do a poll for something in a hurry, and needed to keep it anonymous. Here are the steps you need to take, in order to create your own poll or quiz!

  • Click New>Spreadsheet in Google Docs.
  • Click the “share” tab, and then title your poll.
  • Select “invite” to invite people to fill out the form.
  • Create the form with your possible answers.
    • Put in however many choices you want people to have.
    • Add Help text if you want.
    • Question Type: You can choose from text, paragraph text, multiple choice
    • I populated with numbers, so I could get the Spreadsheet application to interpret the data.
  • Choose recipients… either by adding your contact list… or giving out the URL to others.
    • Set up a formula to interpret and see your data.
    • In the next available column, type: =countif(B2:B500, 1) (this is just an example… use the proper rows and columns from your particular sheet).
    • Continue to make formulas for each of your answer possibility. For my second one, the formula was: =countif(B2:B500, 2)
  • I then wanted to create a chart to show my data. I entered another formula (C2:C4) and clicked the Chart button.
  • Choose the type of chart, and what cells you want the chart to graph for you.
  • Title your Chart, and choose your axis points.
  • If you want, you can format the number cells to hide them. I just made the font white, so it didn’t show.
  • Now I’m ready to publish my chart with the poll results. You can even choose to automatically re-publish and update every five minutes… and then share the link via RSS feed, or URL.

Pretty cool, eh? The wonders of technology never fails to amaze me!