Using Tables to report to Governors
Often, senior leaders resort to manually summarising data in Word or Excel, filling out a table with numbers drawn from various sources in order to report to Governors and others. Sometimes this may even involve calculating percentages on a calculator. If this situation rings a bell, then Insight Tables is the tool you need.
Tables allow you to store all your data in one place by simply dropping columns in place. Contextual information, attendance, prior attainment, teacher assessments, test scores - a table can hold it all and present it at pupil level (very useful for a class teacher wanting an ongoing record of achievement for each pupil), as well as group and cohort level (very useful for governors).
It's the latter that we'll concentrate on here.
This help guide shows you how to set up a Table report. In this guide we'll assume you know the basics and launch straight into building our report for governors. Here, we are going to focus on one type of column specifically:
- A.R.E (Age Related Expectations) column
The aim of this guide is to build a table that shows:
- Percentages of pupils that are working at expectations or above over time
First let's open a new table by clicking on the cohorts menu and selecting 'Tables':
This brings up a blank table with a list of pupils in whichever year group you have been investigating most recently, in this case Year 5:
Adding an ARE Column to a Table
As shown in our other help guide (see link above) you can add columns of pupil characteristics information or assessment data, but here we are going to go straight to adding a ARE column.
Click 'Edit Table' (see screenshot above) and 'ARE Column' from the menu, as shown.
Now we need to select the data for our ARE Column i.e. the data that will be used to define pupils' age related expectations. You could select a single subject for the latest term (e.g. Reading, Summer 2019/20) but here we have opted to use KS1 results: Year 2, Summer SAT TA.
Also note that more than one subject has been selected but clicking the 'add another subject' link indicated. This column will therefore show if pupils met expectations in all three subjects (reading, writing and maths) at KS1.
Then click 'Add Column To Table'. We now have a column of 'Yes' and 'No' values, which indicate whether or not pupils met expectations in all subjects at KS1.
Adding more columns
Now click 'Add Another' and repeat the process, adding in a column for last summer, again to indicate whether or not pupils are meeting expectations in combined subjects. The Year is changed to 'Last Year' and the assessment is changed to 'main assessment'.
Then click add another and add columns in for each term of the current year. Change the year to 'Current Academic Year' and change the term to Autumn, then Spring, then Summer (i.e. we are adding three more columns to our table). The result should look like this: a table showing the the percentage of current Year 5 pupils meeting expectations at KS1, at the end of last year, and across the current year, in reading, writing and maths combined.
This table in its current form is not suitable for governors. The trick is to remove the pupil names and summarise the data. To do this, first click 'Finished'
Then click the 'Display only summary rows e.g. averages' button. This will remove pupil names and reduce the table to a single row of percentages for our selected year group.
And finally, lets break this data down into groups for a more detailed view. Click on the 'Group Pupils' button and select 'Key Groups'
Once created, this table can be applied to other year groups by simply changing the year group from the dropdown menu at the top. Alternatively, you could select more than one year group, and then group by year group plus another grouping option. Here, for example, the table shows ARE percentages by year group and term of birth for years 3-6.
Click the 'Print' button to print your table or save it as a PDF file. Alternatively, click the download button to export it to Excel and copy it into a Word document.