Module 7
Data management
WASH-GEM Introductory Training
Aspects of data management consider both storage and accuracy. We must strive to ensure that data is truthful and safe throughout data collection and analysis.
Storage
Accuracy
Data Management
We recommend using KoBo Toolbox for data management. �KoBo Toolbox is a free and safe cloud-based tool.
The WASH-GEM recommends a cloud-based system to manage data
for increased privacy, reliable access and retrievability.
privacy
retrievability
reliability
Storage
Non-cloud based systems such as filing cabinets or computers
can more easily be stolen, lost or destroyed.
When considering data accuracy, there are four aspects to think about:
Synchronization, verification, clarification and identification.
Synchronization
1
Verification
2
Clarification
3
Identification
4
In collaboration with enumerators
In collaboration with enumerators
Accuracy
Within Kobo Toolbox, the accuracy of data can be checked using
either the database or visual reporting format.
| | |||||
| | |||||
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | |
Within the database version, data managers can tag response approval
and edit responses as required.
| | |||||
| | |||||
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | |
Approved
On hold
Not approved
Within the visual report version, data managers can quickly
explore themes, identify missing data and create printouts.
WASH-GEM
Preliminary Results
The Water, Sanitation, and Hygiene - Gender Equality Measure
|
| |||
|
| |||
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
The first step is to check with enumerators that responses have been accurately
synced from the the data collection system into the cloud.
Synchronisation
1
???
Next, check to see if any data is missing or seems incorrect.
This data can be tagged to help support clarification with the enumeration team
Verification
2
WASH-GEM
Preliminary Results
The Water, Sanitation, and Hygiene - Gender Equality Measure
|
| |||
|
| |||
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
| | |||||
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | |
Once the data manager has checked for any inconsistencies, connect again with the enumerators to clarify any challenges. You may even need to make some phone calls.
Clarification
3
| | |||||
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | |
Last, check to see that the identification codes are accurate and dyads are connected. Then remove all names and phone numbers from the database.
Identification
4
| | |||
| | |||
| | | | |
| John Smith | CAN-001 | +123456789 | |
| | | | |
| Jess MacArthur | CAN-002 | +987654321 | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | |
Depending on the size of you sample, these steps might happen all at once,
or during each debrief session
| | |||||
| | |||||
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | |||||
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | |
We recommend that you watch an introductory video on how to use Kobo Toolbox to create basic reports and edit responses.
The aspects described in this video are engaged with in the
implementation planning workbook and the data cleaning checklist.
Data Cleaning
Checklist
The Water, Sanitation, and Hygiene - Gender Equality Measure
Implementation
Planning Workbook
The Water, Sanitation, and Hygiene - Gender Equality Measure