MEAN Calculation of grades

[trackers]

I set up a marksheet template based on one previously designed.

 

The sheet shows tracking grades for all subjects studied and an average score at the end.

I know I could do this by using the tracking scores rather than grades but went with the existing style of using grades.

 

The average score seems to be based on A* - 90 A -80 etc. I am not getting a consistent correct average though if this assumption is correct.

 

The idea is to eventually have a rank order sheet for prize awarding.

 

I am using MEAN.

 

I am not sure how the MEAN formula determines the numerical value for the grades - is it based on the grade sets that are being applied to the aspects that I am averaging.

 

Another thing is that I have a different marksheet that I set up in the same way for another year group and that seems to work fine.

 

I can't see the difference in how they are set up - so any pointers about where to look for discrepancies would be appreciated.

[bfelton]

It averages the grade values of the results you are referencing.

[trackers]

So the grade values are based on what?

 

if for example an A* is 90+, does that mean that an A* is valued at 90?

[bfelton]

Sorry I jumped a few steps there, the column with grades in it has an aspect attached to it, this aspect has a grade set attached to define which grades can be recorded and what they are worth. The easy way to see the values of the grades from the grade set is to right click on the column heading of the grade column and select "View Aspect Details".

[trackers]

I have looked at the aspects as suggested and eg an A* is valued at 90 - this should mean that the only way to get a MEAN score of 90 would be if every result is an A* - but this is not what's happening.

 

I have students doing 16 subjects and want the grade average as a score for ranking but eg one student has 9A*, 5A, 2B and he is getting a score of 90.

This should give me (9x90) +(5x80) + (2x70)..............all divided by 16 = 84.375.

 

So I am not sure where it is going awry.

[bfelton]

Are you able to post a screenshot of your formula that is generating the incorrect result?

[cw222]

I have students doing 16 subjects and want the grade average as a score for ranking but eg one student has 9A*, 5A, 2B and he is getting a score of 90.

This should give me (9x90) +(5x80) + (2x70)..............all divided by 16 = 84.375.

So I am not sure where it is going awry.

 

Silly question, but what result would 12 * 89 4*99 give(average 91.5)? It's not trying to give you the mean of the cell values, rather than of the grade values is it?

[trackers]

Pic of screen -

 

[bfelton]

Do all the result columns use the same gradeset? do they all definitely have values against each grade? What is the aspect that the result is getting saved to?

[trackers]

In reply to cw222

 

This is what I originally thought might be happening but he fact that the top 9 averages are all 90, then there is a group averaging 87.50 suggests that it is more likely that the standard numeric values for the grades are being applied - otherwise I would expect to be getting lots of unusual numbers rather than these rather neat ones.

 

I realise we could use the cell values /100 to get an average - but we decided grades were fairer, given the number of teachers marking across a subject - they would be very likely to give the same grades for student work while numeric scores may have more fluctuations.

Edited June 27, 2019 by trackers

[trackers]

bfelton:

 

The same gradeset for each subject eg key stage 3 gradeset current- apart from Maths which seems to have a different Gradeset referenced - but which ultimately has the same values in it.

This one subject - Maths -does not have (and I don't know why it is not there) anything filled in the Description column like the others do.

 

 

The aspect it is getting saved to is Year 10 Total Grade Score

 

Which says the Type is Marks-Decimal

and a Min Value of 0.00

Max Value of 300.00 - I am not sure why the number has been set at this - perhaps it should be set to 100.00.

Edited June 27, 2019 by trackers

[bfelton]

What I would be tempted to do is create a data review using formula for each grade column using the VALUE formula and then point the MEAN formula to the new columns, with this you can at least see which true values are being used in the MEAN formula.

[trackers]

I still regard myself as an L driver on all of this...but while I am not certain about what your reply specifically says to do - I do get the general idea, and I'll give it a go as soon as I can.

 

Thanls

 

T.

[trackers]

So - thanks for the suggestion - it is now working. I set up the additional columns with value formula and used them to calculate the overall average properly - and in doing so I discovered why it wasn't working previously !

 

I feel a little foolish - I had set up the original sheet properly - the only reason it was working out the average properly was that I wan't hitting the Calculate button. I realised this when I hit this button after adding the new columns and formula and saw that the original average changed to match the new average I had set up. I had thought that the value appearing on the original sheet had been averaged already but it hadn't. D'oh.

 

Anyway thanks for the help.

 

Off on summer holidays now.

 

This forum has been a massive support all year.

 

Thanks.