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.