| Literature DB >> 24066147 |
Jonathan D King1, Joy Buolamwini, Elizabeth A Cromwell, Andrew Panfel, Tesfaye Teferi, Mulat Zerihun, Berhanu Melak, Jessica Watson, Zerihun Tadesse, Danielle Vienneau, Jeremiah Ngondi, Jürg Utzinger, Peter Odermatt, Paul M Emerson.
Abstract
BACKGROUND: Large cross-sectional household surveys are common for measuring indicators of neglected tropical disease control programs. As an alternative to standard paper-based data collection, we utilized novel paperless technology to collect data electronically from over 12,000 households in Ethiopia.Entities:
Mesh:
Year: 2013 PMID: 24066147 PMCID: PMC3774718 DOI: 10.1371/journal.pone.0074570
Source DB: PubMed Journal: PLoS One ISSN: 1932-6203 Impact factor: 3.240
Needed functionality of electronic data collection in household surveys and the solutions implemented.
| Description of need | Final solutions implemented | |
|
| ▪ Simple design of new surveys▪ Update of existing surveys▪ Display multiple languages | ▪ No Internet connection required for design, drag-and-drop survey builder▪ Create and save templates for fast production of new surveys▪ Entry of multiple translations in form builder▪ Export labels for faster, bulk translation |
| Collection | ▪ Simple data entry▪ Accommodate skip patterns▪ Generate unique identification numbers for each householdand individual▪ Maintain parent-child relationships of household-level and individual-level data▪ Generate random samples of entered records▪ Track external specimens▪ Minimize errors▪ Input text in multiple languages | Android application with base functionality of Open Data Kit plus:▪ Ability to generate relational databases so that data entered once applies to all related records▪ User defined survey preferences▪ Generation of unique record identification▪ Select enumerated residents randomly▪ Save listing of absent persons for ease of review and completion▪ Side-by-side view of enumerated residents and repeating data fields ( |
| Management | ▪ Efficient distribution of survey forms▪ Minimal risk of data loss▪ Append data from multiple devices▪ Convert data to a generic file format for broad compatibility▪ Reduce time to data availability | ▪ Data written to external storage on device▪ Without Internet or mobile network connection, from a local desktop user-friendly interface:1. Distribute forms2. Upload and append collected data3. Convert data to useable format |
|
| ▪ Withstand heat, cold, moisture, and dust▪ Battery life for at least 1 working day▪ Ease of recharging | ▪ Android tablet computer 7″ display▪ Internal battery minimum capacity 6–8 hr▪ Protective case▪ Portable external battery pack▪ AC and DC to multiple USB plugs for charging |
| Capability | ▪ Capacitive touch screen▪ Visible display in bright sunlight▪ Collection of geographic coordinates▪ Camera for scanning barcodes▪ Recoverable data | ▪ Tablet computer with 3.5 mega pixel camera▪ Auto-brightness display setting▪ Internal GPS▪ Removable, external micro SD cards |
Figure 1Example screen shot: looping fields for members grouped within a household record.
As seen in a novel Android application for collecting data in household surveys.
Figure 2Capturing the identification number from a barcode-labeled stool specimen.
As conducted during an integrated survey of neglected tropical diseases in Amhara National Regional state, Ethiopia in 2011.
Time to complete paper-based and Android-based electronic questionnaires during a pilot trial in Ethiopia 2011.
| Paper | Tablet | H0: Paper = Tablet | |
|
| |||
| Total number of households surveyed | 10 | 10 | |
| Mean number of residents per household | 4.9 (1.8) | 4.5 (2.9) | |
| Mean time (sec) to enter data per person registered | 268 (101) | 320 (119) | z = −1.29 |
|
| |||
| Total number households surveyed | 10 | 10 | |
| Mean number residents per household | 3.8 (1.2) | 3.9 (1.2) | |
| Mean time (sec) to enter data per person registered | 260 (197) | 201 (97) | z = 0.68 |
|
| |||
| Mean time (sec) to enter data per person registered | 264 (152.4) | 260 (122) | z = −0.30 |
SD- standard deviation.
Wilcoxon rank-sum test.
Data recorders’ perceptions of electronic data collection post 3-day pilot trial in Ethiopia.
| Aspect explored | Summarized perceptions |
|
| ▪ Paper questionnaire took less time to complete than the electronic questionnaire |
|
| ▪ No printing, sorting, stapling, and labeling with unique numbers is required with electronic data collection |
|
| ▪ Tablet computers were portable, lighter, and less bulky than paper |
|
| ▪ Less eye-to-eye contact with respondent, but was less of a problem once familiar with the tablet computer |
|
| ▪ Transcribing GPS coordinates onto paper forms was a difficult task and the direct capture of GPS coordinates via the tablet was preferred▪ Writing district, village, and community names on a paper form for every household was tedious▪ No writing necessary for electronic data collection▪ Recorders must be attentive to skip patterns on a paper form, but the skip patterns were automatic on the electronic form▪ Entering text, moving the cursor, and editing text fields were most challenging tasks using the tablet computers▪ Accidental selections on single select (i.e., yes or no) questions when the question did not apply could not be de-selected only switched to either option▪ Mistakes on paper forms can be erased and corrected▪ More difficult to return to a completed electronic form and add information than a paper form (i.e., an absent person presents for examination after the survey team has moved to a new household) |
|
| ▪ Risk of losing the data was greater for tablets than for paper forms because paper is tangible▪ Paper forms are difficult to keep clean, dry, and in order |
|
| ▪ Ability to use tablets may be enhanced by experience in using computers▪ Data recorders should become familiar with questionnaires first before using tablets▪ Power management must be covered |
|
| ▪ Keeping device charged where there is no access to electricity |
|
| ▪ Enjoyed learning new technology▪ Questions on the electronic form and entry of data in |
Data comparison of paper-based and electronic data collection from two large-scale, cluster surveys in Ethiopia.
| Indicator compared | Paper-based data collection | Electronic data collection | χ2 or t-test (p-value) |
|
| |||
| Clusters | 360 | 354 | NA |
| Households surveyed | 9,263 | 12,064 | NA |
| Individuals enumerated | 38,851 | 50,858 | NA |
| Individuals examined | 33,800 | 38,652 | NA |
|
| |||
| Individual-level | 0.3% (N = 38,852) | 0.8% (N = 50,884) | 27.96 ( |
|
| |||
| % Individuals enumerated with at least 1 blank field incensus record (age, sex, availability) | 1.7% (N = 38,851) | 1.5% (N = 50,858) | 6.61 (p = 0.01) |
| % households with incorrect unique identifying number | 2.3% (N = 9,433) | 1.8% (N = 12,112) | 6.83 ( |
| Disease classification | 0.2% (N = 33,800) | 0.2% (N = 38,652) | 1.28 ( |
|
| |||
| Blank entries | 0.6%(N = 9,263) | 1.1% (N = 12,064) | 12.14 ( |
| Outlying entries‡ | 1.4% | 0.6% | 38.92 ( |
| Mean household distance in meters to cluster centroid (SE) | 687 (81) | 288 (7) | t = −5.53 ( |
Defined as recorded households with coordinates more than 4 km from cluster centroid, or more than 1,000 m elevation from median elevation of the cluster.
NA, not applicable.
Figure 3Distance between the recorded location of a surveyed household and the cluster centroid.
Households surveyed in trachoma impact assessments in South Wollo (paper-based questionnaire 2010) and South Gondar (electronic data collection 2011), Ethiopia.
Figure 4Proportion of total time (person days) required to complete survey activities by collection method.
Time as implemented using paper-based questionnaire and Android-based electronic form in two large-scale (360 clusters each) trachoma impact assessments in Ethiopia 2010 and 2011.