All Collections
For Data Managers
How to import your Pupil Progress data into SIMS
How to import your Pupil Progress data into SIMS

This article provides a guide on how you can get the grades produced for your students in Pupil Progress into your SIMS MIS.

Tobi Davis avatar
Written by Tobi Davis
Updated over a week ago

It's easy to download a copy of the data in Pupil Progress so that you can upload it into your SIMS MIS. First, on Pupil Progress, click Analysis from the top bar and choose which year group you are looking to download the data for. Then, select Grade Summary from the options on the pop-up box before clicking Continue.

Apr-14-2023 10-51-51

This will show you the Average Unit Grade for all of the students in this year group across all subject areas - 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, such as a unique identifier like Admission Number or UPN.

Once your grade source and columns are configured to what's best for you, toggle Tools at the top and then select Download as XLS. 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, head to SIMS and head to Routines -> Data In -> Assessment -> Import from Spreadsheet. Then click Browse, where you can find the file that you have downloaded from Pupil Progress.

You should then see an Import from Spreadsheet screen pop up, where you can map the appropriate fields to each column. Once you've done this as many times as necessary, click Next, where you'll be able to match the students on your Pupil Progress download with your SIMS MIS based on a unique identifier. You're then able to click Finish to import the data.

If you require any further support with this, please take a look at the following article from SIMS's help centre:

Did this answer your question?