Hi guys,
I'm trying to use excel to analyse my students results in an exam paper. I have split the paper into 26 different sections and have put the childrens scores onto the spreadsheet. It has the childrens names on the left and the amount of marks the got for each questions as a decimal proportion of the available grades.
I want to create a list of students that got 100% of the marks and a list of those that got 0%.
EG - What I have at the moment
Name Q1 Q2 Q3 Q4 Q5 Q6
Kid 1 1 0 0.5 1 1 0
Kid 2 0 0 1 0.5 1 1
What I would like
Q1 Q2 Q3 Q4 Q5 Q6
Kid 1 Kid 2 Kid 1 Kid 1 Kid 2
Kid 2
Q1 Q2 Q3 Q4 Q5 Q6
Kid 2 Kid 1 Kid 1
Kid 2
Hopefully this makes some kind of sense!
If anyone could help, you'd be making a very sleep deprived teacher very happy!
Thanks!
Bookmarks