Spreadsheet: 1d2d1e3e-f143-452d-b899-c77abf6b1c55
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | Audit tool: moderate & severe asthma in adults 2009
 | Introduction
 | This data collection tool records the results of treatment of adults with moderate or severe asthma presenting in Emergency Departments (EDs).
 | A previous audit completed by Emergency Departments in 2007 has assisted EDs in changing their policies and procedures in order to improve care.
 | Comparative data will be made available to participating [NAME]. The purpose of the audit is:
 | - to identify current perfomance in Emergency Departments against CEM clinical effectiveness standards and show the results in comparison with other departments
 | - to monitor progress nationally and enable individual hospitals to compare their current and previous audit results (If the audit in 2007 was returned)
 | - to audit observations and interventions made prior to arrival in the ED and the interface between ambulance and the ED.
 | The audit method is similar to that of the earlier audits. Results of the audit will be published as part of the Care Quality Commission's work on clinical quality. Individual trusts will not be scored as part of the CQC Periodic Review.
 | Clinical Standards
 | The audit criteria are based on the clinical standards for moderate or severe asthma in adults produced by the College of Emergency Medicine (CEM) Clinical Effectiveness Committee. These are available to view on the CEM Standards sheet.
 | Methodology
 | Step 1: Audit Criteria
i | The audit is of adults aged 17 years or over who presented at your ED by ambulance with moderate or severe asthma.
ii | Please exclude patients presenting with life threatening symptoms, or mild cases of asthma with peak flow on arrival greater than or equal to 75% of the expected value, or children aged 16 years or under.
iii | Please select 50 consecutive cases that presented to your department as ambulance arrivals between 1st August 2009 and 31st January 2010. You may need to look at hard copy notes (and not just scanned copies) to check whether ambulance notes are present.
 | Step 2: Data Entry
i | Save this workbook on your own computer or network using an appropriate file name before entering any data.
ii | Enter data for each patient in the next free column of the Data Entry sheet. You must enter the date and time of arrival and pick a response from each of the drop down lists for every patient. Some of the drop-down lists may show a default response of N/A depending on the answers to previous questions. If you go to the Example Data Entry sheet, you will see some typical entries.
iii | Please see the Example Data Entry and FAQs sheets below for guidance on completing the Data Entry sheet. The results will be summarised automatically on the Summarised Data sheet.
iv | The 'patient reference' field should contain an identifiable alphanumeric that you create which can be related to each set of notes, but not related to patient identifiable information (name, patient no., DOB etc.)
v | Please use the drop-down lists of options wherever these are provided. Do not enter abbreviated text - answers must appear in full or the summary formulae will not work.
vi | Do not guess any data that is missing from your records - pick the "not recorded" option from the drop-down lists, or leave times and dates blank as directed.
vii | The timings to be entered into the Data Entry sheet should be obtained from the patients' notes. All times are in 24hr clock format. You must enter a colon between the hours and minutes e.g. 13:45
viii | If the patient arrives on one day e.g. 23:50hrs and is then treated after midnight, enter treatment time as e.g. 00:10. The time interval will be calculated without needing to enter a new date. See Example Data Entry sheet.
ix | If you want to clear all of the data that you have entered (e.g. after entering trial data or to reaudit) use the <Delete all data entered> button at the top of the data entry sheet, [NOT the Excel <Edit Clear> or DELETE/BACKSPACE keys as these would also delete the formulae that produce the default N/A entries].
x | The <Go To Next Blank Record> button can be use to find the next unused column on the data entry sheet.
 | Step 3: Submitting Results
i | The summary data should be e-mailed to the College. Instructions are on the Summarised Data sheet.
ii | Please e-mail the results as soon as 50 cases have been completed or after the audit period ends on 31 January 2010 if there are less than 50 cases. Data must be submitted by 5th February 2010. If possible the results should be checked locally before they are submitted.
iii | Please do not e-mail the complete workbook/file - see the instructions in the Summarised Data sheet.
iv | The CEM Clinical Effectiveness Committee and the Care Quality Commission will become joint custodians of these data.
 | Support
 | Should you have any queries please e-mail your message to [EMAIL] or telephone 020 7067 1269 who will answer general queries and forward clinical queries to Dr [NAME] and technical ones to the Care Quality Commission.
 | Note that the sheets have been protected so that you cannot change any cells apart from those where data can be entered.