Your monthly schoolhouse schedule, on your Google Calendar.
1 · Schedule file
2 · Your line
Events run 6 hours from the report time; SF runs 5:30, and a standardization meeting is 0900–1600 with STAN or 0800–1600 with SC, and ODAWG is 0800–1700. Timed events alert 45 and 30 minutes before; all-day events such as WDAY alert at 1630 the day before. Title comes from the event row, location from the room number.
3 · Check it against the sheet
4 · Send to Google Calendar
One-time setup in Google Cloud Console: enable the Calendar API, create an OAuth client ID of type Web application, and list this page's address under authorized JavaScript origins. Paste the ID here, or set GOOGLE_CLIENT_ID near the top of this file's script so it fills itself in.
5 · Or take the file
SHSked.com is a free web app that copies a CKP-X or IP's monthly work schedule onto their own Google Calendar.
Instructor/Evaluators on a Schoolhouse assignment receive next month's events as a spreadsheet from Schoolhouse Scheduling on the 15th of the month prior. Each Instructor/Evaluator's line shows which event they teach on which day, in which room, and what time to report. Copying that onto a calendar by hand is slow and easy to get wrong — a mistyped report time means missing an event. (Ask me how I know! — Buddy)
SHSked.com reads that spreadsheet, finds your line on it, and writes the month's assignments to a Google Calendar you choose, with the event title, room number, report time and reminders already set. Run it again next month and it updates the existing entries rather than creating duplicates.
The spreadsheet is read in your browser and is never
uploaded. There is no server housing your data and no account to create to use this
app.
More about this app ·
Privacy policy