Online Observation Tool!

Here’s the Form for you to copy and make your own. Click Here!

Here’s the spreadsheet with all the data so you can see it. Click Here!

Here is the teacher spreadsheet, just make a copy of this for each teacher, and watch the video below to set it up.

How to make Individual Teacher Spreadsheets

Here's the code you'll need for each teacher spreadsheet, be sure to use your own form responses link!

=QUERY(IMPORTRANGE("INSERT YOUR GOOGLE SHEET FORM RESPONSE LINK HERE","Form Responses 1!a2:k200"), "Select * where Col2='TEACHER NAME'", -1)