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.
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.