How to use the XLS 10-Subject Grader
The XLS 10-Subject Grader is meant for one student. The grader will calculate the grades that you enter into the grader. Grades are calculated at 1/12 term school-year intervals as well as the current total grade average. The grader is designed to hold 180 grades per subject. [read more about the term intervals]
Student's Name
The grader is meant for one student. Type the student's name, grade, and year in cell D1. See image below.
The Class Titles
The grader is programmed to automatically carry-over the subject names that you type into other cells. Type the subject ONCE in each cell that is next to the number 1.
If you do not want or need the subject name written in all of those places, then unprotect the sheet and clear the code from those cells.
Be sure to protect the sheet after you are finished. It is too easy to accidentally remove important formulas!
I do not fix broken spreadsheets.
The important formulas are in the yellow cells.
References
If for some reason you need to reference some of the grades, use the reference row.
To use the reference row, add your choice of symbols (letters or numbers) across the top. These letters or numbers identifies which column the grade is in. Then pair the reference symbol with the subject and row number. For instance, if you used numbers across the top - 1,2,3,4,5,6,7, and so forth and wanted to reference the first grade in the top row of math, the reference would be: 1-math-1. This type of referencing is good for a printed grader. If you do not plan to have a printed copy, then making a reference to the cell number which the grade is in is an easier way.
Adding Grades
See image below. Add grades in whole number form (76, 99, 100, etc.) in the cells shown below in the image. The grades are averaged at one-twelfth school term intervals and the current total grade average.
Although the grader has Monday-Friday indicators across the top, that does not mean you must add a grade that was earned on a Monday in a column labeled "M." As far as placing grades, it matters more to place grades based on a span of weeks or school term. Each school term on this grader is three weeks or one-twelfth or the school year, so the grades placed in one row are grades that were earned sometime during that one-twelfth school term.
Understanding the Grade Averages
The Term IntervalsEach row segment between the subject name and the yellow grade average cell represents 3-Weeks or a term that could be defined as 1/12 of your school year. Each one of these row segments contains 15 cells for grades. At the end of each row segment is a yellow cell that will calculate a stand-alone average for that row segment - and ONLY for that row segment. The next yellow cell does not include the average from the previous yellow cell. The ONLY average that gives the full average is the one under the column labeled Final Grade. The final grade average averages ALL grades for one subject and each time a new grade is added, the final grade average could change. 
It will not hold still, it will not give you a stand-alone 2nd quarter [only] average. It gives the TOTAL grade average.
As a homeschooler, I know that many of you will want combined term averages, so I will add a 3rd worksheet to this grader to yield several term averages.
June, 25, 2009: I added the term averages worksheet. That took hours. It will show you the "stand-alone" average grade for the terms:
- Every six weeks or 1/6th of school year
- Each quarter or 1/4 of the school year
- Each semester or 1/2 of the school year
Stand-alone average grade: An average of grades that a student earned during a block of time. The stand-alone average does not include grades that were earned outside of the block of time.
Donna Young, June 25, 2009
XLS 10-subject Grader 
