forms

=**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?**
 * Your best answer?
 * See the previous session...
 * [|Forms] (Everyone can complete a demo form - see below...)


 * 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)**
 * Sample Forms (and Spreadsheets) Used By Administrators:
 * [|PLC Reflections] (Via Skip Offenhauser)
 * [|Math Curriculum Review Team Site Level Data Survey] (Via Skip Offenhauser)
 * [|Teaching Assignments] (Via Skip Offenhauser)
 * [|Woodside High School Emergency Plan Form] (Via Kyle Brumbaugh)
 * [|Woodside High School Emergency Plan Spreadsheet] (Via Kyle Brumbaugh)
 * [|Woodside High School Co-curricular Assignments] (Via Kyle Brumbaugh)
 * Resources for Administrators Using Google Forms (from GCT Jason Borgen at Portical.org):
 * [|An 8-minute tutorial on Google Forms for administrators]
 * [|A template] that principals can use to gather data on mastery of the NETS for teachers -- it automatically aggregates the data for them.
 * [|A Google Spreadsheet template] which principals can share with their teachers for paperless lesson plan collection (includes tutorial).
 * Additional GCT Resources for Administrators:
 * [|A Sample Teacher Observation Form] (Click on the "entry" tab.) - From GCT Kern Kelley
 * [|A Blog Post About Using Forms For A Mid-Year Principals' Survey] - From GCT Melanie Holtsman's Principal
 * [|More Ideas] (Collected by Colette Cassinelli)
 * Even More Ideas...
 * Dan Rezac's Freemont Fight Song Form (Embedded in a wiki)


 * Reflection Activity**
 * Consider specific things you learned that you would like to implement in the coming school year. What are your next steps? And what do you still have to learn?
 * Join the [|League Learning Network] the CLMS & CLHS online social network.
 * Reply to the "[|How can you use Google Docs to support your PLC?]" forum discussion.


 * Evaluation**
 * [|Online Evaluation] (A Google Form!)