One of the things that is really overwhelming for an ECT is the amount of Planning you need to get together. More experienced teachers tell me it gets much better after the first 2 years because you have material in the bag to modify, but for now it is all about scheduling new stuff and getting your head around it all.

So, of course I need a spreadsheet and of course it has automation. This is a macro-enabled excel spreadsheet so Excel will ask you if you want to “enable content”. You do, because my code doesn’t work without it.

In the template sheet, organise your timetable and codes as you need. There is a custom ribbon bar at the top under “CodeMonkey”. Pressing the Insert New Sheets button gives you a dialog box

Choose a Monday and a new sheet will be created based upon the content of “Template” and named by the date chosen in YYYY-MM-DD format, which is then sorted into date order.

Adopt, Adapt. Improve. Simon Rundell CC NC-BY-SA 2025