This spreadsheet is a full teacher’s planner book enabling you to replace your paper based record book. It enables you to create a colour coded timetable (and will automatically generate a blank timetable with the appropriate number of period per day), a week by week lesson outline planning sheet, a register for each class that records attendance, performance and behavioural information upon each pupil, homework and test scores. The registers will rank the pupils according to assessment criteria, absences and upon test scores. The class analysis page will give detailed information upon the number of lates/tardiness, discipline issues, forgotten books, no homework, incomplete pieces of work and work graded excellent, good, satisfactory and poor. Schemes of work can be created and reports written upon individual students. Print outs of each class can be used at parent consultation evenings and as a record for SLT. Cover lesson instructions can also be created. I have used this spreadsheet in an ongoing developing form for the last 17 years and haven’t used a paper based planner in that time. The spreadsheet does require the use of macros and so they need to be enabled in excel, see the help page in the spreadsheet on how to do this.
Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.