Joe McMahon

QAR Data

Created

I am reviewing the data that the ESFA has released for R12 QAR and I am noticing a couple of learners showing up from before 2020. I have had a check and the learners have had either withdrawal or achievement all completed on the ILR but cant seem to figure out why they would still be showing up on the R12 QAR data. Any ideas would be appreciated. Thanks in advance, Joe  

Replies

No one has replied to this post.


Ben James

Planned end date in 22/23 perhaps? 

Joe McMahon

That is what I thought at first but looking at 2 I have in front of me right now one has the planned end date of Feb 2021 and another has the planned end date of Dec 2019. I have noticed they are missing an Actual End Date or Achievement Date but I'm not sure how we would get this updated when the information on our PICS account is all filled in for the learners. 

Ben James

Interesting. Can you check in your R12 XML to see if either of those dates were present? Could just be a gremlin. Might be worth checking last year's QAR too, see if they were present/had dates in that dataset.

Joe McMahon

Think that will need to be my next plan, pull all the spreadsheets and compare each. Thanks Ben  

Paul Taylor

Hi Joe

Check the detail in Overdue_Continuing_Aim and the Overdue_Planned_Break columns as these most likely explain why you have learners that appear in 22/23 with pre-22/23 dates. If either of those columns have a 1 in for the learners concerned then it could be that you have updated ILR data (end dates or completion status / outcome) for a prior year after the year end submission for that year.

Thanks

Paul

Joe McMahon

Hi Paul

They both have a 1 in the Overdue_continuing_aim and on further digging the status wasn't put in within the learning year of their completion. I just now need to figure out why they are showing as Learning Outcome 9 which I believe is study continuing when it looks from our ILR that everything is up to date. 

Thanks for the help Paul 

Joe