Forms and Spreadsheets

Google Form Templates

If you are logged into your Google Account, these form templates will automatically copy into your Google Docs Dashboard.

Many of the forms are designed to work with an iPod Touch. For more information about educational uses of that device, go to

http://sites.google.com/site/kernkelley/itouch.

Test and Quizzes

• Self Grading 10 Question Multiple Choice Quiz - Provide a link to this form or embed it into a website. This template scores the answers as soon as students complete the quiz.

• Self Grading 20 Question Multiple Choice Quiz - Provide a link to this form or embed it into a website. This template scores the answers as soon as students complete the quiz.

• Self Grading 50 Question Multiple Choice Quiz - Provide a link to this form or embed it into a website. This template scores the answers as soon as students complete the quiz.

• Self Correcting Spelling Quiz - This form allows a teacher to enter 20 words and once the quiz is completed, it self corrects and analyzes the data.

• Response to Literature Scoring Form - This form collects literature response scores and coordinates the results.

• Virtual Inbox - A form that collects the web address of students work and organizes it by school and grade.

• HS Document Collector and Viewer - This form collects Docs or websites from students and allows them to manage and organize them.

Administrative Forms

• Professional Performance Evaluation - Teacher observation form that the administrators can use.

• Administrative Observation Walkthrough - This is an teacher observation form that the administrators can use. The iPod Touch provides an easy way for data entry, then they can complete the observation in the spreadsheet once complete.

• Technology Survey - This is the survey we give to staff and students at the beginning of the school year.

• Three Minute Administrative Walk-Through - This is an teacher observation form that the administrators use in my district. The iPod Touch provides an easy way for data entry, then they can complete the observation in the spreadsheet once complete.

• Homework Check - This is a detailed form that teachers input student scores and the spreadsheet coordinates the results based on which assignments the teacher was using.

• Discipline Form - This forms allow teacher entry of disciplinary actions. Note: We use avatar names when entering information.

Miscellaneous

• Science Fair Judging Form - This is the scoring form used in a middle school science fair.

• Story Board - Used by student groups to write and produce a video project.

• Booklist Template - Used by teachers to keep track of the names and quantity of books read by students.

• Word Find Template - Not a form, but spreadsheet where the user can create a custom word find.

• Vocabulary Flashcard builder - This spreadsheet creates a custom flashcard sheet.

• Auto-Email Form - This form takes the data entered into it and sends it to the email address asked for by the form

• Observation Record - This Form and Display Spreadsheet show when teachers are observed so they are not always done the same day or class.

• Website collection and Presentation Form - This form collects website addresses and displays the actual site in a gadget which can be embedded into your own website.

• Mileage Tracker Template - This Form is a mileage tracker that helps make travel reports.

Activity: Forms for Data Collection

Create a form for collecting data. Examples include:

• • A Teacher (or Student) Observation Form

  • An Awards Nomination Form

  • A Professional Development Evaluation

  • A Staff or Community Survey

  • A PLC Team Meeting Form

    • • Attendance

      • 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.

'Extra Credit' Activity: Create a self-grading quiz! (Time permitting)

In a small group, create a three question quiz using a Google Form.

Solicit sample answers from other participants.

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!

BONUS: Using Google Docs and Forms on a Mobile Device

Accessing your Google Docs on a Mobile Device

Completing a Google Form on a Mobile Device

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)

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)

Fantastic templates provided by Todd Roth.