The Excel 6-Week Homeschool Planner
About the Planner
The file requires a spreadsheet program such as Microsoft Excel or OpenOffice.
The planner file allows you to create 6 weekly dated planners and a dated
3-week objections list page. The planner can be personalized with up to 9
subjects and a planner title. To make the next 6 weeks, you do have to
either delete content or start with a fresh empty file to create the
planner for the next 6-weeks.
Download the file and save it to your computer. On the Data page, type information in the white cells. The information will be imported into the 6 weekly planners and the Objectives & List worksheets. That is all you need to do unless you want to do more.
How to Use the Planner
Enter Information in Data
On the worksheet with the Data tab, replace the sample information with your information. Type the child's name, the starting date, and the subjects.
The information that you type in Data will be imported into the 6 planners and the Objectives & List page.
Image darkened to highlight the area which takes input.
Note: If you want to add plans to the planner before printing, the cells have been formatted to wrap.
Note: The areas that do not allow typing are not meant to be typed in.
Typing in protected areas will ruin the file because it will overwrite the
code. If you choose to unprotect the sheet, please be careful not to type
in cells that have code.
Objectives and List
This image shows the Objectives & List sheet. It is an optional sheet.
The purpose of the Objectives & List sheet is to have a place for jotting notes, lists, goals, or etc, for the 3-week period.
The name of the sheet can be changed to something else if you do not want to list Objectives.
In lists, you can copy and paste lists into the file as long as the list has a return after each item. The list is 47 lines long and around 20 characters wide I think.
Printing
Always check print preview before printing any Excel file
that I offer. I have the settings to print properly, but sometimes that
does not work well on other computers. Check it first.
To open print preview, go to File > Print Preview
Look for the following in print preview: That each form is printing on one sheet each and how many pages are being printed.
Print preview. If you have chosen to print more than one page, use Next to
look through all pages before printing.
If a single form uses more than one sheet of paper, either adjust the margins or adjust the cells of the form.
To print all 4 of the files at once, hold the ctrl key and select each of them (on the bottom tabs.)
Selected tabs shown are white. To select: hold the ctrl key and
select the ones you want. To unselect, do the same.
Donna Young
June 28, 2006
Download
Excel Weekly Planner