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 example marksheet below shows a summative assessment with strands, assessed on a half-termly basis, including the KS1: Reading standardised assessment results. The view is for entering marks for the 4th assessment period (Spring 2) and includes the student's age, year target, final target and aspirational target.

marksheet.gif

The filters

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

Screenshot_2021-03-23_at_10.32.30.png

 

You can choose a moment in 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.

Screenshot_2021-03-23_at_10.32.56.png

Screenshot_2021-03-23_at_10.33.19.png

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.

Screenshot_2021-03-23_at_10.33.59.png

 

The bulk actions available to use from the mark sheet (if you have all the necessary permissions) are:

  • Bulk Edit Marks
  • 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 age in years (see the How to edit the columns shown in marksheets section above).

Screen_Shot_2018-11-13_at_08.51.17.png

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.

historical_data.png

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 always on the right-hand side

Screenshot_2021-03-23_at_10.37.22.png

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.

Screenshot_2021-03-23_at_10.38.56.png

 

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

strands.png

 

 

How to edit the columns shown in marksheets

You can choose to show or hide different columns in your marksheets by going to Students > Assessment > Assessment Framework > Marksheet settings

  • You can choose to display whether or not the student is part of a demographic such as Disadvantaged or choose to not show baselines in summative marksheets.
  • You can add any User-defined field to display, or show year to date attendance.
  • You can also lock baselines and targets, but please note when they are locked they are locked for all staff on all marksheets.

marksheet_settings.png

 

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

Screenshot_2021-03-23_at_11.19.14.png

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 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 or 7, the thresholds are as shown below:

default_settings_for_judgements.png

 

Here you can see Arbor's default colour coding. For example, if a student is working at their target, Arbor will colour the cell light green and if they are working slightly below their target 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.

default_marksheet_colours.png

 

 

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.

target_judgements.png

 

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.

change_the_colour.png

 

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

example_custom_colours.png  

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.

target_judgements.png

 

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

add_new_judgement.png

 

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

new_amazing_judgement.png

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.

Screenshot_2021-03-23_at_11.24.31.png

 

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

Top Tip: Press your cmd + A keys to select all your assessments. You can then click any assessments to deselect them.

bulk_update_assessment_rules.png

 

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

add_biology_rule.png

 

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.

points_or_grades.png

 

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

biology_judgements.png

 

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.

Screenshot_2021-03-22_at_12.39.43.png

Screenshot_2021-03-22_at_12.42.29.png

Baseline

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.

Screen_Shot_2019-02-26_at_15.57.38.png

Predicted mark baseline

This is the first prediction ever made about a student's attainment at the end of an assessment. It is usually set at the beginning of an assessment by staff.

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

Screen_Shot_2019-02-27_at_12.17.20.png

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.

Screen_Shot_2019-02-27_at_12.14.56.png

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.

Screen_Shot_2019-02-27_at_12.15.58.png

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.

Screen_Shot_2019-02-27_at_12.12.14.png

It can be edited from the Baselines & Targets and Marksheet pages.

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.

Screen_Shot_2019-02-27_at_12.13.46.png

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.

Screen_Shot_2019-02-27_at_12.18.00.png

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.

Screen_Shot_2019-02-27_at_12.18.26.png

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.

Screen_Shot_2019-02-27_at_12.19.49.png

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.

Screen_Shot_2019-02-27_at_12.20.18.png

 

 

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.

default_target_names.png

 

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.

change_the_name.png

changed_in_marksheet.png

Where can I view the renamed targets?

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

Target

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?

Our Summative Assessment Baselines & Targets and Marksheet pages always show the ‘Year Target’ by default.

Screen_Shot_2019-02-26_at_15.35.16.png

 

You can 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)

baselines_and_targets_display.png

 

In Students > Assessments > Summative Tracking > Mark Entry > Marksheet 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)

marksheet_targets_shown.png

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

Comments

4 comments
  • 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?

    0
  • Hi Mark, this sounds like a more complex query that we'd need to look into further with you! Please get in touch at myteam@arbor-education.com so we can get this sorted!

    0
  • Thanks Gwyn - although this was posted two weeks ago....in 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.

    0
  • 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 myteam@arbor-education.com 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.

    0

Please sign in to leave a comment.