Course Outline

Module 1: Basic statistical terms and concepts

Introduction to statistical concepts and GIS for Researchers

• Basic Descriptive Statistics
• Inferential statistics
• Introduction to GIS for Researchers

Sources of Data for Social Statistics

• Population and housing Censuses
• Sample enumeration in censuses
• Household sample Surveys
• Assessments
• Administrative records
• Other sources

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

Module 3: Concepts and Software for Data Processing, management and GIS mapping

• Data collections methods(Web, SMS, Mobile, Email, Social Media)
• Use of Mobile Phones for Data Collection and Processing (ODK)
• GIS mapping for Survey data
• Exercise: Project continuation: Preparing and using a data entry application for the mobile to the survey.

 Module 4: Introduction to Data management and analysis using statistical software

Exploring survey data

• Basic exploratory data analysis procedures
• Basic data quality checks
• Introduction to Excel for Data processing and Analysis
• Data Auditing and Validation using Excel
• Limitations of Excel

Tabulating and graphing survey data

• Tabulation and analysis planning
• File structure and datasets for tabulation and analysis
• Tabulations and Graphics using Excel
• Exercise: Project continuation; Preparing tables and graphics from the survey data

 Module 5: Quantitative Data Analysis using SPSS/Stata/R

Introducing Advanced Statistical software

• Comparison of Data analysis packages
• Overview of SPSS
• Overview of Stata
• Overview of R
• Introduction to stat transfer for converting data into other formats
• Exercise: Project continuation; Importing survey data into formats suitable for the reviewed software

 Module 6: Data Management (SPSS/Stata/R)

• Import, Export, load and save datasets
• Create new datasets
• Review and document the dataset
• Sorting and ordering
• Appending, merging and reorganizing datasets
• Validate data structure
• Identify duplicate observations
• Exercise: Data management for the survey data

Module 7: Graphics (SPSS/Stata/R)

• Tabulating Survey data
• Basics of graphing
• Graphing quantitative
• Graphing qualitative data
• Advanced graphing
• Exercise: Preparing suitable charts and graphs for the survey

Module 8: Advanced Data Analysis Part II (SPSS/Stata/R)

Statistical Inference

• Tests of Association
• Tests of Difference
• Hypothesis testing
• Exercise: Project continuation; performing suitable inferential test and drawing inferences

Module 9: Advanced Data Analysis Part II (SPSS/Stata/R)

Regression analysis

• Linear Regression
• Binary regression
• Logistic Regression
• GLM Model
• The Problems with regression
• Exercise: Modeling the survey data

Introduction to panel data analysis

• Advantages of panel data analysis
• Panel data sets
• Balanced and unbalanced panels
• Panel data dimensions and frequencies
• Properties of estimators
• Graphing panel data

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