Replies
No one has replied to this post.
Glibly, "no"...
You can't get it right right without applying every one of the inclusions and exclusions in the QAR technical guidance, at which point, what exactly are you paying for Pro-Ach for? This goes doubly so for Apprenticeships where working out the correct Hybrid End Year is not something you want to attempt in Excel (speaking as someone who has attempted it in Excel...).
If it's Education & Training and they all start and finish in the same academic year, it's almost doable, thing to remember is who counts as a start. That is:
Where a course is => 168 days in duration, whose who withdraw within the first 42 days are not a start
Where a course is => 14 days and < 168 days in duration, whose who withdraw within the first 14 days are not a start
Where a course is < 14 days in duration, whose who withdraw on the first day are not a start
Also, anyone Funding Model 99 will be an exclusion.
That's the canonical definition, yes, but is only fully of use at the end of the year when everyone is a leaver in one way or another (either completed or withdrawn).
"leaver" and "start" are virtually synonymous for in-year calculations though. So, for in-year, you can do:
starts minus withdrawals/all starts to give you a maximum retention for the end of the year.
Hi Steve, picking this up as ive confused myself on retention calculation.
A) live learners / All starts (including withdrawals before 42 days) x 100
or
B) Live learners / all qualifying starts (not including withdrawals before 42 days) x 100
Based on your convo above, it looks like formula A is correct?
Just to note, new provider, no completions as of yet.
Right, so, anyone withdrawing before 42 days (on a long course) is not a Start, they just aren't part of this conversation at all.
so it's (Starts minus anyone who withdrew after 42 days)/all Starts x 100
with numbers:
10 people begin the (year long) course, 2 of them only attend the first two lessons. A further 4* withdraw after three months:
(8-4)/8 x 100 = 50%
*just making the sums easy!!!
Kelly Knights
Calculating retention
Edited
I'm trying to calculate the retention % for some quals and I'm not sure if my formula is correct. I've checked our pro-achieve but I'm still not convinced I'm on the right path.
Could someone advise a simply way of calculating retention?
Thank you