Provision mapping - provision analysis
Once you have set up some provisions, assigned pupils, and evaluated their effectiveness, you can then build a table to summarise that data, which can be grouped in various ways. This tool works in a very similar way to a pivot table in Excel.
To access the provision analysis tool, first click on the Provisions button in the toolbar and then click on the link in the main provisions area:
This will take you to the provisions analysis tool, which allows you to build a simple summary report report:
The tool works by selecting the pupils in scope, then selecting what data you want to summarise and how you want it organised.
Start by selecting the pupils in the Select pupils and provisions area. Here, we are going to select all year groups to ensure all pupils are in scope. Click on the year group dropdown, click multiple selection, and select all year groups. If required you can also widen or narrow the search dates and apply a filter to restrict your report to a specific period and/or types of provision. In this case, we will leave the default settings which includes all provisions within the last year.
Now we can start building a table. Note the Calculations area below the Select pupils and provisions section. By default, number of pupils is checked, rows are set to be grouped by Provision, and columns by Calculation. The latter means the number of pupils associated with each provision will be calculated in the table:
We can now explore options by selecting more types of data to calculate. Selecting Total cost and Effectiveness will add more summary columns to the table. We now have the total cost per provision and the percentage of pupils for whom the provision is proving effective:
Now we can move some of the options by dragging and dropping. Let's try swapping the grouping options for the rows and columns around:
The table now has a separate column per provision type and calculations are presented in rows.
Finally, switch off number of pupils and effectiveness options and opt to group year group and then by pupil name. Remove the calculation grouping option by dragging it off to the right. This produces a table as follows:
The table now shows the pupils in receipt of each provision, grouped by year group, with costs for each.
We hope this help guide has been useful. Please get in touch with any feedback or if you have any questions.