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 a college education professor for over 17 years. Education has been an integral part of her life in both the classroom and as a principal. Six children later found her dissatisfied with traditional schooling and homeschooling became the better fit. She is also a pastor’s wife, remote project manager, and entrepreneur who now homeschools four of her six children (ages 11-17) in southern Georgia. Jamie loves to share about her homeschool experience and help other homeschoolers find success. Connect with her at [email protected]