  Many schools have a marksheet like the one above – a marksheet that takes all the assessments in a single term across all the subjects offered by school. Once you have a marksheet like this, SIMS Assessment Manager makes it easy to generate various key performance indicates (KPIs) such as:

• Total GCSE Points Score
• Capped GCSE Points Score
• Number of A*-C grades including English and Maths

In this article, I’ll show you how simple it is to calculate the Total GCSE Points Score and the Capped GCSE Points Score.

First, Create a Summary Marksheet

If you don’t have one already, a summary marksheet just displays all the subjects you offer. You’ll need to create one per term. When completed it will look like the marksheet above (yours might not have colours, it doesn’t matter).

Total GCSE Points Score

Note: If you offer double or half GCSE courses, each aspect should ideally be in a gradeset that reflects this. Eg a double GCSE grade C is worth 80 points and should be in a special ‘double points’ gradeset.

• Create an aspect called “Total GCSE Points Score”. It should be a marks integer aspect in the range 0 to 1000.
• Within the summary template add a ‘new column for data entry using a formula’ formula.
• Select the new “Total GCSE Points Score” aspect and choose the same resultset you are using for the other aspects (eg Year 10 Autumn Term)
• Choose the SUM formula
• Tick each of the GCSE subjects you’d like to include in the total Capped GCSE Points Score

Also known as the ‘best 8’ points score, this KPI is just the total score of the highest eight GCSE grades. Calculating this is a little bit more complex.

• Create an aspect called “Capped GCSE Point Score”
• On the template, add a new “column for data entry using a formula”
• Use the new aspect and the same resultset as before
• We’re going to use the MAX formula to choose the highest grade over all the columns
• Create a new “column for data review using a formula” (note this a “review” column, not “data entry”)
• Call it MAX1 and use the MAX formula as per this screenshot: • Repeat this process with a column called MAX2. This new column is exactly the same as MAX1, except the entry in the ‘Max’ box should be 2. This makes the formula return the value of the second highest grade. See below: • Repeat this for MAX3 to MAX8
• Add a “column for data entry using a formula”
• Use the “Capped GCSE Points Score” aspect created earlier and the relevant resultset
• Use the SUM formula to add all the MAX columns together. • Open your marksheet and press calculate.