Highlighting Pupils Who Have Made Three Levels Progress KS2 to KS4

You may also like...

8 Responses

  1. Dave Cattlin says:

    Got a better one

    it’s a little more complicated than that

    give me a call

    JH has my number


  2. Neil Fraser says:

    If all they want to do is identify the pupils then wouldn’t it be easier – and prettier – to use a tracking grid set out like the DfE KS2-KS4 table? This doesn’t allow for as much later analysis as the method shown but would give them a good visual idea of the state of play.

    • david says:

      Tracking grids are certainly easier but it’s useful to be able to see a colour coded Yes or No from within a marksheet. Tracking grids are great, but you con’t save the results of a tracking grid back to an aspect…

  3. VikPaw says:

    Query: In paragraph 4 – level 3 needs 34 points to gain 4 levels progress, is that 4 levels or 3 levels as per title?

    Isn’t it possible to do GCSE grade MINUS KS2 level and get a difference in values from the underlying points? Then wrap an “If > 12 = Green” around it.

    • david says:

      You’re right! typo now corrected!

      The problem with the 12 points is that GCSE grades is that they don’t integrate with NC points. For example, A GCSE grade D is worth 34 points, but a level 3 NC grade is worth 21 points. So there’s notionally 13 ‘points’ between them. It’s comparing apples with oranges, as they say!

  4. Les Roberts says:

    Our targets are based on 3 levels progress and we use BRAG to show B>=Aspire Target + ‘Y’ for On Target, G>=Min Target + ‘Y’ for OT, A<Min Target + 'Y' for OT, R='N' for OT or OT/Assessment not entered (the colours are also shown on reports). This works fine but if the grades are imported then the BRAG colours aren't updated. It's a pain to have to re-calculate 205 individual marksheets prior to running the reports. Is there any way to work around this?

    • david says:

      Hi Les, Could you create a single marksheet based on the ‘all year groups’ option. I.e. instead of creating separate marksheets for each class, reg group or year, just create a single marksheet for the whole school?

      You might still have to create templates for each subject though.

      Generally, adding colours to a marksheet is very laborious and time-consuming. Capita have added a couple of time saving clone options to the nested-if-then-else statements that control the colours, but it still takes too long!

  5. Les Roberts says:

    Hi David, thanks for the reply. We do have the marksheets set up and yes they take ages + getting kicked out after completing 8 or 9 makes it a nightmare. The total number of subject templates is 205 and I have no idea if one teacher has imported some grades. I did create a teplate for a single KS3 year group and it took 1.5hrs to load recalculate and save. I can’t set up a template for the whole school as it will flood fill the BRAG colour with red for KS5 & KS4 pupils if they are not taking a course and this would then create havoc with the reports as the subject would think there was a BRAG grade so the KS5 students would have 60+ lines on an interim report. The other problem is that there are also formulas to convert the grades entered for 4 other fields into a report comment (Excellent, Good, Satisfactory or Poor) so I soon exceed the 255 aspect limit. I really just wondered if there was an easy way of identifying any class that had grades imported. I think my only work around to this would be to use the reports I run overnight and prduce a printout of any class with an incorrect BRAG colour and then just recalculate these classes.

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.