In some countries, a new academic year is about to begin. These are new academic calendar templates for 2012/2013 period. There are four models available now,
> August 2012 to August 2013
> July 2012 to July 2013
> August 2012 to July 2013
> July 2012 to June 2013
There is a new feature developed in these templates which I believe it will help you much on designing your school academic calendar, comparing with previous academic calendars.
The new feature is its capability to mark consecutive dates by typing start and end dates of designated period. There are three tables available to differentiate any period colors. With this feature, you can mark mid or final test, school holidays, and others without typing date after date.
How to use:
Marking single dates:
> Put your date on column B and its description on column C for any exams (green colors).
> Put your date on column D and its description on column E for any holidays (red colors). There is a default US holidays that you can change or replace with your own dates. Or just add new holidays below those US dates.
> Put your date on column F and its description on column G for any exams (blue colors).
Marking consecutive dates:
> Put your start date on column H, end date on column I, and its description on column J. There are three different colors available, brown, yellow and grey.
–Your start and end dates in row 2-9 (H4-I11) will have brown color
–Your start and end dates in row 12-19 (H14-I21) will have yellow color
–Your start and end dates in row 22-29 (H24-I31) will have grey color
You can change any column titles to suit your needs.
You can download those templates below:
2012/2013 Academic Calendar August-to-August V2.11 (38.6 KiB, 4,524 hits)
2012/2013 Academic Calendar August-to-July V2.11 (37.5 KiB, 14,240 hits)
2012/2013 Academic Calendar July-to-June V2.11 (37.6 KiB, 1,701 hits)
2012/2013 Academic Calendar July-to-July V2.11 (38.6 KiB, 1,378 hits)
If you are interested to see how the consecutive date marker formula works or you want to customize the calendar and make it as your official school academic calendar or just want to thank me :), you can get the unlocked version by sending me $4.99 through paypal by clicking the button below.