# Excel Home School Lesson Planner (HOMESCHOOL)

Resource Type
Product Rating
4.0
1 Rating
File Type

391 KB|14 pages
Share
Product Description
***You MUST own a copy of Microsoft Excel to use this file. And some understanding of how Excel works is necessary.***

This Excel spreadsheet was created to help homeschooling families set up all their assignments for the year in one easy to use location.

NO TECH HELP IS PROVIDED. (Sorry... I'm a homeschooling mom myself and I just don't have the time available to walk people through it.)

Basic Instructions

1. Go to the tab below that is marked "subject_1"
2. Decide what subject that should be (Ex. "John's Saxton Math") and type that in the yellow box where the words "Write the Subject Here" appear.
3. Count the number of pages (or excercises) in that text book and divide by 180 school days to determine how many pages need to be completed every day.
4. Type out "pgs. 1-3" "pgs. 4-6" "pgs. 7-9" etc. in the slots Monday through Friday on that subject_1 tab.
5. Fill out all 36 weeks worth of that subject.
6. Go to the tab marked "PRINT OFF WEEK."
7. In column A (on the "PRINT OFF WEEK" tab) change "subject_1" to "John's Saxton Math" (or whatever subject you put in there).
8. Go to the tab marked "subject_2" and repeat steps 2 through 7 above. Continue this through all 12 subjects.
9. Once you have all the assignments for all the subjects entered, then go to the "PRINT OFF WEEK" tab.
10. To print off week number one's assignments, type the digit "1" in the small yellow square at the top of the page. Then go to "file" and "print." To print off week 2, type a 2 in that yellow square... and so on.

Other tips:

A. If you put your mouse on a cell and you see a lot of numbers and letters, that is a formula. DO NOT TYPE OVER IT.
B. Make a backup copy in case you accidently delete a formula and "mess up" the sheet.
C. If you have more children and more subjects than can easily fit within the 12 provided, consider making duplicates of this spreadsheet, one for each child. (Ex. Mary's assignments, Robert's assignments.)
D. Also, this system works wonderfully with the idea of "work boxes," or with the idea of making children responsible for their own learning. Consider giving your children their assignment sheets at the beginning of the week and making them responsible to complete all that's been assigned to them.
Total Pages
14 pages
N/A
Teaching Duration
N/A
Report this Resource

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.