Homeschool Records Workbook: Attendance Tracker, Portfolio Log, GPA and State Rules (Excel / Google Sheets)

What it does

One spreadsheet for the whole homeschool year. Log attendance one row per student per day, and the workbook counts days, hours and months for up to four students, checks them against your state's instruction minimum (New York, Pennsylvania, North Carolina, Florida, Texas, Colorado, or a custom rule), and shows what you still need. Keep a dated portfolio log with reading titles and work samples, enter high school courses to get weighted and unweighted GPA by grade level and overall, and track each state filing as Not started, In progress or Filed. The state rules are quoted from the statutes, regulations and education department guides with citations and a checked date, so you can see the exact wording your tracker is measuring against. Plain formulas, no macros, for Excel, Google Sheets and LibreOffice (Apple Numbers opens it, but the drop-downs and highlighting may not carry over). Includes a filled-in example copy so you can see it working before you type a thing. A records aid, not legal advice.

What's included

• Homeschool-Records-Workbook.xlsx: the blank workbook (10 sheets)
• Homeschool-Records-Workbook-EXAMPLE.xlsx: the same workbook filled in with a fictional family
• Setup: state, school year dates, grading scale, four student slots, four reporting-period dates
• Attendance log: 1,000 rows, drop-downs, duplicate-day check
• Progress: days, hours, average hours per day and months logged; required figures by state and grade; Met / Not yet met; days and hours still needed; days and hours by month and by reporting period (useful for New York's quarterly report hours)
• Portfolio log: 500 rows, date, subject, reading titles, what you did, work sample kept
• Courses and GPA: 200 course rows; unweighted and weighted GPA per student by grade level 9-12 and cumulative; credits earned; Honors +0.5 and AP / dual enrollment +1.0 only on a passing grade
• Filings: the filings the site's sources list for each of the six states (for Texas, only a letter of assurance if a district asks for one), who receives it, when, whether there is an official form, with your state highlighted and a status column
• State rules: minimums by grade band, records requirements, how long to keep records, citations, source links and the verbatim quoted law
• Start here page with instructions and the disclaimer

The files

• Blank workbook (10 sheets) Homeschool-Records-Workbook.xlsx
• Filled-in example (a fictional family) Homeschool-Records-Workbook-EXAMPLE.xlsx

Who it's for

Homeschooling parents in the six covered states who have to keep attendance or a portfolio, plus parents of high schoolers who need a transcript GPA, plus parents elsewhere who want a simple attendance and portfolio workbook (Custom state option). Especially useful to New York and Pennsylvania families, whose rules involve hour counts by grade, quarterly reporting and evaluations.