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.

Try selecting another year group using the Year Group filter. Also try grouping it via the Group Pupils button. The following table shows Year 3 pupils grouped by Pupil Premium eligibility.
Note the summary row showing number of pupils in each group and percentage. These rows will summarise any assessment data you choose to add, including test scores.

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.

*New Features* Note the sticky columns with horizontal labels.

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.

Add as many columns as you like to build up a complete assessment record over time. This can include results from statutory assessments, as well as scores from optional tests and, of course, teacher assessments in any subject.
Note the summary row shows average scores for the Pupil Premium group. All groups will have a summary row showing their respective averages.

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.

Don't forget to click the green Save button once you have named your table.

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):

The table is not restricted to the year group you initially built it for. You can change the year group, filters and grouping options anytime and it will not affect the structure of the table. That means you can use it for any other year group. You can also opt to show pupil names or not, as required.

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

To download the table to Excel, simply click the Download button.

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.

How did we do?

Powered by HelpDocs (opens in a new tab)