By Friday, it can be hard to remember whether the fractions lesson happened on Tuesday or Wednesday, which book you finished, or where you put the writing sample. A short record made while the day is still fresh is more useful than trying to reconstruct a month of learning later.
Keep the routine small enough to maintain: a dated activity log, a place for selected work samples, and a brief weekly check. Your lesson plan can remain separate. The record should describe what actually happened, including any changes to the plan.
Decide what the record needs to do
Start by checking the current guidance from the education authority responsible for homeschooling where you live. Find out what you need to document, submit, and retain. A personal spreadsheet does not replace required forms, reports, or other records.
For your own reference, useful fields may include the date, attendance, subject, activity or lesson, time spent if you track it, and a short note. Keep each child’s records clearly identified.
Write enough to recognize the learning later
“Math” tells you very little when you revisit the entry. “Compared equivalent fractions with fraction strips; completed questions 1–6” identifies the activity without requiring a paragraph about the whole lesson.
Use notes for details that will help you make the next decision. “Needed help finding a common denominator” is more useful than “good day.” Record what you observed without turning every entry into a formal assessment.
If the plan changed, record the activity that took place. A planned worksheet that was never completed should not appear as completed learning.
Keep days and activity entries separate
Several rows can belong to the same date. Reading, mathematics, and a science activity are three entries, but they are not three attendance days. Check how your chosen record counts dates and attendance before relying on its summary.
If you record time, use a consistent format. Forty-five minutes is 0.75 hours, not 0.45. A 45-minute reading session and a 30-minute mathematics session total 75 minutes, or 1.25 hours.
Avoid counting the same time twice. If a 40-minute project combines science and writing, you could record one combined entry or divide the 40 minutes between the subjects. Assigning the full 40 minutes to both would make the total appear to be 80 minutes.
These examples explain the arithmetic. They do not determine what qualifies as instructional time under your local requirements.
Give work samples a home
Use a folder for each child and school year, with subject folders if they help you find things. Date paper samples or scanned files and identify the activity. A filename such as “2026-10-10-writing-first-draft” is easier to match to the log than “scan004.”
Choose samples that help you see progress, such as an early attempt and a later revision. Keep required documents according to the applicable guidance, even if they are stored separately from your everyday log.
Review briefly at the end of the week
Check for missing dates, inconsistent subject names, and typing errors in hours. Match any saved samples to their entries. If you forgot an activity, use your notes and materials to recover the details; do not invent a precise duration you cannot remember.
Then note any follow-up you want in the lesson plan. The log records past learning; the plan tells you what to try next.
The NeatLittleTools Homeschool Record Keeping Spreadsheet offers Setup, Daily Record, and Record Summary tabs in Google Sheets. It supports multiple activity rows for a date and summarizes recorded days, attendance days, and hours by month and subject. It is a personal record-keeping tool, rather than a curriculum, grading system, or guarantee of compliance.