Follow me on Twitter!

Contact Me

Google Forms Workshop

October 22, 2010 CCSD Tech Conference
http://bit.ly/tgforms

  1. Welcome and Introductions
  2. Getting to Know You form: 
    • Look at the question types you can use. 
    • Complete as you feel comfortable.
    • Look at the data in the spreadsheet and in the summary
  3. Idea for classroom use?  Add it to the Google Form Idea Form (see below).
  4. Let's Create a Form!
    • Step-by-Step
    • Question types
    • SAVE solidifies the order of the spreadsheet. 
    • Themes
    • Sending vs. Sharing
      • Share the form, send the form
      • Share the results
      • Purposes:  completion, collaboration
  5. Let's collect some data (send out to the people in our class only)
  6. Analyze the data, things you can and can't do with the spreadsheet.
  7. Advanced Functions
    • Notification settings
    • Collaboration ideas
    • Using/Submitting Templates
    • Forwarding
      • Add forwarding address (Work email---only IF your Google Docs account is NOT associated with your Work email)
      • From:  "Google Docs"
      • Confirm email from your email
      • Filter:  Mark as read, Forward it to (Work email)
  8. Q & A

Google Forms session ‎‎‎‎‎‎‎‎‎‎‎‎(CCSD Tech Conference)‎‎‎‎‎‎‎‎‎‎‎‎

Results from this form: 
If you can't view this spreadsheet, go to:  https://spreadsheets.google.com/ccc?key=0AskjsH6guGUjdGJoZl8tU1NXY0hHenFjOW03QjdXc1E&hl=en

Google Forms session ‎‎‎‎‎‎‎‎‎‎‎‎‎‎(CCSD Tech Conference)‎‎‎‎‎‎‎‎‎‎‎‎‎‎

Pay close attention to the different types of questions on this sample survey.
  • Text:  For short answers
  • Paragraph Text:  For longer answers
  • Multiple Choice:  When you want ONE answer
  • Checkboxes:  When you want more than ONE answer
  • Choose from a List:  Drop down menu, for ONE answer, works best when you have a really long list of choices...saves room on the page. 
  • Scale:  For getting a range of answers for TWO extremes.  On a scale of 0-10 (or anything within that range)
  • Grid:  Use for comparing several items with the same criteria, scheduling, etc.  Only one choice allowed in each ROW.
  • Other:  Section Header, Page Break (for longer forms)

Getting to Know You practice form ‎‎‎‎(CCSD Tech Conference)‎‎‎‎


Results from this form: 
If you can't view this spreadsheet, go to: https://spreadsheets.google.com/ccc?key=0AskjsH6guGUjdDk2cHcwS08yXzA0M3dURU5iSElGV1E&hl=en

Getting to Know You practice form ‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎(CCSD Tech Conference)‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎


What are some ideas you have for using Google Forms in your personal or professional life? 

Google Forms Idea Form ‎‎‎‎‎‎‎‎‎(CCSD Tech Conference)‎‎‎‎‎‎‎‎‎


Results from this form:
If you can't view this spreadsheet, go to: https://spreadsheets.google.com/ccc?key=0AskjsH6guGUjdHY0RTFBNy1fd1d3QWNUcGppVzkwX3c&hl=en&authkey=CNCG2qAJ

Google Forms Idea Form ‎‎‎‎‎‎‎‎(CCSD Tech Conference)‎‎‎‎‎‎‎‎



Tutorials and Tons of Other Resources 

http://sites.google.com/site/sciencequestpd/google-tools/google-form-tutorial

http://googledocs.blogspot.com/search/label/forms/

http://www.teachertube.com/members/viewVideo.php?video_id=143634&title=Google_Forms&vpkey=

http://kinetiva.com/tutorials/creating_online_forms_with_google_forms.pdf

http://technorati.com/videos/youtube.com%2Fwatch%3Fv%3DDCSKJavdglU

http://tbarrett.edublogs.org/2009/03/05/aaargh-too-many-google-forms/

Getting help:  http://docs.google.com/support/bin/topic.py?hl=en&topic=15166

Templates found here:  https://docs.google.com/templates?type=forms&sort=hottest&view=public

http://www.slideshare.net/charleneli/using-google-docs-for-school-sign-ups

http://googledocs.blogspot.com/2010/09/back-to-school-with-google-forms.html 

http://tbarrett.edublogs.org/2008/08/23/10-google-forms-for-the-classroom/

http://sites.google.com/site/colettecassinelli/spreadsheet

How to create self-grading quizzes:  http://www.robinstechtips.com/?p=394

Using the "go to different page based on answer" function:  http://googledocs.blogspot.com/2010/07/page-navigation-in-google-forms.html

For administrators: http://portical.org/tools/gf/


Feedback is appreciated!

Workshop Feedback



















Comments