Softwiro
Free Excel template

Lesson Plan Template for Excel with Curriculum Tracker

Most lesson plan templates give you a nice page for one week and nothing that tells you where the term stands. This workbook keeps every lesson in one table (date, unit, topic, standards, objective, materials, activities, assessment, homework, status) and then does the tracking for you: which standards are covered, which are planned but not taught yet, which have no lesson at all, and whether each unit is on pace for the date you type in. A Weekly plan sheet turns any week into a one-page plan you can print. The sample is a Grade 6 maths term with 41 lessons; clear it and enter your own.

Excel file (.xlsx) · 40 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Lessons” tab, with the numbers and formulas that are in the file.
DateDayUnitLesson topicStandard 1Learning objectiveAssessmentStatusCheck
46274WedUnit 1 - Ratios and ratesWhat is a ratio?RP1Describe a ratio in words and with a colonNoneTaught
46276FriUnit 1 - Ratios and ratesEquivalent ratiosRP1Make equivalent ratios by multiplying both partsNoneTaught
46279MonUnit 1 - Ratios and ratesRatio tablesRP3Complete a ratio table to find missing valuesNoneTaught
46281WedUnit 1 - Ratios and ratesTape diagramsRP3Model a ratio problem with a tape diagramExit ticketTaught
46283FriUnit 1 - Ratios and ratesUnit ratesRP2Find the unit rate from a ratioNoneTaught
46286MonUnit 1 - Ratios and ratesUnit price and best buyRP2Compare prices using unit ratesHomework checkTaught
46288WedUnit 1 - Ratios and ratesSpeed and rate problemsRP2Solve speed problems with a double number lineNoneTaught
46290FriUnit 1 - Ratios and ratesGraphing ratiosRP3Plot equivalent ratios on a coordinate planeQuizTaught

Example from the “Lessons” tab, with the numbers and formulas that are in the file.

What is inside

  • Setup: Teacher, school, course, term dates, the 'as of' date, your units with planned start and end dates, and the assessment types. It also sets how many lessons behind counts as Behind.
  • Lessons: The master plan, one row per lesson, with day and week number worked out from the date. Status is Planned, Taught, Postponed or Cancelled. A Check column flags lessons that are due but not marked and lessons with no standard.
  • Standards: Your standards or learning goals with a code, a description and a unit. Each shows lessons planned, lessons taught and a status: Covered, In progress, Not taught yet or Not planned.
  • Coverage: Lessons taught against planned, share of the term elapsed, due but not taught, pace, standards reached, a pacing table per unit and per week, and assessments per type, with 3 charts.
  • Weekly plan: Type a week number to list that week's lessons with objectives, materials, activities, homework and status on one printable page, with space for notes.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

A lesson plan template answers 'what am I teaching on Thursday?'. A curriculum tracker answers 'am I going to finish?'. This one answers both from the same table, so you only type each lesson once. Standards that never appear in a lesson show up in red, lessons you forgot to mark are flagged, and pacing is measured against the date you set, not against a guess.

How do I track curriculum coverage in Excel?

List your standards once on the Standards sheet, then pick one or two of them on each lesson. The sheet counts how many non-cancelled lessons address each standard and how many of those are marked Taught. A standard is Covered when every planned lesson for it has been taught, In progress when some have, Not taught yet when none has, and Not planned when no lesson uses it.

In the sample, 11 standards are listed. Two are Covered, five are In progress, three are Not taught yet and one (EE3) has no lesson planned, so it is shown in red. Seven of the 11 have at least one lesson taught, which is 63.6%. Finding the unplanned standard in October is far easier than finding it in December.

How do I know if I am behind on my pacing guide?

Set the 'as of' date on Setup. A lesson is due when its date is on or before it and it is not cancelled. The sheet compares the lessons due with the lessons marked Taught. In the sample, 28 lessons are due and 25 are taught, so the class is 3 lessons behind: one postponed lesson and two that are due but not yet marked.

You decide how strict to be. The Setup cell 'Behind only if due lessons not taught are more than' is 1 in the sample, so Unit 2 (1 behind) shows On pace while Unit 3 (2 behind) shows Behind. The term is 68.3% elapsed and 62.5% of the planned lessons are taught. Postponed lessons stay in the count until you reschedule them, and pacing is only a guide: adjust it to your own situation and school requirements.

What should a weekly lesson plan template include?

Most weekly plans cover the date, the topic, the learning objective, the standard, materials, activities, assessment and homework. Those are the columns on the Lessons sheet, so the Weekly plan sheet only has to look them up. Choose the week number and print the page for your planner, a substitute or an administrator.

Up to 8 lessons fit on one week's page. Cancelled and postponed lessons still appear with their status, which makes it easy to explain why a lesson did not happen.

How to use it

  1. On Setup, type your name, school, course and term dates, the "as of" date, and list your units with their planned start and end dates. Edit the assessment types if you like.
  2. On Standards, list the standards or learning goals for the course (a short code, a description and the unit).
  3. On Lessons, add one row per lesson: date, unit, topic, the standard it addresses, objective, materials, activities, assessment and homework. Set the status to Planned, Taught, Postponed or Cancelled.
  4. After each lesson, change its status. Open Coverage to see how many lessons you have taught, whether each unit is on pace and which standards are covered, not yet taught or not planned at all.
  5. On Weekly plan, type a week number to get a one-page plan you can print or share.

Before you start:

  • Capacity: 80 lessons, 30 standards, 8 units and 16 weeks. Unused rows stay blank.
  • A lesson is "due" when its date is on or before the "as of" date on Setup and it is not cancelled. Behind means due lessons that are not marked Taught; Postponed lessons count as not taught until you change them.
  • A lesson that is still Planned but already due is flagged "Mark status" on the Lessons sheet, so lessons you forgot to update do not hide.
  • If you reschedule a postponed lesson, add a new row with the new date and set the old one to Cancelled so it is not counted twice.
  • A lesson can address two standards. If you pick the same standard twice on one lesson, it is counted twice for that standard.

Excel file (.xlsx) · 40 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet holds the numbers of one class, typed in by one teacher. In the School Performance Management Platform, each student's grades, attendance and teacher notes come together, and reports reach parents.

In this sheetIn School Performance Management Platform
Every teacher has a sheet, and the administration collects the files.One dashboard for students, teachers and classes, with exam results tracking and a comparison of performance across terms.
A student's decline shows up in the end-of-term result.AI analyzes the student's grades, attendance and teacher notes, warns early about a possible decline, and suggests a development plan that the teacher decides on.
The parent learns about the problem late.Regular reports to parents on the student's level, teacher notes and the attendance record, plus direct contact with the school through the app.
Attendance lives in a notebook or a sheet per class.Attendance, absence and lateness are recorded for each student and turned into attendance reports and rates that the administration follows for each class.

See School Performance Management Platform · Ask for a demo

Frequently asked questions

Is this lesson plan template free?

Yes. It is free to download, change and share. It is a normal Excel file and opens in Google Sheets and LibreOffice too.

Does it work for any subject and grade?

Yes. Units, standards, assessment types and statuses are lists you type yourself. The sample uses a Grade 6 maths course, but nothing in the formulas depends on the subject, and you can use your own standards codes or learning goals.

What do I do when a lesson is postponed?

Set its status to Postponed. It stays counted as due and not taught, so pacing shows the gap. When you reschedule it, add a new row with the new date and set the old row to Cancelled so it is not counted twice.

How many lessons, standards and units fit?

80 lessons, 30 standards, 8 units and a term of up to 16 weeks per file. Save a separate copy for each course or term.

Can I get a printed version for one week?

Yes. Open Weekly plan, type the week number and print. For testing dates see exam schedule, and for your weekly timetable see class timetable.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Excel templates for teachers: gradebook, lesson planning and follow-up

More free templates for: Teachers

More free templates

All templates · Free tools