MIS Systems Thread, Best way to calculate 3 or 4 levels of progress KS2-4 ? in Technical; I'm looking at the best way of calculating our KS2-4 levels of progress for targets, I have done a template ...
11th July 2013, 12:39 PM #1
Best way to calculate 3 or 4 levels of progress KS2-4 ?
I'm looking at the best way of calculating our KS2-4 levels of progress for targets, I have done a template in the past but it didn't get used and now it's time to create another one. Basically I was thinking a template doing the following.
KS2 points + 12 > conversion to GCSE grade + 6 (or 12) > Marks to grade (GCSE). I thought it best to add the 2 levels at KS3 so the low ability would get onto the conversion scale.
Using the following conversion:
GCSE Grade A* A B C D E F G
Notional level 10 9 8 7 6 5 4 3
I was just after examples of how other people do it, is there an easier way in SIMS? Are my figures completely off ?
11th July 2013, 03:09 PM #2
- Rep Power
To be honest I find this easier to do manually. I have a column for the KS2 level and a column for the GCSE target. Then I filter the level, say 4, and use the assign a grade to column function to enter B. Then do it for the other levels. Much quicker than trying to use a formula.
(I use exactly the same figures that you do.)
15th July 2013, 12:53 PM #3
- Rep Power
If you'd prefer to keep the calculation in your sims template, just use a nested if then else column. So have a column that works out the point difference between target and KS2, then in the nested column, if point difference equals 13 then progress is 3 levels etc etc.
Edit: Oops, I assumed you were using sims. If not then you still know what solution I meant :-)
15th July 2013, 01:06 PM #4
Thanks, my title is a bit misleading but I was actually after the method people use to to enter a KS2 level and calculate a GCSE target based on 3 or 4 levels of progress. I think my stated method is going to work for us okay but if anyone has any better ideas I am open to them.
15th July 2013, 01:25 PM #5
Checking my marksheet it seems I do it this way...
KS2 English test result + 13 = KS4 English target (3 levels progress)
KS2 Maths test result + 13 = KS4 Maths target (3 levels progress)
Average(KS4 English target, KS4 Maths target) = Average 3LP target (for all other subjects)
EDIT: we use SIMS to convert the KS2 grades to point scores, do the maths, then convert back to GCSE grades.
Last edited by tmcd35; 15th July 2013 at 01:26 PM.
By number34 in forum MIS Systems
Last Post: 22nd June 2013, 11:04 AM
By Steve21 in forum Windows
Last Post: 28th October 2012, 02:34 PM
By BackCat3 in forum Hardware
Last Post: 20th May 2011, 12:53 PM
By sidewinder in forum O/S Deployment
Last Post: 11th October 2006, 08:25 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)