Back to Tutorials

Pivotal Progress

A tutorial about interrogating data from Progress

Have you subscribed to TheFrogBlog? Find out more

Who, what and where?

PivotTables can be used to show school administrators which teachers have created trackers, for which subjects and where evidence has been uploaded. 




To create a PivotTable which displays the information shown above follow the steps on the PivotTable - Creating your own tab to download your LO Export report. We don't recommend that you run an export for all your data in one go, but split it down to seperate assessment periods or subject areas. This will allow the report to run faster and will make the data easier to manipulate.

When you have your LO Export data in your spreadsheet, you will need to configure your PivotTable settings as follows. Alternatively, you can use this template. Simply paste your LO Export data into the first sheet and our table will do the hard work.


The fields you will need to select to add to your report are:




Assessor Surname

You will need to lay these fields out as follows:

Columns: Assessor Surname

Rows: Year and Subject

Values: Count of LO/KPI Name


















In our template we have added a "slicer". This allows you to switch between Evidence and Status Update depening on what information you wish to see. 



If you wish to filter your data by Assessment Cycle or Period to allow you to see this information in more detail, we would recommend using another slicer.


To add a slicer, single click on your PivotTable and choose Analyze from the top menu in Excel.

  • Click Insert Slicer
  • Choose the two fields you wish to use - in this case Academic Year and Term.
  • Click OK
  • The slicer will now be present and you can use the different slicer fields to review your data by Academic Year and/or Term.

Tutorials in this series...

product hubs

FrogProgress-600_600.png  FrogLearn 600_600.png  FrogPlay 600_600.png

Product updates

A sneak peek at the new Frog App and updates to the Frog interface.
Save time with pre-populated site templates
FrogLearn now has over 30 mobile themes
How we can work with Multi-Academy Trusts
Progress Hub - All about our student progress tracker
All about our student progress tracker
All about our online assessment system
Helpful information that relates to GDPR functionality inside the Frog platform
Get access and use all our in-platform Site templates
Save time with pre-populated site templates