Workshops‎ > ‎2011-08-19dan‎ > ‎

Forms and Spreadsheets


Bookmark this page: http://goo.gl/L4naq

Dan McDowell
Teacher, West Hills High School
Google Certified Teacher

Session Overview
  1. Forms and Spreadsheets Overview
    • Spreadsheets in Docs
  2. Uses of forms
    1. Collect student information (Form / Results)
    2. Collect data (Form / Results)
    3. Assignment submissions (Form / Results)
    4. Student assessment
    5. 70+ Interesting Ways to Use Google Form in the Classroom
  3. Hands-on
  4. Look what else it can do!
    1. Gadgets add power


Hands-on Activity
Your objective is create one form that you can implement immediately in your classroom or office to (1) reduce waste (2) save time and (3) collect feedback or information.

Part 1: Create the form
  1. Create a new form.
  2. Select the appropriate question types.
  3. Apply a theme of your choice.
  4. Test your form out. 
  5. Complete this Workshop Form and add your URL.
Part 2: Take some surveys
  1. View the surveys of your peers, in the next 5 minutes.
  2. Starting after your survey on the list, take as many as you can in the designated times.
Part 3: Review your results
  1. Use Form > Show summary of responses to get a quick overview of how people responded.
  2. Sort your survey by columns to see how it works.
Additional Resources

Spreadsheets

Forms

Google Docs Tutorial: Forms

Google Docs Video Tutorial: Forms

YouTube Community Channel 

Google Forms for Teachers

Ideas for Forms with Students

More Quick Ideas for Students
  • Use a Google Form as an Exit Card for any classroom lesson or unit
  • Debrief a Field Trip 
  • Science observations
  • Poll the parents in your class quickly
  • Survey Students about ideas, thoughts, reflections
  • Book Reviews
  • QuickWrite for Students- Random topic each day...just write!