Looking for our printable homeschool planner?
When I began homeschooling high school, I put together a simple spreadsheet to use to plan courses and keep track of credits needed for graduation. I gradually expanded that spreadsheet to a workbook that is a full digital planner for an individual homeschooled student.
Get the Digital Homeschool Planner for Excel »
Get the Digital Homeschool Planner for Open Office »
What this digital homeschool planner IS:
- Expandable to cover all years of a student's schooling from elementary grades through high school
- A solution for producing simple, clean report cards
- A solution for keeping track of assignments given and completed, including the amount of time spent
- A solution for keeping attendance
- Printable (be sure to set your print area to only the portion that you want to print)
- Compatible with Excel and Open Office
What this planner ISN'T:
- A comprehensive solution that will keep all information for all students in one file (it is designed to be used one workbook per student)
- A database planner like Homeschool Tracker Plus (affiliate link)
- Compatible with Excel reader (you must have the full version of Excel or plan to use the Open Office version)
- Perfect. There are things that will need to be fixed and improved as the planner is used - we welcome your feedback for both error reports and suggestions.
Notes and FAQs about Homeschool Planner Plus:
I want to edit the planner but it is password protected. Can I have the password?
Yes. The spreadsheet's cells with formulas are locked to prevent unintentional changes to the formulas, which could cause incorrect calculations for GPA and credits earned. Unlock the pages at your own risk using the password letmein.
Will the Digital Homeschool Planner calculate course grades based on the weight of different assignment types?
Yes. When you enter the course details for each course in Homeschool Planner Plus, you may customize the weight given to each type of assignment (homework, projects, tests, etc.). The spreadsheet will calculate the course grade from the weighted averages for the totals of each assignment type.
Will the Digital Homeschool Planner calculate GPA and credits?
Yes. The planner is set up so that it will calculate a weighted GPA for the student based on the grade and weighting information entered into the spreadsheet. This means that in addition to calculating a standard GPA, the digital homeschool planner will also take into account the fact that AP and Honors classes carry weighted grades. The planner will account for half-year classes as well by weighting them as a half credit course.
I have Excel and the file says it cannot be opened because it is password protected. What is wrong?
If you have Excel, make sure you get the Excel version of the planner. The Open Office Version will work in Open Office but Excel seems to get confused when trying to open the Open Office version.
Why can't I keep track of all of my children in the same workbook?
Because of the way the spreadsheets are interconnected, and just one child will have dozens of spreadsheets within their own workbook by the time they graduate, it is inefficient to have more than one student per workbook. If you need to keep track of everyone in one file, I recommend Homeschool Tracker Plus (affiliate link) which is a much more complex and robust planner than our digital homeschool planner.
Why can't I enter the courses once in the Course Planner and have them show up in Course Details?
The workbook is large and adding course detail sheets for every course that might be taken from elementary through high school would make it extremely unwieldy. By allowing you to duplicate the Course Details sheet only enough times for the courses that your child is actually taking, we can keep the file more manageable. For someone only using Homeschool Planner Plus for high school, there will only be 24-30 courses and therefore 24-30 Course Detail sheets. For someone using Homeschool Planner Plus starting in elementary school, there could easily be 100+ Course Detail sheets. That's a lot of scrolling through tabs for someone who doesn't need it.
If you would like to only enter the information once on the Course Planner page, simply create a Course Details page for each course your student is taking. In the Course Description box on the Course Details sheet, type in a plus sign (+) and navigate to the cell on the Course Planner sheet that contains the Course & Provider for that subject. Click on the cell and then click the "enter" button on your keyboard. The contents of that cell will now appear on your Course Details sheet for that course and will update if you update the information on the Course Planner page. If you do this, remember not to move information around on the Course Planner page or you will change the contents of the Course Description on the Course Details page.
Why isn't there a calendar?
Since the Digital Homeschool Planner is designed to be used for many years, it does not include a calendar. If you want a calendar, it is better to use a hard copy of our printable homeschool planner with monthly and yearly calendars or a more robust digital planner like Homeschool Tracker Plus (affiliate link).
Why don't the grades from each Course Details Page automatically transfer to the Report Card sheets?
This is prevented for the same reason that you can't enter the courses once in the Course Planner and have them show up in Course Details. In order to create a workbook that would have enough Course Details pages for every course a child might take, there would be an excessive number of tabs across the bottom (possibly hundreds of tabs). Once the numerical grade for each course is manually transferred to the appropriate cell on the Report Card sheet, the formulas will automatically calculate the GPA for the student.
Homeschool Transcript Maker Now Separate
Our digital homeschool planner formerly included an older version of our transcript template. Our homeschool transcript maker is now revised and updated and is available as a separate file.
Leave a Reply