• 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:

  • Should Parents Force Their Children to Take Piano Lessons?
  • How to Catch Common Misspellings in Writing
  • Free Printable Logical Fallacy Poster
  • How to Create Daily Schedules

Comments

  1. Gwen says

    August 4, 2011 at 1:20 pm

    Thanks so much! I am going to post a link on my blog to this!

    http://heart4thehome-homeschoolramblings.blogspot.com/2011/08/free-gradebook-great-for-high-schoolers.html

    Reply
  2. Stef - Educating Layton says

    August 4, 2011 at 9:31 pm

    squee you added the field trip page! THANKS !!

    Reply
  3. Eva says

    August 5, 2011 at 12:35 am

    Thanks so much!!

    Reply
  4. Linda says

    August 5, 2011 at 11:19 am

    Thanks, Joy. This looks great! I'm sharing it with my homeschool group.

    Reply
  5. Jackie says

    August 6, 2011 at 10:36 am

    Love this. I am going to put a post on my blog (www.quaintscribbles.wordpress.com)
    I have lots of homeschool families that will be able to use it.

    Joyfully,
    Jackie

    Reply
  6. Lynnet says

    August 6, 2011 at 12:10 pm

    This looks good. We have problems using Excel and Office on our home computer, so I use an free on-line grade book: http://www.engrade.com. Incredibly easy to use.

    Reply
    • Joy says

      August 6, 2011 at 12:33 pm

      Thanks for posting that link to Engrade! I'd never heard of it before. Looks really cool!

      Reply
  7. Cara R. says

    August 7, 2011 at 11:20 pm

    Thank you for sharing. As you already know, I shared this on my blog. I'm so sorry I got your name wrong!

    Reply
  8. Tammy says

    August 11, 2011 at 2:52 pm

    From an Excel…I don't like to use the word, but it really fits me here…idiot – thanks so much!

    Reply
  9. Dana ~Are We There Yet? says

    August 15, 2011 at 1:26 pm

    Just entering grades today…the unused subject tabs with their scores of '0' are bringing down the grade point average. Have I done something wrong?

    Reply
    • Joy says

      August 15, 2011 at 2:10 pm

      Are you using the Excel or Open Office version?

      Reply
  10. Monica says

    August 16, 2011 at 10:29 am

    I was wondering on the Gradebook if there was a way to show on the grade report the child's grades by Term as to see the progress through the year?
    I so appreciate all your work you've done for us less-skilled homeschoolers. Bless you!

    Reply
    • Joy says

      August 16, 2011 at 11:19 pm

      @Monica, Monica, I didn't set it up to do grades by term, but you could certainly add that to the spread sheet if you'd like. It's not a feature I use personally, so I didn't think to add it.

      Reply
  11. Chelsey says

    August 19, 2011 at 8:52 am

    What a WONDERFUL grade book. I’ve been looking and looking and never could find what I needed. This is great. We are starting High School this year and need to start keeping grades. One question for you. I am also wanting to keep track of GPA, what would be the best way to incorporate this?

    Reply
  12. Jenn says

    September 9, 2011 at 12:23 pm

    THANK YOU, thank you, thank you! We just began high school this year. I needed some way to keep track of his grades and course studies! This is such a blessing! I am an excel dummy, so this was perfect! I can't thank you enough for helping me out!!!!

    Reply
  13. Micki says

    September 20, 2011 at 11:56 pm

    I just wanted to say thanks for this wonderful site! It is as beautiful as it is helpful. 🙂

    Reply
  14. Missy says

    October 4, 2011 at 2:58 am

    Thank You! This is a wonderful tool and exceeds my expectations. This is going to save me a lot of time this year.
    Blessings!

    Reply
  15. Missy says

    October 4, 2011 at 3:00 am

    Thank You! This is a wonderful tool and exceeds my expectations. This is going to save me a lot of time this year.
    Blessings!

    P.S. I pinned this to my Homeschool Favorites board on http://www.pinterest.com/smokeybutter

    Reply
  16. Brenda says

    December 27, 2011 at 3:31 pm

    Wow – this is wonderful! I really appreciate your willingness to share this wonderful resource! I have been using it to update my records for my freshman's grades and I can't believe how much better I feel about record keeping. Thank you, thank you, thank you!

    Reply
  17. Annette says

    January 30, 2012 at 4:52 pm

    I was wondering the same as a fellow homeschooling mom, What about GPA's. Could you give directions on how to get a GPA on the Grade Report page?

    Reply
  18. Ruth says

    February 13, 2012 at 8:10 pm

    Hello and thank you for creating GradeBook +. Is there a way to add a sheet for Community Service?
    Thank you.

    Reply
    • Joy says

      February 13, 2012 at 8:40 pm

      Absolutely. You should be able to just add the sheet however you'd normally add a new sheet in your program.

      Reply
  19. Nikki says

    July 19, 2012 at 1:00 pm

    I was trying to download your gradebook+…that looks super cool, but every time I try I get a page like this:
    ÐÏࡱá????????????????;??þÿ ???????????????¸?????????µ?????þÿÿÿ????????€??????‚???ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿýÿÿÿÿÿÿÿ?????????????????? ???

    It never goes to a download page just this. It seems that the open office works fine, but I don't really use that. Suggestions?

    Thanks,
    Nikki

    Reply
    • Joy @ Five J's says

      July 19, 2012 at 1:05 pm

      You'll need to right-click and choose "Save As" for the Excel link. Otherwise, if you just click, your browser will try to open it in a new window and it won't be able to read it, hence the ugly code. 🙂

      Reply
  20. Nicky says

    September 4, 2012 at 10:14 am

    Wow, that's a lot of work to get that all prepared & the kinks ironed out. As a result, I'm hesitant to say this, but in case someone is looking for another option, I just wanted to state that I've used another program, called Homeschool Tracker, very successfully for the past several years. There is a free version which works fine for younger grades. Once I needed to start using weighted grading, etc, I made a one time purchase of the HT Plus. I have been VERY pleased with it. http://www.homeschooltracker.com/
    [And no, I'm not affiliated with it 🙂 ]
    Thanks again for this site. I find myself sending links to it to people who are just starting out home schooling since it contains so much helpful info. and answers many of the questions with which new home schoolers struggle.

    Reply
    • Joy @ Five J's says

      September 4, 2012 at 10:36 am

      Nicky, I use homeschool tracker too (the online version) and love it. The big difference between HST and my gradebook is that Homeschool Tracker is a curriculum scheduler + gradebook. My spreadsheet is solely a gradebook. If someone wants to schedule curriculum, I'd definitely say HST is the best option, but if want just a place to record grades, something like my Gradebook would be easy to use.

      Reply
  21. Sue says

    June 15, 2013 at 6:33 pm

    We have completed our first year of homeschool and your program was sent by God for me. I was stressing over how to grade and keep track of our work and do it right when I found your FREE program! It helped me keep our information organized and in one place. Thank you, thank you!
    God bless you!

    Reply
  22. Hope says

    August 5, 2013 at 11:41 pm

    Thank you so much! This is my first year homeschooling my 8th grader and I didn't want to have to create a WHOLE gradebook from scratch. This is awesome!

    Reply
Newer 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

  • Trump signs ‘strategic economic partnership’ with Saudi Arabia
  • Trump Unveils Plan to Slash U.S. Drug Costs by Matching Global Prices
  • NJ Democrats ‘storm’ Newark ICE facility housing MS-13 members in ‘bizarre political stunt’
  • News quiz for week ending 5/9/25
  • Greatest Fear
  • American Manufacturers Overwhelmed With Orders After Trump’s Tariff Crackdown On China
  • US to celebrate “Victory Day for WWII” as Europe commemorates VE Day
  • CIA Launches Chinese Spy Recruitment Video
  • Lowlife jewelry thieves targeting the elderly in Los Angeles
  • Devastating blackout in Spain raises questions about reliance on solar power, wind power
  • 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.