Tuesday, July 28, 2015

Google Forms for Administrators

It has been a busy summer planning and preparing for the awesome school year that lies ahead! In addition to organizing teacher training and getting ready for iPad distribution, I have spent some quality time working with the administrators in our district as they get ready for a new year.

Here are a few of the ways administrators are using Google Forms!

Teacher Information Form
In years past, I started each school year by completing a green information sheet at my school, which the office staff then entered into a spreadsheet for mail merges, faculty phone lists, etc. When a Google Form is used to collect the same information, data is automatically entered into a spreadsheet.

Click HERE to make a copy of a sample responses sheet.
Once you make a copy, click "Form > Edit form" in order to make changes and personalize.



Because my school district has set up a GAFE Domain, it is easy to automatically collect email addresses from those who complete a form. Simply, check the first two boxes under "Form Settings."



For more help, check out this awesome Google Forms Quick Start Guide created by Alice Keeler.

Walk-Through Observation Forms
This has been a very popular request from administrators this summer, and I have enjoyed showing off how using a Google Form paired with Autocrat makes managing observation feedback a breeze!

Try this Sample Observation Form. After you submit the form, you should receive an email with your feedback as an attached PDF. In addition to the PDF you receive, the feedback is stored in the Responses Spreadsheet and in a Google Drive folder. The best part is that once everything is set up, it all happens automatically!

Setting this up involves three components: a Google Form, a Google Docs template, and the Responses Spreadsheet with Autocrat add-on. To get started, check out the step-by-step instructions that I created for administrators in my district. (If you are looking for another type of observation form, here is another template created by Brad Moore and Melissa Tollison.)  

Discipline Referral Forms
It has been exciting to see those I've helped this summer find other ways to apply and personalize what they've learned about Google Forms. Many found that they were able to use a variety of add-ons and features in Google Forms to expedite and improve upon their process for dealing with discipline referrals.

Assistant Principal Lauree Cole and I came up with a Google Form (based on PowerSchool data) for teachers to complete that notifies the administrator team via email when student behavior is referred to the office. The administrators can use the spreadsheet to communicate with one another about who is dealing with the behavior issue and what consequences are being given. We also found that using Autocrat is a great way to email a final copy to teachers and/or parents once the student has visited the office. If you'd like to learn more about how this form was created and set-up, click HERE

No comments:

Post a Comment