V4.2+ V Planners do not need this.
This applies to V4, V4.1 and some copies of V3. If it doesn’t work in your V3, then assume that it is not one of the aforementioned copies. Additionally, this is optional — one does not have to do this.
What it the Alternate Grade Scale?
The current grade scale legend is setup so that –
- +/- grades may be removed – and that results in #2
- Instead of “B” (for instance) representing B-, b, and B+, “B” represents B, B+, A-
While the grades reported on transcripts and report cards are correct, the grade scale legend might cause confusion and that is why I am offering an alternative grade scale legend.
NOTE Regarding +/- Grades
Do not use the alternative grade scale legend if you have removed the +/- grades. Additionally, if you decide that you want to remove the +/- grades after overwriting the original grade scale legend, then BE SURE to the original grade scale legend formulas back in. The original formulas will be included on the file below.
The File with the Formulas
The file is for members only, login is required to download the file.
Right-click the file link and save the file to your computer. Grade Scale Legend Formulas Requires Log-in
Open the file and follow instructions. The file should open with a Plain Text editor such as Notepad or TextEdit.
Note- The file includes grade scale legend formulas, both new and original formulas, that do not contain Grade F.
Screenshots of Some of the Steps
- Go to GS-QP (V3 or V4)
- Unprotect GS-QP
- Place your cursor in cell S11 (this should be the cell that contains the first grade scale lengend)
- Choose which set of formulas that you want – base your decision on the number format
- Select the 3 rows of formulas
- Copy (CTRL C)
- Go back to the V Planner
- Make sure your cursor is in cell S11 – see image in step 3
- Paste (Ctrl V)
- If it looks good, and to be certain of this look at a Transcript or an “RC” worksheet, then protect the worksheet
- If it doesn’t look good, then “undo” (Ctrl Z) and try again
Grade Scale Legend Display is Cut Short in Transcripts
Chances are, after placing the new formulas into GS-QP, the last part of the grade scale legend will not be displayed. The reason for this is that the new legend could be longer than the old legend. The cell usage at the transcripts is quite tight and the space for the grade scale legend occupies columns A-F and rows 33-35 – see image below.
If you do any formatting to cause the whole legend to display, you will have to do all of the work for each legend in columns A-F in the row of the displayed legend. This means — do not touch column G (unless…)! Column G contains the legends for QP scales. Now these QP scales will only appear if your student is earning credits. If your student is not earning credits, then the QP scale formulas may be removed. If the student is earning credits, do not touch column G.
If the grade scale legend is not displaying in full and you need more information about how to format the cells to cause the entire grade scale legend to display, please contact me in the usual way.