Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?
I need to make a comparative chart of Test 1 and Test 2 grades in MS Excel 2007.
This is my data:
Value points: 0–20
Number of students: 35
Grades can go in the vertical axis.
My problem is I don’t want to have each and every of the 35 students grades in a separate column in the horizontal axis but rather, I’d like to group all the students that got 18, 15, 10, etc. in each test. Hope if I am being clear enough. I can’t figure out.
PS: This isn’t homework. I am the teacher comparing T1/T2 results to gather information in order to design Test 3.
This question is in the General Section. Responses must be helpful and on-topic.