JamesDM

Thanks for sharing, a useful and accessible video which might work its way into the next INSET day.

Here's the final version https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/277366/KS4_performance_tables_-_inclusion_of_14-16_qualifications_in_2014.pdf Page 4 states that only full GCSE's will count towards performance measures.

Steven, that sounds like the kind of thing a lot of schools would love to have, I find none of the 3rd party software (or SIMS) ticks every box. I spend a week every half term exporting data into spread sheets which then anlayse the data in a useful way. I'm also in the process of trying to find a clever and user-friendly way of analysing the impact of interventions/provisions for our pupil premium students.

Thanks for the reply but I can't get this to work, using the formula above gives me a value error. I tried using , instead of * to seperate the arrays in the formula but this just gives a total SUMPRODUCT, not a largest 8 SumProduct?

Has anyone got a solution for calculating capped point score per pupil in Excel? So far I've got SUM(LARGE(L2:BF2,{1,2,3,4,5,6,7,8})) but this doesn't take into account the GCSE weighting for equivalencies e.g. if a BTEC subject is in the eighth highest add this twice. I already have a row with GCSE weighting per subject on it so I almost need to combine the above formula with SUMPRODUCT...somehow?

That's the nice neat solution I was after, thanks.

I like your thinking pcstru, thanks. Think I'll create a second sheet, but use actual GCSE points instead of arbitary numbers and then I can use this for calculating point scores at the same time :-)

Hello, I'm using COUNTIF to find the number of each grade for GCSE results but I want it to recognise that some or worth more or less than one GCSE. I was thinking of having a row with the 'GCSE Weighting' in it, i.e. 0.5, 1, 2 etc. but I can't think how to incorporate this into the fomula. I want it to look at the correct cell in the 'GCSE Weighting' row for that result, i.e. Count how many A's there and times it by the correct weighting for each occurance. In previous years I've just grouped different weightings together and used seperate formulas for each group, but I'm trying to cut down the size of the spread sheet (and feel a bit clever). Any ideas?