If you are viewing this website through The National Archives it may be necessary to copy and paste external links directly into your browser.

Improving Services Toolkit: children with long-term conditions: Help

Back to Improving Services Toolkit: children with long-term conditions

What information does the tool present?

  • Emergency hospital admissions for children aged under 19 years with long-term conditions.

  • Bed days and average lengths of stay following admission to hospital.

It allows clinical commissioning groups (CCGs) to compare these measures for the patients registered at their practices with a range of different comparators. Results are colour-coded to show where an area is significantly better, worse or the same as the England average.

It is designed to highlight variations at CCG level and allow benchmarking to inform the commissioning decision-making process for children's services.

The tool will help you to identify opportunities for reducing emergency hospital admissions for children in your local area.

How do I use the tool?

When you open the spreadsheet tool you will be provided with some information about the tool. Clicking ‘Start’ takes you to a page where you can select your CCG, and also decide which measure you are interested in viewing.

Further options lead to more detailed information and analysis. These include:

  • View charts showing how the selected CCG currently performs against all CCGs in England, and specifically against your chosen comparator
  • View charts showing the historical trends of the selected CCG, and of a chosen comparator

The options for comparator are:

  • England average
  • Area team
  • Region
  • The 25% best performing CCGs
  • The 5% best performing CCGs
  • The four most similar CCGs (more information about how these have been calculated can be found in the tool itself)

'Print report' on the CCG selection page will open a pdf containing all the charts and information for the selected CCG. You can print or save this pdf document.

What might I do next with what I learn from using the tool?

Step 1 - Discuss locally
Data forms only one part of the jigsaw. It is important to 'sense check' the findings with colleagues against your own local knowledge. Is the picture the tool gives the one you expect? If not, what might be the reasons? You will have extensive knowledge of the way in which services are provided which will have affected how well you are doing.

Step 2 - Carry out more detailed local analysis.
This may point to other reasons for your results.

  • Use the Data Atlas to find out more information about your local area such as:
    • Number of live births
    • Overall birth rate
    • Ethnicity
    • Number of teenage pregnancies
    • Levels of deprivation
    • Smoking
    • Young people with long-term conditions

  • Use the Data Atlas to carry out comparative analysis. See the guidance for suggestions about the kind of analysis you might like to carry out.

  • Checking for errors in the data, submitted for central collection, which have been used to populate this tool. In the case of DMIT you may find it particularly important to look at how hospitals are coding admissions for children with these conditions.

Step 3 - Collate other evidence to inform your service improvement plan.
The Child and Maternal Health Intelligence Network has a detailed Knowledge Hub which provides easy access to a range of information, evidence, knowledge and expertise relating to all aspects of children's, young people's and maternal health.

Step 4 - Work with the local specialist in your area to develop an action plan.
Contact the local specialist working in your area who is available to work with you to help you gain a full understanding of the potential implications of the tool for your organisation.

Help with macros

When the file is opened in Excel it may have the macros disabled, a security warning will be displayed at the top of the screen click 'Options' and select 'Enable this content' to use the tool.

If you are still experiencing problems with the Excel files, your security settings may be too high. To reset your macro security, follow the instructions here:

Note to Apple Mac users

Note for Apple Mac users: The Excel spreadsheet will not work in Office 2008 for Apple Mac. This is because the macros feature has been removed from this version of the software.

Support and training

If you need further help or advice in using the tool or interpreting the information it provides, contact the local specialist working in your area.

Our local specialists work with you to develop your organisation's capacity to use information and evidence effectively to improve outcomes for people using maternity and children's services in your community.


If you need additional support or would like to give feedback on using the Disease Management Information Toolkit, please use the contact form.

Validates against XHTML 1.0  Cascading Style Sheet compliance  Single A Accessibility compliance