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.

Tip: Instead of fixing the columns to specific terms, you can select 'Term Parameter' from the Term dropdown. This will allow you to select the desired term for your table each time you open it.
Tip: You can change the 'main assessment' to a standardised assessment if you'd prefer your table to be based on test scores rather than teacher assessment. Get in touch if you want to discuss setting thresholds for your test scores.
Tip: Click on the 'Comparison' dropdown in the sidebar to change the type of data. The default is set to 'At or above ARE' but you might be interested in percentages that are above or below.

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'

Don't forget to save your report!

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.

Note: you don't have to build a new report next term or when pupils change. Tables will always up date with the latest data.
Tip: You can add more columns to your report anytime by opening it and clicking the 'Edit' button.

And finally...

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.


How did we do?


Powered by HelpDocs (opens in a new tab)