ONLINE & IN-PERSON
This course utilizes three software: Excel, SPSS, and Stata.
COURSE INTRODUCTION
This Data Collection and Analysis course complements QRTC’s Monitoring, Accountability, Evaluation and Learning course. Humanitarian and development workers will be introduced to the fundamentals of quantitative data collection and analysis, including sample survey design, interviewing, and associated techniques for analysis in support of project-based monitoring and evaluation. This course will be helpful for those with modest experience in monitoring and evaluation and fresh university graduates who are willing to advance his/her soft skills so that they can easily settle for decent and deserved jobs. Participants are encouraged to come to the course with an instrument and/or associated protocols for analysis that can be developed. This should be viewed as an advanced course on data analysis and will address the Relationship between Two Different Quantitative Variables and Multivariate Analysis using correlation and regression analysis. The course is entirely hands-on and uses SPSS, Stata and Excel sheet advanced functions as tools of data analysis.
WHO WILL FACILITATE THE TRAINING?
The course facilitator has around 12 consecutive years of Monitoring, Evaluation, Accountability, and Learning experience at different organizations including Save the Children International, World Vision International, Health Poverty Action (formerly known as Health Unlimited), and Caritas Switzerland and Luxemburg among others with his current role being a MEAL Manager. His primary area of focus revolves around developing and implementing the project Monitoring, Evaluation, Accountability, and Learning (MEAL) systems; taking the lead on the compilation and analysis of program data and learning; designing and conducting research; and setting up and implementing accountability mechanisms. In addition to his hands-on experience in this field, he is the only known well-versed practitioner in Somali-speaking countries who has a Master’s Degree in Monitoring and Evaluation at Mount Kenya University. He also earned his Bachelor’s degree in Statistics and Mathematics with distinction at the University of Hargeisa.
DETAILED TRAINING CONTENTS:
Module 1: Data Field Work Management
- Introduction to sampling methods: simple random, stratified and cluster
- Introduction to nonprobability sampling methods (quota, purposeful sampling and snowballing sampling)
- Introduction to cross-sectional sample-based household surveys
- Questionnaire construction (facts, actions, behavioral and attitude sections)
- Data collection fieldwork Management
- Quality control mechanism put in place during fieldwork
- Utilization of Mobile data collection platforms (Kobo collect) and ODK in the field.
Module 2: Demystifying SPSS Data Entry and Data Analysis
- Introduction to SPSS software uses
- Software installation
- Understanding the basic function of: data view and variable view (variables and records)
- Create a great data entry template on SPSS with a strong focus on coding and scale of measurement
- Familiarize yourself with data, syntax, and output features
- Data analysis using SPSS and producing reports
Module 3: SPSS/Stata Data Analysis Using Basic and Advanced Techniques
- Running Frequency counts
- Running Descriptive statistics such as mean, percentage, and standard deviations)
- Presentation of data with the support of Graphs, tables, and Charts
- Split files and select cases to do specific data analysis for sub-groups
- Doing inferential statistics using one variable:- sample-t-tests and confidence intervals and two –sample-test- tests, paired-samples-t-tests
- Doing inferential statistics using more than two variables: correlation and regression analysis (simple and multiple)
- Exercise: SPSS data analysis project
Module 4: Excel Data Analysis Using Basic and Advanced Techniques
- Create excel Data entry with all data validations
- Running Descriptive statistics using Pivot tables, filtering methods, and counting if functions
- Presentation of data with the support of Graphs, tables, and Charts
- Activate Excel application Add-ins to incorporate data analysis tool pack where all inferential functions are stored in the Excel sheet
- Doing inferential statistics using one variable:- sample-t-tests and confidence intervals and two –sample-test- tests, paired-samples-t-tests
- Doing inferential statistics using more than two variables: correlation and regression analysis(simple and multiple)
- Exercise: Excel data analysis project
Module 5: Report Writing skills using analysed data
- Report writing in the key achievement reports
- Write up for study reports such as needs assessment, baseline, and evaluation studies
- Separate data analysis for Qualitative and qualitative but interpreting them together.
- How to use analyzed data in Monitoring and Evaluation
- Exercise:Report Writing using FGDs and Survey data
COURSE APPLICATION PROCESS
In-person Class Fee
- We charge 70 dollars for the physical classes covering (the facilitator fee, course completion certificate training materials-presentations, and rich reading materials with linked videos) to the participants who attend in-class training.
- We also have flexible and self-paced classes for online trainees with recorded course lectures
Online Class Fee
- For the online trainees, they just need to pay 40 dollars and get a course completion certificate and training materials-presentations and rich reading materials with recorded video lectures in Somalia by our facilitators together with regular mentoring and coaching for a minimum of 30 days including free job application guidance if needed
- The online classes will be open to all interested participants who have internet access in the greater Horn of Africa (Somalia, Somaliland, Kenya, and Ethiopia among other countries).
Discounts
- A group of three people who will be attending the same course at a time will have a discount of 17%.
Payment Methods
- Payment modes: deposit at ZAAD/Edahab:633499969 or Dahabshil account Hargeisa 32342 before respective courses deadlines.
- Use the Register/Join button below to register for classes
Help
- In case you need further details about the MEAL course or any other information kindly feel free to reach us at +252633499969 or What sup texts.
ONLINE
$40
IN-PERSON
$70
Register for this course and develop yourself professionally
Additional Information
WHO SHOULD ATTEND THIS COURSE?
This is a general training targeting variety of programme management staff, government officials, middle-level managers, policy makers and project officers working in different settings. This training also is a great eye-opening opportunity for unemployed and fresh graduates who are willing to advance his/her soft skills so that they can easily settle for decent and deserved jobs.
THE TRAINING DURATION
This is a 5-day-long training with 3 hours of 50% theory and 50% practical sessions for each day. We have also flexible and self-paced classes for the online trainees with recorded course lectures. The course always takes one month.
TRAINING OBJECTIVES
- Develop skills required for Analysing quantitative data (descriptive statistics)
- Fully equip yourself with versatile data analysis software: SPSS and Excel
- Familiarize yourself with quantitative research methods and survey design
- Equip participants with an understanding of the data entry templates and best practices involved in data, data analysis, and data usage
- Provide participants with effective rules of thumb and a framework to do advanced data analysis techniques-regression analysis
- Provide training participants with basic Report writing skills on utilizing key performance indicators in the project log frames.