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

• Stage Assessments i.e. KS2 Results
• Exam Results i.e. GCSE Results

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

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

Adding for example a Formula Column- Review-Exam Result – English this will mean that the Column will appear on all Assessment Sheets for all subjects. If you want to show a different Exam Result column for each Subject then you could follow the process below;

1. Create an Assessment Type called for example ‘GCSE Result’
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
4. Import your Exam Results in a csv format see How to Import Assessment Data

See an example csv below;

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

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

Exam Results in a Student Broadsheet

Use this process to create an assessment 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.