Homeschool attendance tracker spreadsheet

Many homeschool families keep a record of school days and hours. A spreadsheet that totals them as you go makes that record easy to keep.

The Homeschool Planner has a 180-day attendance log for up to 4 students, an hours log by subject, a lesson and assignment tracker with grades, and a dashboard for each student showing days attended toward 180, hours by subject against weekly targets, and average grade. An overview compares all students side by side.

Requirements differ by state, so check your state's rules; this is a record-keeping tool, not legal advice. Works in Excel and Google Sheets.

What you get

You get two files, a blank template and a filled-in example, plus a Start Here guide. Open them in Microsoft Excel, or upload them to Google Drive and open them with Google Sheets (free). You type in the input cells; the formulas, totals and charts update themselves.

Tips

• Set the school year start date and subjects first.
• Log attendance and hours at the end of each school day.
• Review the dashboard at the end of each month.