Googling your hand hygiene data: Using Google Forms, Google Sheets, and R to collect and automate analysis of hand hygiene compliance monitoring - 25/05/18
, Stephen P. Furmanek, MS MPH b, William A. Mattingly, PhD b, Janet Haas, PhD, RN, CIC, FSHEA, FAPIC c, Julio A. Ramirez, MD b, Ruth M. Carrico, PhD FNP, RN, CIC, FSHEA bHighlights |
• | We created an easy-to-use, platform-independent hand hygiene data collection process using Google Forms and Google Spreadsheets. |
• | Using R and RStudio Shiny, we built an online analytics engine to provide on-demand, automated reporting directly from the Google Spreadsheet. |
• | By reducing the workload of data collection and analysis, more time may be spent on improving hand hygiene adherence. |
Abstract |
Background |
Hand hygiene is one of the most important interventions in the quest to eliminate healthcare-associated infections, and rates in healthcare facilities are markedly low. Since hand hygiene observation and feedback are critical to improve adherence, we created an easy-to-use, platform-independent hand hygiene data collection process and an automated, on-demand reporting engine.
Methods |
A 3-step approach was used for this project: 1) creation of a data collection form using Google Forms, 2) transfer of data from the form to a spreadsheet using Google Spreadsheets, and 3) creation of an automated, cloud-based analytics platform for report generation using R and RStudio Shiny software.
Results |
A video tutorial of all steps in the creation and use of this free tool can be found on our YouTube channel: watch?v=uFatMR1rXqU&t. The on-demand reporting tool can be accessed at: handhygiene.
Conclusions |
This data collection and automated analytics engine provides an easy-to-use environment for evaluating hand hygiene data; it also provides rapid feedback to healthcare workers. By reducing some of the data management workload required of the infection preventionist, more focused interventions may be instituted to increase global hand hygiene rates and reduce infection.
Le texte complet de cet article est disponible en PDF.Key Words : Hand hygiene, Antisepsis, Open-source software, Shiny, Observations, Hawthorne effect
Plan
| Conflicts of interest: None to report. |
Vol 46 - N° 6
P. 617-619 - juin 2018 Retour au numéro
Article précédent
- Use of a verbal electronic audio reminder with a patient hand hygiene bundle to increase independent patient hand hygiene practices of older adults in an acute care setting
- Shanina C. Knighton, Mary Dolansky, Curtis Donskey, Camille Warner, Herleen Rai, Patricia A. Higgins
- Asymmetric transfer efficiencies between fomites and fingers: Impact on model parameterization
- Christine Greene, Nancy Hernandez Ceron, Marisa C. Eisenberg, James Koopman, Jesse D. Miller, Chuanwu Xi, Joseph N.S. Eisenberg
Bienvenue sur EM-consulte, la référence des professionnels de santé.
L’accès au texte intégral de cet article nécessite un abonnement.
Déjà abonné à cette revue ?