I struggled for years with a Diary and Organisers both leaving me to fill in loads of information. I came up with this spreadsheet. I type in my timetable once and a formatted diary picks up my timetable and writes it into a 2 page for 1 week diary page. Works with a 5 lesson 1 or 2 week timetable.
Before printing I have to write in the first Monday of the term’s date and then the spreadsheet will fill in the rest of the dates. I can type in before and after school duties and clubs, then they will print out on each of the rest of the pages.
Print this out as a booklet and away you go. I split it and put it in a filofax or just Print it out onto A4.
Here you will get a copy of the spreadsheet and a video of me talking through the instructions of what to do.
Edit July 23
I have updated this
added ToDo Notes
1 page per month Diary
Increased Font Size in Diary
I have left my timetable in for next year just so you can see what I have done. I copy my who timetable as a picture to the front of the Diary page it is very helpful (See pics)
Something went wrong, please try again later.
Excellent. Just what I was looking for!
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.