Creating a ranked student list
If you've been with Arbor a while you might remember the old forecast grades page. We are unhiding this page to allow you to generate lists of students you've entered into each exam series, which you can then export to excel to create your ranking. We've detailed the full process below.
Step 1 - Enter the grades in Arbor
If you've got the right permissions, you'll be able to go to Students > Examinations > Results > Forecast Grades to enter grades.
Click into the filters to select an exam series and a year group if needed, then click Apply Filters.
Every exam will then populate in the table along with the candidates entered, their candidate numbers, UCIs, ULNs, year group and date of birth.
Teachers can then enter grades for their students for the subject they teach. Please note: Teachers will be able to see grades entered for their students for other subjects as well.
If you are not the teacher of a student, or if the student has not been entered for a particular subject, you won't be able to put a grade into that field. Only the highlighted fields can have grades put into them.
Step 2 - Export and separate your data
Once all of the grades have been input to all the subjects in a series, you can export them out of Arbor. Just click the download button to download the table to Excel or as a Live Feed.
Now you have a list of students and their Centre Assessment grades, which you can share with other team members to help decide on a ranking. In this example, I've uploaded my excel file to Google sheets to allow me to share it.
Step 3 - Add a ranking
In your spreadsheet, you can delete any unneeded columns (such as any UMS columns). You can also separate each subject into its own sheet if you want to. Just duplicate your tab, then delete any unwanted columns so you have one subject in each tab.
You can then remove the rows for any students who are not taking this subject if you wish.
You can then click and drag each row up or down to move your students into a ranking, and add a ranking column.
Step 4 - Send your rankings off to the awarding organisations
Once you've finalised your rankings, you can send them to the awarding organisation. The process for this is likely to be different for each awarding organisation, so please contact them for further information.
Keeping a record
Please note that we will be removing the Forcast Grades page once it is no longer required for Covid-19 purposes. This means that if you would like to keep a record in Arbor of the forecast grade please retain the spreadsheets you have created.
If you would like to be able to compare students predicted results with the ones issued by the awarding organisation, when results are released you will be able to go to the Examinations > results > By Subject page to see and download student's grades for each subject, for comparison.