Electronic Teacher Planner / Teacher Mark Book

This is the Full paid for version of the Electronic Teacher Planner/Mark book spreadsheet. The Free evaluation version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-free-evaluation-version-11912398
A TWO WEEK Timetable version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-two-week-version-12358075
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 for you so you just have to clickand 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.