Skip to content

We've built 200+ tools — open your toolbox, there's something in here you probably need.

LeadAfrik
← TemplatesSchools & churches

Free Lesson Planner (Excel, CBC-aware) — timetable, lesson plans and topics tracker

Planning that lives on loose sheets is planning you cannot see. This free planner puts it in one place, built for a Kenyan CBC classroom. Fill your weekly timetable, write a plan for every lesson with its strand, learning outcomes, activities and resources, and track each topic from not started to covered, so at any point in the term you know what you have taught and what is still ahead.

Download — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up
Prefer Google Sheets? You don't need Microsoft Excel →
  1. Download the file above.
  2. Open Google Drive, then New → File upload and choose the file.
  3. Right-click it in Drive → Open with → Google Sheets. It becomes a fully editable Google Sheet — every formula and tab intact — and works on your phone too.

The .xlsx format opens free in Google Sheets, LibreOffice, or Excel for the web — no paid software required.

What's inside

  • Weekly timetable grid (periods down, Monday to Friday across) with subject dropdowns
  • A lesson plan per lesson: strand, learning outcomes, activities, resources and notes
  • Status dropdown (Planned, Delivered, Postponed) that colours itself
  • Topics-covered tracker from not started to covered, per subject
  • Summary of lessons planned, delivered and topics covered, counted for you
  • Formulas locked; only the yellow cells accept typing; works on a phone

The tabs

  • Start Here (guide)
  • Timetable
  • Lesson Plans
  • Topics Covered
  • Summary

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

Basic vs Premium

The free version does the job. The premium does more of it.

The free basic workbook above is a complete, formula-driven template you can use forever. The premium upgrade adds the extras that turn record-keeping into a management tool.

Basic — Free

  • The core sheets and formulas, in KES
  • Works in Excel or Google Sheets, on your phone
  • Yours to keep, no sign-up

Premium — KES 500

  • A term dashboard of lessons planned versus delivered by week, drawn as bars
  • A subject-load analysis: periods, lessons planned and lessons delivered per subject
  • A printable weekly plan (A4) you can pin up or hand to the head of department
  • Kiswahili labels alongside English (Somo, Mada, Malengo, Shughuli)
Get Premium — KES 500 · Excel (.xlsx) ↓Pay once via M-Pesa (Kenya) · yours to keep · opens in Excel or Google Sheets

On the Timetable tab, fill each period from Monday to Friday with the subject you teach, chosen from a dropdown. On the Lesson Plans tab, add one row per lesson: the week, day, subject, strand, sub-strand or topic, learning outcomes, activities, resources and a reflection, then set the status to Planned, Delivered or Postponed. The Topics Covered tab lets you list your term's topics and mark each Not started, In progress or Covered as you go.

The Summary counts your periods, your lessons planned and delivered, your delivery rate and the share of topics covered, all worked out for you. Yellow cells are the only ones you type in; every other cell is a locked formula, and the status columns colour themselves so progress is obvious at a glance. It opens in Excel, WPS or Google Sheets, with no macros.

Do it online instead

Turn your term marks into a printable transcript

Open the free tool →

Custom work

Need a template made just for you?

Can't find the exact workbook, or want one branded and built around how your business actually runs? We build custom Excel & Google Sheets — bespoke financial models, dashboards, sector trackers, data clean-up and automation. Need it in English or Kiswahili, or another language? Just ask. Tell us what you need and we'll quote.

Request a custom template or Excel service →Email info@leadafrik.com

Frequently asked questions

Is the basic version free?

Yes. The basic Lesson Planner is free to download and keep, term after term. The premium upgrade, with a term dashboard, a subject analysis and a printable weekly plan, is an optional KES 500.

Is it built for CBC?

Yes. The lesson plan uses CBC language (strand, sub-strand, learning outcomes, learning activities and resources) and the topics tracker follows your scheme of work, so it fits how a Kenyan classroom actually plans.

How does it show what I have covered?

The Topics Covered tab marks each topic Not started, In progress or Covered, and the Summary turns that into a percentage covered. The premium dashboard adds lessons planned versus delivered for each week of the term.

Tools & templates you may need

Class Attendance Register →CBC Grade Tracker →School Fees Management →Church Finance & Membership →Student Report Card Generator →School Inventory Tracker →Student Marks & Gradebook →Exam Analysis Dashboard →Teacher Timetable Generator →Private Tuition Income Tracker →All templates →

Available in English, with Kiswahili labels in the premium version. Need it in another language, or a custom build? Email info@leadafrik.com.