What is the best way to compare relative performance of students?

An institute has some 200 students. They have to study in different courses and appear for the test which is of 100 marks. However, all of them do not appear in the same number of tests. Depending on their experience, the number of tests they appear may vary.

But at the end of the academic year, their performance has to be evaluated and a relative ranking has to be generated. What is the best way to do this?

A sample on how the data would look like is given below:

|Student|No. of Tests|Total Marks|
|Student 1|12|1195.00|
|Student 2|13|1294.50|
|Student 3|35|3484.50|
|Student 4|35|3484.50|
|Student 5|29|2883.00|
|Student 6|29|2882.67|
|Student 7|42|4171.50|
|Student 8|40|3968.00|
|Student 9|6|595.00|
|Student 10|28|2775.83|

A broot force way to go with this will be calculating average for each of the students.
Considering the load that if some student takes more courses, there will be higher workload, and thus he deserves some sort of bonus for taking more number of courses.
This bonus can be adaptive in sense that more the number of courses one takes, burden would be higher, thus he deserves an even higher bonus score.

There can be many solutions to a single problem like this, it may vary acc to their approach.

1 Like

Average seems not to be a very good way in this case. If you see the data, the average of student 1 is greater than student 7 where student has taken more number of tests compared to student 1.

Yes, which is the reason I tried introducing this bonus score thing for number of courses a student takes.