It also explains how to view and interpret the Reports pages. These will be updated with the latest findings from the second phase as well as show findings from the first phase (April to July 2020).
This is a data collection and reporting tool to support child health services during the COVID-19 pandemic. We asked representatives, such as the paediatric clinical lead, to respond on behalf of their Trust or Health Board on a weekly basis.
Registering and accessing the data capture system
Members from our mailing list (mostly clinical leads) received a link to access the data capture system. Clicking on it will direct you to the log in screen.
If you are a clinical lead and have not yet received an invite to submit data, contact us on email@example.com.
Phase 2 of data collection - winter 2020-21
We have moved into the second phase of data collection for the impact of COVID-19 on child health services over winter 2020-21. The first phase was conducted over April to July 2020 and you can read the full report of the findings and our letter to the editor of Archives of Disease in Childhood.
Entering data in new questionnaires
As you log on to the platform, click on click here to submit data (see below):
Next, go to Organisation to select the Trust or Health Board you belong to/are entering data for.
You will then see a summary of your previous entries from phase 1, as well as the phase 2 one-off snapshot questionnaire and winter weekly alert system.
Please note if you already submitted data in the first phase, you will not need to go through this process again.
Please complete the one-off snapshot questionnaire first.
To enter data, click on Answer now. You will go to the questionnaire. Complete this and then select Submit at bottom of page.
Viewing the findings
On the main page of the data capturing and reporting tool, at the bottom, you will be able to click on Reports page.
If you have access, you will be redirected to the page below. There you can view submissions for phase 1 (Initial organisation information, each weekly data collection) and for the phase 2 one-off snapshot questionnaire, as well as all weeks, showing trends, and maps.
If you click on Graphs, you will see a page withoverall answers to each question, as shown in the picture.
Maps will display the same results but in map form, showing which areas of the country gave what responses.
Finally, you will be able to obtain “raw” data in a spreadsheet format by clicking on Download CSV
You will also have the option to view graphs as summarised by date and NHS region, as shown in the picture below. This is only available for phase 1 at the moment.
The Date and Region drop-down menus will allow you to triangulate results by week of data collections and different areas of the UK.
Finally, If you click on submitter map (see figure below) you will see which organisations in the UK are registered to submit data.
Interpreting the results
The Reports page will display slightly different graphs depending on what users choose to view.
It follows the same structure as the questionnaire and is organised as specified below:
- Phase 1
- Services - the number of organisations responding whether they are or are not currently providing different areas of paediatric service is shown in graphs.
- Staffing and capacity – for all weeks’ data, we show the mean, median and interquartile range (quarter 1 and quarter 3) on a graph. The mean is the average calculated by adding up all responses and then dividing by the number of responses. The median is the middle value when all responses are ranked numerically. The interquartile range is a variance statistic, quarter 1 (Q1) is the middle value of the first half of the rank-ordered set, and Q3 is the middle value of the second half of the rank ordered set. For each week's data we display histograms representing the distribution of responses by number of trusts.
- Activity - the percentage of respondents saying that activity has increased, decreased or not changed is shown for each week's data.
- Phase 2
- Staffing and capacity - we show the mean, median and interquartile range similarly to phse 1, with more detailed questions about staffing and grades as well as outpatient services based on feedback gathered from phase 1 of data collection.
- Staff workload and wellbeing - displays whether staff were assessed for risk, the proportion of vulnerable, extremely vulnerable staff, and at risk staff; availability of PPE, COVID-19 tests, and perceptions of stress and burnount concerns.
- Activity and patients - displays concerns about virtual consultations, the proportion of inpatient brds occupied by children and young people admitted for mental health needs, whether children are being seen in the Emergency Deparment and whether they are being taken into consideration fo future planning.
"View only" access
If you did not submit data during the collection period but would like to view the findings on the reporting tool, you can still request access by following the instructions below.
First, register for an account. You will get an email with a link to activate your account.
Once your account is active, you can go to the reporting tool home page. At the bottom, you will see a Request to view button as shown below.
This will direct you to the screen as shown below. Enter your RCPCH number or a justification to view and click Submit. Once we approve your request, you will be able to access the Reports page.