How summative marksheets work - customise or add more columns and colours

In this article, we'll show you around the different areas of the marksheet and show you how you can customise the columns and colours shown.

A marksheet is a tool that is used to enter and record marks, comments and evidence for summative or ad-hoc assessments. The user can also add certain student demographic information such as a students age as well as various targets, to use as a reference on the sheet. You can find out more about how to use marksheet to enter and record marks here.


How the marksheet works

What are the different sections of the marksheet?

All the marksheet sections shown can be found by using the bar below the marksheet to scroll. Each section is explained in more detail below.

The filters

Click into the filter bar at the top of the page to edit your marksheet.



You can choose a date range time to view the marksheet from, the group of students and the assessment by clicking the filters at the top of the page. Click the tick boxes to display additional information such as the student's final target, and a column for adding notes.



Bulk actions

Bulk actions allow for faster mark entry and a number of other actions such as creating an intervention group or contacting the guardians of a student.



There are also additional bulk actions available to use from the Summative Tracking Marksheet (if you have all the necessary permissions):

  • Create new intervention
  • Add to existing intervention group
  • Add to custom group
  • Send Email to Students
  • Send SMS to Students
  • Send Letter to students
  • Send Email to Primary Guardians
  • Send SMS to Primary Guardians
  • Send Letter to Primary Guardians
  • Send In-app message to Primary Guardians
  • Bulk Set Suggested Marks
  • Set/Unset Approved
  • Set Marking Staff 
Student name and demographic information

This section shows which students they are entering or viewing marks for. You can also include additional columns for reference information, such as the student's attendance (see the How to edit the columns shown in marksheets section).

Historical data

Historical data is only visible on marksheets where you are able to and have chosen to include baseline assessments such as a KS1: Reading standardised assessment. In some cases, a student that is part of your current assessment might not have a mark recorded for the standardised assessment that you have included. In this case, the mark will be greyed out as shown above.


Academic year information

The academic year section can appear on the left or right side of the marksheet depending on the type of information being displayed:

  • Baselines will always be displayed on the left-hand side as a point of reference
  • Targets are to the right


Assessment periods

The assessment periods shown depends on the date that the user has chosen in the filters. The default date of the marksheet is today’s date.

  • Dark green means the student is exceeding their target
  • Light green means they are working at their target
  • Orange means they are working below target

For summative assessments without strands, the Completed Assessment Periods section will display the mark entered for the relevant assessment period.

For summative assessments with strands, the Assessment Period average mark will be displayed in this column for the relevant assessment period.



If you have chosen to show the Display grade set in the filters, you can see the mark in the Display gradeset as well as the current mark.



If your assessment has strands, the grade for each strand will be displayed, as well as the weighted average.




How to edit the columns shown in marksheets


How the marksheet is colour coded - editing Target Judgement Rules

How do Target Judgement Rules work?

Target Judgement rules determine how mark sheets are colour coded, depending on how your students are doing in their assessments relative to their targets, giving you a clear visual indication of students that might benefit from an intervention. You can set up as many Target Judgements as you need, and can change the names of your Target Judgements to align with the language you use at your school.

For the marksheets to be colour-coded, you will need to have input a mark for the assessment period, and the Year Target, shown here: Adding and locking Targets


What are the default settings for Target Judgements?

Judgement rules are initially set to be the same across all assessments. By default, Arbor automatically calculates whether the student is working Significantly Below, Slightly Below, At or Above their current target.

Significantly Below is between the lowest value on the scale and the midpoint of the lowest value and the target. Slightly Below is between the midpoint of the lowest value and the target. 

They will cause the mark sheets to display four colours - orange, yellow, light green or dark green.

For example, if your assessment uses the new GCSE grade set and a student has a current target of 7, the thresholds are as shown below:



Here you can see Arbor's default colour coding. For example, if a student is working at their target (7), Arbor will colour the cell light green and if they are working slightly below their target (grades 4, 5 or 6) Arbor will colour the cell yellow.

The more target judgements you have set up, the more colour steps you will see between orange and green.




Editing the default Target Judgement Rules or adding more

Editing the colours in marksheets or renaming your target judgements

Go to Students > Assessments > Assessment Framework > Targets > Target Judgement Rules > Target Judgements. Select the target judgement to edit the name or change the colour it will colour-code the marksheet with.



For example, you might want to amend them to be called Emerging, Developing, Secure.

Changing the colour will override the colours for all the Judgements in Marksheets and Report Cards. To use your own colours other than the default, be sure to select a colour for every judgement.



Here's an example of how the colour coding can look if you've chosen your own colours.


Adding more Target Judgements

Go to Students > Assessments > Assessment Framework > Targets > Target Judgement Rules > Target Judgements. You can add new target judgments by clicking +Add.



In the slide over, choose the name and where to place the judgement. Then click Add judgement.



Your list will then be updated and you can use this new judgement with all of your assessments.


Changing how Target Judgements Rules work for each assessment

You can adjust the thresholds for each target judgement by going to Students > Assessments > Assessment Framework > Targets > Target Judgement Rules > Assessment Rules.

To see what target judgements have been set up for each assessment, select the assessment from the Assessment drop-down menu. You can add target judgement rules for any assessment that has been added to your Assessment framework. This means you only have to define these rules once for an assessment. They will apply to every academic year that the assessment has been added to the Annual Policy for.



You can use the Bulk Update button to apply the same settings to all your assessments. 

Top Tip: Press your Ctrl+A (Windows) or Cmd+A (Mac) keys to select all your assessments. You can then click any assessments to deselect them.



To set rules for an individual assessment, click the assessment, then on the next page click +Add.



In the slide over, you can adjust the thresholds for your judgements and select between points or grades. You can choose whole numbers or up to 2 decimal places to allow for finer rules. Click Save changes.



This will then be reflected in the mark sheets and on report cards.



How the target columns work

What are the targets and why do you use each one?

Arbor uses several types of targets in our Summative Assessments. Understanding the different types are key when setting up your assessments for the academic year from the Baselines & Targets page, and for data entry and analysis from the Marksheet page.

Here you can see the two pages for the same assessment. We explain what the different columns mean below.




This is a student's starting point for any assessment.

If the student was enrolled in the assessment during the last academic year, their final mark last year will appear as the Baseline this year.

It can be edited in bulk from the Baselines & Targets page. It can be viewed from the Marksheet page.


Predicted mark baseline

The predicted mark baseline is carried over from the last predicted mark the previous academic year. So if a student is given a predicted mark of 4 in the summer term, their predicted mark baseline for next year will be 4.

This is not editable, but it can be viewed from the Marksheet page.


If no Predicted Marks are entered for subsequent assessment periods, the Predicted Mark Baseline will be used as the Predicted Final Mark. 

Teacher targets

Each Teacher Target shows the mark a student should get at each assessment period, based on their Baseline and Year Target. This target is useful for tracking progress against teacher expectations to identify who needs more support.


When you first set up your Assessment and have added a Baseline and a Year Target, the Teacher Targets are automatically filled with targets showing progression. For example, if you have three termly periods, the Baseline is 3 and the Year Target is 6, the teacher targets will be 4, 5 and 6. The final Teacher Target will be the same as the Academic Year Teacher Target.

It can be edited from the Baselines & Targets page. It is not displayed on the Marksheet page. Teacher Targets contribute to the judgement of whether students are working Above, At or Below on the Marksheet.

Academic Year Teacher Target 

When you first set up your Assessment and have added a Baseline and a Year Target, the Academic Year Teacher Target will be the same as the Year Target. You can then edit this if necessary based on the Teacher’s observation and prediction - this could be the same as the Year Target, higher or lower based on the individual student. The adjusted Academic Year Teacher target will then become the Year Target.

It can be edited from the Baselines & Targets page. It is not displayed on the Marksheet page.


Predicted mark

This is input every assessment period and can be used to track changes in what the teacher thinks the student will achieve at the end of the assessment over time.


It can be edited from the Baselines & Targets and Marksheet pages - to be able to do so, make sure the date range in the filters only covers one assessment period. If the date range overlaps with more than one assessment period, you won't be able to edit the predicted mark.

It is used to set the Final Predicted Mark.

Predicted final mark

This represents the final grade that the teacher thinks the student will actually achieve.

It is non-editable. It can be viewed from the Baselines & Targets and Marksheet pages.


Predicted Final Mark is derived from other targets in a hierarchy.  The system prioritises targets in this order:

  1. Most recent assessment period's Predicted Mark
  2. If no Predicted Marks exist, Predicted Mark Baseline

This means if a student has no Predicted Mark entered for spring, but has 7 entered for Autumn, the Teacher target, the Predicted Final Mark is 7. 

Suggested mark

If the assessment you have chosen is linked to a Curriculum, Arbor can suggest a mark for each student based on their curriculum results.

It is non-editable. It can be viewed from the Marksheet page only.

School target rules - Attainment Target and Progress Target

If you don't want to set Academic Year Teacher Targets for each student, you can set targets for all students in bulk.

  • Progress Target - Set a target based on how much progress students should make from their baseline. For example, students should make 1 grade level of progress compared to the baseline at the start of the year.
  • Attainment Target - Set a target all students in a particular group should reach, no matter their baseline. For example, all students should reach at least a grade 4 by the end of the year.

These are set at a school level by going to Students > Assessments > Assessment policy > School Target Rules. For instructions on how to do this, read our article here.

They can be viewed from the Baselines & Targets page.

They can contribute to the Year Target on the Marksheet and Baselines & Targets pages.


Year target

This is what the student is expected to achieve at the end of the academic year, for example, what level a student is expected to achieve at the end of year 10. For students in their final year of the assessment, the Final target and the Year target will be the same.

It is non-editable. It can be viewed from the Marksheet and Baselines & Targets pages.


The ‘year target’ is derived from other targets in a hierarchy.  The system prioritises targets in this order:

  1. Academic Year Teacher Target - Individual target, manually set
  2. Progress Target - Calculated from the baseline and desired progress points
  3. Attainment Target - A set target for all students based on ARE (Age-Related Expectations)

This means if a student has no Academic Year Teacher target, the Progress target will be used, etc.

Aspirational target

This is a stretch target for what the student could achieve at the end of the academic year if the student does extremely well or excels that year in their studies. It is usually higher than the other targets.

It is editable from the Baselines & Targets page. It can be viewed from the Marksheet page.


Final target

This is what the student is expected to achieve at the end of the course, based on analysis of prior attainment. It is usually set at the beginning of an assessment. For students in their final year of the assessment, the Final target and the Year target will be the same. For example: 

  • For secondaries, the overall grade a student is expected to achieve in their GCSE.
  • For primaries, the grade a student is expected to achieve in their end of Key Stage assessments.

It is editable from the Baselines & Targets page. It can be viewed from the Marksheet page.




Renaming and viewing the target columns

How do I rename the target columns?

You can change the names for your summative assessment targets from Students > Assessments > Assessment Framework > Targets. Here you can see all the target names.



To add an alias of a target and rename the column in the marksheet, just click a target. Choose the alias in the slide over, then click Save changes.

To remove the alias, just click the target again and remove all the text in the Alias field.



Where can I view the renamed targets?

You'll be able to view the renamed columns on these pages:


Baselines & Targets

Summative Marksheet

Full Marksheet

Year  ✓  ✓  ✓ (add using the filters)
Teacher  ✓  ✗  
Period  ✗    ✓ (add using the filters)
School progress  ✓  ✗  
School attainment  ✓  ✗  
Final  ✓ (add using the filters)  ✓ (add using the filters)  ✓ (add using the filters)
Aspirational  ✓ (add using the filters)  ✓ (add using the filters)  ✓ (add using the filters)


Can I choose which targets to display in marksheets?

By default, our Summative Assessment Baselines & Targets and Marksheet pages show the ‘Year Target’.



Top Tip:

By default, you can also view most targets from Students > Assessments > Summative Tracking > Mark Entry > Baselines and Targets. You can select not to display each assessment period teacher target by un-ticking the box in the filter.

  • Teacher Target
  • Academic Year Teacher Target
  • Attainment Target
  • Progress Target
  • Year Target
  • Aspirational Target (add this by ticking the box in the filter)
  • Final Target (add this by ticking the box in the filter)

On marksheets, you can view these targets.

  • Year Target
  • Aspirational Target (add this by ticking the box in the filter)
  • Final Target (add this by ticking the box in the filter)
Was this article helpful?
0 out of 0 found this helpful
I'm still stuck!


  • why can I not see any A level Flightpath targets in the assessments and teacher marksheets, even though I have a) manually entered them and b) also done a bulk upload.

    The ones I can see are because I have gone into Targets and Baslines and have manually overridden the target per student per flightpath (for a class of 3 A level students - this is 6 columns of targets, so 18 changes in total for 1 A level class in Year 12).

    Why do the flightpath targets not appear when I upload the targets? The Year Targets appear but nothing else does?

  • Hi Mark, this sounds like a more complex query that we'd need to look into further with you! Please get in touch at so we can get this sorted!

  • Thanks Gwyn - although this was posted two weeks that time the error has been something to do with uploading targets into the Year or Teacher target which creates derived flightpaths - I have sorted this out but the literature above needs to be clearer about the pitfalls of what targets need to be entered on the download sheets as its not that clear and if you have not had any training and just doing it blind - you are going to make lots of frustrating mistakes.

  • Hi Mark, thanks for your feedback on this article!
    I'd love to work with you to improve the guidance here, so please get in touch at to put forward your suggestions about how we can make this resource more useful for schools.
    If your query is urgent, we'd always recommend webchatting, phoning or emailing us as you'll get a faster response that way.

  • hi Gwyn,

    when looking at a marksheet for a whole department, how can i view the class code/ class teacher. i want to quickly be able to identify from an entire department marksheet as to what student is in what class and what teacher has not completed a marksheet. this was easy in sims and seems impossible to do quickly in arbor.

  • Hi Jamie, this is possible using Data Collection Policies! Using Data Collection Policies you can see the marksheets each teacher has to fill in, see how much they've completed and send them an email reminder.


Article is closed for comments.