Thursday, March 1, 2012

Tool #4: Google Forms

Google Forms is used to solicit responses from people. The results of surveys, tests/quizzes, questionnaires, meeting evaluations, or votes are automatically transferred to a Google spreadsheet, which has built-in result summary charts and diagrams.

To complete the requirements for tool #4:
1. Create a Google form with at least 3 questions, preferably of different types. Available question types are: text (for short answers), paragraph text (for longer answers), multiple choice, check boxes, choose from a list, scale (eg. on a scale of 1-5…), and grid.
2. Share the form with hilgendorfd@apps.district279.org
3. Mail the form to at least 3 respondents. If the form is not based on an actual need, please ask other TTT participants to respond. In this case, make your forms short and easy so we don’t overburden the TTT participants.
4. Respond to any live forms that you receive.
5. Respond to the Google form posted on the blog. It’s the entry prior to (below) this one. You can also find it in the Quick Links to the right, or at Tool #4 Google Form to Complete
6. View your Google spreadsheet on your Moodle/Osseo Apps account.
7. View the response summaries.
8. If you haven't been making new posts to your blog, write one about this tool, after you try it out. 
Here is a nearly 13-minute-long screencast showing how to do these things. This can also be viewed on You Tube here.

2nd Year Participant Requirements:
(Optional challenge activities for first year participants)
Try any or all of these, if you want to expand your use of this tool.
  • Try out 4-6 questions types.
  • Prepare a quiz or pre-test for your class. Use something that you would actually be giving the class. If you don’t have a class, send out a different survey that meets a genuine need.
  • Embed the form in your blog (or another web page for which you have editing rights) and direct respondents to the page, rather than send this form out as an e-mail. If you use this technique and you want to know who made which response, you will want to include a question that asks for their name. To embed a form, go to the spreadsheet for the form and select “Embed form in a webpage” from the “Form” menu.
  • When the results are in, use the Snipping Tool (part of the Windows 7 operating system) to copy a chart onto a Google docs Presentation slide (or more slides). Feel free to give them titles and any other information to make it clear what you are sharing and why.
  • Share the Presentation with someone. Feel free to share it with hilgendorfd@district279.org, if there is no genuine need to share the information with someone else.
  • If you have text answers, you may want to try copying the answers from one of your questions and pasting them into Wordle.com to create a visual image of the results. This allows you a quick visual synopsis of the words that respondents used to answer a question, with more frequently used words larger. If you do this, I also recommend randomizing the resulting Wordle until you find one that you especially like.To make a file of the Wordle, you will need to take a screenshot of it, either using the Snipping Tool or Command-Shift-4 on a Macintosh computer.
Recommended Action:
  • On a semi-related note, I recommend that you forward your apps emails to your regular address. This way you don’t have to check both accounts. To do this, 
  • Open your e-mail from Osseo Apps. That’s your @apps.district279.org account. 
  • Click on the little gear icon to the right of your user name at the top right corner of the e-mail page and open “Mail Settings.” 
  • Click on the blue “Forwarding and POP/IMAP” menu. 
  • Under “forwarding,” forward a copy of incoming email to [your regular address] and “mark Osseo Area Schools Mail’s copy as read.”

4 comments:

  1. Perfect! I was trying to create a google form for Tool 2 and I was a little lost. I hope this will help me.

    ReplyDelete
  2. Any feedback on how to clear a form? I want to send a form that I've used for a class in the past but don't want all their data on it. I feel like I could make a copy but then how do you reset it to clear the data? Help!

    ReplyDelete
    Replies
    1. I also have this problem and NO SOLUTION. I ended up copy/pasting the whole form, then deleting all the answers, then re-typing the heading. Not LOL.

      Delete
  3. Megan,
    I suggest making a copy and then deleting all the rows from the new spreadsheet except the headers. This will create a new form/survey as well as a new spreadsheet.
    Let me know if that works for you.
    -Dhaivyd

    ReplyDelete