Skip Navigation

Spreadsheet

Homeschool Year Planner — Pace Every Lesson on Your School Calendar, Re-Pace When You Fall Behind (Excel + Google Sheets)

A homeschool planner for Excel & Google Sheets that paces every lesson across your real school calendar and re-paces what's left when you fall behind.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • Enter each book's lesson count once — the Lesson Plan gives every lesson a planned date on your real school calendar
  • Fell behind? Catch-up shows lessons left, what still fits, the lessons per week now required, double-up days and the re-paced finish
  • Break-aware calendar — your school week, breaks and holidays, numbered school days for 52 weeks, and the last day found from your own day target
  • Fixed days or Loop — a course meets on the weekdays you tick, or takes the next turn in a rotation; a finished loop course leaves the rotation
  • A sick day is one row in Day changes, on the School Calendar tab — the calendar, the plan and every finish date move, and nothing is retyped
  • One Weekly Plan view — pick a child and a week for that week's lessons as a checklist, done lessons ticked from the Done Log
  • Ahead, on pace or behind per course and per child, with a projected last lesson — and days and hours counted against your own targets
  • An 11-tab workbook (Excel and Google Sheets) + a 17-page guide + printable weekly lesson pages · up to 5 children and 40 courses · no subscription

A homeschool planner that re-paces itself

This workbook paces every lesson of every book across your real school calendar, and re-paces what is left when you fall behind. Enter each curriculum’s lesson count once. The Lesson Plan puts every lesson on a school day, skipping your weekends, breaks and holidays. When a sick week puts you behind, Catch-up shows the lessons per week now required and the re-paced finish date, and the Lesson Plan moves every overdue lesson forward from today.

A paper weekly planner, filled in by hand, works until the first sick week, and then every page after it is wrong. Fixing it means rewriting the rest of the term. This planner does that arithmetic for you, for up to 5 children and 40 courses.

Your real school calendar, built once

On Year Setup you set the first day of school, which weekdays are school days, your breaks and holidays (up to 20), and your own day and hour targets. The School Calendar lists every date for 52 weeks, numbers each school day, and finds your last school day from your day target.

A sick day, a field trip or a Saturday make-up is one row in Day changes, on the School Calendar tab. Add it, and the calendar, the lesson plan and every finish date move with it. Your Done Log of finished lessons is kept apart from the plan, so it never changes when the plan does.

Every lesson gets a date: Fixed days or Loop

List each course on Courses with the number of lessons in the book, the minutes per lesson, and how it is scheduled:

  • Fixed days — the course meets on the weekdays you tick (math every day, science on Tuesday and Thursday).
  • Loop — the next lesson comes up on the next school day in rotation, for subjects you rotate through. A loop course that has finished leaves the rotation, and the others take its turn.

The Lesson Plan lists every lesson with its planned date and week, with room for up to 3,000 lessons, and Courses shows each book’s planned finish date.

Fell behind? Catch-up does the math

Catch-up compares what you have logged with the plan and, for every course, shows the lessons left, how many still fit before your last school day, your normal lessons per week, the lessons per week now required, the double-up days needed, a verdict and the re-paced finish date. You pick the method: Keep the rhythm (the rest of the book continues at its normal pace, and the finish date moves later) or Fit by the last day (the remaining lessons are squeezed into the school days you have left).

One week, one child, one page

The Weekly Plan is a single view with a child picker and a week picker, not a separate sheet for every week. It lays out that week’s lessons as a checklist, Monday to Sunday: days that have passed show what was logged, and the days ahead show the re-paced plan. Print it for the kitchen table, or use the undated printable weekly lesson pages instead.

Progress, days and hours

The Progress Dashboard marks every course and every child AHEAD, ON PACE or BEHIND, with a projected last lesson. It also turns what you log into attendance days and hours, counted against the targets your family sets.

Plan the year, then prove it

Binder Export lays your done days and hours out in the columns of our Homeschool Portfolio, Attendance & Transcript Records Binder, which keeps the attendance, portfolio and transcript records. The planner plans and paces the year; the binder keeps the record of it.

What this is, and what it isn’t

This is a planner. It schedules and counts the lessons you plan and log, and it states no state’s homeschool law. The day and hour targets are yours to type in. The blank copy starts at 180 days and 900 hours as examples, not requirements. Check what your own state asks for with its official sources.

Own it, don’t rent it

Subscription homeschool planning apps charge a fee every year. This is a file you keep: no account, no subscription, no per-child fee, and the Excel file works offline. It opens on a clearly fictional example family so you can see every tab working, and a blank copy is included for your own year. Next year, change the start date and the courses. It works in Excel 2016 or later and Microsoft 365, in Google Sheets through the one-click copy, and in LibreOffice.

Want to try the pacing first? The free Homeschool Curriculum Pacing Calculator is a smaller version of this planner’s pacing. No email, no signup.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • The workbook works in Microsoft Excel, Google Sheets, and LibreOffice Calc — see What's included above for every file in the download
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • 00 — Start Here guide (PDF, 17 pages): setting up the year, Fixed days vs Loop, the lesson plan, the Done Log, catching up, days and hours, and the binder export
  • 01 — The Homeschool Year Planner workbook (.xlsx, 11 tabs): Start Here, Year Setup, School Calendar, Courses, Lesson Plan, Weekly Plan, Done Log, Progress Dashboard, Catch-up, Binder Export, Pace Grid — pre-filled with a clearly fictional example family
  • 02 — The same workbook, blank (.xlsx)
  • 03 — Printable Weekly Lesson Pages (PDF, 8 pages): 6 undated page designs, including the weekly lesson page and a loop tracker
  • One-click Google Sheets copy — a ready-made native version (no import needed), linked from Open in Google Sheets.pdf
  • READ-ME-FIRST.txt

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

One purchase covers personal and household use plus internal use within one organization, including coworkers. You may share completed outputs and client-specific documents. Reusable templates cannot be resold, published, or distributed outside your licensed group; reusable client copies or additional organizations need their own purchase or an explicit product-specific or separate written license. Included client-gift permissions remain valid within their stated limits. Read the digital product license. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Compare the setup effort, collaboration, and automation you need. Ardent Workshop sells ready-made templates; a custom spreadsheet or software platform may fit better depending on the job.

  1. Blank spreadsheet

    Build the structure around your own process, with time set aside for formulas, layout, and maintenance.

    • Flexible structure
    • You build it
    • Software costs vary
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Software platform

    Consider a platform when you need shared workflows, automation, or integrations. Check the specific plan, permissions, and export options.

    • Features vary
    • Check total cost
    • Check data portability

Ready to start

Instant download · Free lifetime updates · Personal & internal business use

$12.95 USD
Buy now

Pairs well with