Admin or SLT - Get to the summative marksheet and add or import assessment marks

Accessing the marksheet

For any assessment

To access and manage all assessments go to Students > Assessments > Annual Policy > Manage Assessments.

Using the ‘+’ icon next to the assessment name, you can expand the assessment and see the type of assessment created i.e. Curriculum.



Click on the subject you wish to mark or look at in more detail, then click the green 'Marksheet' button to reach the marksheet.


For the current data drop

Go to Students > Assessments > Summative Tracking. Here you can see all of your summative assessments. Use the filters to look at only certain student groups.

Top Tip: Using the Students in... filter will filter based on the student group the assessment has been linked to, rather than all students. So, for example, if the assessment has been linked to a course, you'll need to select the course rather than the year group.



Here you can also see the Mark Input Status page which lists the assessments and whether marking has not been started as yet, has been started or has been completed.



To access the Marksheet, you can click the assessment on the Summative Tracking page, then click the Marksheet button in the slide over.



For a specific assessment

Go to Students > Assessments > Summative Tracking > Mark entry > Marksheet from the left-hand menu and use the filters at the top of the page to select the assessment.

The filters also let you select the Date Range, Cohort(s), Assessments and Grade Sets you wish to input marks for.

Please note: If you are wanting to enter marks for a different term you will need to select a date from within that term.



Assessments linked to a certain course

Go to School > Programmes > Courses to select the class - you may need to click +



Then go to Assessment > Full Marksheet from the left-hand menu.




Adding marks into the marksheet

From the marksheet

Entering Marks Individually

Once you have accessed the correct marksheet, you can begin to enter marks into the grid.

  • Click into a field to open the drop-down menu of values to select from, or start typing.
  • Auto-complete suggests the shortest match (e.g. type “A” and “A” will be suggested first rather than “A+” or “A-”.
  • Hit your Enter key to save the value and move onto the cell below. Then hit Enter again to start typing into the new field.


Bulk entering and copying marks

You may have multiple students in your class all with the same mark. To save time you can bulk enter the marks.

Just tick the students you want to enter the same mark for by ticking the box on the left-hand side of their name. Click on the pencil icon to select one of the options.



Bulk Edit MarksIn the slide over, choose the grade/mark that applies to the selected students and then click on the green Save Changes button.



Bulk Copy Marks - Copy assessment marks between past, present and future assessment periods. Both the source and target assessment periods must be visible in order to select them, so remember to change the dates in the filters! You can see which marks will be copied over - any marks highlighted in red will be overridden, and grey will not be changed.




Multiple Column Edit Marks (only available from a course Full Marksheet) - update the marks for the same assessment period for multiple assessments at once.



Adding comments

The marking grid also contains a Comment column where you can add any additional comments to support the mark the student has been given. (These comments can then be fed directly to the Report Card module when needed.)

To add a comment click on the comment cell and a pop-up window will appear for you to type your comment into.




Please note that to enable you to add predicted marks, you'll need to make sure the date range in the filters only covers one assessment period.


Using the import spreadsheet

You can use our import spreadsheet to import baselines, marks and targets in bulk for your students. Download and complete the import spreadsheet for the assessment(s), then upload it into Arbor. The spreadsheets are available for the assessments you have already created within Arbor.

Please note: This process will override any existing marks already input into your Assessment. Any fields left blank in your spreadsheet will not override any marks in Arbor, allowing you to add marks for the current data drop without editing your baselines or targets.

What you can and can't import

You can use this feature to import:

  • Academic year baseline
  • Academic Year Teacher Target
  • Final target for the assessment
  • Marks for any data drop in the current academic year
  • Period teacher targets (if selected)
  • Comments (if selected)

You will not be able to import:

  • Predicted mark baseline, predicted final mark and predicted marks
  • Suggested marks (as this is automatically calculated based on curriculum assessment marks)
  • Attainment or progress target (this is set automatically by setting up target rules)
  • Aspirational target
Importing summative assessment marks

Go to Students > Assessments > Summative Tracking > Mark Entry > Import from the left-hand menu. Click the green Download Import Spreadsheet button to select the single or bulk option.



Fill in the slide over with the assessment information then click Download import spreadsheet.

You can choose to import teacher targets. This allows you to quickly and easily set the same or different teacher targets per assessment period instead of Arbor calculating the target from the baseline and end of year target.



Once you have downloaded the spreadsheet, fill in period marks for each student as appropriate.

Please note that this spreadsheet is custom made for the import you are doing and that you cannot change the academic year, students or assessment in this sheet. You must use the correct grade set and only valid grade values. If you want to import for a different academic year, assessment or set ofstudents, you must create a new import spreadsheet.

Please note: Please do not change the student names or IDs, and do not rearrange any column or change column letters or row numbers. If you do, we cannot guarantee that the right marks will be imported for the right students.



Once you have filled in the sheet, you can import it on the same page by clicking the grey Upload Import Spreadsheet button.



You can choose your file to upload, then click Upload.



On the next page, you can see the information about the import. Double-check the information you are about to import.

Scroll down to the bottom of the page and click Delete import if any data is incorrect, or click Import data to import the assessment marks.


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



Please sign in to leave a comment.