INTRODUCTION

New developments in data science offer a tremendous opportunity to improve decision-making. In the development world, there has been an increase in the number of data gathering initiative such as baseline surveys, Socio-Economic Surveys, Demographic and Health Surveys, Nutrition Surveys, Food Security Surveys, Program Evaluation Surveys, Employees, customers and vendor satisfaction surveys, and opinion polls among others, all intended to provide data for decision making.

It is essential that these efforts go beyond merely generating new insights from data but also to systematically enhance individual human judgment in real development contexts. How can organizations better manage the process of converting the potential of data science to real development outcomes? This ten days hands-on course is tailored to put all these important consideration into perspective. It is envisioned that upon completion, the participants will be empowered with the necessary skills to produce accurate and cost effective data and reports that are useful and friendly for decision making.

It will be conducted using SurveyCTO, GIS, NVIVO and STATA

COURSE OBJECTIVES

• At the end of course participants should be able to:
• Understand and appropriately use statistical terms and concepts
• Design and Implement universally acceptable Surveys
• Convert data into various formats using appropriate software
• Use mobile data gathering tools such as SurveyCTO
• Use GIS software to plot and display data on basic maps
• Qualitative data analysis using NVIVO
• Workflow use commands in STATAManage, edit and structure large databases in STATA
• Generating descriptive statistics in STATA
• Creating powerful publication-quality graphs in STATA
• Data Analysis/Estimations in STATA
• Write reports from survey data
• Put strategies to improve data demand and use in decision making

DURATION

10 Days

WHO SHOULD ATTEND

This is a general course targeting participants with elementary knowledge of Statistics from Agriculture, Economics, Food Security and Livelihoods, Nutrition, Education, Medical or public health professionals among others who already have some statistical knowledge, but wish to be conversant with the concepts and applications of statistical modeling.

COURSE CONTENT

Module1: Basic statistical terms and concepts

• Introduction to statistical concepts
• Descriptive Statistics
• Inferential statistics

Module 2: Research Design

• The role and purpose of research design
• Types of research designs
• The research process
• Which method to choose?
• Exercise: Identify a project of choice and developing a research design

Module 3: 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
• Exercise: Planning for a survey based on the research design selected

Module 4: Introduction to SurveyCTO

• Introduction and Key Concepts
• Overview of ODK and Kobotolbox
• Advantages of SurveyCTO
• Key Features of SurveyCTO
• Case studies on use of SurveyCTO

Module 5: SurveyCTO Server

• Components of SurveyCTO
• Data aggregation, storage, and dissemination
• Setting up a SurveyCTO server
• Managing users & user roles

Module 6: Setting Up SurveyCTO Collect App

• Installing SurveyCTO collect from google play store
• Configuring SurveyCTO collect app
• SurveyCTO Collect Application Interface

Module 7: SurveyCTO Online Form builder

• Creating a form
• Input types
• Adding question to Form
• Form logics
• Import and export forms

Module 8: Building Forms using XLSForms

• Introduction to xlsform designer
• Components of XlSForm
• Question types
• Handling constraints and required options
• Form skip logic
• Form Operators and Functions
• Grouping Questions
• Settings Worksheet
• Importing xlsforms to surveyCTO server

Module 9: Using SurveyCTO Collect

• Managing forms in SurveyCTO Collect
• Collecting GPS data
• Submitting data to SurveyCTO Server

Module 10: Monitoring Data with SurveyCTO Data Explorer

• Monitoring Submission statistics
• Monitoring Form submissions and dataset
• Reviewing and correcting incoming data
• Summarize data submitted for individual fields
• Summarize the empirical relationships between field

Module 11: Data Management

• Exporting &Exporting data from SurveyCTO as CSV via SurveyCTO Sync
• Importing SurveyCTO – CSV file into statistical applications
• Downloading data directly from SurveyCTO

Module 12: Visualizing Geographic Data

• Exporting GPS Coordinates to Google maps and Google Earth
• Exporting GPS data for Mapping/Visualizing

Module 13: 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 14: Understanding Qualitative Research

• Qualitative Data
• Types of Qualitative Data
• Sources of Qualitative data
• Qualitative vs Quantitative
• NVivo key terms
• The NVivo Workspace

Module 15: Preliminaries of Qualitative data Analysis

• What is qualitative data analysis
• Approaches in Qualitative data analysis; deductive and inductive approach
• Points of focus in analysis of text data
• Principles of Qualitative data analysis
• Process of Qualitative data analysis

Module 16: Introduction to NVIVO

• NVIVO Key terms
• NVIVO interface
• NVIVO workspace
• Use of NVIVO ribbons

Module 17: NVIVO Projects

• Creating new projects
• Creating a new project
• Opening and Saving project
• Working with Qualitative data files
• Importing Documents
• Merging and exporting projects
• Managing projects
• Working with different data sources

Module 18: Nodes in NVIVO

• Theme codes
• Case nodes
• Relationships nodes
• Node matrices
• Type of Nodes,
• Creating nodes
• Browsing Nodes
• Creating Memos
• Memos, annotations and links
• Creating a linked memo

Module 19: Classes and summaries

• Source classifications
• Case classifications
• Node classifications
• Creating Attributes within NVivo
• Importing Attributes from a Spreadsheet
• Getting Results; Coding Query and Matrix Query

Module 20: Coding

• Data-driven vs theory-driven coding
• Analytic coding
• Descriptive coding
• Thematic coding
• Tree coding

Module 21: Thematic Analytics in NVIVO

• Organize, store and retrieve data
• Cluster sources based on the words they contain
• Text searches and word counts through word frequency queries.
• Examine themes and structure in your content

Module 22: Queries using NVIVO

• Queries for textual analysis
• Queries for exploring coding

Module 23: Building on the Analysis

• Content Analysis; Descriptive, interpretative
• Narrative Analysis
• Discourse Analysis
• Grounded Theory

Module 24: Qualitative Analysis Results Interpretation

• Comparing analysis results with research questions
• Summarizing finding under major categories
• Drawing conclusions and lessons learned

Module 25: Visualizing NVIVO project

• Display data in charts
• Creating models and graphs to visualize connections
• Tree maps and cluster analysis diagrams
• Display your data in charts
• Create models and graphs to visualize connections
• Create reports and extracts

Module 26: Triangulating results and Sources

• Triangulating with quantitative data
• Using different participatory techniques to measure the same indicator
• Comparing analysis from different data sources
• Checking the consistency on respondent on similar topic

Module 27: Report Writing

• Qualitative report format
• Reporting qualitative research
• Reporting content
• Interpretation

Module 28: Introduction to Statistical concepts and general analytics IN STATA

• Research design
• Samples and populations
• Comparison of experimental and non-experimental designs
• Exploring variable types

Module 29: Familiarizing with the application

• Datasets
• Commands
• Working with variables in Stata
• Basic analysis using Stata

Module 30: Charting and Graphical presentation using Stata

• Classifying different charts and processing them using STATA
• Understanding the Graph command syntax
• Graphs for categorical Vs Numeric variables
• Managing chart output in STATA
• Multivariate charting

Module 31: Statistical Tests using Stata

• One Sample T Test
• Independent Samples T Test
• Paired Samples T Test
• One-Way ANOVA

Module 32: Measures of Associations in Stata

• Chi-Square test
• Pearson’s Correlation
• Spearman’s Rank-Order Correlation

Module 33: Predictive Models using Stata

• Linear Regression
• Multiple Regression
• Logistic Regression
• Ordinal Regression

Module 34: Panel Data Analysis using Stata

• Exploration of panel data
• Fixed effects model/LSDV
• Random effects model
• Choosing the appropriate model

Module 35: Time Series Analysis using Stata

• Introduction to time series analysis using Stata
• Plotting a time series
• Seasonal differences
• Auto correlations
• Forecast models in Stata

Module 36: Econometric Analysis

• Econometric Analysis of cross-sectional data
• Econometric Analysis of panel data
• Econometric Analysis of time-series data

Module 37: 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
• Preparing a report for the survey, a communication and dissemination plan and a demand and use strategy.
• Presentations and joint action planning

GENERAL NOTES

• This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.

• Training manuals and additional reference materials are provided to the participants.
• Upon successful completion of this course, participants will be issued with a certificate.
• We can also do this as tailor-made course to meet organization-wide needs. Contact us to find out more: training@data-afriqueconsultancy.org
• The training will be conducted at DATA-AFRIQUE TRAINING CENTRE, NAIROBI KENYA.
• The training fee covers tuition fees, training materials, lunch and training venue. Accommodation and airport transfer are arranged for our participants upon request.
• Payment should be sent to our bank account before start of training and proof of payment sent to: training@data-afriqueconsultancy.org