This guide contains a list of suggested data areas to consider standardising for use with Bromcom’s Vision product.
As you can see, there is no standardisation required to use certain dashboards in Vision. Some data items (e.g. Enrolment, Exclusions) are already standardised.
It is also helpful for Trusts to wait until they have their own Vision system live, linked to their schools, so they can see any data discrepancies in the live data.
| Vision Data Area | Suggested Minimum Standardisation | Suggested Maximum Standardisation | Description |
| Student Enrolment | No standardisation required | User Defined Fields (UDF) | Standard DfE coding used in Vision Dashboard but standardised UDF will increase analysis potential in PowerBI and future Student Dashboard enhancements |
| Student Attendance | No standardisation required | Custom attendance marks | Standard DfE coding used but be aware that custom attendance marks will affect analysis by Attendance Mark in PowerBI |
| Student Exclusions | No standardisation required | No standardisation required | Standard DfE coding used in Vision Dashboard and PowerBI |
| Student Safeguarding | Action Categories Incident Categories Incident Status | Action Categories Incident Categories Incident Status Agencies Areas | To be able to fully utilise the suite of analysis tools in Vision Safeguarding Dashboard it is recommended to standardise the “Incident Category”/”Status” and the “Action Category”. Other fields of Safeguarding data that may be compared in PowerBI, if standardised, are “Agencies” and “Areas” |
| Student Behaviour | Event Types | Event Types Events Outcomes Action Types Actions | The Vision Behaviour Dashboard will be able to analyse negative and positive events without any standardisation but to be able to compare behaviour across the trust it is suggested that “Event Types” are standardised. This allows Events to be grouped by an overarching categorisation (e.g. Severity Level) |
| Student Assessment | Assessment Type Subject Name Year Group Name Term Name | Assessment Type Subject Name Year Group Name Term Name | Assessments in MIS and Vision are identified by a combination of “Assessment Type”, “Subject Name”, “Year Group Name” and “Term Name”. To compare like-for-like Assessments across the trust these Assessment elements must be standardised |
| Staff | No standardisation required | No standardisation required | Standard DfE coding used in Vision Dashboard and PowerBI |
| Staff Absence | No standardisation required | Staff Absence Codes | Analysis of DfE categorisation and duration can be done without any standardisation. To analyse the nature/reasons for absence then “Staff Absence Codes” can be standardised |
| Exam Performance | No standardisation required | No standardisation required | The new KS4 Performance Dashboard in MIS requires no standardisation to be aggregated at the Trust level |