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.
Overview
There are two ways to fill the template spreadsheet this year: from study data or from the latest R12, R13, or R14 Single ILR file (i.e. from the Single ILR tab in the Funding Menu) - this option is for customers with sub-contractors/partners who submit a merged ILR to the ESFA.
For Hosted customers the template spreadsheet is available to download from the SSRS CL Benchmarking folder where the reports are located.
For Hosted customers the 17/18 Club SSRS reports have been moved to the 2017-18 Club folder.
CL Benchmarking Data Report (updated from 17/18)
This report will generate the numbers required to paste into the TERMS DATA sheet of the "1819 Benchmark Template V2 (WMS).xlsx" spreadsheet. The report design has been updated from last year.
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 also shows the number of sub-contracted and direct delivery enrolments (split by the partner UKPRN field and SSA Tier 1).
CL ILR Benchmarking Data
This report will generate the numbers required to paste into the TERMS DATA sheet of the "1819 Benchmark Template V2 (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 1819 Benchmarking Template (WMS).xlsx spreadsheet
Once you have the SSRS reports installed (The reports are updated by WMS for Hosted customers):
- 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 for non-Hosted customers
Please get in touch with the helpdesk if you would like copies of the updated SSRS reports and the modified 1819 Benchmarking Template spreadsheet.
Global hosted customers with SSRS
The SSRS reports have been updated and the spreadsheet template is available to download from the SSRS CL Benchmarking folder.