Field testing of a simple ODK application for Double Data Entry for community-based healthcare research and disease surveillance

Iwara I. Arikpo, Anthony T. Okoro, Ememobong N. Aquaisua, Martin M. Meremikwu

Abstract


Data quality plays a vital role in the reliability of data for planning and decision making. The methods used for data collection and entry further heightens the concern for data quality. This paper addresses the techniques of double data entry as an efficient and simplified approach designed to improve the quality of paper-based records. 

Data from implementation of the operations research component of a larger health intervention project in Abia State, South-east, Nigeria, was used for the implementation. Paper-based data were entered independently by two data entry clerks with unique identifiers (IDs) using ODK application. The data was then exported in .csv format into Microsoft Excel application and compared for discordant entries.

The algorithm auto-compared all records by the data entry clerks and returned zero and non-zero values for all concordant and discordant entries respectively. This allowed for easy spot checks on the questionnaires and subsequent correction of the erroneous entries.

Double data entry is efficient, cost effective and robust in achieving high data quality with paper-based records.

Keywords


data quality; double data entry; data cleaning; paper-based records; data entry errors; paper forms

Full Text:

PDF

References


Census.gov. (2017). International Programs - Census and Survey Processing System (CSPro) Documentation. Retrieved from United States Census Bureau: https://www.census.gov/population/international/software/cspro/csprodocs.html

Coleman Data Solutions. (2014). Advantages of Double Key Data Entry and Verification. Retrieved from Coleman Data Solutions: http://www.blog.coleman-data.com/advantages-double-key-data-entry-verification/

EPiData. (2019). EpiData Software. Retrieved from https://www.epidata.dk/index.htm

Google Cloud Platform. (2016). Google Cloud Computing. Retrieved January 2015, from Google Cloud Platform: https://cloud.google.com/

Gregg, M. (2008). Field Epidemiology (3rd ed.). New York: Oxford University Press, Inc.

IHSN. (2017). Finalize collection (data entry). Retrieved from International Household Survey Network: http://www.ihsn.org/node/111

Krishnankutty, B., Bellary, S., Kumar, N., & Moodahadu, L. (2012). Data management in clinical research: An overview. Indian Journal of Pharmacology, 44(2), 168-172. doi:10.4103/0253-7613.93842

Ndume, V., Nkansah-Gyekye, Y., & Ko, J. (2014). Double Entry Data Capture as an Alternative Solution for Quality of E-Health Records. International Journal of Computer Applications, 93(4), 29-35. doi:10.5120/16204-5490

NISR. (2016). Data Processing. Retrieved from Rwanda - Integrated Household Living Conditions Survey 2005-2006: http://microdata.statistics.gov.rw/index.php/catalog/39/dataprocessing

Open Data Kit. (2017). Open Data Kit: Collect. Retrieved 2017, from OpenDataKit: https://opendatakit.org/use/collect/

OpenClinica. (2017). Entering Data for an Event Into CRFs. Retrieved from OpenClinica Reference Guide: https://docs.openclinica.com/3.1/openclinica-user-guide/submit-data-module-overview/enter-data-event-completing-crfs#content-title-4845

REDCap. (2019). REDCap. Retrieved from https://www.project-redcap.org/

Scott, J., Thompson, A., Wright-Thomas, D., Xu, X., & Barchard, K. (2008). Data entry methods: Is double data entry the way to go? Poster presented at the Western Psychological Association Annual Convention. Irvine, CA.

Shaffer, T. L., & Groninger, N. P. (1995). Double Data Entry for Novice Users. 20th Annual SAS Users Group International Conference (pp. 111-1116). Orlando, FL: SAS Institute, Inc.




DOI: https://doi.org/10.26483/ijarcs.v10i3.6410

Refbacks

  • There are currently no refbacks.




Copyright (c) 2019 International Journal of Advanced Research in Computer Science