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+.

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 on FacebookPin on PinterestTweet about this on TwitterEmail this to someone
DISCLOSURE: To support my blogging activities, I may receive monetary compensation or other types of remuneration for my endorsement, recommendation, testimonial and/or link to any products or services from this blog. Please note that I only ever endorse products that are in alignment with Five Js' ideals and that I believe would be of value to my readers. I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. You can read my full disclosure here.
Subscribe Via Email
…or subscribe via RSS

Comments

  1. says

    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]

  2. says

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

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

    [Reply]

  3. says

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

    Are you using the Excel or Open Office version?

    [Reply]

  4. Monica says

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

    @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]

  5. says

    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]

  6. says

    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]

  7. Brenda says

    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]

  8. Annette says

    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]

  9. Ruth says

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

    [Reply]

    Joy Reply:

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

    [Reply]

  10. Nikki says

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

    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]

  11. Nicky says

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

    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]

  12. Sue says

    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]

  13. Hope says

    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]

  14. adena says

    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]

  15. Carrie says

    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]

  16. Xio Callahan says

    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]

  17. says

    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]

  18. Rhoda Jane Olmstead says

    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]

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>