I'm currently working in a school and students answered a 50 question form on ICT Ability. The results of this form have been put into a spreadsheet and I have to order the names in terms of ability.
I know how to do each row to check if the answer was correct but I'm wondering if I put in a row with the correct answers, is there a way to rank each student in a percentage with how many answered the same as the row?
Name Q1 Q2 Q3 Q4 Answer No True False Portait John No True False Portait Jenny Yes True True Landscape April Yes False True Landscape
Name % John 100 April 25 Jenny 0