Exporting summative assessment marks for analysis outside of Arbor

You can download marks for summative assessments in Arbor using our export pages. Just go to Students > Assessments > Summative Tracking > Export and select one of the menu options on the left-hand side.

Export Raw summative marks or targets and baselines

Go to Export > Raw summative assessment marks or Raw summative baselines and targets to quickly download or live feed your assessment data into PowerBI or Google Looker Studio.

You can filter down your data by year group, assessment or assessment period.

Screenshot_2022-12-21_at_12.27.34.png

 

Exporting to Power BI

If exporting to Power BI, be sure to tick that authentication is required and to output as JSON. 

Screenshot_2023-03-27_at_17.00.35.png

Screenshot_2021-08-06_at_10.22.29.png

Screenshot_2021-08-06_at_10.22.45.png

 

In power BI, click Get data > Blank query

Screenshot_2021-08-06_at_10.25.05.png

 

Paste the query into the bar at the top, then right-click List and select To Table.

paste_into_bar_at_top.png

Screenshot_2021-08-06_at_10.32.21.png

 

Click the grey button that has appeared on the heading, and select OK.

Screenshot_2021-08-05_at_14.57.59.png

Screenshot_2021-08-05_at_14.58.35.png  

 

 

Export all marks

If you want to export all your marks, you can use our Export Student Marks pages.

  • Use the All Student Marks page if you are in a small school such as a primary.
  • Use the Bulk Export Student Marks page if you are a large school such as a secondary. We recommend this option for schools with large data tables to avoid having to wait a long time for the data to load.

The All Student Marks table

You can use this page to see student marks across multiple assessments and export them in other formats using the Download button.

In the filters, add the data range you'd like to export data for, select the students to include and add your assessments.

Screenshot_2023-03-27_at_17.01.16.png

 

You can then see the marks recorded for each student.

Screenshot_2022-06-21_at_15.29.01.png   

The Bulk Export Student Marks download

You can use this page to export the same information into a downloadable Excel file without needing to wait for the table to load first.

Just add the data range you'd like to export data for, select the students to include and your assessments.

Screenshot_2021-08-06_at_10.18.41.png

 

Once you click the Export button, you'll receive a message that the export is generating.

export_notification.png

 

Refresh your page and you'll get a notification pop up in the top right of your page. Click the notification to download the excel file to your computer.

export_ready.png

 

You can then open the file.

open_excel_file.png

open_exported_marks.png

 
Was this article helpful?
0 out of 2 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.