Workshop 2 preparation
Collect and check data about critical systems
Invite organisations that have failed to provide full and accurate data.
Understand the analytic spreadsheet and start loading it with satisfactory response data.
3 minutes
Analytic spreadsheet walkthrough
5 minutes
Add data to the analytic spreadsheet
Data quality in your NCRA is essential,
this document provides guidance on how to assess the quality of data
Guidance for assessing
data quality
New VBA NCRA Analytic spreadsheet
Old NCRA Analytic spreadsheet
These are the old and new versions of the analytic spreadsheet for the NCRA.
Note the new version uses VBA and aligns to the VBA version of the NCRA questionnaire
NCRA Analytic spreadsheet
NCRA Analytic spreadsheet
This spreadsheet helps you track
your returned responses
Response returns progress checker
6 minutes
The national level analytics
4 minutes
The sector level analytics part 1
4 minutes
The sector level analytics part 2
4 minutes
The sector level analytics part 3
6 minutes
The organisational analytics
This download contains an interactive test to help ensure you get great data quality
Zipped interactive test download
Training: Demo analytic spreadsheet
Training - NCRA analysis.
Demo data in a version of the analytic spreadsheet.
Have a look and see how the graphs and charts work, and use the data checker to help identify where data could be improved.
Training - NCRA responses.
The 3 examples show responses that can be classed as 'good', 'OK', and 'needs improvement'.
See if you can identity which worksheet relates to which response. And consider what you would do next to ensure you have great data quality.
Training:
3 system examples
