Blank lesson plan template
LESSON PLAN Course and group: Date and duration: Lesson topic: LEARNING OUTCOME By the end of the lesson, students will be able to: EVIDENCE OF LEARNING What students will produce, say, solve, or demonstrate: Success criteria: STARTING POINT Prior knowledge or prerequisite: Likely misconception or barrier: SEQUENCE AND TIMING Opening / activation (___ min): Instruction or modeling (___ min): Guided practice and feedback (___ min): Independent or collaborative application (___ min): Check for understanding (___ min): Closing and next step (___ min): ACCESS AND MATERIALS Materials, links, and preparation: Accessibility, differentiation, or accommodations: AFTER THE LESSON Evidence collected: Adjustment for the next lesson or next offering:
Filled example: 75-minute database lesson
LESSON PLAN Course and group: Introduction to databases — Group 02 Date and duration: October 8 — 75 minutes Lesson topic: Choosing INNER JOIN or LEFT JOIN LEARNING OUTCOME By the end of the lesson, students will be able to compare INNER JOIN and LEFT JOIN results and justify the appropriate choice for a stated reporting need. EVIDENCE OF LEARNING Evidence: One working query and a two-sentence justification based on the required rows. Success criteria: correct join; expected rows retained; justification refers to unmatched records. STARTING POINT Prior knowledge: SELECT, table aliases, primary and foreign keys. Likely misconception: assuming LEFT JOIN always returns more rows. SEQUENCE AND TIMING Opening / activation (8 min): predict the output of two joins from a small diagram. Instruction or modeling (15 min): run both queries and trace matched and unmatched rows. Guided practice and feedback (17 min): pairs correct a query that drops customers with no orders. Independent application (25 min): choose a join for two reporting scenarios and write the query. Check for understanding (5 min): hinge question—what changes when the filter moves from ON to WHERE? Closing and next step (5 min): submit the query and justification; preview joins across three tables. ACCESS AND MATERIALS Materials: schema diagram, accessible SQL file, browser-based database sandbox. Access: diagram text alternative; keyboard-accessible sandbox; pairs may explain orally before writing. AFTER THE LESSON Evidence collected: exit queries and justifications. Adjustment: revisit WHERE filters if more than one-third of responses drop unmatched rows.
Start with the learning outcome, not the activity. “Discuss chapter 4” describes what the class will do; “compare two database normalization choices and justify one” describes what students should be able to demonstrate. A focused outcome helps you decide what evidence to collect and which activities are worth the available time.
The six decisions every lesson plan should make
| Decision | Question to answer | Example |
|---|---|---|
| Outcome | What should students be able to do? | Explain when a left join changes the number of returned rows. |
| Evidence | What will show that learning happened? | A worked query plus a two-sentence justification. |
| Starting point | What do students already know? | Basic SELECT and INNER JOIN syntax. |
| Sequence | What progression reduces unnecessary difficulty? | Prediction → demonstration → guided practice → independent task. |
| Check | How will you notice misconceptions during class? | One hinge question before independent work. |
| Follow-up | What happens with the evidence? | Targeted practice or a short review at the next class. |
How to complete the template
- Write one observable learning outcome. Use a verb that describes evidence: explain, solve, compare, design, interpret, or critique.
- Choose the smallest credible piece of evidence. It may be a response, worked example, demonstration, annotated diagram, or brief explanation.
- Plan the learning sequence backward from that evidence. Remove activities that do not prepare students to produce it.
- Reserve time to check understanding before the final task. A quick check should change what you do next, not merely occupy time.
- After class, record one adjustment while the lesson is fresh. That note makes the plan genuinely reusable.
Practical timing guide for a 75-minute class
- 5–10 minutes: activate prior knowledge and clarify the outcome.
- 15–20 minutes: model or explain the central concept with one complete example.
- 15–20 minutes: guided practice with feedback.
- 20–25 minutes: independent or collaborative application.
- 5 minutes: synthesize, collect evidence, and name the next step.
For online or hybrid teaching, keep the same decisions but separate synchronous and asynchronous work. State what must be completed before the meeting, what benefits from interaction, and where students will find feedback afterward. Do not duplicate the same explanation across several tools when one clear course context can connect the document, activity, and assessment.
Common planning mistakes
- Listing activities without stating what students should learn from them.
- Planning more content than the available time allows.
- Saving all evidence of learning for a high-stakes assessment.
- Using “participation” as evidence without defining what productive participation looks like.
- Rebuilding the plan every term instead of recording reusable notes and resources.