Reducing errors from the electronic transcription of data collected on paper forms: a research data case study
- PMID: 18308994
- PMCID: PMC2409998
- DOI: 10.1197/jamia.M2381
Reducing errors from the electronic transcription of data collected on paper forms: a research data case study
Abstract
We conducted a reliability study comparing single data entry (SE) into a Microsoft Excel spreadsheet to entry using the existing forms (EF) feature of the Teleforms software system, in which optical character recognition is used to capture data off of paper forms designed in non-Teleforms software programs. We compared the transcription of data from multiple paper forms from over 100 research participants representing almost 20,000 data entry fields. Error rates for SE were significantly lower than those for EF, so we chose SE for data entry in our study. Data transcription strategies from paper to electronic format should be chosen based on evidence from formal evaluations, and their design should be contemplated during the paper forms development stage.
Figures
References
-
- Neaton JD, Duchene AG, Svendsen KH, Wentworth D. An examination of the efficiency of some quality assurance methods commonly employed in clinical trials Stat Med 1990;9:115-123discussion 24. - PubMed
-
- Hakansson I, Lundstrom M, Stenevi U, Ehinger B. Data reliability and structure in the Swedish National Cataract Register Acta Ophthalmol Scand 2001;79:518-523. - PubMed
-
- Smyth ET, McIlvenny G, Barr JG, Dickson LM, Thompson IM. Automated entry of hospital infection surveillance data Infect Control Hosp Epidemiol 1997;18:486-491. - PubMed
-
- Microsoft Office Word2003 ed.. Redmond, WA: Microsoft Corporation; 2006.
-
- Microsoft Office Access2003 ed.. Redmond, WA: Microsoft Corporation; 2006.
Publication types
MeSH terms
LinkOut - more resources
Full Text Sources
