Home › Forums › Data issues › Devolution Postcodes
Tagged: AEB, Devolution
This topic contains 6 replies, has 4 voices, and was last updated by Peter Talbot 6 months, 1 week ago.

AuthorPosts

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
ClareJune 16, 2018 at 8:33 am #265087Hi 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
HTHJune 16, 2018 at 2:16 pm #265128Thank you Martin. Wonderful as ever đź™‚
June 16, 2018 at 3:39 pm #265136We 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/_xuCVtcXe6GdyDSJune 21, 2018 at 3:40 pm #266321Hi 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 â€śdevocommissionersâ€ť.
My previous estimates of what share of our own contract would go to devocommissioners 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!
June 21, 2018 at 3:44 pm #266323Hi 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
MattSeptember 13, 2018 at 12:02 pm #286725Thanks for the headsup 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.
September 13, 2018 at 3:10 pm #286811
You must be logged in to reply to this topic.