OCTOBER 12, 2020

Grade Book Spreadsheet and Report Card Template


One 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!

Homeschool Report Card Template

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]