How do the "Grade" calculations work?
Grade
Description: Assigns a grade to values within user-defined bands.
Accepts: Exactly one column, multiple grade bands
Notes:
Grade band values must be contiguous (that is, the maximum of one must be the minimum of another) so that it is not possible to have values that fall between bands. E.g. if A had a minimum of 85 and B had a maximum of 84, a grade would not be able to be assigned to a student who received a mark of 84.5.
In the event of a value falling on the border of two bands, the grade is assigned to the better band, e.g. A has a minimum of 85 and B has a maximum of 85, a student with a mark of 85 would receive an A.
Grades are stored in the database as integers, and need to be converted to their grade values for display.
Note: markbook stores grade values in the opposite order to reports at this time.
Things to take note of:
Again, grade band values must be contiguous. ie If A is minimum of 85, B MUST have a maximum of 85.
Grade by percentage
Description: Assigns a defined percentage of grades to a list of values
Accepts: Exactly one column, multiple percentages
Notes:
The percentage bands for this calculation must add to 100, ratios are not allowed.
It is assumed that percentage bands will be input from best to worst.
Values are assigned to the higher grade if there is any room left in the band, even if the majority of the percentage that the mark would fill is in a lower grade. E.g. If there are 3 marks, and the Bands are A-40% and B-60%, the highest two marks would receive A and the lowest would receive B.
In the event of value equal values spilling over bands, all equal marks would receive the higher grade, and any following values will assume that the places in the lower grade have been taken. E.g. For the marks 100, 90, 90, 50 and the Bands A-40% and B-20% and C-40%, normally the top two marks would receive A, the 3rd would receive B and the 4th would receive C. However, since the 2nd and 3rd marks are equal, the 3rd mark will also receive an A, but the 4th mark will still receive a C.
Grades are stored in the database as integers, and need to be converted to their grade values for display.
Note: markbook stores grade values in the opposite order to reports at this time.