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!

43 thoughts on “How to use Google Docs for Live Polls and Quizzes”

  1. Pingback: ITLnet Blog
  2. Pingback: Geek Picks
  3. Pingback: News
  4. Pingback: GeekPicks
  5. polls are soo scewed. To see if people like Frosted flakes, u canask around for opinions. Who ever says yes will be taken to a room and then “officially” take the poll. They will all say yes, and the poll will say kids like Frosted Flakes.

    sooooooooo untrustworthy

  6. Plug your speakers in…
    there is a sound bar scroller by the time on the video, make sure that is to the right…
    make sure your speakers are plugged in….

  7. ok why dont google make a simple online thingy to make poll quistionere :S ? this way is time consuming and kinda hard

  8. Hi!

    Thank you for the tip, i’ve used this several times since i saw the movie.
    Hope you continue with this.

    //SwedenPro

  9. You know, this is pretty cool. Another free app brought to you by Google. I am definitely going to use this on my class. Spreadsheets basically have no limitation and this is amazing just for the simple fact that you can use it in real time.

  10. Google Docs sounds like a great thing. I still haven’t tried but I will. Thats just shows that more Apps are being replaced with the Internet. Things that we would need a certain Program to do can now be done online at a website such as Google Docs or AniMoto. Soon more things will be able to be done online.

  11. I was there for that video, a lot of people started voting more than once, I bet now Google is going to create a system for this because of you :) you tend to be a big influence lol.

    Google docs just needs to develop a bit more in some areas, as polling. I would also see security being a big hazard, i guess they have good security, but still I wouldn’t want all my work documents online.

  12. i do not mean to advertise in a post, but anyone who owns a video game console should try xlink kai. It is a free way to play games online. if you use xlink kai, put this on every post.

  13. PLEASE DON’T READ THIS. YOU WILL GET KISSED ON THE NEAREST POSSIBLE FRIDAY BY THE LOVE OF UR LIFE. TOMORROW WILL BE THE BEST DAY OF UR LIFE. HOWEVER IF YOU DON’T SEND THIS TO AT LEAST 3 VIDEOS YOU WILL DIE IN 2 DAYS. NOW UV STARTED READIN DIS DUNT STOP THIS IS SO SCARY. xSEND THIS TO OVER FIVE QUIZZES IN 143 MINUTES WHEN UR DONE PRESS F6 AND UR CRUSHES NAME WILL APPEAR ON THE SCREEN IN BIG LETTERS. THIS IS SO SCARY BECAUSE IT ACTUALLY WORKS 6!!!!

  14. thanks great post. is there a way to make the responses not anonymous? i would like to know who answered what. any help?

  15. WTF how can i make it to restrict people from reposting on the same poll ?????? and it should be handled remotely
    as some free online polls provide this functionality but as soon as you delete cookies and refresh the page you can
    ote once more … ??????

Leave a Reply

Your email address will not be published. Required fields are marked *