Googling your hand hygiene data: Using Google Forms, Google Sheets, and R to collect and automate analysis of hand hygiene compliance monitoring

•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...

Full description

Saved in:
Bibliographic Details
Published in:American journal of infection control 2018-06, Vol.46 (6), p.617-619
Main Authors: Wiemken, Timothy L., Furmanek, Stephen P., Mattingly, William A., Haas, Janet, Ramirez, Julio A., Carrico, Ruth M.
Format: Article
Language:English
Subjects:
Antisepsis
Data Collection
Guideline Adherence - statistics & numerical data
Hand hygiene
Hand Hygiene - statistics & numerical data
Hawthorne effect
Humans
Internet
Observations
Open-source software
Patient Compliance - statistics & numerical data
Shiny
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:•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. 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. 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. A video tutorial of all steps in the creation and use of this free tool can be found on our YouTube channel: https://www.youtube.com/watch?v=uFatMR1rXqU&t. The on-demand reporting tool can be accessed at: https://crsp.louisville.edu/shiny/handhygiene. 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.
ISSN:0196-6553
1527-3296
DOI:10.1016/j.ajic.2018.01.010