There is a special race in Jordan called the “Dead to Red”. It is a 250km running race. You take a relay team of ten people, and you have 24 hours to get from the Dead Sea to the Red Sea. You start at 6pm, and you run all through the night. It’s a massive, …
Audit Tool: Calculate the Time that a Data Collector takes per Question using ODK
One question that many M&E officers or information managers ask when collecting data in KoboToolbox or ODK, is “How long did the enumerator spend on each question?” To track this, you can use a tool called an “audit log” in your XLSForm questionnaire. It might be easiest if you want to watch a video tutorial …
Collect Disability Data using the Washington Group Short Set
Do you disaggregate your data by disability status, whether you’re collecting monitoring data or programme activity data? In this article and tutorial video, I show you how to use the Washington Group Short Set of Questions on Disability and how to programme them into XLSForm so you can collect disability data using KoboToolbox or ODK. …
Reporting to your beneficiaries is important: Lessons about Beneficiary Accountability from COVID19
If you now find yourself in the midst of the coronavirus crisis, let me ask you how much you appreciate getting data and information every single day about the crisis. You probably read daily about 1) how the crisis itself is progressing and 2) what your government is doing (or not doing) to mitigate the …
8 Ways to Adapt your M&E during the Pandemic
So all of a sudden you’re stuck at home because of the new coronavirus. You’re looking at your M&E commitments and your programme commitments. Do you put them all on hold? Postpone them until the coronavirus threat has passed and everything goes back to normal? Or is there a way to still get it all …
Add Geopoint, Geotrace, and Geoshape to a QGIS Map
When you collect geopoint, geotrace, or geoshape data using ODK Collect or KoboToolbox, you can display them in QGIS. In this article, I’m going to show you very quickly how to do that. Now, if you want to know how to collect these kinds of GPS data questions using ODK or KoboToolbox, go check out …
How to Collect GPS Data using ODK Collect and KoboToolbox
How do you collect GPS data using KoboToolbox or ODK? In humanitarian and development work, it’s common to collect GPS locations to map your information. Maybe you need to map village locations. Or maybe you’re mapping remote “roads” that don’t show up on any road map you have. You might even need to map farmers’ …
Prevent Selecting “None of the Above” with any Other Option – XLSForm Constraint Tutorial and Template
I want to share with you a useful XLSForm constraint that you can use when you create digital questionnaires for Kobo Toolbox, ODK, Ona, or SurveyCTO. Someone recently asked me this question: “How can I create a constraint such that respondents can’t select “I don’t know” and another option. I want to create a constraint …
Make a Colour Palette for Professional Maps, Reports, and Dashboards
Let’s talk about the colours you use for visualizing your data! And more specifically, about creating a colour palette to use for your visuals based on your organization’s branding colours. Whether you’re colouring a map, or colouring charts in a report, or in Excel, or in PowerPoint, or even if you’re creating dashboards. I’ve created …
RAND Function in Excel to Choose a Random Sample
Do you ever have to report on an M&E outcome indicator and give a percentage, for example, 70% of the population was impacted? How do you figure out what that percentage is? A lot of the time you’ll base that number on the results of a survey. But for your survey results to be valid, you …