Standardization ensures that the data in a set is internally consistent. That is it ensures that the data is of the same kind and format for each data element that you are collecting.
Standardization helps to minimize data collection and analysis errors and prevents inconsistencies.
- Data should be coded harmoniously
If data is coded as “no” = 0 and “yes” = 1, then all yes/no questions should use that same coding scheme.
- Standardize free text into categorical data
Whenever possible, free text should be standardized into categorical data. Rather than asking an open-ended question, ask questions with controlled choices.
- Treat date and time data consistently
Choose one date format and employ that standard throughout all of your date fields using active validation. (ie: YYYY-MM-DD)
