Description
In this course, you will learn :
- Using MS Excel and ODK Build, convert any paper-based questionnaire to an ODK compatible format.
- Create a free subdomain with Free DNS.
- Create and manage a Digital Ocean VPS account.
- Configure and manage an ODK aggregate server in Digital Ocean.
- Install ODK Offline data collection on mobile devices.
- Upload data to an ODK Aggregate cloud server.
- On ODK aggregate, you can analyse, visualise, and map data online.
- Using ODK Briefcase, download data from ODK aggregate for further analysis in software such as MS Excel, Stata, SPSS, R, and others.
Syllabus :
1. Form/Questionnaire digitization using the XLSForms Syntax
- Getting started with XLSForms syntax (Setting up the workbook)
- Worksheets explained
- Getting started with simple questions
- Select one, select multiple and required questions
- Validating forms
- Referencing and specify other questions
- Hint, relevance, and skip logic
- Constraints, select multiple and specify questions
- Specify others, relevance and grouping questions
- Relevance and skip logic (Recap)
- Repeating questions (Loop)
- Calculate, take photos and record GPS questions
- Consent and multiple language questions
- Troubleshooting, validating and converting forms (Questionnaire)
2. Setting up the ODK Aggregate Server
- ODK Aggregate server setup introduction and preview
- Creating an account at FreeDNS and adding a sub-domain
- Creating an account in Digital Ocean
- Installing ODK Aggregate on Digital Ocean
- Enabling HTTPS on the server
- ODK Aggregate management and administration
3. Mobile Device setup and Mobile Data Collection
- ODK Collect and mobile phone setup
- Collecting data on mobile phones and uploading to the server
- Viewing and analyzing data on the server
- Exporting data using ODK Briefcase for further analysis