Mothering › Forums › Education › Learning at Home and Beyond › for those of you that have a spreadsheet schedule
New Posts  All Forums:Forum Nav:

for those of you that have a spreadsheet schedule  

post #1 of 13
Thread Starter 
so...
if you have a spreadsheet schedule that you made up...will you share it with me? i'm in the process of creating a spreadsheet type schedule for next year. it's harder than i thought. i'd really love to see an example.

btw, i'm NOT asking if you think i need a schedule at all, lol. i am trying to make one, and simply need a little assistance. TIA!!
post #2 of 13
I don't have time to post the actual chart, but I have the school week in 5 days, and each day divided into 15-60 minute increments, depending on the smallest common denominator of all the days. For instance if we have two 15 minute activities on Mon, Wed, Fri and a single 30 min activity on Tue, Thu then it's 15 minute slots across the whole week.
I have school lessons, snacks, lunch, free time, regularly scheduled classes (guitar, gymnastics) printed in there, really everything that is scheduled between 8 am and 5 pm.
Chores used to be on the chart, but it works better to have them on their own list, so the kids choose when to do them, though they are divided into morning, afternoon, evening chores, with suggestions for extra credit chores in each section.
Play dates and special events are just written on the week's chart, and each day has its own colored pencil to color in the slot that has been completed. That way it's easy to see at the end of each week what's working- look, Art on Thursday is consistently not getting done til Friday, let's move the schedule around a little bit.
Oh my goodness, that all sounds a little bit obnoxious to me, but I assure you, having a schedule and having it set up in a way that is consistent and easy for the kids to figure out it is really great. It's one of my happiest achievements this year- finally making a schedule that works, is on the computer, easy to fine tune, and easy for everyone to understand, even grandparents and others.
post #3 of 13
I wanted just a very basic breakdown of what we need to cover in a week so I use this
http://donnayoung.org/forms/planners...f/semester.pdf

I plug in the names of each subject in the top and divide each into 36 weeks
I then type in the page numbers or lesson numbers that need to be covered in each week.
post #4 of 13
Thread Starter 
thanks, i appreciate both of you sharing your ideas. i think i found a schedule that i can use as a starting point. i'm using a lot of living books next year & i was trying to utilize a spreadsheet so i can better understand which books compliment each other and what subjects they fall under, etc. i found a fairly good one by a sonlight user, and i think i can tweak it and relax it a bit to make it work for us. thank you again!
post #5 of 13
post #6 of 13
Thread Starter 
thank you! your schedule looks really good. the thing is, i'm not trying to make a weekly schedule. i am trying to make a 36 week schedule, lol - i wasn't very clear in my original post. i'm sorry about that...i'm still trying to figure it out myself.

i've always utilized a flexible weekly schedule in the past, but now i am trying to create my own loose curriculum based on all of the books we own (sort of like sonlight). i know it probably sounds like *too* much, but it will really help me with organization and making sense of our books and what subjects they cover, etc. i've got the first week complete...now 35 more to go. thank god i'm starting now, lol.
post #7 of 13
I have a yearly schedule, too. I didn't understand what you were asking for the first time! I don't have it on the computer, though- it would be easier if it were.

I make a page for every week, so each sheet has 6 day columns (one column for the weekend) and one row for each subject. Then I go through the whole year and mark out all the holidays we'll be taking. Then I plan the main lesson blocks and write those in, with all of the materials and books that I am planning for each block, the ones I already have in one color, ones that I need to get from the library or gather some other way in another color. I write in main lesson ideas for each week.

A lot of the stuff we do daily I don't have planned out- like Latin. I would have probably planned to do the entire Lively Latin Book 1 this year, but we're taking more than two weeks for some of the lessons, so I'm sure we'll be working on it next year, too. The lessons that are just ongoing and don't have a set completion, like math, I just write in the yearly schedule the materials and books we're using, ideas for projects, websites, etc. as I come upon them. I make a notation when we start and finish books or projects, for future reference.

It's simple, and in a binder, where I also keep idea lists for each subject and a wish-list for school supplies.
post #8 of 13
Thread Starter 
Quote:
Originally Posted by mama-aya View Post
I have a yearly schedule, too. I didn't understand what you were asking for the first time! I don't have it on the computer, though- it would be easier if it were.

I make a page for every week, so each sheet has 6 day columns (one column for the weekend) and one row for each subject. Then I go through the whole year and mark out all the holidays we'll be taking. Then I plan the main lesson blocks and write those in, with all of the materials and books that I am planning for each block, the ones I already have in one color, ones that I need to get from the library or gather some other way in another color. I write in main lesson ideas for each week.

A lot of the stuff we do daily I don't have planned out- like Latin. I would have probably planned to do the entire Lively Latin Book 1 this year, but we're taking more than two weeks for some of the lessons, so I'm sure we'll be working on it next year, too. The lessons that are just ongoing and don't have a set completion, like math, I just write in the yearly schedule the materials and books we're using, ideas for projects, websites, etc. as I come upon them. I make a notation when we start and finish books or projects, for future reference.

It's simple, and in a binder, where I also keep idea lists for each subject and a wish-list for school supplies.

thank you! that is actually very helpful!!! i am trying to create the same format you mentioned, but i only made 5 columns vertically and then the horizontal rows list subjects, books, etc.

i was super unclear in my first post, lol. i'm sorry about that!!! i'm just trying to organize myself because i have so many great books. i finally realized that i don't need to buy anything else. i have wonderful rich books right here...i just want to create a schedule now that makes it all flow together to create a relaxed curriculum ....as opposed to just randomly reading books each day.

thanks again for your thoughts!!! it lets me know i'm on the right path!
post #9 of 13
Quote:
Originally Posted by elizawill View Post
thank you! your schedule looks really good. the thing is, i'm not trying to make a weekly schedule. i am trying to make a 36 week schedule, lol - i wasn't very clear in my original post. i'm sorry about that...i'm still trying to figure it out myself.

i've always utilized a flexible weekly schedule in the past, but now i am trying to create my own loose curriculum based on all of the books we own (sort of like sonlight). i know it probably sounds like *too* much, but it will really help me with organization and making sense of our books and what subjects they cover, etc. i've got the first week complete...now 35 more to go. thank god i'm starting now, lol.

:P
I have one of those, too, but it's not online yet. I'm leaving for vacation, but I'll link to it as soon as I get back.
post #10 of 13
Thread Starter 
Quote:
Originally Posted by theretohere View Post
:P
I have one of those, too, but it's not online yet. I'm leaving for vacation, but I'll link to it as soon as I get back.

THANK YOU! i would really love to see it!!!!!
post #11 of 13
:
post #12 of 13
Quote:
Originally Posted by elizawill View Post
THANK YOU! i would really love to see it!!!!!
I just updated my blog with how I've broken our materials into weekly chunks- if that's not clear enough let me know. I'm so fascinated by how everyone organizes their homeschools.
post #13 of 13
I use this site

www.planbookedu.com


It is weekly but you can do the whole year at once if you wanted to.
You can also fill in something once and have it repeat example "typing" on Tuesday and then it will show up on next Tuesday's schedule.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Learning at Home and Beyond
This thread is locked  
Mothering › Forums › Education › Learning at Home and Beyond › for those of you that have a spreadsheet schedule