Dear All,
RE: DATA COLLECTION, MANAGEMENT, ANALYSIS AND MAPPING USING ODK, STATA AND QGIS
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 11th to 22nd Nov, 2019
Event Information
Course Name: Data Collection, Management, Analysis And Mapping Using Odk, Stata And Qgis.
Venue: Tech for Development Training Center, Nairobi, Kenya
Event Date: 11th to 22nd Nov, 2019
Course Fee: KES 75,000 OR USD 1,100
Online Registration: Register here
Introduction
ODK
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.
Stata
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.
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.
Duration
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.
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.
Requirements
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
• 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)
• 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
• 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
• 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
• Importing OpenStreetMap data: SpatialLite Database
• Data filtering and extraction
• Exporting layers to a local CRS
• Extracting and preparing thematic OSM data
• Filtering OSM data to create desired features
• Using the Graphical Processing Modeler to automate workflows
Expected Training Outcomes
By the end of this training course participants will have learnt:
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 analyses skills in STATA.
3. How to develop maps and perform geographical data analysis in QGIS
Methodology
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.
Action plan
Visit our website for more details.
Tailor-made training
This training course can also be tailored for your organization. This way, your organization will benefit by:
• Using own datasets and 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.
Testimonials
Kindly visit this link to see video and photo testimonials of our previous training events.
FAQs
Need more information? Kindly visit this link to see answers to frequently asked questions.
How to participate
Register as individual

Contact information
Email: outreach@t4d.co.ke
Tel: +254 706909947
Website: www.t4d.co.ke

Kind regards.
Rose Muthoni,
Customer Relationship Officer,
Tech For Development
Innovation for impact