Choose a thumbnail or use the arrows to explore all 6 product photos. Click to enlarge.
Homeschool Record Keeping & Progress Tracker Kit | Attendance, Curriculum & Learning Hours
Keep attendance, learning hours, curriculum progress and student summaries in one editable homeschool tracker for Google Sheets and Excel.
- 10 organized Google Sheets + Excel tabs
- Blank workbooks + filled fictional examples
- Attendance, hours and lesson progress
- 3 PDFs, including a printable year-end checklist
Keep your homeschool records in one place.
Record what each student worked on, how much time they spent learning, and which lessons they completed. Use those records to review progress throughout the school year.
Attendance hard to reconstruct?
Log attendance by student and date, with learning hours calculated from matching daily entries.
Lessons spread across subjects?
Record planned and completed lessons so you can see what each student has covered.
Year-end records scattered?
Review a student’s attendance, hours and progress in a printable summary with space for parent notes.
See what each student worked on.
Create a student profile once, then use that student ID in your daily entries. Select the ID on the dashboard whenever you want to review their records.
- Log dates, subjects, activities and learning minutes
- Record attendance and review calculated learning hours
- Track lesson completion and informal assessment scores
- Keep separate notes on reading and enrichment activities
Use student aliases where possible and keep sensitive records private.
10 tabs for planning and record keeping.
The Google Sheets and Excel versions use the same tabs for student setup, daily entries and progress reviews.
📊 Dashboard
View attendance days, learning hours, curriculum completion and informal assessment results by student.
🗂️ Start Here + Student Setup
Follow the setup steps and add student IDs, aliases, grades and school years.
📅 School Calendar + Daily Learning Log
Keep school events and breaks in the calendar. Log learning activities and minutes by student and date.
✅ Attendance & Hours
Enter attendance and use matching daily log entries to calculate learning hours, with an optional override.
📚 Curriculum Progress + Grades & Assessments
Review lesson completion by subject and calculate percentages from informal quizzes and projects.
📝 Reading & Activities + Year-End Summary
Log books and enrichment separately, then select a student to print their year-end overview.
Editable workbooks and three PDFs.
Start with a blank workbook or open a filled example to see how the tabs work together.
- Blank Google Sheets workbook with a Make a Copy link
- Filled Google Sheets workbook with fictional student records
- Blank and filled Excel workbooks in XLSX format
- Access PDF with links to all four workbook versions
- Quick Start PDF with setup steps and tab-by-tab guidance
- Printable Year-End Checklist PDF for reviewing your records
Set up your tracker in three steps.
The Quick Start Guide walks you through the workbook.
Open the Access PDF
Choose Google Sheets or Excel and decide whether to start blank or explore the filled example.
Make your copy
Select Make a Copy in Google Sheets, or use Save As or Save a Copy in Excel.
Add students and start logging
Set up a unique ID for each student and begin recording lessons, attendance and learning time.
Review and check your records as you go.
Use the dashboard for a regular check-in and the year-end summary when you’re ready to print.
👥 Individual student views
Switch student IDs to review separate records in one workbook.
🧮 Linked formulas
Calculate learning hours, lesson completion percentages and informal scores from your entries.
📅 Duplicate attendance flags
Matching attendance rows for the same student and date are highlighted for you to review.
📄 Printable student summary
Review each student’s records and add parent notes before printing.
Good to know before buying.
What exactly is included?
Blank and fictional filled workbooks for Google Sheets and Excel, plus an Access PDF, a Quick Start Guide and a printable Year-End Checklist.
Does it work in Excel?
Yes. Open the included blank or filled XLSX file in Excel and save your own copy.
Do I need a Google account?
Sign in to Google to make an editable Google Sheets copy. You can open the XLSX files directly in Excel.
Can I use it for multiple students?
Yes. Give each student a unique ID, then select that ID on the Dashboard or Year-End Summary.
How are learning hours calculated?
Attendance & Hours uses Daily Learning Log entries that match the student ID and date. You can enter an override where needed.
Can I print a year-end summary?
Yes. Choose the student ID in Year-End Summary, add parent notes and print the overview.
Is this a one-time purchase?
Yes. The kit is a one-time digital download.
What does the license cover?
The files are for personal use by one household.
Full product description and terms of use
HOMESCHOOL RECORD KEEPING & PROGRESS TRACKER KIT — GOOGLE SHEETS + EXCEL
One organized home-learning system. Clearer attendance records, learning hours, curriculum progress and student summaries.
Bring your family’s everyday homeschool planning into one practical homeschool record keeping spreadsheet. Track learning sessions, document attendance, monitor lesson completion and review informal assessments without juggling multiple notebooks and disconnected files. Created for U.S. homeschooling parents and caregivers managing one or more students.
WHAT'S INCLUDED IN THE $19 KIT
- Google Sheets — BLANK workbook: native editable 10-tab template with a Make a Copy link.
- Google Sheets — FILLED EXAMPLE: fictional student records to demonstrate the dashboard and workflows.
- Microsoft Excel — BLANK + FILLED: two editable XLSX workbooks.
- 01_ACCESS_GOOGLE_SHEETS_AND_EXCEL.pdf: four clickable buttons linking to the corresponding blank and filled files.
- 02_HOMESCHOOL_QUICK_START_GUIDE.pdf: practical setup, tab-by-tab guidance and troubleshooting.
- 03_HOMESCHOOL_YEAR_END_CHECKLIST.pdf: printable checklist for reviewing your own records.
THE 10 WORKBOOK TABS
- START HERE — instructions, privacy reminders and setup steps.
- DASHBOARD — select a student ID to see attendance days, recorded learning hours, curriculum completion, informal assessment averages, reading and lesson entries.
- STUDENT SETUP — unique student IDs, aliases, grades, school years and optional personal targets.
- SCHOOL CALENDAR — log learning events, breaks, holidays and optional field trips; calendar entries do not automatically create attendance.
- DAILY LEARNING LOG — record the date, student, subject, learning activity and minutes.
- ATTENDANCE & HOURS — enter one attendance status per student and date; matching daily-log minutes calculate learning hours, with optional manual override.
- CURRICULUM PROGRESS — enter planned and completed lessons; see automatic completion percentages and statuses.
- GRADES & ASSESSMENTS — record informal quizzes and projects and calculate earned-points percentages.
- READING & ACTIVITIES — keep a separate record of books, activities and enrichment. Time logged here does not automatically add to attendance hours.
- YEAR-END SUMMARY — student-specific, printable overview with an area for parent notes.
WHAT MAKES IT PRACTICAL
- Built for more than one student: change the selected student ID to see individualized dashboard results.
- Automatic calculations: linked formulas for learning hours, curriculum progress and informal scores.
- Ready to customize: clear green-and-white tables, status dropdowns, and up to 500 prepared data-entry rows per tracking table.
- Duplicate attendance alert: rows with the same student and date are highlighted to help prevent accidental overcounting. Review and correct any duplicates yourself.
- Blank and filled examples: start from scratch or explore a fictional example first.
HOW TO GET STARTED
- Open the Access PDF. Select MAKE A COPY for a private Google Sheets workbook, or open an Excel XLSX file and choose Save As / Save a Copy.
- Add each student’s unique ID and school-year information in STUDENT SETUP.
- Enter learning minutes in DAILY LEARNING LOG, mark attendance in ATTENDANCE & HOURS, and update curriculum units and informal assessments.
- Select a student on DASHBOARD and YEAR-END SUMMARY to review progress and print your personal summary.
FREQUENTLY ASKED QUESTIONS
Do I need a Google account? Only for Google Sheets Make a Copy. You can use the included Excel files without a Google account.
Are attendance days entered automatically? No. You enter one attendance status for each student/date. When the date and student ID match a Daily Learning Log entry, the sheet can calculate logged hours automatically.
Does it calculate school GPA or create an official transcript? No. Assessments are informal, unweighted percentages; this is not an official transcript or GPA calculator.
Does it meet my state's homeschooling requirements? State recordkeeping rules vary and may change. Verify your own requirements independently; this planner does not certify legal compliance.
Can I use it for multiple children? Yes. Give each student a unique ID and choose the student on the dashboard.
Is this a physical product or subscription? No. It is a one-time digital toolkit, with no physical shipment or recurring subscription.
IMPORTANT LIMITATIONS & TERMS
For personal/family educational organization only. Not legal, credentialing, academic, or teaching advice. The kit does not replace any official homeschool records, required evaluations, school forms or state-specific documentation. Store student information privately, use aliases where possible, back up your workbook, and avoid uploading sensitive information about minors into shared files. Fictional example records are not real student data. Licensed to one household for personal use; redistribution and resale are not permitted.
Keep your homeschool
records ready for review.
Start with the blank Google Sheets or Excel workbook, or see how it works with the filled example.