Skip to main content
All CollectionsFor Data Managers4Matrix
How to import your Pupil Progress data into 4Matrix
How to import your Pupil Progress data into 4Matrix

A step-by-step guide on how you can get the grades produced for your students in Pupil Progress into 4Matrix.

Tobi Davis avatar
Written by Tobi Davis
Updated over 3 months ago

How can I import my Pupil Progress data into 4Matrix?

It's easy to download a copy of the data in Pupil Progress so that you can upload it into 4Matrix for further analysis.

  1. First, on Pupil Progress, click Analysis from the top bar and choose for which year group you are looking to download the data.

  2. Select Grade Summary from the options on the pop-up box before clicking Continue.

  3. This will show you the Average Unit Grade for all of the students in this year group across all subject areas

Apr-14-2023 10-51-51

Something to note:

  • You can change what grade is being pulled from the 'Source' dropdown along the top bar.

  • You're also able to click 'Configure Columns' above the students' names on the left hand side if you'd like to add any additional fields.

  • Gender and UPN must be included in order for you to copy this data into 4Matrix.


What Next?

  • Once your grade source and columns are configured, toggle Tools at the top and then select Download as XLS. (Pictured in the GIF below)

  • This will download all of the Grade Summary's raw data as an Excel file, which can then be easily copy and pasted elsewhere as needed.

  • You're able to repeat this process as many times as is necessary across multiple year groups.

Apr-14-2023 10-56-54

image-png-Apr-14-2023-10-03-07-8100-AM

Now that you have a download of your assessment data;

  1. Head to 4Matrix and select the Admin tab.

  2. Then, go to Spreadsheet -> Pupils / Results.

  3. This will open the Identify Data box, where you can select the academic year and year group before creating a new series and adjusting any other options.

  4. When on the Select Data tab, switch back to your Pupil Progress download and copy the data.

  5. You can then click Paste to import this in to 4Matrix.

  6. Then, all you need to do is match up the columns and subjects, and click Finish when you're done.


πŸ“– Pupil Progress Tip

For more info, please take a look at 4Matrix's guide on importing data -> 4Matrix | Guide: SPREADSHEET Import

Did this answer your question?