Follow the steps in this article to download a copy of the data in Pupil Progress for uploading into your Arbor MIS.
In Pupil Progress, click Analysis from the top bar and choose which year group you're looking to download the data for.
Select Grades Summary from the options before clicking Continue.
This will show you the Average Unit Grade for all students in the year group across all subject areas - you can change what grade is being pulled using the Grade Type dropdown on the left-hand side.
Open Student Attributes from the left menu to add any additional fields, such as a unique identifier like Admission Number or UPN.
Once your grade source and columns are configured, open Tools from the left menu and 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.
Repeat this process as many times as is necessary across multiple year groups.
What's next?
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. 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. 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!).
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.
📖 Team Tip
Take a look at the following Arbor help article for further insight: