Lesson Delivery Template – Excel SoW Planner

Lesson Delivery Template (Excel – Macro-Enabled)

This Excel-based template is designed to help teachers and subject leads plan, track, and manage lesson delivery across the academic year. It’s especially useful for departments using Microsoft Teams and OneNote, for subjects with multiple lessons per week, and for departments with non-specialists.

What it does:

• Provides separate sheets for subjects taught 1–6 times per week allowing all years (7-13) to be created.
• Lets you link to lesson PowerPoints, lesson plans, and online resources.
• Tracks when homework should be set and when it is due, as well as in-class assessments.
• Includes a simple “Complete Lesson” button to mark lessons as taught (with automatic date stamping and colour coding).
• Offers a clear visual overview of curriculum coverage across the year which is great for Heads of Department or subject leads.

Extras:

• Built-in guidance via comments to support setup and use.
• Fully editable to suit your school’s structure and terminology.
• This tool is ideal for keeping lesson delivery consistent and transparent, especially when working across multiple classes or team-teaching.