xlsx, 66.51 KB
xlsx, 66.51 KB
jpg, 1 MB
jpg, 1 MB
jpg, 954.86 KB
jpg, 954.86 KB
jpg, 1020.32 KB
jpg, 1020.32 KB
jpg, 1.06 MB
jpg, 1.06 MB

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)

Creative Commons "Sharealike"

Reviews

5

Something went wrong, please try again later.

jarmstrong49

a year ago
5

Excellent. Just what I was looking for!

Dkeith

5 years ago
5

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.