You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.
Notes
Looking for feedback from the YouPD community on how to improve this idea
Push my thinking
This is a rather clunky way of accomplishing this, with potential problems with the IMPORTRANGE formula. Is there perhaps a more straight forward way to script this? Can this be 'packaged' for more easier sharing out?
Useful links
Comments
Walk-thru Teacher observation Form with individual shared spreadsheet
Problem of practice
Managing teacher observations while keeping individual information private.
Solution
Using spreadsheet formulas for IMPORTRANGE from a master data spreadsheet, create individually shared spreadsheets for each teacher that are populated with filtered data from the master set of all teacher observations.
Cast your vote
Tweet this
Post to Twitterpowered by educators
empowered by
Interesting approach
Rob,
Thanks for posting this! Here's a similar system built with the formMule script, which doubles as a formEmailer and allows for the teacher email to be looked up automatically using the VLOOKUP function. http://youpd.org/miniobs
I don't typically provide the teacher a running record of their observations other than what we put in the body of the email, though I've recently added the docAppender script, which would allow you to submit the form in a way that appends a different Google Document depending upon the teacher being observed, and would accomplish something similar to your approach.
You are right that the number of tabs would quickly overwhelm an admin in a larger school, which is why we generally just keep it to the email.
Cheers!
Andrew
Interesting approach
I'll have to take a look at the DocAppender and see if that might be a cleaner way to create an independent archive for each teacher without the multiple tabs and importRange function. Thanks
Video Link
Not sure video uploaded correctly, so here is link to Youtube copy
http://www.youtube.com/watch?v=ttYY3WTiVpY