• Homeschooling 101: The Basics
  • Strategies & Tips for Parents
  • Printables & Downloads
  • Resources for Homeschooling
  • Our Curriculum: What We've Used
  • Home
  • Blog
  • About
  • Contact
  • Advertise

Five J's Homeschool

Free Homeschooling Resources to Help Parents Raise Lifelong Learners

  • Homeschooling 101The Basics
  • Printables& Downloads
    • Free Gradebook+ Download
    • All Printables & Downloads
  • Strategies & TipsFor Parents
  • ResourcesFor Homeschooling
  • Our CurriculumWhat We've Used
  • See Recent Posts
  • Language Arts
  • Math
  • Science
  • Social Studies
  • Life Skills
You are here: Home / Homeschooling / Planning & Organization / Free Homeschool Gradebook & Record-Keeping Spreadsheet

Filed Under: Planning & Organization · Printables & Downloads · Free Curriculum · Homeschool Planning

Free Homeschool Gradebook & Record-Keeping Spreadsheet

Free Homeschool Gradebook & Record-Keeping Spreadsheet
School started for us this week, and since I'm now homeschooling a high schooler, I've been scrambling all summer to figure out how best to keep track of grades and other important records.

As usual, I looked around the internet, and although I found some spreadsheet templates for keeping grades, none of them seemed to be a perfect fit for us.

And so (surprise, surprise!) I made up a gradebook spreadsheet of my own which I'd like to share with my readers.

I'm actually very excited about how it turned out, because it's morphed into more than just a gradebook, which is why I've officially dubbed it Gradebook+.

DISCLAIMER: I have tried to the best of my ability to make sure all formulas in this spreadsheet are accurate, however, I cannot guarantee that it is without errors. Consequently, by using this Gradebook+, you assume responsibility for ensuring that calculations are accurate. I cannot be held liable if errors occur in calculations.

Here is what's included in Gradebook+:

  1. A Summary Overview of all the current grades in each course
  2. An Attendance Record that is not year-specific, so it does not have to be altered from year to year
  3. Adjustable grading scale and weighted grades
  4. Room for recording grades for up to 12 different courses, including information about the course such as curriculum and resources used
  5. Ability to record up to 5 different types of grades (such as daily, quizzes, tests, etc.) with each type having a different weight if desired
  6. Grades automatically averaged according to weight and number of credits for the course
  7. A printable Book List, Extra-Curricular Activities Report, and Field Trip List
  8. A printable Report Card and Course List that are automatically generated
  9. Detailed directions about how to use the spreadsheet template

Since I'm sure I'll be updating Gradebook+ at times, I'm hosting it on its own page at FiveJs.com. You can download Gradebook+ here for either Open Office or Excel.

I also want to say a huge "Thank You" to my wonderful friends Jessica @ LifeAsMom.com, Jen @ SavingAndGiving.net, and Lynn @ LynnsKitchenAdventures.com who tested Gradebook+ with Excel and spent a lot of time helping me troubleshoot errors. I could not have done this without them!

You can see some screenshots of Gradebook+ below. Click on the thumbnails to view full size.

I hope this can help other homeschoolers who have high schoolers to keep track of their grades and credits for their high school transcript as they prepare for college.

Share this:

  • Twitter
  • Facebook

You may also like:

  • Teaching Children How to Fill Out Forms
  • Recorder Fingering Chart
  • The Golden Goblet (a vocabulary list/glossary)
  • Weekly Homeschool Conference & Evaluation Forms

Comments

  1. adena says

    August 15, 2013 at 11:46 pm

    Best thing I could find on the internet. Much better then 3 sights I tried that you have to pay for to keep online records. Thank you for sharing!

    Reply
  2. Carrie says

    August 22, 2013 at 7:57 pm

    Thank you. I found your Gradebook+ using google search. This is exactly what I wanted, but didn't know how to do it in calc or excel without spending hours doing it. I praise my Lord fer setting your gift before my eyes. May you be generously rewarded for your service to busy homeschool moms.

    Reply
  3. Xio Callahan says

    August 28, 2013 at 3:26 pm

    I am a home school mom of 4. Your site is a God send!!! THANK YOU so much for the time and devotion this obviously took to be this nice of a site!!!!

    xoxoxoxo-

    Xio

    Reply
  4. Tara says

    September 30, 2013 at 7:46 pm

    is there a way to enter extra credit?

    Reply
  5. Julie says

    April 17, 2014 at 8:12 am

    Joy,

    Thanks so much for sharing your grade book! You have saved us so much time and effort. I have shared this with my local HE group in England (US Military). Blessings,

    Julie

    Reply
  6. Rhoda Jane Olmstead says

    August 7, 2014 at 2:58 pm

    Thank you so much for your work on this. It worked so much better for me than anything else I tried. I've been using it for two years, going on three. I'm made a few modifications to it since I'm familiar with Excel just to get it to mold better with my workflow. Thanks so much. This is awesome!

    Reply
  7. Melissa says

    February 5, 2015 at 3:33 am

    Exactly what I was looking for. THANK YOU!
    Sharing on my FB page.

    Reply
  8. Amy says

    September 3, 2015 at 6:50 pm

    THANK YOU! Homeschool organizational heaven!!!!!!!

    Reply
  9. Heidi says

    September 6, 2015 at 12:46 pm

    Very nice work! I would love to see this formatted for Google Sheets So it could be accessed through mobile devises as well!

    Reply
  10. Debbie says

    January 3, 2016 at 9:48 pm

    Thank-you for your work and for sharing! I'm just starting but the set-up has been easy so far 🙂

    Reply
  11. Amber says

    May 12, 2016 at 9:10 am

    Just wanted to say that I used this program this year (our first *real* homeschool year!) and it made my life so much easier! I am setting up the program again for next year's grades, and just sent my Sister in Law the link as well! Thank you so much for this!

    I will add in, I tried putting in attendance daily, but it got a tad confusing for me, so now I just mark it on our calendar, and then put in the dates in bulk, it's easier for me that way.

    Reply
  12. Vasuki says

    May 18, 2016 at 3:48 pm

    Thank you for sharing this, especially for free! It is just what I was looking for.

    Reply
  13. Lisa B. says

    August 18, 2016 at 5:49 pm

    Thank you, thank you, thank you! This is fantastic and just what I needed to create a comprehensive record for my son's high school years. Thank you so much for giving this away! I appreciate it more than I can adequately express. 🙂

    Reply
« Older Comments

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Free Printable Homeschool Planner

RSS Student News Daily

  • US Army’s 250th Anniversary Grand Military Parade and Celebration on June 14
  • Memorial Day 2025
  • Harvard blocked by DHS from enrolling international students
  • Credibility
  • News quiz for week ending 5/23/25
  • Supreme Court to decide major case on judges’ power
  • U.S. to Build Space-Based Missile Shield: Trump’s ‘Golden Dome’ Explained
  • Iran defies U.S., vows to continue uranium enrichment even if deal is reached
  • Supreme Court rules Trump admin must give Venezuelan gang members more time to challenge deportation
  • UAE to build biggest AI campus outside US in Trump deal, bypassing China
  • Home
  • About
  • Contact
  • Advertise
  • Privacy Policy
  • Disclosure
  • Terms of Use

© 2007–2025 Five J's Homeschool. All rights reserved. Design by Five J's Design.