SSA Data Management, Analysis and Reporting Training
To download all training materials in a compressed file, please click here. To access individual files, see below.
Course Programme (Example)
Day 1
Day 1
Session | Time | Activity |
|---|---|---|
Introduction to the course | 08:30-10-00 | Opening remarks Objectives (Presentation) Methodology Ground rules Evaluation Group photograph |
10:30.11:00 | Tea/Coffee break | |
Database design | 11:00.13:00 | Structure: 30 min presentation; 1 hour exercise; 30 min discussion (Presentation) a. Defining data-base b. Excel database i. General rules ii. Defining variables iii. Coding and standardizations iv. Data cell validation and comments |
13:00-14:00 | Lunch break | |
Database management | 14:00-17:00 | Structure: 30 minutes presentation; 2 hours practice (in pairs); 30 minutes plenary discussion. (Presentation) a. Data entry errors i. Common mistakes b. Data verification and cleaning i. Number and text filters ii. Advanced filters iii. Forms check iv. Removing duplicates v. Verification using two or more variable values c. Deriving variables i. Column insertion ii. Calculations and common errors during derivation of variables Exercise 2: Data cleaning and deriving variables (Handout) (Example 1) (Example 2) |
Day 2
Day 2
Session | Time | Activity |
|---|---|---|
Recap | 08:30-09-00 | Reminding participants of the training content of the day before |
Data analysis using pivot tables | 09:00-13:00
10:30-11:00 | a. Presentation: Generating pivot tables (09:00 – 9:30) (Presentation) i. Field lists (filters, column, rows and values) ii. Creating tables iii. Sorting, filtering and statistical calculations b. Types of pivot tables (09:30 – 10:00) i. Simple pivot table ii. Two dimensional pivot table iii. Multi-level pivot tables c. Updating pivot tables (10:00 – 10:15) i. Refreshing ii. Changing data source Tea/Coffee break |
Presentations: Charts | 11:00-13:00 13:00-14:00 14:00-14:30
14:30-15:00 | Exercise 4.1: Pivot Table Analysis (Handout) (Exercise) Lunch break i. Creating, changing and switching chart type ii. Chart title, legend and data label iii. Standard deviation (STDEV) and error bars Exercise 4.2: Creating charts (Handout) |
Interpretation of pivot table results | 15:00-15:30
15:30-16:00 16:00-16:30 | Structure: Presentation a. Introduction b. Statistical significance c. Biases d. Confounding factors e. Sources of information to help with interpretation Tea/coffee break Exercise: 5.1: Interpretation of results (Handout) (Exercise) |
Day 3
Day 3
Session | Time | Activity |
|---|---|---|
Recap | 08:30-09:00 | Recap of Day 2 |
Analysis of qualitative data | 09:00-10-30 | Structure: Presentation (30 minutes) and Exercise (1 hr) (Presentation) a. Introduction b. Attributes of qualitative data c. Sources of qualitative data d. The five steps in qualitative data analysis Exercise 6.1. Analyzing FGD Recordings |
10:30.11:00 | Tea/Coffee break | |
Reporting | 11:00.13:00 | Structure: Presentation and discussion (Presentation) a. Introduction b. Principles of good reporting c. Structure of the report d. General Discussion |
13:00-14:00 | Lunch break | |
Closing ceremony | 14:00-15:00 | a. Closing remarks b. Presentation of certificate to attendees |
