In this guide we’ll look at how to add Exam Results Columns for Tracking Templates.
Important Information
- It is the schools responsibility to ensure that Exam Results are not shared with any Students, Parents, or Staff Members who should not have access prior to the Embargo being lifted.
Exam Result Columns in Marksheets are hidden by default to;
- Protect Exam Results that are still under Embargo from being viewed by Staff Members who should not have access to Embargoed Results
- Prevent them from being shared accidentally with Students/Parents via the Assessment module of Student Portal or MCAS before the Embargo is lifted.
Other MIS Areas to Check in order to see Exam Results in Marksheets
- Ensure the Exams Season is not embargoed.
For the following three processes see Setting up and using the KS4 Dashboard
- Ensure that the Exam Option are mapped to the Subjects
- Ensure that Analysis Subject Mapping is complete for that Academic Year
- Ensure that the Analysis Data Transfer has been completed.
Permissions
Access: The minimum permissions required to access Manage Templates can be found in the Assessment Module from within Config > Setup > Roles and Permissions. The options discussed in the Configurations section of this guide can only be accessed by those with the Administrator Role.

Related Articles
- How to Add Formula Columns to a Marksheet
- How to Setup Assessment Configurations for MyChildAtSchool
- How to Create an Assessment Sheet
Adding an Exam Results Column to an Existing Marksheet
Navigate to Modules > Assessment > Manage Templates.

In the Assessment Templates drop down, ensure Tracking Templates is selected, then select the Marksheet you would like to add the Exam Results Column to using the tick box to the left and click Edit.

in the Columns section click Add.

In the pop-up that appears, select Add Formula Columns from the Column Type dropdown.

This will open more fields, in Column Type select Review, then use the Column Name field to give the Column a name that allows you to easily identify what the information in the column relates to.
Select Exam Result in the Formula drop down, then in the Subject dropdown, select which Subject you would like to see the Exam Results. Finally select whether you would like to see the Highest, Lowest, most Recent or Oldest result using the radio buttons below.
Once you’re happy click Add.

Once you’ve added all required columns, click Save & Close at the top of the page.
