Sort
If a student is "at the head of the class", that usually means that student has answered more questions "correctly" than any of the other students. So, to be at the head, get scores that are higher numbers. But with a modern spreadsheet, it is easy and quick to sort the list some other way than high score down to low. If we want to think of errors made, the student with the lowest number of errors may be "best". If we calculate the mean or the median of the scores and calculate how many points each student is from that average, we can sort our spreadsheet by "distance from the average" quickly and easily.
I heard a college advisor say that the best single skill a college student could take away for college is the knowledge of how to use spreadsheet software. The most popular spreadsheet is "Excel" by Microsoft. You can get Excel along with other handy software for about $150 but you can get "Sheets" from Google free.
<< Home