You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.
- Using an Apps for EDU account, open and generate your own copies of the 5 templates below.
- Authorize the PushData script on "Master Student List," "Master Advisory List," and "Lateness Log" spreadsheets
Authorize SendEmails script on "Lateness Log"
Connect "Master Student List" to "Link Generator" using PushData script
In Master Student List set trigger on PushData script to "On Edit"
Connect Master Student List to Lateness Log - ReceivedStudentData sheet
Connect Master Advisor List to Lateness Log using PushData script
Connect Master Student List and Lateness Log to Data Warehouse using PushData script
Set FormKey and Domain on Link Generator (note that FormKeys is a hidden sheet)
Set Additional Script Triggers: Lateness Log ->SendEmail trigger on form submit, Lateness Log -> PushData trigger once an hour, Master Advisor List -> PushData trigger on edit
Testing: Substitute a test email you can check for an advisor in Master Advisor List substitute a test email for a student with that same advisor in Master Student List Use the link generator to submit a lateness form on that same student. If emails arrive, you know that spreadsheet scripts are running fine!
Update your bell schedule in Link Generator (hidden sheet) and Lateness Log (Unless you know how to modify the spreadsheet formulas, do not change period numbers, just times)
Create or use existing Google Site (or page, if using page-level permissions) that is visible only to school faculty. Embed the Link Generator in a page (hide all unneeded sheets). Create another page and embed all relevant lateness charts.
Now clear out and replace fake data fromMaster Student List (leave headers)Master Advisor List (leave headers)Check Link Generatorand Lateness Log to ensure changes propagated correctly.Test and tweak!In some cases, you may need to drag tally formulas down to accomodate longer student or advisory lists.Do not abuse your new powers...
Much credit due to ACTVF Principal Mark Dunetz for pioneering some of these techniques as a deep and integral part of running his unmistakeably effective school.
The PushData script was authored primarily by math teacher and self-taught coder David Wees.
Geeky fun excerpts of YouTube clips and music credited to Tesla coil rockers, ArcAttack!
DIY Student Information System: Module 1, "The Lateness Zapper"
Problem of practice
Cast your vote