Google Forms

Google Forms provide an easy-to-use tool for gathering information, for organizing data, and for assessing students and providing feedback. Lately, more and more people at AAS have been using them, so I wanted to highlight the variety of uses and some of their benefits here.

Plus, recent updates to Forms make them look more professional and also offer very convenient ways to instantly visualize data and interpret responses, even without going to the accompanying spreadsheet.

Speaking of spreadsheets, first you should understand the way Google Forms work. Here are the basic steps and a couple important details for AAS use.

  1. You create a Form. You have a choice of whether to require AAS user login. This can be useful to limit use to only students and faculty at school. However, if you want to open up the form for others outside AAS, do not choose this. Also, plan your questions and craft them to get exactly the types of information and data you want to collect. You can add images, videos, and many types of questions. You can also organize the form into multiple pages with headers. If the form is a quiz for student assessment, you can enable a password and/or turn it on and off to keep it relatively secure and control who takes it and when they can access it.
  2. You send the Form and users complete it. A Form can be completed on any device with web access – any desktop, laptop, tablet, or phone = BYOD-friendly. The responses and data that users enter can be kept just in the form or can be sent to a Google Sheet(similar to Excel). Later you can also reuse a form by attaching it to a new Sheet.
  3. You easily organize and analyze the data. This allows you to make informed decisions. If you have collected written responses from people, reading them in a spreadsheet is not easy. However, a few Add-Ons for Google Sheets allow you to easily produce Google Docs or PDFs with the information from each Form user submission.
    • Save As Doc – This creates a Google Doc from each Form entry and saves them in your Drive. It is very easy to use but has limitations to the look of the Doc.
    • autoCrat – This one allows you to create a custom template — such as a achievement certificate, a special document with a letterhead and custom text, or a feedback rubric. It generates a Google Doc or a PDF from each form entry, which is saved and can also be emailed to whoever you designate.
    • Flubaroo – This allows teachers to use Forms as assessments — quizzes or tests. It processes the Form responses on the spreadsheet compared to an answer key you enter; then it produces a sheet with the grades. You can also mark written short answers or even paragraphs and provide comments. You can even share results and feedback with students in a variety ways with Flubaroo. More updates and additions are continually being made.

Finally, here is list of current uses of Forms here at AAS!

collecting and organizing information

  • PTO Enhancement Grant Applications – This Form is set up with autoCrat to automagically produce and save a PDF and share it with specific members of the PTO.
  • Move / Renovation Requests for the Housing Committee – This also uses autoCrat to save a Google Doc version of each Form submission into a folder that is shared with all the committee members.
  • Sign up for study rooms and extra help before examsMatt Groves, Joe Kahn, and Paul Lennon have used this recently. It is easy to share the info with other teachers and students and to check whether all students completed the Form.

assessment/feedback

  • Map and Geography quiz in Grade 7 Humanities – With Flubaroo, the marking of the quiz is quite quick and easy. This quiz included a map image, a variety of question types that are automatically graded, and short response questions that teachers mark manually. Amey Law is leading the way here!
  • Scientific Inquiry Rubric – This Science Department work-in-progress will allow teachers to assess students’ lab work and collect data longitudinally as they progress from lab to lab, from year to year.
  • Walk-through form for MS Admin to provide teachers with feedback and gather appraisal data – If an administrator drops by a classroom and takes some notes on an iPad or laptop, they are probably using a Form to collect that info. autoCrat then sends it to a Google Doc, which is filed in Drive and can be shared with the teacher to add his/her reflection as well. These notes can then provide a good starting point for feedback and further conversations for PD.
  • Student Intervention tracking in the HS admin/counselors/GLLs – When teachers are concerned about a student’s behavior or academic standing in class, they employ different strategies to help the student. These efforts are documented through the Form so that other teachers and counselors can be informed and further assistance for students can be determined. Some formulas and set-up in the accompanying spreadsheet makes the data easily searchable by student, by teacher, and by grade level.

visualizing data and responses

  • Time Management Survey of Grade 11 students – Katrina Senour wanted to quickly find out how students think about and employ time management strategies. The data is readily available for her to understand the student responses. image sample:

Please contact Devin or Paul if you want to try out any of these uses of Google Forms!