Direct download · XLSX checked with LibreOffice Calc
This free Excel template helps teams manage lesson plan template. This free Excel lesson plan template gives instructors, curriculum teams, and course operations staff a structured way to create and review lesson plans in 2026. The workbook provides 200 prepared operational rows for recording objectives, success criteria, instructional activities, phase-by-phase timing, differentiation, assessment evidence, statuses, and review dates.
Automatic calculations flag timing issues, missing required fields, and review deadlines, while the dashboard summarizes the lesson plan portfolio. Populated sample lessons demonstrate the format and should be replaced or removed before operational use.
Preview 1 — “Dashboard” sheet Click to enlarge
In practice
What this template helps you manage
✓
Standardize lesson planning: Keep essential instructional and operational details in a consistent, row-based format across courses, programs, grade bands, subject areas, instructors, and delivery modes.
✓
Build lessons around measurable outcomes: Document each learning objective, success criteria, applicable standard or competency, materials, differentiation or supports, and assessment evidence.
✓
Balance instructional time: Allocate whole minutes to the opening, direct instruction, guided practice, independent practice, and closure. The workbook totals these phases and compares them with the scheduled duration.
✓
Find incomplete plans: The calculated Readiness Check identifies plans missing one or more of the nine fields required by the workbook: Plan ID, Lesson Title, Course/Program, Lesson Date, Scheduled Duration, Learning Objective, Success Criteria, Assessment/Evidence, and Status.
How to use it
How to use the workbook
Start on Lists & Settings and confirm the As of Date, Upcoming Window, Timing Tolerance, and Review Alert Window. Next, open Lesson Plans and enter one lesson per row, assigning a unique Plan ID to each active record. Complete the lesson context, objective, success criteria, resources, instructional phases, differentiation or supports, assessment evidence, status, and relevant review dates. Enter phase durations as whole minutes; the gray calculated columns will total planned activity minutes, calculate time variance, and report timing, readiness, and review results. Resolve any issues shown by those checks, then use the Dashboard to review portfolio totals, status and delivery-mode charts, and non-archived lessons scheduled within the configured upcoming window. Yellow cells are intended for entry, while gray formula cells should not be overwritten.
Preview 2 — “Lesson Plans” sheet Click to enlarge
Inside the file
Included features and controls
＋Four purpose-built worksheets: Dashboard presents summaries and charts; Lesson Plans contains the operational records; Lists & Settings stores thresholds and selection lists; and Instructions explains workflow, required fields, data handling, and limitations.
＋200 prepared lesson rows: The Lesson Plans sheet provides rows 5 through 204 for operational records. Its Excel table spans A4:AI204 and includes filters across all 35 columns.
＋Comprehensive lesson plan fields: Record Plan ID, title, course or program, grade or band, subject area, owner, date, duration, delivery mode, standard or competency, objective, success criteria, materials, instructional phases, supports, assessment evidence, follow-up, status, review dates, and notes.
＋Calculated timing outputs: Planned Activity Minutes sums the five phase-minute fields. Time Variance subtracts Scheduled Duration from that total. Timing Check reports Missing duration, No timing entered, Within range, Over planned, or Under planned according to the configured tolerance.
Excel Lesson Plan Template for Structured Instructional Design
This lesson plan template brings instructional design and course operations into one consistent record. Each lesson can include its program context, grade or band, subject area, owner, date, delivery mode, standard or competency, learning objective, success criteria, materials, differentiation, assessment evidence, and follow-up work. The row-based structure supports comparison and filtering without claiming to track student-level outcomes.
Preview 3 — “Lists & Settings” sheet Click to enlarge
Lesson Timing Template with Automatic Variance Checks
Plan time across five instructional phases: opening or warm-up, direct instruction, guided practice, independent practice, and closure or reflection. The Excel formulas add the entered phase minutes and compare the result with the scheduled lesson duration. The Timing Check uses the tolerance on Lists & Settings to distinguish plans within range from those that are over or under planned, while also identifying missing duration or timing data.
Lesson Readiness and Review Tracking
The workbook separates editable lesson details from calculated operational checks. Readiness Check reports whether the nine workbook-required fields are complete. Review Alert compares Review Due Date with the configured As of Date and Review Alert Window to identify overdue, due-soon, current, or undated reviews. Archived records are excluded from review alerts.
Preview 4 — “Instructions” sheet Click to enlarge
Lesson Planning Dashboard for Course Operations
The Dashboard summarizes total lesson plans, plans that are both Ready to Teach and complete, upcoming non-archived lessons, timing issues, incomplete plans, and overdue or due-soon reviews. It also counts plans by status and delivery mode, presents two corresponding charts, and displays lesson records scheduled within the configurable upcoming period.
Common questions
About this template
The Lesson Plans sheet contains 200 prepared operational rows, covering rows 5 through 204. The table spans columns A through AI, for 35 fields and calculated outputs.
The Readiness Check returns Complete only when Plan ID, Lesson Title, Course/Program, Lesson Date, Scheduled Duration, Learning Objective, Success Criteria, Assessment/Evidence, and Status are populated. If any of these nine fields is missing, it returns Missing required fields.
Planned Activity Minutes adds the minutes entered for the opening, direct instruction, guided practice, independent practice, and closure. Time Variance subtracts Scheduled Duration from that total. Timing Check then uses the configured tolerance to return Within range, Over planned, Under planned, Missing duration, or No timing entered.
The Dashboard shows total lesson plans, ready-and-complete plans, upcoming lessons, timing issues, incomplete plans, and review alerts. It also includes status and delivery-mode summaries with two charts, plus an upcoming lesson review area.
The status choices are Draft, In Review, Ready to Teach, Taught, and Archived. The delivery modes are In Person, Virtual, Hybrid, and Self-Paced. Both fields use lists maintained on Lists & Settings.
No. The workbook is intended for lesson-level planning, and its instructions say not to enter student names, student identification numbers, grades, attendance, disability information, or other student-level information. It is an internal planning template and does not establish compliance with education, privacy, accreditation, or regulatory requirements.
Editorial process
Prepared and reviewed against the workbook
Course Ops Workbook Team
Workbook preparation
This functional byline identifies the team role that structures the workbook, sample data, calculations, and operating checks.
Course Ops Editorial Team
Editorial review
This functional byline identifies the team role that checks the page against the generated workbook and states its limits.
