The Qualification and Achievement Rates (QAR) Report calculates your achievement rates for different types of Learner Aim. The calculations used in this report are regularly updated to meet the ESFA specifications for the current year.

Report Options

The following customisation options are available:

• Report Type – Four report types are available, each of which calculates the achievement rates for a different type of programme:

  • Apprenticeships

  • Traineeships Programme

  • Traineeships Component Aims

  • Education and Training

• Report Total Type – Here you can choose whether the report uses Overall or Timely achievement. Choosing All will include both types in the report. If you are running an Interactive Report, however, you cannot choose All.

• To – Here you can specify the date up to which achievement rates will be calculated. You can either choose a Fixed Date and choose the relevant date from the calendar date selector, or choose one of the relative values such as Today, Start of Week, Start of Month or others. If you choose a relative value, it is possible to add a positive or negative Offset value, which will adjust the date by the specified number of weeks.

• Learner Tags – Here you can restrict the report to rates for learners with specific Tags. Choosing a tag from the drop-down menu will add it to the field. You can add multiple tags to the field and remove any added ones by selecting the X icon. The following tag options are available:

  • Any – This will restrict the report to learners that have at least one of the specified tags.

  • All – This will restrict the report to learners that have every specified tag.

  • None – This will restrict the report to learners that do not have any of the specified tags.

Spreadsheet Output for the QAR Report

The qualification and achievement rates report consists of a single sheet listing each relevant learner aim with its Overall and Timely achievement data. Along with the achievement and learner details, any Optional Fields chosen when building the report will be included as additional columns.

Interactive Output for the QAR Report

The interactive output for the QAR report will display either your Overall or Timely achievement rates, depending on the Report Total Type chosen when building the report (you cannot choose All for the interactive report). The only Chart Types available for QARs are Bar Chart and Table.

Instead of the Analysis Method option available for other interactive reports, there are instead two Report Presets you can use:

• Achievement Rate % – This shows the percentage of achieved aims out of all aims included in each cohort (as specified by the Analysis Column).

• Cohort Count – This shows the number of achieved aims for each cohort (as specified by the Analysis Column).

Hovering over each bar will show the exact percentage or numerical value, and selecting a particular bar will show all aims which are included in the cohort.

Using the option to ‘Show all aim data’. Note that this will include all aim records that could be included in any report type, including Retention and Forecast figures, not just the records included in the currently displayed figures. You will need to manage the data in a spreadsheet to restrict it to those values.