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+:
- A Summary Overview of all the current grades in each course
- An Attendance Record that is not year-specific, so it does not have to be altered from year to year
- Adjustable grading scale and weighted grades
- Room for recording grades for up to 12 different courses, including information about the course such as curriculum and resources used
- 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
- Grades automatically averaged according to weight and number of credits for the course
- A printable Book List, Extra-Curricular Activities Report, and Field Trip List
- A printable Report Card and Course List that are automatically generated
- 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.
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!
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.
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
is there a way to enter extra credit?
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
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!
Exactly what I was looking for. THANK YOU!
Sharing on my FB page.
THANK YOU! Homeschool organizational heaven!!!!!!!
Very nice work! I would love to see this formatted for Google Sheets So it could be accessed through mobile devises as well!
Thank-you for your work and for sharing! I'm just starting but the set-up has been easy so far 🙂
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.
Thank you for sharing this, especially for free! It is just what I was looking for.
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. 🙂