QAR Apprenticeship Data – Cohort Numbers

Home Forums Data issues QAR Apprenticeship Data – Cohort Numbers

Tagged: 

This topic contains 2 replies, has 2 voices, and was last updated by  gmoore 2 months, 1 week ago.

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

  • gmoore
    Participant

    Hi,

    Just downloaded and reviewed our 2017-18 QAR apprenticeship data.
    All the numbers in the Summary, Comparative and Minimum Standards sheets correspond with our own internal tracking systems. But the Trend sheets show cohort sizes for 2017-18 that are twice the cohort sizes shown on the other (correct) sheets. This then results in a different overall QAR % to the one shown on the other sheets.

    Is this a error? Does anybody else have this issue?

    Thanks

     
    #327259

    neil1702
    Participant

    Our numbers are consistent across all the tabs in the provisional report. I’ve not delved into the full data yet, but everything appears to be OK, so far.

     
    #327620

    gmoore
    Participant

    I have now worked out why this is happening. The pivot table selector in the top right hand of the Trend spreadsheets has a default setting of All which results in the Overall and Timely data being added together. Hence the almost double values.

    So this issue is not the result of an error, just my inability to correctly use a pivot table!

     
    #328670
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.