Homeschool Multi- Child Scheduler- On Google Sheets- Video Tutorial

Have you every wondered "How am I going to figure out how to schedule our days homeschooling multiple children!!??" I found out last year what a headache that can be (and also found out how to go through lots of scratch paper trying to figure, then re-figure, what days and times would work out best for us). I also had a 2-year-old I had to factor in (I mostly tried to think of things for him to do besides destroy the house--which mostly did not work, toddler life, right?). THIS year, I made a point to make scheduling a smoother process! In another time in life, I loved creating spreadsheets, so I figured why not create one for this task! And so came this jewel. Just below are the steps to fill in this scheduler, as well as anything you ever might want to know about it (and possibly way more than you care to know, hehe). If you'd like to skip ahead to more details in written form go HERE. For a Short Overview Video of the Product jump to it HERE.

Table of Contents: Video Minute Time Stamps by Subject (4 Video Clips Total):

Min. Mark 0:00:49 [Video Clip #1]- Entering "Subjects" & "Names" onto corresponding sheets
Min. Mark 0:01:42 [Video Clip #1]- Choosing which Tab to use based on # of children being scheduled & Special formatting tips for using Sheets/Tabs for scheduling more than 2 children
Min. Mark 0:06:34 [Video Clip #1]- Start filling out the scheduler- What I did & helpful tips
Min. Mark 0:02:30 [Video Clip #2]- Using "# Ordered Rows" column & Sorting Data on Page
Min. Mark 0:04:50 [Video Clip #2]- Sample of what Final Scheduler Sheet looked like for me
Min. Mark 0:07:05 [Video Clip #2]- Condensing Rows once all data is entered & schedule is complete--this step is to tidy up the sheet & combine matching time slots etc.
Min. Mark 0:08:40 [Video Clip #2]- Sample of Color Coded Conditional Formatting for "Time Amount Allotted" column & Info on using this tool to match Independent Work for one child to Dependent Work for another child in order to set appropriate time slots
Min. Mark 0:00:00 [Video Clip #3]- Directions Page Checklist
Min. Mark 0:00:50 [Video Clip #3]- Printing Scheduler Once Complete
Min. Mark 0:01:26 [Video Clip #3]- Directions on how to Transfer data to the "Daily Schedule" Sheet/Tab
Min. Mark 0:00:00 [Video Clip #4]- How to Hide Rows & Overview of "Key" on Daily Schedule
Min. Mark 0:02:35 [Video Clip #4]- How to add border to your Daily Schedule
Min. Mark 0:03:37 [Video Clip #4]- Sample of my final "Daily Schedule" after transferring data from the scheduler sheet.
Min. Mark 0:04:30 [Video Clip #4]- Closing Comments

Note: Sorry for the breathy/static sounds on parts of the video...my mic was a bit too close!

Video Clip #1 of 4---Video Clips Continue after this screen:

Video Clip #2 of 4---Video Clips Continue after this screen:

Video Clip #3 of 4---Video Clips Continue after this screen:

Video Clip #4 of 4:

More Details on this Resource: This Online Multi-Child Scheduler helps you input each of your children's subjects into a color-coded organizer. Once data is entered into the spreadsheet for each child, you will be able to see clearly:

where independent work needs to be scheduled to other children while you work with one child
where group work can be scheduled
allotted time amounts that match up between:
one subject that can be done independently by one child and
other subjects that cannot be done independently by the other child(ren).
Plus a sheet to transfer all your data over to a Monday-Friday "Daily Schedule"
Color-Code Conditional Formatting applied to "Time Allotted" cell (in increments of 5 minutes up to 60 mins).
Color-Coded Conditional Formatting applied to Children's name (formatted by 1st initial).

This scheduler was soo helpful in my planning process. Here is page 1 of my scheduler:

Note: All of the Shading and Coloring of Cells is done Automatically as you type...everything has conditional formatting to help you visualize what needs to be done.

After finishing this sheet, I transferred all that neatly organized data into a Monday-Friday Daily Schedule included on another sheet (see where I extracted cells to copy over to the Daily Schedule based on days and times shown within the scheduler).

If you have not got a Homeschool Multi-Child Scheduler of your own yet, Click HERE to go to my TpT Store where can purchase this handy resource! If you want to see a Video Tutorial of this resource, scroll back up HERE on this blog post to see just how I used this resource and also see details on how you can personalize it to your needs!! I hope it helps you as much as it did me!!

Short Video Overview of Resource: