Devolution Postcodes

Home Forums Data issues Devolution Postcodes

Tagged: ,

This topic contains 6 replies, has 4 voices, and was last updated by  Peter Talbot 1 week, 2 days ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts

  • cpdoyle
    Participant

    Hi everyone

    Does anyone know where I can find a complete list of devolution postcodes so we can check our learners for AEB funding please.

    Thanks in advance
    Clare

     
    #265087

    Martin West
    Participant

    Hi Clare,
    Depending on the area you may have to include more than one administrative area, but you can download the postcodes from here:
    https://www.doogal.co.uk/AdministrativeAreas.php
    HTH

     
    #265128

    cpdoyle
    Participant

    Thank you Martin. Wonderful as ever 🙂

     
    #265136

    Peter Talbot
    Participant

    We use the ONS postcode file with a lookup table of Local Authority Districts to MCA’s. https://ons.maps.arcgis.com/home/item.html?id=8da1cb5b6daa4d72b8bbef115cf26746
    http://www.petertalbot.net/files/_xuCVtcXe6GdyDS

     
    #266321

    Peter Talbot
    Participant

    Hi everyone.

    As we are a national provider, my task is to predict how much of our total AEB contract will be allocated to each MCA and GLA – the “devo-commissioners”.

    My previous estimates of what share of our own contract would go to devo-commissioners were based on learner numbers, or a combination of the Adult Skills Formula and Community Learning student numbers. Now (June 2018) we have received a letter “giving you data to help you model and estimate your 2019 to 2020 ESFA allocation.”

    The letter makes clear that the formula will be used for Adult Skills, but for Community Learning it tantalisingly states: “We will … determine an average unit cost for each community learning qualification weighted by the programme weighting factor associated with the SSA …”.

    I have been trying to figure out what that means and my interpretation is as follows.

    Say we deliver three learning aims, LA1 LA2 and LA3. Their PW factors respectively are PW1 PW2 and PW3. The number of students achieving each learning aim are NS1 NS2 and NS3. The unweighted average unit cost is UC.

    Therefore the total cost TC must be NS1 x UC x PW1 + NS2 x UC x PW2 + NS3 x UC x PW3
    Hence UC = TC/(NS1 x PW1 + NS2 x PW2 +NS3 x PW3)

    So: add up the number of achieved learning aims in each programme weighting, and multiply each total by its programme weighting factor, then divide the total CL funding by the sum of the aforementioned weighted totals to obtain the unweighted unit cost. Then weight this unit cost by the appropriate PW factor to determine the value of each learning delivery, and allocate that to your devo area by student postcode.

    I’d be interested to know what anyone else thinks!

     
    #266323

    mattww
    Participant

    Hi Peter (and all)

    Have you seen the youtube video that the ESFA have released on devolution and the way that you can work out how you will be affected? It was on update yesterday

    https://www.youtube.com/watch?v=s8_oELfEJ_0&feature=youtu.be
    cheers
    Matt

     
    #286725

    Peter Talbot
    Participant

    Thanks for the heads-up Matt! I think my arithmetic is basically correct but I guess I will have to drink some strong coffee and watch the video a couple more times.

     
    #286811
Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.