What is shown in a marksheet and how to add additional columns

What is a Marksheet?

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.


Marksheet settings

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.



The different sections of a 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.

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.




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.



What can I do in each section?

1. 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.

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

2. 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.

3. 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.

4. Academic year information

Left-hand side: Screen_Shot_2018-11-13_at_08.51.55.png

Right-hand side:Screen_Shot_2018-11-13_at_08.52.33.png 

The academic year section can appear on the left or right side of the marksheet depending on the type of information being displayed. For instance, baselines will always be displayed on the left-hand side as a point of reference and targets are always on the right-hand side.

5. Completed assessment periods


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.

Dark green means the student is exceeding their target, light green means they are working at their target and orange means they are working below target.

6. Current assessment periods


The current assessment period depends on the date that the user has chosen in the filters. For instance, if you set the date in the filters to April 17th, the current assessment period will be ‘Spring 2’, as shown above.

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

The default date of the marksheet is today’s date.


Why not join in the conversation in the Arbor Community?

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



Please sign in to leave a comment.