
Grade Book Spreadsheet and Report Card Template
October 12, 2020One of the most difficult things about homeschooling is the record keeping. With all of the quizzes, tests, and other assignments the work can get out of hand. One of our favorite ways to tame this paper tiger is to use a spreadsheet. One spreadsheet can cover four years’ worth of schooling and even several students. This is definitely a simpler more streamlined option. When your student has finally finished their high school years, you simply print out the spreadsheet and include it along with your transcript and other resources that tell your student’s story.
Free Homeschool Grade Record Spreadsheet
For our free downloadable spreadsheet, simply click the image below to open a copy of the sheet. Then click “FILE” and choose “make a copy” or “download.” This will enable the spreadsheet to become yours. You can also add to the spreadsheet for each student or additional semesters. To do this, just right click on the “student 1” tab at the bottom left corner and choose “duplicate.” You can add sheets for each of your student’s grades, multiple students, or dedicate a sheet to quizzes and one to tests. The final column does automatically average the grades you enter… so kudos to not having to use a calculator!
If you would rather have a paper/pencil version of a homeschool grade book, then you’ll want to visit our Back to Homeschool Help Pack. In that pack, there is a beautifully designed grade book that can be reproduced for each child or each year along with several other fun planning pages.
Free Homeschool Report Card Template
Once you’ve kept grades for a while, usually about 9 weeks, you’ll want to create a homeschool report card! You can simply take your grade book and average your student’s grades and then add their final grades for each subject into this handy printable report card template. These come in handy for discounts to places like Chuck E. Cheese as well as participation in Pizza Hut’s reading program and other fun rewards for children.
For your teens, this report card is a great tool for building your final high school transcripts. Creating a report card each year will help you simplify the process of building a high school transcript!
Jamie Gaddy
Jamie Gaddy, B.S., M.Ed., Ed.D. has been a college education professor for over 17 years. Education has been an integral part of her life in both the classroom and as a principal. Six children later found her dissatisfied with traditional schooling and homeschooling became the better fit. She is also a pastor’s wife, remote project manager, and entrepreneur who now homeschools four of her six children (ages 11-17) in southern Georgia. Jamie loves to share about her homeschool experience and help other homeschoolers find success. Connect with her at [email protected]
Latest Posts

Every homeschool family I spoke with agreed: Burnout happens but it’s not a hopeless situation. And just like any other crisis event, there are reasons why it occurs -- and most of those reasons…
Read more >
Guest post by Heidi Rosenberg When you are a student, exams are part and parcel of your academic life, especially as a high school homeschooler! Exams can be stressful and can mount a lot…
Read more >
Sponsored by Time4Writing. With the pandemic, school-closings, and remote learning still a reality in communities from coast to coast, children are facing challenges like never before. If…
Read more >