Methodology and Software for Processing and Analyzing surveys and Assessments data SPSS Stata Excel ODK

Course date: 14/10/2019 to 18/10/2019 Duration: 5 Days Course fee: USD 800, KES 65,000

INTRODUCTION

Research, Data Management, Graphics & statistical analysis has always been integral parts of development work and has been playing a critical role towards achieving of Sustainable development Goals (SDGs). As a result, knowledge of research methodologies and application of statistical application software's to support data analysis in this era is very important. Statistical Packages for Social Sciences (SPSS) and STATA software has proved to be quite useful for the purpose of data management, graphical representation, and statistical analysis of data. Both software are user-friendly, reduces the time and efforts of the researcher employed in the process research. This course aims at equipping participants with knowledge and vast skills which will enable them to use SPSS and STATA in Data Management, Graphics & statistical analysis. At the end of the course, participants will become familiar with using ICT tools and methods to conduct data collection, statistical analysis and reporting.

 

DURATION

5 Days

 

LEARNING OBJECTIVES

By the end of the training, you will be able to:

  • Understand both descriptive and inferential statistics
  • Understand various data collection techniques and data processing methods
  • Use mobile phones for data collection(Open data Kit)
  • Use basic functions and navigation within Stata and SPSS software
  • Create and manipulate graphs and figures in Stata and SPSS software
  • Handle statistical data analysis tasks in Stata and SPSS software
  • Export the results of your analyses.

 

TOPICS TO BE COVERED

Module 1:

Introduction

Mobile Data gathering

  • Benefits of Mobile Applications
  • Data and types of Data
  • Introduction to  common mobile based data collection platforms
  • Managing devices
  • Challenges of Data Collection
  • Data aggregation, storage and dissemination
  • Questionnaire Design

Getting started in ODK

  • Types of questions
  • Data types for each question
  • Types of questionnaire or Form logic
  • Extended data types geoid, image and multimedia

 

Survey Authoring and Preparation of mobile phone for data collection

Survey Authoring

  • Design forms using a web interface using:
    • ODK Build
    • Koboforms
    • PurcForms

Preparing the mobile phone for data collection

  • Installing applications: ODK Collect
    • Using Google play
    • Manual install (.apk files)
  • Configuring the device (Mobile Phones)
  • Uploading the form into the mobile devices
  • Hands-on Exercise

 

Designing forms and advanced survey authoring

Designing forms manually: Using XLS Forms

  • Introduction to XLS forms syntax
  • New data types
  • Notes and dates
  • Multiple choice Questions
  • Multiple Language Support
  • Hints and Metadata
  • Hands-on Exercise

Advanced survey Authoring

  • 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

 

Hosting survey data

Hosting survey data (Online)

  • ODK Aggregate
  • Formhub
  • ona.io
  • KoboToolbox
  • Uploading forms to the server

 

 

Module 2:

Research, Data management and Statistical Analysis using Stata

Introduction

  • Introduction to Statistics Concepts
  • Concepts and Software and technologies for Data Collection and Processing
  • Stata Basics
  • Data Structures and Types of Variables
  • Data Management using Stata
  • Output Management
  • Basics of stata programming
  • Tabulating data with Stata

 

Descriptive Statistics

Measures of Variability and Central Tendency  

  • Describing quantitative data
  • Describing qualitative data

 

Stata Graphics

  • Graphing quantitative data
  • Graphing qualitative data

 

Correlation, Chi-square and mean comparison analysis

Correlation  

  • Correlation
  • Subgroup Correlations
  • Scatterplots of Data by Subgroups
  • Overlay Scatterplots

 

Chi-Square 

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

 

Comparing Means

  • One Sample t-tests
  • Paired Sample t-tests
  • Independent Samples t-tests
  •  Comparing Means Using One-Way ANOVA 

 

Comparing Means Using Factorial ANOVA 

  • Factorial ANOVA Using GLM Univariate
  • Simple Effects

 

Module 3: Regression Analysis and Nonparametric Statistics 

Regression Analysis

  • Assumptions of selected types of regression
  • Linear regression; Binary logistic regression; ordered logistic regression; multinomial logistic regression and Poisson regression

 

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

 

Longitudinal/panel and Time series Analysis

Panel data analysis

  • Introduction to panel data
  • Longitudinal/panel data analysis

 

Time series Analysis

  • Basic elements of time-series analysis
  • Managing and summarizing time-series data
  • Time series data analysis
  • Introduction to forecasting

 

 

Module 4:

Research, Data management and Statistical Analysis using SPSS

Statistical Concepts and Overview of SPSS

Statistical Concepts

  • Descriptive Statistics
  • Common inferential statistics

 

Overview of SPSS

  • SPSS window-dialog boxes
  • File Extensions (new, Open, Open Datasets)
  • Save, Save As, Import and exporting datasets
  • Creating and editing a data file

 

Data Entry/Management, Descriptive Statistics and Graphics

Data Entry/Management

  • Entering categorical and continuous data
  • Defining and labeling variables
  • Validation and Sorting variables
  • Transforming, recording and computing variables
  • Restructuring data
  • Replacing missing values
  • Merging files and restructuring
  • Splitting files, Selecting cases  and weighing cases
  • Syntax and output

 

 

Descriptive Statistics: Measures of Variability and Central Tendency  

  • Describing quantitative data
  • Describing qualitative data

 

Graphics using SPSS

  • Chart Builder
  • Graphing quantitative and qualitative data

 

Quantitative Data Analysis (Part I)

Correlation  

  • Correlation
  • Subgroup Correlations
  • Scatterplots of Data by Subgroups
  • Overlay Scatterplots

 

Regression Analysis

  • Assumptions of selected types of regression
  • Linear regression; Binary logistic regression; ordered logistic regression; multinomial logistic regression and Poisson regression

 

Comparing Means

  • One Sample t-tests
  • Paired Sample t-tests
  • Independent Samples t-tests
  • Comparing Means Using One-Way ANOVA 

 

Module 5:

Comparing Means Using Factorial ANOVA 

  • Factorial ANOVA Using GLM Univariate
  • Simple Effects

 

Comparing Means Using Repeated Measures ANOVA 

  • Using GLM Repeated Measures to Calculate Repeated Measures ANOVAs
  • Multiple Comparisons

 

Quantitative Data Analysis (Part III)

 Chi-Square 

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

 

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

 

 

 

 

***************************

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 Mobile: +254 732 776 700 or 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.

 

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact us through Mobile: +254732776700

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.

 

Course Date: 14/10/2019 to 18/10/2019 Duration: 5 Days Course fee: USD 800 , KES 65,000
Call us on +254 732 776 700
Book your Training (Training Calender)
Follow us