How to analysing data within spreadsheet

sorry- new to this. Hopefully this title has now been changed. mybad!

Boom! We in action again.

Ha ha! Sorry soberguy looks as though I will be driving you to drink if I cant explain this. Please bear with me...

Right... the maths score ARE the colours! for example... Joe what level you on in Maths? ~Joe then answers purple!

There are no numbers (although the computer should know through lookup table that purple actually equates to 3. We created this so that we could easily average the colours. I say easily- ive not a clue how! Someone fixed this for me).

Right as for column D- this just shows what class the children are in so that i can pull off information for each class- but you will see in the sheet titled 'maths' that i refer to the classes as cohort groups. The reason for this is that children will change class each year but their cohort group will remain constant- the year they joined primary education.

Do you understand that complicated formula that I posted before? This is the key to averaging out the maths colours for each child. This bound to be the first step.

Don't give up on me soberguy. We have built this international relationship of our for over 1 hour now. That is an hour you will never get back- dont let it go to waste! :-)