New KS4 Resources Part 2: KS2 Fine Level and Grade

You may also like...

19 Responses

  1. D Harvey says:

    still can’t get rid of those pesky decimals… rounding and trunc and they are still there…

  2. C Folling says:

    We have just discovered if you use the =LEFT(Number,3) this works!

  3. Deb Harvey says:

    Will try that! Ages ago, in some of our local support team documents, they stated that you had to change the date of the entry of these values to approximately the time that they would have been given,, eg July 2011 for current year 11s. Is this so critical do you know?

    • David Pott says:

      Hi Deb,

      I think that was back in the days before result sets. The only time I ever change the result entry date is when calculating reading agesome Otherwise it’s not used.


      • Deborah Harvey says:

        Thanks David, it was last summer though,, not that long ago! The documentation said that the SIMS report wouldn’t work if the result date was not set to the date of the actual testing period.
        I won’t worry too much then, I will just put the result set as KS2 validated result,, which is the other thing we were told to do!

        • David Pott says:

          Hi Deb,

          I think that was specific to the School Report rather than the new KS4 resources. I was looking at the Assessment information that forms part of the School Report and my first impression was that the KS4 resources would be more useful than the simple A8/P8 data reported in the school report. Let me know what you think!


  4. Deborah Harvey says:

    Hi David
    well so far it looks encouraging… we had a trial of 4Matrix and the figures for P8 and Att8 from that matched what i got out of the SIMS KS4 analysis for year 10 which was encouraging to say the least. I didn’t ever set up the School Report for P8 as the estimates were already out of date and the baseline data used wasn’t fine levels, I seem to recall, and we were happy with the output we got from a template set up according to your post 2014 post.

    Current year 10 data in KS4 SIMS and in 4Matrix uses 2017 point values SO P8 values are very different from previous .

    Year 11 data was complicated as some of our students do Science A or B in year 10 and so there is a result that needed to be included with the rest of the predictions. That took a bit of resolution but I think it’s ok now.
    I really like the report output, the mapping is fairly straightforward as long as you do it methodically and you don’t need to know Qan numbers ( good for year 10 as I don’t yet know the new Qans for specs for English and Maths or History for next year for example) .

    I have yet to examine the output in detail for year 11 but P8 is lower than the value our basic P8 calculations generated and I am not sure why. Maybe the dreaded 2dp issue is at work yet again but as these calculations are both based on 2015 estimates and the same baseline KS2 figures, I would have thought they would be more similar– 0.04 difference. I am about to see if I can get the data to 1dp and see the change!

    I like the output, it is clear and each sheet is easy to compare with the previous data collection . I like the National values comparisons but don’t like them being 2014 values! One sheet without any formatting issues and once the calculations are done behind the scenes, it runs easily. I don’t like the fact that anyone can run the reports without knowing whether new data or mapping has been done. But if new data is always number crunched straight away, shouldn’t be too much of an issue. I think the mapping is easier.

    None of these systems are ever transparent to set up and I would hate to have to explain the set up to someone else! . I still like your P8 calculations the best. That also took a while to set up but I understood the whole thing so much better at the end of it and now can use it to check other reports.However the KS4 analysis gives lots of other PI values and the new indicators too.

    there,, you did ask my thoughts!

  5. David says:

    Thanks Deb,

    I hadn’t realised that the national comparisons on the Excel report were based on 2014 rather than 2015 results. I will try and find out when the 2015 averages will be included.

    Also interesting is that the points change for GCSE equivalence in 2017 (where, for example, a C grade will be demoted from 5 points to 4 points) is making such a big impact. Many people feared that it unduly penalised schools with lots of pupils on C, D and E as these grades had a one point drop in value.

    We shall see!


  6. Sarah Maurice says:

    I can’t see KS2 Average Fine Level as an actual column heading in FFT Aspire – only KS2RWMFineLevel – is that effectively the same thing for current year 11??

  7. Sarah Maurice says:

    The KS2RWMFinePoints is 4 decimal places! (that’s the double figure one eg 26.3077). I’ve rounded and pasted as value etc to get to 2dp….And divided by 6 rounded to 1dp to get KS2RWMFineLevel (eg 4.4), Have I got everything in the right place and order?

  8. Chris Innes says:

    for the 2017 exam cohort DFE October 2016 P8 update says use KS2 reading and KS maths test scores

    On Aspire should i now ignore the column “KS2RWMFineLevel” and import into sims the average of “KS2ReadingFineLevel” and “KS2MathsFineLevel”


  9. Andy Landers says:

    Hi, its definitely just the KS2 reading and KS2 Maths from now on so FFT KS2RWMFineLevel is out. However what im struggling with is order of the calculation – to calculate Average FGL do I average the reading and maths point scores then divide total by six OR divide the reading and maths point score each by six to get individual reading and maths FGL then average. This does produce quite different results and does move some pupils between prior attainment groups. Anybody got any ideas.


  10. Dh says:

    I think there is sample calc in the latest Progress 8 doc from you get a different number whichever way or method you use in most cases but its another way of tracking groups of students. No one really knows what value they will end up with for P8 next summer!

Leave a Reply

Your email address will not be published. Required fields are marked *

Comment moderation is enabled. Your comment may take some time to appear.

This site uses Akismet to reduce spam. Learn how your comment data is processed.