Technology and PLCs: Data Collection with Google Forms


Google Forms allow users to quickly and easily create an online form that feeds collected data directly into a shared spreadsheet. This is a powerful way for members of a PLC to collect the data needed to make informed decisions about instruction, best practice, and other matters related to the school or community. Forms can be used for polls, surveys, and evaluations - or for collecting event registration data, WASC evidence, and best practices. A Google Form can even be used to create online common assessments that, with a little ingenuity, can also be self-grading. Unlike many similar services, Google Forms is free - a feature of the Google Docs online office suite.



Agenda


Welcome Activity
  • Were you in the previous session?
  • Do you have a Google Account?
  • Have you used Google Docs before?
  • Could you explain Google Docs to a colleague?
  • What do you hope to get out of today's workshop?

What is Google Docs? And what are Forms?

Interactive Overview (with Link to Help Pages):
  • Forms (Everyone can complete a demo form - see below...)

Activity 1: Who are we?
  • No Google account is required!
  • Complete this demo survey .
  • View the results .
  • Demonstration: View summary.
  • Demonstration: Create and publish a chart.
  • Demonstration: Self Grading Quiz (Your answer to the last question on the survey will be graded!)
  • Are you ready to see how to create, edit, and collaborate on specific PLC documents? (Grin or Frown?)

Activity 2: Create a Form for Data Collection, Analysis, and Sharing
  • Create a form for collecting data. Examples include:
    • A Teacher (or Student) Observation Form
    • A WASC Data Collection Form
    • An Awards Nomination Form
    • A Professional Development Evaluation
    • A Staff or Community Survey
    • A PLC Team Meeting Form
      • Attendance
      • Team Smart Goal
      • Strategies and Action Steps
      • Responsibilities
      • Timeline
      • Evidence of Effectiveness
    • Advanced: A Self-Grading Quiz
  • Mock up a "proof-of-concept" to illustrate something you might actually implement.
  • Send the "live form" link to colleagues so they can fill out your form.
  • Share the results with colleagues or publish them as a web page.
  • Optional: Create (and publish) charts of the results.
  • Are you ready to move on? (Grin or Frown?)
    • Time permitting we can view more samples...
    • Or create a self-grading quiz...
    • Or talk about using Google Docs with a mobile device.

CHALLENGE Activity: Create a self-grading common assessment! (Time permitting)
  • Create a three question quiz using a Google Form.
  • Solicit sample answers from some colleagues.
  • Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.)
  • Fill Down so that the IF formulas you've written can "grade" all the responses at once!
  • Advanced: Create a SUM formula to total up the total score for each person that took the quiz. Then create another formula to calculate the percentage. Finally, create a nested IF formula to convert the percentages to letter grades!
  • Time Permitting: Share your quiz with me so I can share with the large group.

More Sample Uses of Google Docs Forms (for Administrators)

Reflection Activity

Evaluation