Assessment Grids can be used to create a colour coded grid to cross reference and highlight how students assessment data compares and where students grades differ across different subjects or assessment points and how grades collected compare against targets.
- For example, in this guide we’ll create a grid to compare English current grades for Year 11 students in the Autumn and Spring data collection points (Terms) to show progress in a grid format
- You can also add visual indicators to the grid to further compare the data for example green arrow up to show comparison of data to target, this is done in Data Sources Individual
- The examples in this guide are taken from a Secondary training database.
Access: The minimum permissions required to access Assessment is found in the Assessment Module of Config>Setup>Roles & Permissions.
Go to Modules>Assessment>Manage Templates.
Then from Assessment Templates drop down choose Assessment Grids
Then click New
In the Assessment Grid panel give the Grid a Name and define Column and Row Heading formats, choose Cell Type, Header Position and Row Order.
Active will be ticked by default.
Click Edit in the Data Sources panel to Define Data Element for the Columns and Rows and Specify the Grades to Include.
Tip: Add the most recent data collection to the Column.
Choose the Assessment Type, Term, Year Group and Subject, remember to Specify the Grades to include
Save.
Data Source > Individual
Use Individual to define the Target and use the Specify Comparison details panel to define where a grade collected in the Columns and Rows differs from a Target.
For example this will show where a Student received a Grade 4 in Autumn , a Grade 5 in Spring, this show the Students Current GCSE grade has improved across the two data collections however, if there Target is a 6 then they are still below Target.
Control and click cells in the Comparison Matrix to then Apply colours to grid (use Border Colour and/or Fill Colour)
In the example below have clicked Control and Click to select the cells on the diagonal
Then clicked the Yellow colour in Fill Colour and Apply.
Then click on the Matrix Key with the Yellow colour and Edit
In this example the Description has been defined as Same
Below is an example of a completed Comparison Matrix
The last step is to define the Assessment Grid Allocation, click Add to chose the Group Name.
In the example below we have chosen 2 English Classes.
You do have the option to Copy the Assessment Grid and then modify the chosen Assessment Data, for example, for different Subjects or Assessment Points
Once the Assessment Grid is complete click Save & Close
Go Modules>Assessment>Assessment Sheets List .
Filter to see Assessment Grids.Double click on your Assessment Grid
Click on the top left Settings cog. You can then configure the Columns, Header and Row Order, chose a Group to further filter the Students in the Assessment Grid.
Tip on Columns choose List or Count. Column List is the default. Click on student names to access student profile
Click on the numbers in the Grid to see Student Names.
In the example below we can see James Bromley was given a Grade 3 in Autumn then a Grade in Spring so is showing Green in the Grid as his grade has improved however, the red exclamation mark shows us he is still below Target.
Click on the top left green excel icon to export to xls. or click Print if required.
