During the remote learning phase of the pandemic, it was suddenly important to have google calendar reflect our school schedule. This sheet tried to make life as easy as possible for teachers who had a complex Bell schedule not simply represented in repeating events and a Google infrastructure that automatically generates a calendar per Google Classroom class and brought it together.
The basic idea is simple:
- I use vanilla spreadsheet magic to let teachers pick the block their class is in and get the correct settings for creating repeating events that represented our school's block schedule.
- I use Google Apps Script to fetch the list of a teacher's current classes and the calendars associated with them.
- I use Google Apps Script to take the scheudle parameters and automatically create recurring events for teachers that match up to when their classes actually meet.
If you're using Google Classroom and need to input special schedules, you can make a copy of this spreadsheet, change up the logic to fit whatever weird Bell Schedule you're dealing with, and you should be ready to roll.
There is a more bare-bones version of this tool here if you just need to schedule Google calendar events from a spreadsheet.