- Weeded out anything with an ultra-conservative religious slant
- Took out anything with outdated information
- Removed anything that had to be followed exactly
First, I typed in a master list with all the dates we planned to have school. We follow the local school calendar, so I used those dates. Next, I numbered each day, starting with one, referring to the day in the overall school year.
Each subject had its own sheet with the unit names and how many days each should probably take. So, if a unit stated on the 10th day of school and took 5 days, Excel looks up the calendar dates for the 10th and 15th day of school. The next unit would automatically be scheduled to start on the 16th day of school.
The unit names were added to their respective start dates on the master list by subject. This list could now be used either as is, or pulled into a sheet with a more normal calendar layout.
Now, when a unit runs long, I can update it in just one place and all the other units’ start dates are move accordingly!