Methodology for the Development of a Data Collection Tool
Author(s)
Gonzalez Durio J1, Hex N2
1Becton Dickinson, San Agustín del Guadalix, M, Spain, 2York Health Economics Consortium, York, UK
Presentation Documents
OBJECTIVES: While carrying out time motion studies, a need was identified to reduce the burden of data collection during the preparation of IV treatments in aseptic units across UK hospitals. The objective was to build a tool to harmonise the process of data collection, allowing standardisation and basic data analysis.
METHODS: York Health Economics Consortium were engaged to explore solutions. Support was provided by an on-site qualified pharmacist, who co-developed data collection sheets and verified data quality. Treatment preparation stages were identified and mapped, and workflow was assessed.
A paper data collection sheet was designed to record times per task and errors made. An Excel Spreadsheet was developed to store data and perform basic data analysis, such as preparation time per medication per working day; time per task; times per working day and task. This had the advantages of in-time data collection and the facilitation of basic data analysis. However, there was heavy reliance on technicians accurately recording data, with the risk of errors during data collection and transcription phases. To address this the spreadsheet evolved to a ´Google Sheets´, with the same advantages, as well as the ability to input data mimicking the paper sheet, reducing the risk of errors during the transcription phase, and being accessible from different sites to facilitate multicenter studies.RESULTS: The tool has been developed and successfully used with data from different sites and different therapeutical fields (Chemotherapy, IV Antibiotics and Parenteral Nutrition), requiring adaption due to variation in tasks in the three different workflows. Staff reported ease of use of the standarised paper sheets.
CONCLUSIONS: The tool developed facilitates the collection and analysis of data from multiple centres. Other areas of the hospital (beside the aseptic unit) will benefit from the use of a similar tool, such as the central dispensary and hospital wards.
Conference/Value in Health Info
Value in Health, Volume 26, Issue 11, S2 (December 2023)
Code
RWD17
Topic
Real World Data & Information Systems
Topic Subcategory
Data Protection, Integrity, & Quality Assurance
Disease
Medical Devices, Oncology