Class Average in Individual Report
I've been asked to set up a field in an Individual Report where the results in a column from AM7 are averaged across one entire class and displayed on the report.
I can see how to get a % or count up for grade aspects but not for numerical ones. Is it even possible? Same for min max.
Example in hand:
- Assessment columns are filled in, say 5, and these are averaged to give a final result.
- Final result is averaged over the whole class and a min-max worked out.
- Report shows the class average for a subject is 60%, the highest result is 90% and the lowest 20%. The child has only 30% so their parents can see he is doing relatively poor. Repeat for other subjects on the report.