Topic: Innovative reporting highlights resident call bell response trends for improved care outcomes.
Day: Thursday 22 October 2020
Time: 1:30pm-1:50pm AEDT
Cooinda Aged Care is now better able to highlight trends in resident call bell data thanks to an innovative new report. Comparing this structured data against incident occurrence and staffing resources allows more informed decisions and focuses attention on areas with potential for improvement.
Previous reporting was generated directly from the call bell program itself. The reports produced were difficult to interpret and therefore impossible to quickly identify trends. Cooinda approached Joseph Daw to create a report that would better more user friendly. The idea was to be able to collate call frequency and duration over the day to be able to compare this to incident occurrence and staffing levels.
Key to the report was highlighting calls that took longer than a set threshold to be responded to, for example longer than 5 minutes. In addition, the report was to be broken down into three segments, all data, data for each wing of the facility, and finally an option to select an individual resident’s specific call history. Previously this would require multiple reports to be exported out of the existing software, and then comb through those reports to find the desired data.
The new report utilises a macro-enabled Excel workbook to import the raw data and then present it based on the needs of the user. The key to reporting is ensuring data is entered correctly. This is achieved by a macro that allows the user to import the call history from a single report out of the call bell program without any manual data handling. This method minimises the risk of corruption compared to the user entering or copying the data.
Once the call history is imported into the Excel report, the user can select a data range and response time, either for all data, specific wings, or a specific location. A report showing the collated data, along with a graphical representation is then produced. This report is then easily exported to PDF for quick analysis of trends.
Joseph Daw has always had a passion for design and technology. In 2008, he was awarded the Prime Minister’s Award for Skills Excellence in School and the Australian Vocational Student Prize. In 2014, he was nominated for the Victorian Young Achiever Award.
Joseph is always exploring how companies can use technology to improve workflow and efficiency. He has created a number of different projects for organisations to enhance their operations including maintenance tracking, monthly invoices, and data analytics.
Joseph currently lives in Adelaide. Outside of work he can be found out on the golf course or enjoying some of the regions stunning wineries.