Unweighted Scores - Using One Grade Weight
What if I change my mind and want to weigh grades or activate or remove a grading column?
Weighted Scores - Using Two or More Grade Weights
The "Errors" That the Term Grader Displays
The Extra Grade Cells - "Term Exam" and "Other"
V Planner 4.2, High School V Planner V4.2, and Homeschool Lesson Planner V4 are ready for use. Download from the Member's area.
This page is about the term grade calculators. They are the 6 blue calculators that are on the right side of the s-sheets. Each one is associated with a grading term and marked thusly.
The other calculators that you should read about are:
I've called the term calculators by several different names. Here is a list.
Term Grade Average Calculators
Term Grade Calculator
The Term Grade Calculators will calculate scores, attendance, points, and, if enabled, class hours for the period of days in each term. By setting up the term grade calculators grading columns are activated. The grading columns are located to the right of lesson plans. When scores are placed into activated grading columns, then those scores are calculated and translated into grade averages for the class.
The term calculators make the report cards possible. Without the term grade calculators, report cards could not be as detailed as they are. If you need to use the report cards, then please take the time to set up the term grade calculators.
In V Planner V3, the number of grading terms is set and can be changed at the Data worksheet. V Planner supports up to six grading terms; I recommend that you use no less than two.
Number of grading terms and what they can mean-
Two grading terms is the same as having two semesters in which you need have grade reports.
Four term graders will give you "quarterly" grade reports.
If you do not need to weigh grades, then set the first grade column in the term graders at 100% .
If you decide that you want to weigh grades or if you need to alter how a term grade calculator is set up then go ahead. Remember - the term calculators do not change the scores that you have already added in the activated grade columns, the term calculators look at the scores in the activated grade columns and "calculate" based on your settings. Settings in the calculators can be changed without affecting your data.
Be aware of this if removing a previously used activated grading column-- If an activated grading column in a certain term is removed, then any scores that were placed in that column for THAT term will not be included into class grade averages.
Pictured below is an empty unused term grader. I brought the column bar down on the screen-shot for reference.
Grade Column - There are four grade columns on the term graders and they are columns N, O, P Q. When activated, each grade column in the term grader can calculate data from columns F, G, H, I. The grade columns are 4 rows tall.
Activated Grade Column - In an active grade column, the last two rows will have a background color that matches the first two rows. The active grade column will expect scores and will trigger an error if no scores are entered during the grading term.
Grade Column Names - Each activated grade column should be given a name. The name should be a short and descriptive - Examples: A grade column that is used for tests should be named Tests, Quizzes, or Exams. A grade column that is for daily work could be named Daily, or Work, or Practice.
Just a note- Terms are not set up at the term grader. See Setting up Terms.
1. If all of the school work "counts the same" then in Column N and next to their word Term, type 100 (the percentage sign will automatically appear)
2. Next to the term number, give this grade column a name.
Please notice that as soon as you type "100" in Column N, you have activated the grade column. The grade columns have 4 rows each and with activated, all four row will have the same background color.
3. Repeat steps 1 and 2 for each term grader that you need to use.
Note One student should use the same number of term graders for all of his/her subjects.
For instance, do not use 2 term graders in math and then set up 4 term graders in spelling.
1. Naturally you have to decide how many grade weights to use and the value of the grade weights, but once you have decided (and you can come back and change the weights later) type the weights in the row next to the word "Term" in each term grader that you plan to use.
Each term grader can use a different grade weight system.
Usage example: Using 4 terms
In a certain class, terms 2 and 4 will have a special project - Activate an additional weight column for the special project in terms 2 and 4.
Rule 1 The grade weights must add up to 100%. If they don't you will see an error. Below is a screen-shot of what this error looks like. Error is circled in red (!!)
30% + 60% + 5% + 1 % does not equal 100% - fix it.
2. Add names to each active grade column.
I added an extra block of cells to each term grader. This block is completely optional! The grades (there is room for two) placed in these special cells will weigh against the entire term average. I will explain what that means with an example:
Please note that if you choose to make Term Exam and / or Other equal to 100%, this will not trigger an error alert.
If you choose to make Term Exam and / or Other equal to 100%, the grades
in the grade columns that are next to the lessons plans will not count at all.
Scenario: High School Joe is taking Biology. His class has several grading areas - his labs, his tests, certain daily work, and one big whopping test that occurs 4 times during the course - that's a quarterly test - a Term Exam.
You can set up the term graders in any way to allow extra weight to this Term Exam. You can add an additional grade column and give it a large portion of the required 100% or if you are using 4 grade terms for High School Joe for all of his subjects, then I recommend using the Term Exam cell for his quarterly test. Next I will post a screen-shot of this example. Please notice in the example the impact of using the "Term Exam." In words, the impact is that the Term Exam takes 40% of the entire term average. See the 60% under the AVE? - 60% is the value of Labs, Tests, and Other in the term average. That is what it means "to weigh against" -- One item - the term exam - is taking 40% of the term average.
A screen-shot of NOT using the Term Exam, but instead using the grade columns.
For the example, I had to change the grade weights to account for the addition of the 40% "Exam" weight. Compare this to the first example of using the Term Exam, you can see there is not much difference.
Keep in mind that these cells are optional and that any grade place in the extra cells will weigh against the entire term grade average.
The term grader will tell you that the average is "Pending." In this case, that only means that there are no scores in the activated grade columns. As soon as you place a scores in the activated grade columns the word "Pending." will go away, so don't worry about it.
Be sure to select "Using" from the drop-down in Column U.
Of course the "Pending." error will still be there because there are no grades, so don't be surprised by it. The word NO will appear because - 1. there is an error present and 2. the term grader is in use with errors. Don't worry about it, if everything else is okay, the NO will go away once grades are added.
Err3 checks to make sure that all activated grading columns are in use and that Using is selected.. Err3 is a delayed message. It is important to correct this so that scores are calculated correctly.
Err2 is related to the extra score cells Term Exam and Other. If the weights are set too high for these parts that will trigger Err2.
!! next to the weight value row means that the score weights do not yet equal 100%.
The V Planner is a spreadsheet file in xls and xlsx format. To use the file, you must have Microsoft Excel on your computer. The V Planner is available from YoungMinds web site. YoungMinds is online via a subscription and on Donna Young's Site-CD.