Posts: 2,656
Threads: 164
Likes Received: 2,763 in 1,861 posts
Likes Given: 838
Joined: Jul 2014
Tech Support (Parent and Student Access)/RE: Importing Schedule into Google Sheets
04-07-2025, 12:50 AM
(This post was last modified: 04-07-2025, 12:51 AM by Elaine Shutt.)
What a helpful discussion! I’ve been using Pages (Mac) for years and frustrated by certain things, but I just kept on keeping on. I’m going to try Numbers and see if it reduces frustration!
Posts: 140
Threads: 19
Likes Received: 190 in 80 posts
Likes Given: 28
Joined: May 2023
Tech Support (Parent and Student Access)/Importing Schedule into Google Sheets
04-08-2025, 09:44 AM
(04-07-2025, 12:50 AM)Elaine Shutt Wrote: What a helpful discussion! I’ve been using Pages (Mac) for years and frustrated by certain things, but I just kept on keeping on. I’m going to try Numbers and see if it reduces frustration!
Do it!
Soli Deo Gloria,
Sarah DS (Y7), DS (Y5), DD (Y3), DS (Y1), DD (4)
Posts: 1,043
Threads: 108
Likes Received: 1,125 in 507 posts
Likes Given: 1,160
Joined: Aug 2020
Tech Support (Parent and Student Access)/RE: Importing Schedule into Google Sheets
04-08-2025, 12:59 PM
(04-06-2025, 06:51 AM)SarahLee33 Wrote: I’m another spreadsheet gal (someone bought me a shirt that says “I’ve got a spreadsheet for that!
). I just copy it from the google doc over to google sheets. It’s really not to big of a hassle. I also separate the terms into separate tabs….so much you can do!
I do it this way now, too. I used to just work with Word because it didn't require as many formatting touch ups. But I really need the schedule to be viewed and edited from whatever device I have at hand. So I switched to Sheets. I used to make separate checklists, but I don't have time for that anymore, so I just fill the cell with gray after I've heard or seen a narration for that reading. I also highlight columns to indicate co-op break and online class breaks. This helps me decide how to spread out the readings. Also helps us keep our bearings if we fall behind. Which week were we supposed to be on by now? Oh yeah, co-op break fell on such and such week, so we should be on Week ____ now.
Now that I need to keep track of grades for high school, I'm experimenting with having an identical schedule in different tab in which I quickly enter an appropriate percentage in the cell along with filling the cell with gray. But this is not working out well for me. I'd love other suggestions for keeping track of grades. I have one student for whom I hardly need to keep track of grades, because he is so consistent, but I have another who is all over the place.
Second generation homeschooler. Grateful to my Father for the privilege of educating my children at home. Thankful for his longsuffering when homeschooling sneaks up onto the pedestal to become my idol.
Posts: 140
Threads: 19
Likes Received: 190 in 80 posts
Likes Given: 28
Joined: May 2023
Tech Support (Parent and Student Access)/Importing Schedule into Google Sheets
04-08-2025, 10:43 PM
(04-08-2025, 12:59 PM)HannahA Wrote: I do it this way now, too. I used to just work with Word because it didn't require as many formatting touch ups. But I really need the schedule to be viewed and edited from whatever device I have at hand. So I switched to Sheets. I used to make separate checklists, but I don't have time for that anymore, so I just fill the cell with gray after I've heard or seen a narration for that reading. I also highlight columns to indicate co-op break and online class breaks. This helps me decide how to spread out the readings. Also helps us keep our bearings if we fall behind. Which week were we supposed to be on by now? Oh yeah, co-op break fell on such and such week, so we should be on Week ____ now.
Now that I need to keep track of grades for high school, I'm experimenting with having an identical schedule in different tab in which I quickly enter an appropriate percentage in the cell along with filling the cell with gray. But this is not working out well for me. I'd love other suggestions for keeping track of grades. I have one student for whom I hardly need to keep track of grades, because he is so consistent, but I have another who is all over the place.
How detailed do your grades need to be? Every assignment or just per quarter/year?
Excel has some built in grade book templates that may work well for your needs. I used to use them when I taught science at a co-op. There’s also some free online resources that would be similar but I say it depends on the level of specifics you need for your state. I know some can just give grades for the “class” for the year.
Soli Deo Gloria,
Sarah DS (Y7), DS (Y5), DD (Y3), DS (Y1), DD (4)
Posts: 2
Threads: 1
Likes Received: 0 in 0 posts
Likes Given: 0
Joined: Sep 2024
Tech Support (Parent and Student Access)/RE: Importing Schedule into Google Sheets
04-10-2025, 11:16 AM
This is super helpful! Thank you everyone!