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

This article provides a guide on how you can get the grades produced for your students in Pupil Progress into your Arbor 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 Arbor 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

Once you've got the file, you'll need to head over to Arbor to download a copy of their import spreadsheet.

To do this, go to Students -> Assessments -> Summative Tracking -> Mark Entry -> Import from the left hand menu, however we'd recommend taking a look on Arbor's own help centre for the full info on how to download the file that fits your needs.

You're able to find a link to the page here -> Arbor | Using the assessment import spreadsheet. This will then download a similar looking Excel file where you can paste in your Pupil Progress data (or use a =Match/Lookup function if you're an Excel whiz!).

add_in_the_assessment_marks.png

Once the data has been filled in, you can upload the Arbor spreadsheet by clicking the green Upload Import Spreadsheet button from the page you were on before, directly below the button used to download it in the first place.

For any further info on this, please take a look at the following Arbor help centre article:

Did this answer your question?