Send to a Friend

Yeahright's avatar

Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Asked by Yeahright (3880points) June 25th, 2012

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.

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.