I am working on an audition list for my band students. I have multiple fields that I am giving students a “score” for and would like to give them a rank based on how they scored on multiple fields. I am struggling because some scores are based on 100, with 100 being the best, and some are just a total of things completed (ie. student attended 3 extra meetings).
I would like a way to rank students automatically as I enter new scores for audition material. I can get a new average automatically, that’s not a problem. However, I can’t seem to figure out how to get an automatic ranking of students.
This is especially problematic as I will be ranking students that play different instruments separately. (there will be a rank of 1 for Flute and Clarinet, not just a top rank total.) Though a ranking of the entire group that updates automatically would be better than no ranking at all.
Any ideas?