I didn’t use grades or gradebooks for elementary school. We simply worked toward mastery.
However, since Elijah is in high school now, I’ve decided to conform to the system in some ways, and I am keeping records and grades.
I didn’t want to buy an electronic gradebook, and I knew my tech-savvy husband could make something for me. I gave him a basic idea, and he created a Microsoft Excel spreadsheet for me.
How to Use the Homeschool High School Gradebook
This homeschool high school gradebook is super simple to use. I hope I don’t complicate it. Please feel free to ask questions. Here goes!
The first thing we need to discuss is categories of evaluation.
Categories of evaluation include the various ways you evaluate (or grade) your students. Common categories include tests, quizzes, daily assignments, presentations, projects, labs, etc.
There are two options for this gradebook. One allows for three categories of evaluation, and the other allows for four categories.
You must assign a weight (20%, 30%, 40%, etc.) to each category.
Please see the photo below. The highlighted area is where you add the weight. It needs to be in the form of a decimal (20%=0.2, 30%=0.3, 40%=0.4).
The combined weights must be equivalent to 100% or 1.0.
If you understand that, the rest is super simple. Pinky swear.
The second thing you need to know is that you type in your category titles at the top. You’ll see in the example below this class included quizzes, assignments, and projects.
The final thing you do is type in descriptions of each quiz or assignment as well as a percentage scored on the assignment.
That’s it! The spreadsheet magically does all the math for you. The grade is visible in the lower right corner of the page.
Start a new gradebook for each course.
To print on one page, choose landscape orientation. Choose fit sheet on one page. Super simple.
Download the Free Homeschool High School Gradebook
Are you ready? Grab the FREE gradebooks below!
- Gradebook Version 1 (includes three categories of evaluation)
- Gradebook Version 2 (includes four categories of evaluation)
More Homeschool High School Record Forms
If you found this gradebook helpful, you might want to check out my other recordkeeping posts:
- How to Keep Records for Homeschooling High School
- Homeschool High School Transcript
- High School Volunteer Log
- Reading List Record Form
- Course Record Form
- Homeschool Attendance Sheet
I'll show this to my wife. She'll understand it better than me. lol
Thank you so much for sharing your spreadsheets. I dream of being organized, and then life happens. These forms will be a huge blessing with my two high schoolers! The the grading form is an answer to prayer! I can't wait to try it out along with the other forms!
Thank you so much for posting this! It's a big help to me. . .spreadsheets and I don't always speak the same language! LOL This is so easy to use, and simple, no unnecessary information to fill in–so straightforward. Thank you a million times over!
You are welcome, Stacie! 🙂 I love simple!!
I’m homeschooling high school and recording grades for the first time this year. This grade book is so helpful, many thanks!