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

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

Venue: Tech for Development Training Center, Nairobi, Kenya

Event Date: 20th April to 1st May 2020

Course Fee: KES 220,000 OR USD 2,200

Tech for Development-T4D would like to invite you to a high impact Training Course in Data Collection, Management, Analysis and Mapping using ODK, Stata and QGIS to be held in Nairobi, Kenya from 20th April to 1st May 2020.

Why train with us?

  • Our focus is on helping your organization achieve workplace performance improvements.
  • Our rigorous pre-training evaluation ensures a robust training model that aligns training with the culture, strategic direction, and internal resources of your organization.
  • Our extensive experience, expertise and client base - We have conducted training to over 10,000 attendees from 20 countries around the world.
  • We boast of staff and associate trainers/facilitators with a combined 400+ years of experience training and facilitating in fields of technology, research, software development, ICT4D, GIS, M&E and soft skills.
  • We are not independent contractors; all our people work as part of your Project Team.
  • Attendees benefit from our post training support and mentorship provided to each attendee for 12 months after completion of any training course.
  • Small class sizes - No more than 15 people to ensure you get the most from our trainers.



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 lifetime 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 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 analyses procedures and results 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 wanting to switch to new technologies for data processing has 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 a 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 shape files 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 learnt:

How to develop, manage and administer and implement a mobile data collection platform using ODK.

The core statistical concepts, clearly demonstrate data management and analyses skills in STATA.

How to develop maps and perform geographical data analysis in QGIS


This instructor led training course 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 professional 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 the T4D Training Centre in Westlands, Nairobi, Kenya. The course fee covers 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.

Training fee

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


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

Email: [email protected]

Mobile Number: +254 706909947


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

Send proof of payment to [email protected]


Kindly visit this link to see video and photo testimonials of our previous training events.


Need more information? Visit this link to see answers to frequently asked questions.

Cancellation policy

Payment for the 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.

Contact information

Tel: +254 706909947
Email: [email protected]

Kind regards.

Lennox I. Mucheni
Customer Relationship Officer,
Tech For Development.
Innovation for Impact