My students have completed a touch typing test that have given them a WPM (words per minute) result.
I now want to give a score to those results out of an arbitrary number, say 10. I will later use this number for weighting with other tests for a final end of semester score.
I also want the touch typing test score to be comparative to the WPM result so that if a WPM result is miles above the next result, the scores may drop from 10 (1st student) to 7 for the next student - with no one in the class getting a score of 8 or 9 - thereby indicating that the student who got a 10 is significantly out-performing the rest of the class.
Sample data:
Student | WPM Result
----------------------
Student 1 | 54.4
Student 2 | 61
Student 3 | 86
Student 4 | 52.5
Student 5 | 45.8
Student 6 | 117.7
Student 7 | 107.8
I have all the data in Excel, so I can work with a formula type answer.
Any thoughts?