If any users take part in the annual Community Learning Benchmarking Club data submission, haven't filled their template spreadsheets in yet, and have access to SSRS reports we may be able to help.
There are two ways to fill the template spreadsheet this year: from study data (as per last year's reports) or, new for this year, from a Single ILR file - this option has been put in for providers with sub-contractors who report their data by sending ILR's generated from other systems and who merge those ILR's into their own provision.
CL Benchmarking Data Report (updated from 16/17)
This report will generate the numbers required to paste into the TERMS DATA sheet of the "1718 Benchmarking Template (WMS).xlsx" spreadsheet. The report works from TERMS Study data and requires the user to select the funding year they want to see data for (just in case you want to generate data from other years for comparison purposes). The report has been updated to show the number of sub-contracted and direct delivery enrolments (split by the partner UKPRN field) and numbers for learners and enrolments with low or no qualifications recorded in prior attainment.
CL ILR Benchmarking Data
This report will generate the numbers required to paste into the TERMS DATA sheet of the "1718 Benchmarking Template (WMS).xlsx" spreadsheet. The report may require the user to select the appropriate site and funding year if it cannot determine these by itself. The report will look for the latest of R12, R13, or R14 from the site's Single ILR's (not working ILRs) to use. As there is no attendance information in the ILR there is no data generated for the attendance rate question.
Filling in the 1718 Benchmarking Template (WMS).xlsx spreadsheet
Once you have the SSRS reports installed:
- Run the relevant report, depending on whether you want to generate the numbers from Study data or from an ILR file
- Export the report to a Word document and save it locally
- Open the exported Word document and the modified template spreadsheet
- Select and copy the table of data from the Word document and paste it into cell A1 of the "TERMS DATA" sheet of the modified template spreadsheet.
This should automatically fill the majority of the numbers in the DATA part of the spreadsheet in leaving you to fill the name of the authority in and copy the relevant allocation details across.
Benchmarking Course Detail
If you ran the Study Data based CL Benchmarking Data report and you require data for Course Detail there is a second SSRS report ("CL Benchmarking Course Detail") that will generate a list of the CL courses in TERMS along with the GLH details and enrolment counts. As with the benchmarking data save the report output as a Word document, then copy and paste the table into the relevant spreadsheet.
Benchmarking ILR Course Detail Reports
If you ran the ILR based CL Benchmarking Data report and you require data for Course Detail there is a second SSRS report ("CL ILR Benchmarking Course Detail") that will generate a list of the CL courses in TERMS along with the GLH details and enrolment counts. As with the benchmarking data save the report output as a Word document, then copy and paste the table into the relevant spreadsheet.
NB: Whichever Course Detail report you use check to see if your list goes past row 609 of the course detail spreadsheet as if it does you will need to modify the Sum() functions in cells B8 and B9 to take account of the extra rows otherwise the figures will be wrong.
Getting the reports
Please get in touch with the helpdesk if you would like copies of the updated SSRS reports and the modified 1718 Benchmarking Template spreadsheet.