Interrogating data with pivot tables

A tutorial about analysing data extracted from Progress

Explore using Frog for CPD... Professional Development Platform

PivotTables - Using the example

PivotTables can be used within MS Excel to manipulate data to show any kind of report schools wish to see. The first report we will look at creating is something similar to the student tracker wtihin Frog Progress that could be printed or adapted for use outside of the platform.

These instructions will take you through building a report with an example pivot table which can be downloaded here. To make your own table from scratch, please see the "PivotTables - Creating your own" tab above.



Run the Learning Objective Export Report from your FrogProgress platform making sure to only export latest judgements).

Open the downloaded report in Excel.



Delete the dummy data from cells A-Q on the LO Export tab of the example tracker report which can be downloaded above.

Note: Make sure to keep the headers and row R which contains a formula to create a student's full name from the report.



Replace the dummy data with a copy of your own data. 



Click onto the Tracker Report tab and refresh the data in the PivotTable. This can be done either by using the Analyze tab at the top of the screen or by right clicking somewhere in the table and choosing Refresh.


You should then be able to see a pivot table showing your own data:



Depending on the data in use, it is possible that some of the filters may need to be changed. The most likely filters that could need to be changed are the Term, Event Type or Subject filters. These filters can be added and removed using the PivotTable Fields options. 

Getting started series...

Product HUBS

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



Discover how Frog can be used for...