Training Course in Data Collection, Management, Analysis and Mapping using ODK, Stata and QGIS

Start Date: December 13, 2021

End Date: December 22, 2021

Starts in: 8 Days

Event Location: Nairobi

Training Fees: USD 2,552.00

Other Dates: January 18, 2021, February 15, 2021, March 15, 2021, April 19, 2021, May 17, 2021, June 14, 2021, July 19, 2021, August 16, 2021, September 20, 2021, October 18, 2021, November 15, 2021, December 13, 2021

See Future Events: Data Science and Analytics, Mobile Data Collection, Data Analysis, Data Visualization, Data Science, QGIS, ODK, Stata




Open data kit commonly referred to as ODK is a set of popular free and open-source tools that allow us to collect data using mobile devices. Being a pioneer tool of its nature, ODK is one of the most popular mobile data collection tools. The fact that ODK is free and open source also makes it a darling to users considering the budget constraints that come with projects. Other reasons for its popularity include but not limited to: Allows offline data collection, has an active online community and support base, ability to collect rich data (photos, audio, video, signature, etc), ability to collect location data (points, traces, and polygon), allows collaboration and data sharing, enables data aggregation, management and visualization on cloud platforms amongst others.


From simple to complex datasets, STATA makes it easy for analysts to maximize the use of their data. Other than quantitative data analyses, STATA can be used for exploring and analyzing geo-tagged datasets. The Graphical User Interface (GUI) of STATA is user-friendly for beginners, and those not familiar with commands.

On the other hand, STATA commands are simple and easy to grasp. You can use STATA for analyzing socio-economic datasets, experimental datasets, and medical survey datasets among others.

QGIS (Mapping)

A Geographic Information System is a multi-component environment used to create, manage, visualize, and analyze data and its spatial counterpart. Most datasets you will encounter in your life can all be assigned a spatial location whether on the earth’s surface or within some arbitrary coordinate system (such as a soccer field or a gridded petri dish). So, in essence, any dataset can be represented in a GIS.

QGIS is a very capable open-source (free) GIS software. It encompasses most of the functionality included in ArcGIS. If you are looking for a free, open-source, and easy to use GIS software QGIS is a wonderful choice given its multi-platform support.


10 days

Why this course

Data collection, management, analyses, and mapping has always been a bully for many people, either because of their divergent academic background from research/statistics/GIS and/or mathematics or because they have not been introduced well to understanding data and analyzing it for information purposes. Whether you are a researcher or a member of the project management team, evidence-based decision-making is becoming a mandatory tool in organizations and for prioritizing development needs. Facts must be presented in figures and qualitative values in order to justify them for decision purposes. Based on these needs, the course has been specifically designed to help participants understand data collection, organization, management, basic data analyses in STATA, and mapping in QGIS. Participants will also learn useful statistical concepts for data analysis procedures and results in interpretation.

Who should attend

Any person willing to learn mobile data collection using ODK, data management and analysis using STATA and mapping using QGIS to improve their general knowledge on data collection, management, analyses, and mapping for academic research, organizational data, or want to switch to new technologies for data processing have the right footing to this course. You do not have to be a researcher, statistician, an academician, or have prior knowledge in GIS in order to attend.


Participants are advised to bring a PC laptop with Windows XP Service Pack 3 or later with at least 2GB of RAM. You should also ensure that the laptop is installed with a genuine antivirus and is well updated.

If your computer is password protected please ensure that you have the administrator password for the purpose of installing software during the training.

Course Outline

ODK (Mobile Data Collection)

Digitizing your questionnaire

  • Introduction to basic XLSForm syntax for survey authoring
  • Getting started – Survey authoring using XLSForm syntax
  • Types of questions
  • Data types for each question and form logic
  • Intermediate survey authoring
  • Advanced survey authoring
  • Form Validation and Conversion for ODK Aggregate
  • Troubleshooting common syntax errors

Device calibration (Mobile Phones/Tablets) – ODK Collect

  • Introduction to ODK Collect
  • ODK Collect installation and configuration
  • Uploading forms into ODK Collect manually
  • Downloading form into ODK Collect from ODK Aggregate server

Hosting survey data (Online) – ODK Aggregate

  • Introduction to Google app engine/Digital Ocean/AWS for ODK
  • Introduction to ODK Aggregate
  • ODK Aggregate – Download and setup
  • ODK Aggregate administration and calibration
  • Data analysis in ODK aggregate

Downloading data for analysis

  • Downloading data from ODK Aggregate
  • Introduction to ODK Briefcase
  • Download and setup ODK Briefcase
  • ODK Briefcase calibration and administration

Stata (Data Management and analysis)

  • Introduction to Data Management, Surveys, and Experimental Designs
  • Data Collection Techniques
  • Introduction to STATA datasets, Edit, Browse, List, Generating Variables, Codebook, Use written programs) Data Management in STATA (Import, Data Labelling, Handling Duplicates, Missing Values, Reshape, Append, Merge, Collapse, Data Transformation, Creating Dummy Variables)
  • Data Exploration (Simple tables, cross-tabulation with measures of association, Measures of Central Tendency, Outliers, Quartiles, Percentiles, Skewness, Kurtosis, Variance, Standard Deviation, Standard Errors, Ladder/Gladder)
  • Data Graphing (Pie charts, bar graphs, histograms, scatter plots, line graphs, panel graphs, QQ plots, matrix plots, survival curves, etc.)
  • Advanced Analyses (Normality tests, variance tests, t-tests, One-way & Two-way ANOVA, MANOVA, ANCOVA, OLS Regression, Logistic/Binomial Regression, Factor Analyses/PCA, GLM, Cox Regression, Other Regression Models)

QGIS (Mapping)

Introduction, cartography and GIS, and creating maps in QGIS

  • Basic conceptual understanding of cartography, GIS, and mapping
  • Gain familiarity with geographic data and information, and how it’s encoded within computer files
  • Gain basic familiarity with the QGIS interface
  • Gain awareness of spatial reference and projection issues
  • Practice opening a variety of geographic data with QGIS and viewing their attributes within QGIS
  • Perform basic map styling
  • Create and export a basic map as a static image file

Thematic data mapping, Geocoding, and point in polygon analysis

  • Load shapefiles and CSV data into QGIS
  • Data transformation
  • Create classed choropleth map
  • Adjust the legend to help the map tell a clearer story
  • Load tabular CSV data into QGIS and performing a tabular join
  • Obtaining and working with US Census data
  • Understand and perform geocoding of tabular data
  • Learn about some of the geocoding tools available online
  • Understand and perform a point in polygon analysis

Heat maps, creating and editing vector Geometries

  • Map point data
  • Create a ‘heat map’ representation of the data
  • Georeferencing
  • Digitizing data
  • Digitizing data with Open Street Map in QGIS
  • Introduction to Open Street Map
  • Importing OpenStreetMap data
  • Importing OpenStreetMap data: SpatialLite Database
  • Data filtering and extraction
  • Exporting layers to a local CRS
  • Introduction to Geoprocessing
  • Geoprocessing with a buffer analysis
  • Extracting and preparing thematic OSM data
  • Filtering OSM data to create desired features
  • Managing CRSs in a Geoprocessing Workflow
  • Extracting attribute types of interest
  • Creating a buffer around a Polyline feature
  • Clipping features within a buffer
  • Geoprocessing functions
  • Using the Graphical Processing Modeler to automate workflows

Expected Training Outcomes

By the end of this training course participants will have learned:

  1. How to develop, manage, and administer and implement a mobile data collection platform using ODK.
  2. The core statistical concepts, clearly demonstrate data management and analysis skills in STATA.
  3. How to develop maps and perform geographical data analysis in QGIS


The instructor-led training is delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials, and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.


Upon successful completion of this training, participants will be issued with a certificate of participation.

Training venue

The training is residential and will be held at T4D Training Centre in Westlands Nairobi, Kenya. The course fees cover the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their travel expenses, visa application, insurance, and other personal expenses.


We can also tailor-make our courses for you. This way, you/your organization will benefit by:

  • Using their own tools during the training
  • Being able to choose areas of interest you wish the trainer to put more emphasis on
  • Taking the course in-house or at a venue of choice
  • Cutting on the cost of transport and accommodation

For further inquiries, please contact us on details below:

Email: [email protected]

Mobile: +254706909947


Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: [email protected]

Mobile Number: +254706909947

Training fee

The course fee is KES 150,000.00 or USD 2,200.00 exclusive of VAT. The course fees cover the course tuition, training materials, two (2) break refreshments, lunch, and study visits. Participants will cater for their travel and accommodation costs.


Payment should be transferred to Tech For Development – T4D account through the bank on or before the course starting date.

Send proof of payment to [email protected]

Cancellation policy

Payment for all courses includes a registration fee, which is non-refundable and equals 15% of the total sum of the course fee.

  1. Participants may cancel attendance 14 days or more prior to the training commencement date.
  2. No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure



First Name*:
Required field
Last Name*:
Required field
Required field
Phone Number:


Scroll to Top
Receive the latest news

Subscribe To Our Weekly Newsletter

Get notified about our new courses