Supporting and monitoring data entry clerks

Aim

To secure high quality of data by accurate data entry, by supporting the data entry clerks and monitor their data.

 

Requirements

  • Standardized data entry procedures, including how to cope with missing data;
  • Quality monitoring of first set of data entered for each measurement instrument;
  • Problems/issues/missing data to be documented in a logbook by the data entry clerks;
  • Immediate implementation of modifications in test protocol;
  • Regular meetings to discuss data collection issues between the executing researcher and data entry clerk(s).

 

Documentation

  • Standardized protocol for data entry, including how to cope with missing data;
  • Protocol for quality monitoring of data entered;
  • Logbook with problems/issues/missing data, kept by the data collectors;
  • Problems/issues that lead to modifications in the test protocol.

 

Responsibilities

Executing researcher:
  • To supervise and monitor the data entry clerks;
  • To carry out analyses on the first set of data to monitor the quality of the data.
Project leaders:
  • To ensure that the data entry clerks are being supervised and monitored by the executing researcher;
  • To ensure that the executing researcher carries out analyses on the first set of data to monitor the quality of the data.
Research assistant:
  • To check for completeness of measurement instruments;
  • To note problems/missing data in a logbook;

 

How To

Once data is collected by data collectors (see guideline 1.2-01), the data are mostly handed over to the data entry clerks. It is important to keep track of their data entry, and to support them in any problem or issue. After all, they are making sure to entry your data. So, it is important to intensively support the data entry clerks and to monitor the quality of their data.
Prior to data entry, the methods of quality monitoring need to be documented. It is advised to provide this type of information to the data entry clerks as well. A lot of information and guidance for data entry clerks is included in this PowerPoint presentation about quality principles.

 

Supporting and monitoring data entry clerks
The executing researcher is advised to make a standardized protocol about how to process questionnaires. This is very important when data entry is being carried out by different people. Data entry clerks need to document what the most important problems are during data entry in a logbook. It is advised to sit down with the data entry clerk and discuss these issues that are not clear, differences in interpretation, problems, etc.
The executing researcher can create a so-called fake questionnaire, for data entry clerks to practice with most frequently occurring responses to questions with room for interpretation. Examples are:
  • There is a question which includes a single response option, but the respondent has selected two answers;
  • Illegibility of the respondent’s hand writing;
  • The respondent is asked to indicate in minutes how long he or she has taken on a particular activity. The respondent has provided ‘1’ as a response – it appears that the respondent meant ‘one hour’, i.e. 60 minutes.
Data entry clerks can practice with such a fake questionnaire, which has to be checked and discussed by the executing researcher.

 

Monitoring the data entry
During the data collection period, small data sets can repeatedly be analyzed at variable level in order to monitor the entered data, i.e. ‘continuous monitoring’. Examples of this include producing frequency distributions or random double data entry. This exclusively concerns descriptive statistics to search for data entry errors, and does not involve the analysis of the research question.
The questionnaires need to be checked for completeness prior to the data of the questionnaire is entered. If possible, missing data should be retrieved.

  

Audit questions

  1. Has the quality monitoring been carried out on the first data set entered by the data entry clerk(s) and have the results of the quality monitoring been documented?
  2. Have the data entry clerks been trained?
    1. If so, has a protocol or fake questionnaire been used?
  3. Have problems arise during the data entry?
    1. If so, have these problems been recorded and solved?
  4. Have data been monitored at variable level during the data collection process?

 

V2.0: 12 May 2015: Revision format
V1.3: 1 Jan 2010: English translation
V1.2: 8 Jul 2008: Small addition
V1.1: 23 Nov 2006: Addition of use of fake list, example input protocol