Electronic Teacher Planner / Teacher Mark Book (Two Week Version)

This is the Full paid for version of the Electronic Teacher Planner/Mark book spreadsheet for teachers with a TWO WEEK TIMETABLE. The Free evaluation version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-free-evaluation-version-11912398
The paid version for a ONE WEEK TIMETABLE is available from: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-12357931
This 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 periods 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 20 years and haven’t used a paper-based planner in that time. The spreadsheet uses macros (embedded code) to automate the functions so you only have to click a button to add registers 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 Windows PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.