Data Managers can use this guide to add the following to an Assessment Sheet;

• Stage Assessments i.e. KS2 Results
• Exam Results in a Student Broadsheet
• Exam Results in a Subject Assessment Sheets

Access: The minimum permissions required to access Assessment is found in the Assessment Module of Config>Setup>Roles & Permissions.

For creating Tracking Templates see How to Create an Assessment Sheet

Stage Assessments

Go to Modules>Assessment>Manage Template

Select the required Tracking Template and Click Edit

In the Columns panel in the Tracking Template Click Add

Then from the Column Type drop down select Add Formula Columns

Then choose Review as Column Type, give the Column a Name

From the Formula drop down select Stage Assessment

Then choose the required drop down fields from the Stage, Subject and Stage Assessment

In the example below KS2, Mathematics Outcome and KS2-MAT-MAM-TT-NE has been chosen.

Click Add

Exam Results in a Student Broadsheet

Use this process to create an Exam Result student broadsheet, one row per child with a column for each Exam Result to show ALL EXAM RESULTS for Year 11 Students.

Go to Modules>Assessment>Manage Template

Select the required Tracking Template and Click Edit

In the Columns panel in the Tracking Template Click Add

Then from the Column Type drop down select Add Formula Columns

Then choose Review as Column Type, give the Column a Name

From the Formula* drop down choose Exam Result, then choose a single Subject from the Subject drop down and then in Result to select either choose Highest, Lowest, Recent or Oldest.

Repeat this process for all subjects.

This process is in effect adding the Exam Results into the Bromcom Assessment Module.

You will need to map Exam Option Subjects and run the Analysis Data Transfer, see How to use Exam Option Subjects – Bromcom

Exam Results in a Subject Assessment Sheet

If you are using a Tracking Template that is being distributed to all classes with associated year groups and subjects, so for example it’s being used for all subjects you deliver and you want the Year 11 GCSE results to show in your Year 12 Subject Assessment Sheets as a column.

Note: If you add a Formula Column-Review-Exam Result-English to a Tracking Template this will mean that the column will appear on all Assessment Sheets for all subjects so everyone Teacher will be able to see the English Result.

If you want to show a different Exam Result column for each Subject in each Assessment Sheet then you could follow the process below.

1. Create an Assessment Type called for example ‘GCSE Result’ – do not create one called Exam Result as this already exists by default in Bromcom
2. Create a Term called for example ‘Exam Result’
3. Create a csv of your Exam Results with the column header in format Assessment Type$Term$Year Group$Subject. You can create this broadsheet in Exam Results in a Student Broadsheet in this guide
4. Import your Exam Results into Assessment in a csv format see How to Import Assessment Data

See an example csv below;

Then you can then add this Assessment Type to your Tracking Template to show a different Exam Result Column for each subject in each Assessment Sheet.