Hello Marcus, thank you for this plugin, it will be useful.
I think I've succeeded in getting the gradebook to do all the magic calculations, here's the way I went about it for any future readers and if I've missed a step to make it easier, please let me know as I will be repeating this methodology for several other BTEC courses:
Set up 2x custom scales in the course: one for the qualification type (single, double, triple award BTEC as some students on each course do different unit combinations) and another scale that represents all the possible grade outcomes for a BTEC qualification from U to D*D*D*:
I then set the grade book up with categories for each unit, and two custom grade items called 'QualType' and 'Points'
'QualType' uses the scakle (BTEC2016 diploma type) and Points is a numerical, 0-270 in this case:
I edited the calculation for each category (Unit A, Unit B etc) and it was here that I applied the "GLH" weighting for that specific unit to convert assignment grade to points:
In the gradebook, teachers select which qualification type each student is currently working toward [here, the 'Points' column is overriden to 255 so I could test that the course total changed, but it should read 16 otherwise as only unit A has been marked]:
There is a custom calculation on 'Points' that just sums each of the totals for unit A, unit B, etc, and then a final custom calculation for overall course total:
The two major improvements that I would welcome but couldn't find would be:
- VLOOKUP: I'm using nested IF statements; I couldn't find any suggestion of there being a VLOOKUP feature in any documentation
- Accessesing the 'weight' value: all items/categories in the gradebook have a 'weighting' input field (set to 1.0 in this example and largely ignored by my custom calculations): if I could have this as a variable in the custom calculations, I could put the GLH for each unit in this field, and then would be able to use the same custom calculation for each unit as it could just reference the weight to select the correct point scores. Is that possible?