Homeschool Portfolio Tracker — High School Transcript & Credit Hour System — product cover

Category: Spreadsheets · Tracking Dashboards

About this product

Keep four years of homeschool high school organized in one workbook: courses, credits, GPAs, attendance, and the portfolio evidence behind it all — with a print-ready transcript at the end.

WHAT'S INSIDE (8 sheets, 100% formulas, works in Excel, Google Sheets, LibreOffice)

  • SETUP: your school, student, editable 4.0 grading scale, optional Honors/AP weighting (+1.0), and your own hours-per-credit convention
  • COURSES: 60 course rows across grades 9-12 — credits, hours, grades, and Honors/AP flags compute grade points, quality points, credits earned, and a LOW HOURS check automatically. F earns 0 credits; P earns credits without touching GPA; blank rows stay planned
  • TRANSCRIPT: print-ready parent-issued transcript — courses by year, year GPAs, cumulative unweighted + weighted GPA, total credits, school-profile notes, signature line. Prints on one page
  • CREDITS: your graduation targets by subject (editable example set included) with earned vs. remaining and ON TRACK / SHORT pace flags
  • ATTENDANCE: school days, hours by subject, and a reconciliation check against your course hours
  • PORTFOLIO: work samples, assessments, activities, awards, community service hours — the evidence file behind the transcript
  • DASHBOARD: cumulative GPAs, credits earned/remaining, portfolio counts
  • README: the workflow, in plain language

ALSO INCLUDED: Quick-Start Guide PDF (setup in 10 minutes, the weekly workflow, printing the transcript) and a single-buyer license.

IMPORTANT, PLEASE READ: homeschool laws, attendance rules, and graduation requirements vary by state and country — verify your local requirements. Targets, the grading scale, and the hour convention ship as EXAMPLES for you to set. This is a record-keeping aid, not legal advice, and the transcript is a parent-issued record with no accreditation. Sample student and all data are fictional, included to demonstrate the system.

$24 — instant download. One workbook, four years, zero guesswork.

What's included

  • Homeschool-Portfolio-Tracker.xlsx — 8 sheets, 100% formulas (works in Excel, Google Sheets, LibreOffice):
  • SETUP — your school, student, editable 4.0 grading scale, optional Honors/AP weighting (+1.0), and your own hours-per-credit convention
  • COURSES — 60 course rows across grades 9–12: credits, hours, grades, and Honors/AP flags compute grade points, quality points, credits earned, and a LOW HOURS check automatically (F earns 0 credits; P earns credits without touching GPA; blank rows stay planned)
  • TRANSCRIPT — print-ready parent-issued transcript: courses by year, year GPAs, cumulative unweighted + weighted GPA, total credits, school-profile notes, signature line; prints on one page
  • CREDITS — your graduation targets by subject (editable example set included) with earned vs. remaining and ON TRACK / SHORT pace flags
  • ATTENDANCE — school days, hours by subject, and a reconciliation check against your course hours
  • PORTFOLIO — work samples, assessments, activities, awards, community service hours: the evidence file behind the transcript
  • DASHBOARD — cumulative GPAs, credits earned/remaining, portfolio counts
  • README — the workflow, in plain language
  • Quick-Start Guide (PDF) — setup in 10 minutes, the weekly workflow, printing the transcript
  • README-license.txt — single-buyer license

Key features

  • 60 course rows across grades 9–12 → grade points, quality points, and credits earned compute automatically
  • LOW HOURS check → courses that fall short of your hours-per-credit convention are flagged
  • Honest grade handling → F earns 0 credits; P earns credits without touching GPA; blank rows stay planned
  • Print-ready transcript → courses by year, year GPAs, cumulative unweighted + weighted GPA, total credits, and a signature line — prints on one page
  • Graduation targets by subject → earned vs. remaining with ON TRACK / SHORT pace flags
  • Attendance reconciliation → school days and hours by subject, checked against your course hours
  • Portfolio evidence file → work samples, assessments, activities, awards, and community service hours behind the transcript
  • Your rules, not ours → editable 4.0 grading scale, optional Honors/AP weighting (+1.0), and your own hours-per-credit convention in SETUP
  • QA-verified → 225/225 checks passed against an independent model + LibreOffice recalc, 0 error cells

Frequently asked questions

Is the transcript accredited?

No — the transcript is a parent-issued record with no accreditation. This is a record-keeping aid, not legal advice.

Do the built-in targets match my state's requirements?

Not necessarily — homeschool laws, attendance rules, and graduation requirements vary by state and country. Verify your local requirements. Targets, the grading scale, and the hour convention ship as EXAMPLES for you to set.

How do Honors/AP courses count?

SETUP includes optional Honors/AP weighting (+1.0) that you can turn on or off; the transcript shows both unweighted and weighted cumulative GPA.

What happens with an F or a Pass grade?

An F earns 0 credits; a P earns credits without touching GPA; blank rows stay planned.

Is the sample student real?

No — the sample student and all data are fictional, included to demonstrate the system.

What software do I need?

The workbook is 100% formulas and works in Excel, Google Sheets, and LibreOffice.

Homeschool Portfolio Tracker — High School Transcript & Credit Hour System — product image

Homeschool Portfolio Tracker — High School Transcript & Credit Hour System

One 8-sheet Excel workbook for homeschool high school: courses, credits, GPAs, attendance, and the portfolio evidence behind it all — with a print-ready transcript at the end.

$24

Buy Now on Gumroad

Related products

More Spreadsheets
Small Business KPI Dashboard — product image
Spreadsheets

Small Business KPI Dashboard

Know your numbers in 15 minutes a month. A formula-driven spreadsheet tracking the 9 KPIs that matter — revenue, margins, CAC, conversion, cash runway — with trend charts and a target scorecard. Sample data preloaded.