generic lesson planner

Copyright 2012 © Anna Jackson / www.EvangelismStuff.comAll rights reserved. No unauthorized copying. No reselling.

Basic Instructions

1. Go to the tab below that is marked "subject_1"

5. Fill out all 36 weeks worth of that subject.6. Go to the tab marked "PRINT OFF WEEK."

Enjoy your school year, and may God bless you!

EvangelismStuff.com/lesson_planner

Other tips:

Make a backup copy in case you accidently delete a formula and "mess up" the sheet.

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.

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 17, 20, 3, or whatever… type that week number into the yellow square.

By the way, if this spreadsheet was a blessing to you, please consider the suggested donation of $2.00. To make the donation, you can go to:

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.

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.)

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.

Monday Tuesday Wednesday Thursday Friday 1

subject_1 Pages 1-10 Computer Time Puzzle / Game

subject_2 example Monday example tues example W example th EXAMPLE FRIDAY

subject_3 3 mon 3tue 3 wed 3 thurs 3 fri

subject_4 4 4 4 4 4

subject_5 5 5 5 5 5

subject_6 6 6 6 6 6

subject_7 7 7 7 7 7

subject_8 8 8 8 8 8

subject_9 9 9 9 9 9

subject_10 10 10 10 10 10

subject_11 11 11 11 11 11

subject_12 12 12 12 12 12

Frog and Toad all Year pgs. 18-29

Open book test next Monday, make sure we

review for it!!!

Anna/3, Jack/2, Leah/K Week_____

Tuesday Wednesday Thursday Friday

Pages 1-10 Computer Time Puzzle / Game Write the Subject Here

Monday

Frog and Toad all Year pgs. 18-29

Open book test next Monday, make sure we

review for it!!!



example Monday example tues example W example th EXAMPLE FRIDAY Write the Subject Here

Monday



3 mon 3tue 3 wed 3 thurs 3 fri Write the Subject Here

Monday



4 4 4 4 4 Write the Subject Here

Monday




Monday

generic lesson planner

Documents