+ Post New Thread
Page 1 of 4 1234 LastLast
Results 1 to 15 of 52
MIS Systems Thread, Progress 8 Measure in Technical; So I'm sure most of you have seen the document from the dfe laying out their current ideas on the ...
  1. #1
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    199
    Thank Post
    48
    Thanked 38 Times in 30 Posts
    Rep Power
    22

    Progress 8 Measure

    So I'm sure most of you have seen the document from the dfe laying out their current ideas on the progress-8 measure, with promises that we'll have the full one at the end of February.

    I'm starting to build out some marksheets to look at my current y9s and see how they line up under the progress 8, and was doing well until I got to the actual progress 8 measure.

    I've got my Y9s in with their estimated grades, going across 15 subjects. Going from the dfe guidance I need to count their best 8 grades with the following rules:

    2 of the 8 have to be English and Maths
    3 of the 8 have to be from Ebacc subjects; Science, ICT, Geography, History, Spanish, French (easy enough, Max 1, 2, 3 columns pull that)
    the last 3 have to be from the Ebacc, as well as Art, Drama, Muisc, Computing, and any Vocational courses that make the list.

    and here is where I'm having a problem, as if I use Max 1, 2, 3 columns, I'm going to get overlap from the Ebacc subjects (I'm sure) - so how can I pull the highest 3 grades that aren't included in the Ebacc Max columns?

  2. #2

    Join Date
    Feb 2014
    Posts
    2
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    my understanding is that you rank the ebacc subjects all the way from 1 to 6 and then in the final grouping only include the ebacc subjects ranked 4 to 6, avoiding any overlap?

    have not go round to building it yet bethink this should work - let me know f I have helped or confused please.

    dave

  3. Thanks to Dave_Bensley from:

    tombry (24th February 2014)

  4. #3
    Seb1780's Avatar
    Join Date
    May 2013
    Location
    Suffolk
    Posts
    276
    Thank Post
    117
    Thanked 109 Times in 85 Posts
    Rep Power
    102
    Quote Originally Posted by tombry View Post
    .....where I'm having a problem, as if I use Max 1, 2, 3 columns, I'm going to get overlap from the Ebacc subjects (I'm sure) - so how can I pull the highest 3 grades that aren't included in the Ebacc Max columns?
    Would something like this work?

    max1,2,3(min1,2,3(ebacc),other subject1, other subject2,.........))

  5. Thanks to Seb1780 from:

    tombry (24th February 2014)

  6. #4

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,356
    Thank Post
    36
    Thanked 362 Times in 247 Posts
    Rep Power
    81
    Progress 8 isn't completely defined as yet. You can get close to what has been put up within AM but some of the bits around the edge need to be hard coded unfortunately. The plan is to get a report into AM probably with the autumn release. Schools are not required to report on Progress 8 until next year.

  7. #5
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    199
    Thank Post
    48
    Thanked 38 Times in 30 Posts
    Rep Power
    22
    @Seb1780, you put me onto the right way of doing it - I just need to include the Max 1, 2, and 3 columns in my 4, 5, and 6 checked columns.
    @PhilNeal,

    I appreciate that we won't have to report on it until next year, but I have Y9s that are choosing their options, and will start those options in May/June when the Y11s leave for study break, and would like to see what they look like. I also know that it's not been completely defined yet, but it has basically been frameworked, so it's easy enough to get a start on it.

    As for the edge bits that would need hardcoding, I'm not sure what those would be - it seems to be a very simple measurement, and outside of the issue I was having above, I think I'll be able to get it set up today. Can you explain what you mean?

  8. #6

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,356
    Thank Post
    36
    Thanked 362 Times in 247 Posts
    Rep Power
    81
    @tombry I've spoken to the experts and you are right. It can be done in marksheets but its quite convoluted and a hard coded report will be produced.

  9. Thanks to PhilNeal from:

    tombry (24th February 2014)

  10. #7
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    199
    Thank Post
    48
    Thanked 38 Times in 30 Posts
    Rep Power
    22
    @PhilNeal

    Either I've way oversimplified this, or I'm confused by what your experts consider to be a convoluted mess!

    I've got Max 1-6 columns set up pulling in my top 6 Ebacc scores, I then have other 1-3 Max columns pulling from EBacc Max 4-6, as well as my other subjects.

    I've doubled English, throw it all together and get my scores.

    Seems far less convoluted than the 60 step process I was sent on how to set up tracking the EBacc as the nested if statements treat a blank space as greater than a number (which still isn't 100% accurate, but by now I know who my 4 or so false positives are)

  11. Thanks to tombry from:

    davidpott (25th February 2014)

  12. #8

    Join Date
    Sep 2012
    Posts
    4
    Thank Post
    1
    Thanked 4 Times in 3 Posts
    Rep Power
    0
    @tomby

    I think you've done it! I've just had a play with MAX formulas as you suggest and (with a minor alteration) - it works.

    I've included the updated advice about doubling the highest score of Eng Lan or Eng Lit, then using the second higher of the two with the Ebacc 'pool' (see https://www.gov.uk/government/upload...rk_reforms.pdf)

    Progress8.PNG

    The first column is just the math grade - 'as is'

    Next, a couple of MAX formulae identify the highest and second highest eng lang or lit grade, then doubles the highest.

    A second set of MAX Ebacc 1 to MAX Ebacc 6 formulas look across the remaining EBacc subjects (but not english or math)

    A third set of MAX Other 1 to MAX Other 3 formulas look across the second highest english column, the MAX 4, 5 and 6 Ebacc subjects and all the other non EBacc subjects

    The Progress 6 Column uses a SUM formula to add together MAX EBacc 1 + 2 + 3 and MAX Other 1 + 2+ 3

    Finally the Progress 8 column uses a SUM formula to add together Progress 6 + DOUBLE English + Maths Grade

    I need to go and lie down. What do you think?

    <EDIT>Forgot to double weight maths - but you get the idea.</EDIT>
    Last edited by davidpott; 25th February 2014 at 09:06 PM.

  13. 2 Thanks to davidpott:

    Tash (20th March 2014), tombry (25th February 2014)

  14. #9
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    199
    Thank Post
    48
    Thanked 38 Times in 30 Posts
    Rep Power
    22
    @davidpott

    Exactly what I did, although as I only have y9s not separated to eng and eng+lit yet, didn't get that set up, so props to you on that, I'll make sure to take that in when we split them off in a couple months.

    Edited to add:

    Set yourself up a new gradeset using the p8 points, aspects to hold them, and a mark sheet to copypasta the grades from one to another, take about an hour or so, but you'll need it soon enough
    Last edited by tombry; 25th February 2014 at 08:54 PM.

  15. #10

    Join Date
    Sep 2012
    Posts
    4
    Thank Post
    1
    Thanked 4 Times in 3 Posts
    Rep Power
    0
    Good advice about the new 1-8 values for the grades A*-G - I've not really taken the implications on board yet...

  16. #11

    Join Date
    Mar 2011
    Location
    Bristol
    Posts
    121
    Thank Post
    26
    Thanked 24 Times in 20 Posts
    Rep Power
    18
    These marksheet templates look good.

    One thing to bear in mind is the English is only double weighted if both English & English Literature have been studied (with, as you say, the higher grade counting.) Easily achieved in a template, but you may need to tweak what you describe above (off the top of my head I'm thinking an extra GRADE TALLY COLUMNS counting the 2 English columns and then multiply the English MAX points by this value.)
    Last edited by Ecclesbury; 26th February 2014 at 10:14 AM.

  17. #12
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    199
    Thank Post
    48
    Thanked 38 Times in 30 Posts
    Rep Power
    22
    well for the first year it won't matter - as the English Exam they take carries some Literature study in it - at least that's what the fact sheet from the gov says, and I'm just trying to give our Head something to look at to prepare him for how different it looks compared to our current methods.

  18. #13

    Join Date
    Mar 2011
    Location
    Bristol
    Posts
    121
    Thank Post
    26
    Thanked 24 Times in 20 Posts
    Rep Power
    18
    Ah yes, that's true. A lot of this will depend on each schools particular curriculum offer as doing a Double English course, or one with some literature, as you say, will still count double.

    Of course they could change all manner of other things anway, but I'd hope that large scale changes won't be

  19. #14

    Join Date
    Mar 2010
    Location
    UK
    Posts
    175
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    17
    If you have access to FFT data you could add in est. 'A' for those subjects, and subtract the predicted grades from them, and work out whether you will be below the Dfe floor (avg -1/2 a grade difference), or averaging +1 grade above and get a free pass from an Ofsted inspection for 12 months.

  20. #15
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    199
    Thank Post
    48
    Thanked 38 Times in 30 Posts
    Rep Power
    22
    well I know what I'm putting together tomorrow

SHARE:
+ Post New Thread
Page 1 of 4 1234 LastLast

Similar Threads

  1. How do you measure yourself? (KPI's)
    By Oops_my_bad in forum Educational IT Jobs
    Replies: 6
    Last Post: 16th October 2007, 05:32 AM
  2. Schools in Special Measures
    By tosca925 in forum General Chat
    Replies: 5
    Last Post: 30th August 2007, 12:12 PM
  3. Network progress
    By DMcCoy in forum General Chat
    Replies: 7
    Last Post: 30th July 2007, 10:14 AM
  4. Measurable Standards
    By GrumbleDook in forum General Chat
    Replies: 6
    Last Post: 3rd April 2007, 09:37 PM
  5. What's your inside leg measurement?
    By ITWombat in forum General Chat
    Replies: 18
    Last Post: 5th March 2007, 01:10 PM

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
  •