
In the previous lesson, we learnt about various definitions. We learnt about XLSForms, that they were simply a standard for development of ODK tools. You may notice that from now on I will use the words tool and form interchangeably.
Don’t worry about that, because I will be saying this while I am referring to the same thing. These are the ODK based digital surveys that we shall be building on this course.
Now let’s just get right into it. As of now you understand that XLSForms are just worksheet documents, that can be edited on a worksheet software such as Excel. I’m sure most of my students are familiar with Excel, just in case you are using a Linux system such as Ubuntu you may use LibreOffice to accomplish this.
In the next video, we shall learn about the general structure of an XLSForm.
Imagine this, you have been given the task to conduct a survey for the International Child Health Organization (ICHO). In the previous years, ICHO has been collecting survey data using paper-based questionnaires. You are required to convert physical survey forms to digital tools.
How do you begin? We shall be learning how to do it from now on. Please head over to the resources section of this lecture, and download the attached Excel file name basic_format.xlsx. This is a basic template which we shall use to get started.
Disclaimer: ICHO is not a real organization, but we we shall use it for learning purposes.
An XLSForm is made up of three worksheets, we may as well refer to them as tabs:
· The survey worksheet
· The choices worksheet
· The settings worksheet
Out of the three worksheets we have discussed, this one is not mandatory but is highly recommended to include.
There are many more column names that the ODK standard provides for inclusion, however the following should not miss from your settings tab:
form_title
form_id
version
As you’d notice on the basic_format.xlsx file you downloaded previously, there is a column named “allow_choice_duplicates”. This is not a mandatory column, it was added to the tool as a fix for a previously encountered error.
You can read more about this from this link https://forum.getodk.org/t/error-allow-choice-duplicates/21440
Content gets reviewed from time to time, this is the most updated course on ODK and KoboToolbox, so be sure to find new topics!
Also, the instructor is ready to answer your questions any time through the messaging platform.
By the end of this course, you should be able to do the following:
Getting Started with ODK and XLSForm Fundamentals
Definitions
XLSForms Structure
Getting work environment ready
ODK Aggregate
Deploy our first ODK Tool
Configurations
Worksheets : Survey , Choices, Settings
Project 1: Design an NGO Research Tool
Widgets: Text, Number, Date/Time, Select One, Select Multiple, GPS , Image e.t.c. and how to program them for various needs.
Validation logic for example how to ensure only certain data is allowed on some widgets.
Load forms into ODK Collect/KoboCollect on an Android device.
Use ODK Collect/KoboCollect to fill out forms with participants.
Reducing Enumerator Fatigue: Using Question Groups and Looped Questions.
Implementing skip logic to determine the way questions flow within a digital survey.
Upload survey data from KoboCollect to an Aggregate Server such as KoboToolbox.
Export data from an Aggregate server
Why should you use ODK?
•ODK allows for built-in checks and skip patterns, meaning they do not have to be done manually by an enumerator. All this is meant to ensure higher quality of data collected.
•Data collection processes can be monitored remotely, and it is possible to make adjustments to a survey even after data collection has started. Submissions can be viewed, and they show when and what data has been submitted. With some adjustments, it is possible to record names of the submitters.
•Promotes a better use of time and saves on costs especially with no need for time-consuming data entry, as seen while using traditional paper based questionnaires.
Thank you so much for making a purchase of this course, it is because of learners like you that my team and I produce this kind of content. We really do hope you shall have learnt a lot by the time you are done with this course.