You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.


Browse and make a copy (File->Make a copy) of the mini-observation template here and go to the "Read Me" tab for instructions on how to set it up.  The template contains entirely made up teacher data and is not intended to show best practice in the notation of administrator feedback.

Push my thinking

What design choices in this system would you change if you could?


Teacher Mini-Observation Tracking System using Google Forms and Scripts

Problem of practice

How can overburdened school administrators manage their workflow to enable short mini-observations aligned to a teacher effectiveness framework like Danielson without getting locked into expensive, proprietary software?


This well thought-out template, created by a collaboration between a highly successful NYCDOE principal and an Apps Script developer, makes data entry a snap, helps administrators prioritize observations, and supports communications with teachers.

Cast your vote


Tweet this

Browse other items with similar tags

The formMule (aka "The Mule") is a Google Apps script that is useful for automating lookups, emails and calendar events created dynamically from Google Forms.
Recommended by 64 educator(s).
This tutorial presents the pre-Add-on version of Doctopus. Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects. For tutorials on the new version of Doctopus, see
Recommended by 188 educator(s).
The autoCrat Script was written to be a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents. No scripting ability required to use.
Recommended by 290 educator(s).
This is a simple script housed in a google sheet that allows teachers to create handouts for their classroom, shares the student appropriately and organizes the handouts in a collection. It can be used to create sheets as well as docs.
Recommended by 19 educator(s).
The docAppender script installs on the form-containing spreadsheet and provides users a web app where they can easily select which document they want to append. This is especially useful for logging meeting takeaways or keeping running records on faculty or student files. Very mobile friendly, as all usage involves URLs that can be loaded in a smartphone or tablet.
Recommended by 15 educator(s).
This hack provides starter templates for a pair of Google Docs worksheets (one private, one public) that can then be connected using (included) Apps scripts to encourage users to submit Google forms only for open time slots or resources. Test.
Recommended by 16 educator(s).
This hack shows how to install a Google Apps Script in your Google Site to look up the grades of the currently logged-in student or parent and generate a live bar of progress from your Google spreadsheet!
Recommended by 20 educator(s).