• Inspired Learning
    • reading
    • writing
    • art
    • math
    • science
  • Creative Learning
    • Preschool Activity Bags
    • LEGO Learning
    • Field Trips
    • Lapbooks & Notebooks
  • Interest Led Learning
    • Delight Directed Learning
    • Cultivating Curiosity
  • Co-op Learning
    • CO-OP Class Ideas
    • Geography Fair
  • Privacy Policy

Walking by the Way

the road to inspired learning

  • Inspired Learning
    • reading
    • writing
    • art
    • math
    • science
  • Creative Learning
    • Preschool Activity Bags
    • LEGO Learning
    • Field Trips
    • Lapbooks & Notebooks
  • Interest Led Learning
    • Delight Directed Learning
    • Cultivating Curiosity
  • Co-op Learning
    • CO-OP Class Ideas
    • Geography Fair
  • Privacy Policy

Homeschool High School Gradebook

September 3, 2016 by ami 13 Comments

My kids are somewhat clueless about grades. They don't typically know what grade they are in (4th and 9th for the record), and they haven't had any experience with letter grades.

Well, 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 really 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.

Homeschool High School Gradebook - free and easy to use!

This 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). 

Homeschool High School Grade Book

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.

FREE Homeschool High School Grade Book

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.

Are you ready? Grab the FREE gradebooks below!

  • Gradebook Version 1 (includes three categories of evaluation) 
     
  • Gradebook Version 2 (includes four categories of evaluation)

If you found this gradebook helpful, you might want to check out my other high school forms:

  • Volunteer Log
     
  • Reading List Record Form
     
  • Course Record Form

Filed Under: homeschool high school

Comments

  1. Richard Hunsucker says

    September 4, 2016 at 10:25 pm

    I'll show this to my wife. She'll understand it better than me. lol

  2. Ann says

    February 1, 2017 at 10:28 am

    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!

  3. Stacie says

    May 9, 2017 at 2:35 pm

    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!

  4. ami says

    May 22, 2017 at 9:07 pm

    You are welcome, Stacie! šŸ™‚ I love simple!!

  5. Melissa says

    August 22, 2017 at 9:55 am

    I’m homeschooling high school and recording grades for the first time this year. This grade book is so helpful, many thanks!

  6. ami says

    September 3, 2017 at 9:34 am

    You are welcome. šŸ™‚ I had to have something super simple! Happy it is helping others, too.

  7. Rachel says

    December 30, 2017 at 6:12 pm

    Ami,

    Thank you for posting these gradebook templates (and thanks to your husband for creating them)!

  8. Rachel P says

    April 5, 2018 at 6:22 pm

    Thank you, Ami, I really hate reinventing the wheel. I am super thankful that you made these forms and shared them with us :). Kind of like old times (at homeschoolshare)

  9. ami says

    April 6, 2018 at 9:56 am

    Good to see you here, Rachel! Hope you are doing well. šŸ™‚

  10. Brook says

    December 6, 2018 at 2:05 pm

    Thank you so much for this!!
    Is there a way to make it longer? For instance, I have a class for my child that has 180 lessons. There is only room for I think 20 lesson grades if I go straight down.

  11. Bekki says

    April 10, 2019 at 2:16 pm

    I’ve never had to record grades. I’m not sure what I need to do. Is this for every subject, or do I need to make a new sheet for each subject? Sorry, I’m just new and confused. LOL

  12. ami says

    April 13, 2019 at 9:45 am

    Hi Bekki,

    I use a separate spreadsheet for each subject. šŸ™‚

  13. Leah says

    September 30, 2019 at 1:32 pm

    Thank you for sharing this!

Leave a Reply Cancel reply

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

Meet Ami

Welcome! I’m a big believer in inspiring kids, cultivating curiosity, delight directed learning, living books, field trip adventures, and keeping your sanity while homeschooling. I hope you find something encouraging here today! You can learn a bit more about me here.

Connect with me

  • Email
  • Facebook
  • Instagram
  • Pinterest
  • RSS

Subscribe

Search

Popular Posts

The Ultimate List of Homeschool Co-op Class Ideas

The Ultimate List of Homeschool Co-op Class Ideas

40+ Books for a 3rd Grader Who Loves to Read

40+ Books for a 3rd Grader Who Loves to Read

Ultimate Guide to Preschool Busy Bags

Ultimate Guide to Preschool Busy Bags

LEGO Unit & Lapbook

LEGO Unit & Lapbook

Ten Favorite Free Websites for Homeschool

Ten Favorite Free Websites for Homeschool

25 Ways to Cultivate Curiosity in Your Children

25 Ways to Cultivate Curiosity in Your Children

We’re Going on a Word Hunt Sight Word Activity

We’re Going on a Word Hunt Sight Word Activity

LEGO Learning Kindergarten Kit

LEGO Learning Kindergarten Kit

Read to Me & ABC Preschool Curriculum

Read to Me & ABC Preschool Curriculum

Copyright © 2019 · Simplify on Genesis Framework · WordPress · Log in