How do I import my Pupil Progress data into Arbor?
Follow these simple steps to download a copy of the data in Pupil Progress, so that you can upload it into your Arbor MIS.
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. (Pictured in the GIF below)
3. 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.
4. 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.
5. 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.
6. 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!). (Pictured below)
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.
📖 Pupil Progress Tip
For any further info on this, please take a look at the following Arbor help centre article: Arbor | Can we import data in bulk from a spreadsheet?