Yearly Lesson Plan Template

Map the school year into units on a timeline, then plan and tick off the individual lessons inside each unit.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Education

Tables

Units, Lessons

Fields

23

Views

grid, timeline, kanban, calendar

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Units

12 fields · 4 sample rows

  • Year plan (Grid)
  • Timeline (Timeline)
  • Status (Kanban)
UnitTextSubjectSingle selectGradeSingle selectTermSingle selectStartsDateEndsDateWeeksFormulaLearning objectivesLong textAssessmentSingle selectStatusSingle selectLessonsLink to another tableLesson countCount
Cells and organismsScienceGrade 7Term 120 Sep 202625 Oct 20265Identify cell parts; compare plant and animal cells; use a microscope safely.Lab practicalTaughtPlant vs animal cells, Microscope practical2
Forces and motionScienceGrade 7Term 126 Oct 202629 Nov 20264.9Describe balanced/unbalanced forces; calculate speed; investigate friction.Unit testIn progressWhat is a force?, Friction investigation, Speed = distance / time3
Chemical reactionsScienceGrade 7Term 29 Dec 202613 Jan 20275ProjectPlanned0
Ecosystems & food websScienceGrade 7Term 317 Feb 202724 Mar 20275PresentationPlanned0
Field details
Unit · Text
Subject · Single select
Science, Mathematics, English
Grade · Single select
Grade 7, Grade 8
Term · Single select
Term 1, Term 2, Term 3
Starts · Date
Ends · Date
Weeks · Formula
IF(AND({Starts}, {Ends}), ROUND(DATETIME_DIFF({Ends}, {Starts}, 'days') / 7, 1), BLANK())
Learning objectives · Long text
Assessment · Single select
Unit test, Project, Presentation, Lab practical, Portfolio
Status · Single select
Planned, In progress, Taught, Reviewed
Lessons · Link to another table
Links to Lessons
Lesson count · Count

Lessons

11 fields · 5 sample rows

  • Lessons (Grid)
  • Calendar (Calendar)
LessonTextUnitLink to another tableDateDateLengthDurationObjectiveTextActivitiesLong textMaterialsTextHomeworkTextTaughtCheckboxReflectionLong textResourcesAttachment
What is a force?Forces and motion30 Oct 20260:45Define force and give examplesPush/pull sorting game; spring balance demoSpring balances, toy carsYes
Friction investigationForces and motion13 Nov 20261:30Plan a fair test on surfacesRamp experiment in groups of 4Ramps, sandpaper, towelsWrite up results tableYesRan over time; split into two periods next year.
Speed = distance / timeForces and motion21 Nov 20260:45Calculate average speedStopwatches, measuring tape
Plant vs animal cellsCells and organisms30 Sep 20260:45Compare cell structuresYes
Microscope practicalCells and organisms5 Oct 20261:30Prepare an onion-skin slideMicroscopes, iodine, slidesYes
Field details
Lesson · Text
Unit · Link to another table
Links to Units
Date · Date
Length · Duration
Objective · Text
Activities · Long text
Materials · Text
Homework · Text
Taught · Checkbox
Reflection · Long text
Resources · Attachment

Yearly Lesson Plan Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates