+ Post New Thread
Results 1 to 5 of 5
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 ...
  1. #1
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,006
    Thank Post
    124
    Thanked 286 Times in 263 Posts
    Rep Power
    109

    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 ?

  2. #2

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    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.)

  3. Thanks to number34 from:

    ChrisH (11th July 2013)

  4. #3

    Join Date
    Oct 2011
    Location
    Grimsby, North East Lincolnshire
    Posts
    19
    Thank Post
    5
    Thanked 6 Times in 6 Posts
    Rep Power
    8
    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 :-)

  5. Thanks to Mirmo from:

    ChrisH (15th July 2013)

  6. #4
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,006
    Thank Post
    124
    Thanked 286 Times in 263 Posts
    Rep Power
    109
    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.

  7. #5

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    6,056
    Thank Post
    896
    Thanked 1,008 Times in 821 Posts
    Blog Entries
    9
    Rep Power
    349
    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.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS - best way to produce video or help sheets for teachers
    By number34 in forum MIS Systems
    Replies: 11
    Last Post: 22nd June 2013, 11:04 AM
  2. Replies: 7
    Last Post: 28th October 2012, 02:34 PM
  3. Best way to store 20TB of Data?
    By BackCat3 in forum Hardware
    Replies: 17
    Last Post: 20th May 2011, 12:53 PM
  4. Best way to 'image' a suite of Macs
    By sidewinder in forum O/S Deployment
    Replies: 10
    Last Post: 11th October 2006, 08:25 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •