FAO.org

Home > In Action > Food Security Capacity Building > Project components > Seeds > SSA Data Management, Analysis and Reporting Training
Food Security Capacity Building

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.

Daily Registration

Participant Registration Form

Daily Attendance Sheet

Evaluation Sheet

Session Evaluation

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

c. Exercise 1: Designing data base (Handout) (Example)

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