Andy Mackenzie

Hybrid Year Achievement Rates

Created

None

Hi, im looking for some assistance on the ESFA Hybrid Year Achievement Rates.

I'm used to Achievement Rates and understand them well, but this Hybrid Year concept is new to me. But:-

  • How do you calculate them?
  • What do they aim to show?

Many thanks for your help

 

Andy

Replies

No one has replied to this post.


Martin West

For monitoring delivery in an academic year, it is normal to calculate achievement rates based on the number of starts in the year.

The ESFA QAR is designed to report rates where the programme duration is longer than a year such as 2/3 year courses and Apprenticeships and uses the later of the planned end date and achievement date to define the reporting year, all aims/programmes planned or completed during 2020/21 will be reported against the hybrid year 2020.

See Business rules: https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/990234/ESFA_business_rules_for_QAR_2020_to_2021_FINAL_v3.0.pdf

HTH

(Edited)

Andy Mackenzie

I thought Achievement Rates were defined by Leavers and not by Starters?

Its always been via Sector/Qualification Leavers & Achievers at the end of the year which made sense. I know BIL has always been an issue but I'm just trying to get my head around what is trying to be achieved by capturing this Hybrid Year.

Andy

Dave Jeffries

Hi Andy. I do mine after each upload (and can't see on View Your Education Data, as the ESFA forgot to put our UKPRN on the list!), using the occupancy report.

The hybrid end year is the later of the planned end date and actual end date (eg 1. learner planned to end in August, actually ends in July but the later is August, example 2 learner planned to end in July but actually ends in Aug, then their hybrid end date is August). If the hybrid end date is in the 20/21 contract year, then they are potentially in scope for that year's QAR. To only get those in scope, I then remove in learning, any BIL not returned, also remove any who haven't met the qualifying period (so I calculate the planned days on programme and the actual days on programme to do this). I then perform the calculations using the following:

The overall QAR is the number of achieved learning aims as a percentage of the total number of learning aims in the cohort that ended.

The overall pass rate is the number of achieved learning aims as a percentage of the total number of learning aims that have completed all the planned learning activities.

The overall retention rate is the number of learning aims that have completed all of the planned learning activities as a percentage of the total number of learning aims that ended

The timely QAR measures the number of aims achieved on or before their planned end date, or no more than 90 days after.

(The calcs are done via Power BI so at the click of a button I can get split by age, gender, ethnicity, level, prior attainment, qual, etc)

Dave

Martin West

For in year achievement it is achievers of starters in a year/number of starts in the year that were due to complete.

For QAR its not the starts in the year but those that were planned to complete or did complete in the year and they use the last 5 years of data to capture all starts that have the current hybrid year

(Edited)

Andy Mackenzie

Thanks Guys, I kind of understand the logic of it...I think. However using the 'View Your Eduction' dashboard I'm getting more confused.

I'm looking at the Dashboard QAR Hybrid data and I don't quite understand the figures being shown. Using the Raw Data source I still cant understand as what is the 2020.5 data? As this isnt currently being shown in our Dashboard Data.

 

Andy

Martin West

2020.5 is used as the hybrid end year for those who have not completed, but due to errors in producing the data this year due and to the exclusion of 2019 hybrid year and other errors in calculation the R10 QAR has resulted in the data all but being useless to providers.

HTH

Andy Mackenzie

Thanks Martin, I've been struggling to make sense of the Raw Data and where its pulling the figures from to produce the Dashboard Figures. As it wasn't reflecting what the figure we thought it should be.

I've emailed the ESFA direct for clarification.

Thanks Again.

Andy