
Last 10 Patients Data collection tool
This tool uses patient information to identify variation in journey times. It helps you understand what is happening in the patient pathway and how this can vary from patient to patient. Mapping the last 10 patients is also useful for comparison with locally agreed care pathways, timescales or key stages in a patient’s journey. It complements both conventional process mapping and value stream mapping
Mapping the last 10 patients can help those trying to understand patient flow within their pathway and identify their longest waits. By looking at a few pathways in detail you are likely to see some improvement ideas that will be applicable to many other patients. For more information see the NHS England how to guide: https://improvement.nhs.uk/resources/mapping-last-10-patients/
Use this tool when you want to explore the journey that patients are going on through the pathway. It may expose differences in practice or workload, which can cause unhelpful variation, unnecessary delays and compromise safe care
Start by deciding your start and end points, then the intermediate points along the way. Most literature suggests around 10, but you will have to work to your own situation. Enter your data in the Data Capture sheet where indicated. Use the charts to explore your findings:
The patient pathways chart shows you all the pathways at a glance.
From here you may be able to see a clear bottle neck by the prominence of once colour.
The Distribution of Waits shows a box and whisker chart for each of the touch points in your pathway. Half of patient waits fall inside the box and half outside, with the line showing the median of waits.
The distribution can show you if there is a lot of variation in that particular step. The ideal step in a pathway will have little variation and be shorter.
Long ""whiskers"" show there are outliers, which could be one anomaly. It is worth checking if these are unusual cases.
Template and example of Last 10 Patients Data collection tool