Advanced Google Forms and Data Analysis

Link to Sample Spreadsheet

The Tool: Google Forms

Tutorial Site for Scripting: www.youpd.org

List of functions for Google Spreadsheets

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 begin_of_the_skype_highlighting end_of_the_skype_highlighting

  • More Ideas (Collected by Colette Cassinelli)

Form Templates used in R.S.U. #19.

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

Administrative Forms

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