Skip to main content
All CollectionsFor Data ManagersBromcom
How to import your Pupil Progress data into Bromcom
How to import your Pupil Progress data into Bromcom

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

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

How can I import my Pupil Progress data into Bromcom?

It's easy to download a copy of the data in Pupil Progress so that you can upload it into your Bromcom MIS.

  1. 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. (Pictured in the GIF below)

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. (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

What's next?

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

  • Now that you have a download of your assessment data, head to Bromcom and from the left hand side select Modules -> Assessment -> Assessment Sheets List.

  • Once you open the assessment sheet that you're looking to update, click the Export button towards the top of the page - this should then download another Excel spreadsheet where you can paste in your grades from Pupil Progress (or use a =Match/Lookup function if you're an Excel whiz!). (Pictured below)

  • Once you have made the changes to the Bromcom assessment sheet, save the file and then click Import (immediately to the left of the export button from earlier) to upload this.

  • You'll then just need to save this on Bromcom and your grade data has been imported!


Pupil Progress Tip

If you require any further support with this, please take a look at the following article from Bromcom's help centre: Bromcom | How to Import Assessment Data Using a Marksheet

Did this answer your question?