Post Death Information Audit
Guidance
Post Death Information (PDI) Audit and Tool
The Post Death Information Audit has been designed so that data on the deaths of residents can be collected and analysed as the care homes undergo the Six Steps to Success Programme. This audit should assist in preparing feedback for the care home and in developing reports to evaluate the implementation of the Six Steps to Success programme.
There are four audit tools which will support collation and analysis of the data and these are available on the Six Steps webpage under the Audits section.
1PDI Pre-programme Audit
This paper audit tool will allow you to gather information on thedeaths of care home residents that occurred in the six months before the care home started the programme. This will form a baseline against which the deaths of residents occurring after the care home has joined the programme can be compared. The audit is simple to complete and consists of a series of questions which should be answered by writing in the free spaces or by ticking the boxes when available. This paper audit can be printed for care home staff to complete by hand as they look back over their resident’s notes. Once complete the data of up to 30 residents collected in this audit can be transferred into the electronic PDI Tool.
2PDI Post-Programme Audit
This paper audit is identical to the PDI Pre-programme Audit PDI and should be used by the home after they have completed the programme to support them in continuing to monitor the deaths of residents.
3PDI Ongoing Audit
This paper audit is identical to the PDI Pre-programme Audit and should be used during the programme (Step 1- Step 6) to record the deaths of residents which occur once the care home has joined the programme. Once complete the data of up to 30 residents collected in this audit can be transferred into the electronic PDI Tool
4Electronic PDI Tool
This spread sheet will allow you to store the datacollected from the PDI Pre-Programme and PDI Ongoingaudits and will automatically prepare feedback for the care home which can be used to evaluate the implementation of the Six Steps to Success programme. Instructions on the use of this tool can be found in this document.
Electronic PDI Tool
This tool will allow you to enter the data you have collected from the care home on thePDI Pre-Programme and PDI Ongoing Audits. The tool will then automatically convert the data into some simple graphs which will show the development that the care home representative has made throughout the programme.
The tool has four main sections Front page, PDI Pre-Programme, PDI Ongoing and Results which can be accessed by clicking on the tabs at the bottom left of the screen:
Front Page
This sheet contains general information and instruction on the use of the tool.
PDI Pre-Programme
This sheet allows you to enter the data collected from up to 30 deaths recorded in the PDIPre-Programme audit. If the care home representative feels confident doing so they can directly enter this information into this tool which will save the entry of the data from the paper version.
Instructions on using this section of the tool can be found in the next section.
PDI Ongoing
This sheet is identical to the PDI Pre-programme section and allows you to enter the data collected from up to 30 deaths recorded in the PDIOngoing Audit.
Results
Once the data has been entered for the PDI Pre-Programme and PDI Ongoing auditsections this part of the tool will automatically update to produce a series of graphs; summarising the data in a way that can be used to feedback to the care home representative or used in reports. This feedback looks at the key areas that care homes should be focusing on in improving the deaths of their residents.
Instructions for completion
1To enter the data collected in the PDI-Pre Programme audit begin by entering the name of the care home into the box in the PDI Pre-Programme section of the tool.
2Now enter the data collected around the death of Resident 1. This is done by working through each box that lies under Resident 1 and entering the data that was collected in the paper version of the audit. All the questions are in the same order as they appear in the paper version.
When entering data for questions which have tick boxes on the paper version click on the corresponding box in the audit tool and a drop down arrow will appear. Click this arrow and a drop down box will appear containing the options (as shown in the picture below).
When entering data for questions which have free written answers in the paper version just click on the corresponding box and type the answers. For some questions, such as Date of Death, the data should be entered in the format specified. If the data is entered incorrectly then a message will appear giving you guidance on how to enter the data in the correct format.
3Now complete step 2 for up to 30 residents.
4Oncethe PDI Pre-Programme audit has been completed data should now be entered in the same way as step 2 in the PDI Ongoing section of the tool otherwise the file should be saved for completion at a later date.
Handy tip
It would be advisable to create aPDI Auditfolder in ‘Your Documents’ where you can save all the care home’s spreadsheets. This will allow you to storethe Pre-Programme data collected at the start of the programme and then revisit after the Conclusion Workshop to update the tool with the data collected in the PDI Ongoing audit.
5Once the PDI Pre-Programme and PDI Ongoingsections are completed the tool will collate this data and present the findings simple graphs in theResults section. This can be used to feedback to the care home. The tool produces this feedback automatically and as long as the PDI Pre-Programme and PDI Ongoing sectionshavebeen completed correctly results should look like this:
Handy tip
To transfer the graphs into a separate document or presentation left click on your mouse at the top left corner of the graph you wish to transfer. The graph should now be highlighted. Right click on your mouse and a drop down box will appear. Select ‘Copy’. Open the document or presentation you wish to put the graph into and put your cursor where you wish the graph to appear. Right click on the mouse the drop down box will appear select ‘paste’. The graph should now be displayed in your document or presentation.
1