Planning your homeschool schedule (with a really cool spreadsheet)

Homeschool planning shouldn’t be stressful, overwhelming or complicated.

I’ve created the STAR reading plans with families like yours in mind. The reading plans follow four cycles of history, science, enrichment, and so many other subjects. All children in the family will be following the same timeline, the same artist, composer, poet, habits, life skills, and other subjects. They are divided into “Forms” to group your children into instead of grades:

  • Form 1: first through third grade (6-9 years old)
  • Form 2: fourth through sixth grade (9-12 years old)
  • Form 3: seventh and eighth grade (12-14 years old)
  • Form 4: ninth and tenth grade (14-16 years old)
  • Form 5: eleventh grade (16-17 years old)
  • Form 6: twelfth grade (17-18 years old)

Under each topic and each form, I’ve included reading schedules for many different resources, so that you have options to choose books that suit your family best. My hope was that you would be able to find a read aloud book in each subject, and also books for independent reading for your children who can read. 

Originally, I only published spreadsheets with all of the potential readings included. This made for pretty large spreadsheets, sometimes with twenty-five or more titles. To avoid overwhelming mamas with all of the options, I decided to make spreadsheets with one book per spreadsheet.

This has helped a lot of people, but overwhelmed others–who have told me that they liked the long spreadsheets with all of the resources. Because of that, I’ve decided to start including both: the long spreadsheet with all of the resources listed, by subject and form (for example, a long spreadsheet full of every single science & nature book for the cycle, sorted by form, and then a history spreadsheet, etc.) and also, the spreadsheets with a single book on them, like this:

Custom Family Guides

When I started STAR Homeschool Community (the homeschool community I launched in Lynchburg, VA), I offered the opportunity for each family to get a “Custom Family Guide” that I created. It was a lot of work to make these guides, and I learned that it was not a sustainable solution. So, what I’ve decided to do is teach you how to make your very own spreadsheet that works best for your family!

Here’s how to do it! Click on the link below to make a copy of the blank Custom Guide spreadsheet I created:

STAR Custom Guide (Editable Spreadsheet)

The spreadsheet looks like this:

and this:

How to Customize the Spreadsheet to Make Your Own Guide

Here’s what you’re going to do:

First, head to the cycle you’d like to use this year. You can find the cycles at the top of the page, under Homeschooling.

Click on the cycle you would like to use.

When you are in the cycle you’ve chosen, click on the subject you would like to start with.

Once you’re in the subject you’d like to start with, select the download for the book you would like to add to your schedule.

Open the pdf download you’ve chosen and highlight one row on the first spreadsheet with the title, author and assignments for Weeks 1-7, like this (the blue part is highlighted):

Click “copy” like this:

Make sure you have only selected a single line, and not anything above or below it.

Now, head over to the copy of the Custom Guide spreadsheet that you have made. Make sure you are on the tab of the same Term as the spreadsheet you copied from. You can select the term at the bottom of the spreadsheet.

Now, click the cell under the topic you’d like to place the selected title under. Click on the first left cell under that topic, like this:

And now, click “paste”:

The contents of the downloaded spreadsheet should appear on your custom spreadsheet, like this:

Keep Going & Create a Completely Customized Guide!

Continue with the same book in Terms 2, 3 and 4. Make sure you paste the content from Term 2 into the spreadsheet tab that says “Term 2,” and so on. You can copy and paste as many books as you like! When you’re finished making a guide for the books you would like to read aloud, make another copy of the spreadsheet and make a guide for each of your children who are able to read independently. Print these guides and use them as your check off list for the week.

Some Tips

Adding Rows

To add a row, you will want to select the whole line above where you want to add a row.

Go to the top menu, to “Insert” and click “Rows” and then “Insert 1 row below” or “Insert 1 row above” if you’d rather add a row above the line you have selected.

There shouldn’t be any reason to add an extra column to this spreadsheet. The GLC terms are 7 weeks long, and there are 4 terms per year.

Deleting Rows

To delete a row, you will want to select the row again, like this:

Then, go to the top menu and click “Edit,” and then “Delete,” and click on the line that says “Delete Row __” (whichever row you have selected), like this:

Adding Other Resources

You can add any resources you like to this spreadsheet. Maybe I haven’t scheduled a book you want to cover with your kids–no problem, just add it to your own custom spreadsheet. Make sure to comment on this site to let me know which books you’re using!

Leave a Comment