Data Collection Analysis and Visualization Using ODK Stata and Quantum GIS in Monitoring and Evaluation

FineResults Research Services would like to invite you to take part in our upcoming workshops on Monitoring and Evaluation & Project Management courses at our FineResults Research Services training facilities in Nairobi, Kenya
17/02/2025 To 28/02/2025 Data Collection Analysis and Visualization Using ODK Stata and Quantum GIS in Monitoring and Evaluation
14/04/2025 To 25/04/2025 Data Collection Analysis and Visualization Using ODK Stata and Quantum GIS in Monitoring and Evaluation
11/08/2025 To 22/08/2025 Data Collection Analysis and Visualization Using ODK Stata and Quantum GIS in Monitoring and Evaluation
20/10/2025 To 31/10/2025 Data Collection Analysis and Visualization Using ODK Stata and Quantum GIS in Monitoring and Evaluation
Venue: Fine Results Research, Nairobi, Kenya
Course Fee: USD 2200
Introduction
A logical framework is an important part of monitoring and evaluating the progress and success of the project. The Logical framework provides various components of a project such as goal, objectives, activities, results and indicators. Indicators are linked to data anticipated to be collected during monitoring and evaluation of projects. Indicators provide a standard against which to measure impact brought about by project activities. Open Data Kit (ODK) helps to collect accurate and timely data for decision making. Whereas, Stata support data analysis, Quantum GIS helps in visualization of spatial data collected using ODK.

Duration
10 days

Course Objectives
By the end of the training, the participants will be able to;
• Learn how to develop a logical framework
• Understand and appropriately use statistical terms and concepts
• Use mobile data gathering tools such as Open Data Kit (ODK)
• Learn how to conduct data analysis using stata
• Use GIS software to visualize data on maps
• Write reports from survey data

Who Should Attend?
This short course is ideal for government staff with monitoring and evaluation responsibilities, project teams, NGOs staff, consultants, project managers, M&E specialists and researchers.

Course Content
Module 1: Introduction
• Data types- Qualitative and quantitative data
• Research designs in qualitative data and quantitative data collection and analysis
• Developing a logical framework
• Components of a logical framework
• Mobile data collection in Monitoring and Evaluation
• Introduction to common mobile based data collection platforms
• Data aggregation, storage, and dissemination

Module 2: Survey Planning, Implementation and Completion
• Types of surveys
• The survey process
• Survey design
• Methods of survey sampling
• Determining the Sample size
• Planning a survey
• Conducting the survey
• After the survey

Software for Data Processing, management and GIS mapping
• Data collections methods (Web, SMS, Mobile, Email, Social Media)
• Use of ODK 2 for Mobile Data Collection
• Importing ODK data into SPSS and Excel
• Exercise: ODK exercise.

Module 3: Mobile Phone-Based Data Collection
• Overview of available mobile phone based data collection platforms.
• Types of questions and their data types.
• Questionnaire/Form logic
• Extended data types geoid, image, and multimedia
• Survey Authoring
• Design forms using a web interfaces using:
• Hands-on Exercise
• ODK Build
• KoboToolBox
• Preparing mobile devices for data collection
• Installing application: ODK Collect
• Configuring the device (Mobile Phones)
• Uploading the form into the mobile devices

Module 4: Advanced survey Authoring: XLSForms
• Introduction to XLSforms syntax
• New data types
• Notes and dates
• Multiple choice Questions
• Multiple Language Support
• Hints and Metadata
• Conditional Survey Branching
• Required questions
• Constraining responses
• Skip: Asking Relevant Questions
• The specify other
• Grouping questions
• Skipping many questions at once (Skipping a section)
• Repeating a set of questions
• Special formatting
• Making dynamic calculations

Module 5: Hosting survey data: Cloud Hosting
• Google Apps Engine
• ODK Aggregate
• KoboToolbox
• Formhub
• Hosting Survey Data: Local Server Hosting
• Configuring ODK Aggregate on a local server
• Downloading data
• Manual download (ODK Briefcase)
• Using the online server interface

Module 6: Downloading Data and Introduction to Research Process
• Downloading data from server and exporting to Stata
• Overview of the research process
• Introduction to statistical concepts
• Descriptive Statistics
• Inferential statistics
• Types of research designs

Module 7: Introduction to Data management and analysis using Stata
• Overview of Stata Software
• Import, Export, load and save datasets
• Sorting and ordering
• Appending, merging and reorganizing datasets
• Identify duplicate observations
• Statistical Inference
• Correlation
• Simple linear Regression and Multiple linear Regression
• Comparing Means Using t-tests
o One Sample t-tests
o Paired Sample t-tests
o Independent Samples t-tests
Comparing Means Using One-Way ANOVA
• One-Way Anova
• General Linear Model to Calculate One-Way ANOVAs
• Exercises

Chi-Square
• Goodness of Fit Chi Square All Categories Equal
• Goodness of Fit Chi Square Categories Unequal
• Chi-Square for Contingency Tables
• Exercises

Nonparametric Statistics
• Mann-Whitney Test
• Wilcoxon’s Matched Pairs Signed-Ranks Test
• Kruskal-Wallis One-Way ANOVA
• Friedman’s Rank Test for k Related Samples
• Exercises

Module 8: Introduction to GIS
• Working with Spatial data (GPS Coordinates)
• Spatial Mapping
• Introduction to Fusion Table
• Exporting GPS Coordinates (Google maps) to Fusion tables
• Exporting data to Fusion tables using QGIS
• Converting data to shape files
• Integrating Mobile Data Collection tools into projects

Module 9: GIS mapping of survey data using QGIS
• Introduction to GIS for Researchers and data scientists
• Importing survey data into a GIS
• Mapping of survey data using QGIS
• Exercise: QGIS mapping exercise.
Module 10: Report writing for surveys, data dissemination, demand and use
• Writing a report from survey data
• Communication and dissemination strategy
• Context of Decision Making
• Improving data use in decision making
• Culture Change and Change Management

***************************
Training Customization
This training can also be customized for your institution upon request. You can also have it delivered your preferred location. For further inquiries, please contact us through:
• Phone: 254 732 776 700 or 254759285295
• Email: training@fineresultsresearch.org

Requirements
Participants should be reasonably proficient in English. During the trainings, participants should come with their own laptops.

Training Fee
The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.
Cost
In-person USD 2200
Online USD 1710
REGISTRATION
February in-person
April in-person
August in-person
October in-person

Accommodation
Accommodation is arranged upon request. For reservations contact us through phone: 254 732 776 700 or 254759285295 or Email: training@fineresultsresearch.org

Payment
Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org

Cancellation Policy
• All requests for cancellations must be received in writing.
• Changes will become effective on the date of written confirmation being received.