There doesn't seem to be a way to take an average of outcomes on an individual student basis. Please refer to extract from a previous posting (to which there were no replies - indicating perhaps that there is no current answer)



I need to be able to take an average of each outcome for each student. So I might have 6 occurrences of Outcome 1 (eg; achieves accuracy in spelling and expression) and I need to reduce this to a single average score for the course (which I have expressed in terms of an A-E rating).

Elena showed me where to find outcome reports but this, it seems, only does an average for the class.

I have a rudimentary understanding of formulas as used in Excel, and I see there is a calculation function within the gradebook. Am I barking up the right tree here? I want to avoid a formula where I have to manually pick columns to be averaged - I'd rather one that identifies all "outcome 1" columns and automatically calculates the average.