Calculating and Importing Avg. GCSE Scores in Wales

Calculating and Importing Avg. GCSE Scores in Wales

The Prior Attainment Article gives further detail of the prior attainment scores we use, and the information required to calculate the scores.

The prior attainment is crucial to your Alps analysis as it provides the baseline score from which we can measure your students’ progress. Without this baseline, we won’t be able to provide value-add analysis.


The following import steps are specifically for KS5 students in Wales:

Calculating your scores without short courses:

If you do not have any short course GCSEs, please follow these steps when calculating your scores:
  1. For Welsh schools using 9-1 grades, here are what the grades for the full course GCSEs are worth: 9 = 8, 8 = 7.67, 7 = 7, 6 = 6.33, 5 = 5.67, 4 = 5, 3 = 4, 2 = 3, 1 = 1.  
  2. For Welsh schools using A*-G grades, here are what the grades for the full course GCSEs are worth: A* = 8, A = 7, B = 6, C = 5, D = 4, E = 3, F = 2, G = 1, U = 0. 
  3. We recommend that you use the Find and Replace (ctrl + F) tool to quickly convert the GCSE Grades to their number equivalents. 
  4. Please treat the Combined Science grades as two separate grades in your calculation, by splitting them out over two separate columns in Excel.
  5. Exclude any BTEC/vocational courses from your calculation. 

Please watch the video below on how to calculate and import your Avg. GCSE Scores:



Calculating your scores with short courses:

If you have any short course GCSEs, please follow these steps when calculating your scores:
  1. For Welsh schools using 9-1 grades, here are what the grades for the full course GCSEs are worth: 9 = 8, 8 = 7.67, 7 = 7, 6 = 6.33, 5 = 5.67, 4 = 5, 3 = 4, 2 = 3, 1 = 1. The short courses are worth half of these full courses, and should also have a weighting of 0.5 when calculating the scores. 
  2. For Welsh schools using A*-G grades, here are what the grades for the full course GCSEs are worth: A* = 8, A = 7, B = 6, C* = 5.5, C = 5, D = 4, E = 3, F = 2, G = 1, U = 0. The short courses are worth half of these full courses, and should also have a weighting of 0.5 when calculating the scores. 
  3. We recommend that you use the Find and Replace (ctrl + F) tool to quickly convert the GCSE grades to the Alps Points equivalents. 
  4. Please treat the Combined Science grades as two separate grades in your calculation, by splitting them out over two separate columns in Excel.
  5. Exclude any BTEC/vocational courses from your calculation. 
When calculating your scores with short courses you will need to create an equivalence row at the bottom of your Marksheet to count how many GCSEs each subject is worth. A full course is worth 1 and a short course is worth 0.5, as shown in this example:


Then you need to convert your GCSE Grades to their Alps Points equivalent:



In the screenshot above, the original grade for the short course was a 9. If this was a full course then the Alps point equivalent would be an 8, but because the short course is worth half the amount of a full course, the Alps point equivalent for this short course is a 4.  

The calculation you need to use is as follows:

Total sum of points divided by GCSE equivalence. 

In the example below, I have 5 full courses and 1 short course, which is equal to 5.5 GCSEs. 

My total points are 42.34 (8 (FC) + 8 (FC) + 7.67 (FC) + 7.67 (FC) + 7 (FC) + 4 (SC)). 

So, I need to divide 42.43 by 5.5, which comes out at 7.69.

See example below:





If you need to import additional data, including prior attainment, please go to Students, use the drop-down lists to navigate to your Academic Year and Year Group, then click on Import Additional Data. Choose Update and merge, shown below. You can then launch the import wizards from this screen. This applies for all Key Stages in all countries.


Once you have imported your students’ prior attainment, you will be able to import personalised targets. This process is very similar to the other grades imports, and is covered in more detail in the Personalised Targets Article.

 


    • Related Articles

    • Calculating and Importing Avg. GCSE Scores in Northern Ireland

      The Prior Attainment Article gives further detail of the prior attainment scores we use, and the information required to calculate the scores. The prior attainment is crucial to your Alps analysis as it provides the baseline score from which we can ...
    • Calculating and Importing Avg. GCSE Scores in England

      The Prior Attainment Article gives further detail of the prior attainment scores we use, and the information required to calculate the scores. The prior attainment is crucial to your Alps analysis as it provides the baseline score from which we can ...
    • Adding Average GCSE Scores for KS5 imports for International Schools

      The Prior Attainment Article gives further detail of the prior attainment scores we use, and the information required to calculate the scores. The prior attainment is crucial to your Alps analysis as it provides the baseline score from which we can ...
    • Average GCSE Score Calculation - Grade Conversions

      For all KS5 imports, you will need the Average GCSE Scores as a baseline for your students. The manual GCSE Score calculator allows you to enter the received GCSE grades one by one, and will calculate the Average GCSE Score for you. Key Stage 5 Prior ...
    • Different Types of Prior Attainment Scores

      Your Prior Attainment scores can be imported within the + Year Group step, or you can use the + Prior Attainment wizards to import your data and make use of our prior attainment calculators. The Prior Attainment import wizard will change based upon ...