Introducing the Tables report
The Tables report is a true workhorse. It may not have the visuals of other reports in Insight but it is extremely powerful. If you've ever had to run numerous reports, looking for various figures, which you then compile in your own table template or spreadsheet, then Tables is going to save you a lot of pain and effort. Tables allows you to pull all of your data - demographics, attendance, attainment and progress - into one place. Build it once and it will refresh with new data each time you run the report. It's a brilliant feature.
And now it's had a facelift. Tables has a new, more intuitive interface with sticky column headers and horizontal labels. You can read a summary of the changes here. Other help guides on inserting assessment comparison and progress columns, which will add an extra dimension to your tables, are also available.
In this help guide we're going to find out about the key changes and build a basic report.
1) Accessing Tables
Click on Tables in the Cohorts menu to get started:
2) Selecting and grouping pupils
When you first open Tables, you will be presented with a list of names in column 1. This will be the cohort you were looking at last time you ran a report. You can easily change the pupils by using the filters and groups at the top of the screen.
3) Adding Pupil Info Columns
Pupil Info Columns, as the name suggests, adds demographic data to the Table. Click the Add Column button and select Pupil Info Column from the list:
Select an aspect from the list and click the new Add Column button. Then click Add Another Column and repeat. In the following example, columns showing Gender and Disadvantage have been inserted into the table, and Term of Birth is about to be added.
4) Adding Assessment Columns
Now let's add some data! Click on the Add Column button again and this time select Assessment Column. First, let's add pupils' phonics scores by selecting the criteria shown in the screenshot below.
Then we can add a recent standardised test score in reading. Click Add Another Column, as shown below.
In this example, a column of Rising Stars test scores have been added, but you can add whatever data you like.
5) Removing pupil names
If you wanted to show the table to governors, for example, you will need to temporarily remove pupil names. This is easily done by clicking on the Settings button. At this point you'll be prompted to give your table a name.
To remove pupil names, click the 'Show summary rows, but hide pupil rows' option as shown below.
This will produce a table as follows:
To make this even more interesting and comprehensive, switch the pupil grouping option from Pupil Premium to Key Groups.
This changes the table grouping from Pupil Premium/Not Pupil Premium, to your list of Key Groups, as follows:
6) Loading reports
Once you have built and saved your table, you can find it again by returning to Tables via the Cohort menu and clicking the Open button (see below):
Under this menu you'll also find preset table templates provided by Insight, as well as any provided by a Trust you're part of.
7) Downloading your Table
We hope this introduction to the new look Tables report has been useful. In the next two help guides (coming soon) we'll cover the Assessment Comparison and Progress Columns. If you need any help with this or any other feature of Insight, please do get in touch.