One of the most difficult things about homeschooling is the record keeping. With all of the quizzes, tests, and other assignments the work can get out of hand. One of our favorite ways to tame this paper tiger is to use a spreadsheet. One spreadsheet can cover four years worth of schooling and even several students.This is definitely a simpler more streamlined option. When your student has finally finished their high school years, you simply print out the spreadsheet and include it along with your transcript and other resources that tell your student’s story.
For our free downloadable spreadsheet, you’ll need to have a Google Drive account and log into it. When you click on the image below, it will automatically ask you if you would like to make a copy of this spreadsheet. You’ll want to click yes, and it will automatically download to your Google Drive. You can then edit it and change it to fit your specific homeschool needs. If you need different subjects just click on them and change them. If you want to weight your tests, I suggest duplicating the sheet (record). To do this, just right click on the “student 1” tab at the bottom left corner and choose “duplicate.” You can add sheets for each of your student’s grades, multiple students, or dedicate a sheet to quizzes and one to tests. The final column does automatically average the grades you enter… so kudos to not having to use a calculator!
Jamie Gaddy, B.S., M.Ed., Ed.D. has been an education professor for over 17 years. She is also a pastor’s wife, freelance writer, and entrepreneur who now homeschools four of her six children (ages 9-15) in a sweet tea sippin’, wrap around porch sittin’, sweet southern Georgia town. Jamie is also a contributing author at Online Education for Kids and MomSCHOOL