- 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!
No comments:
Post a Comment