Data Collection Analysis and Visualization Using ODK Stata and Quantum GIS

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: [email protected]

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: [email protected]

Payment

Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: [email protected]

Cancellation Policy 

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

Host or Publisher FineResults Research Services Nairobi, Kenya