Module 12: Understanding how to input data into the RAP worksheets (advanced session)

Objectives

This module explains how to obtain input data (related to population, labour market, macroeconomics, general government operations) and fill the POP, EAP, ECO and GGO worksheets of the RAP. These worksheets are identified by their blue colour, and include historical and projected data. In a country, historical data may be available at several sources, but projections may have to be made by users. The module also includes hands-on exercises to practice filling of input RAP worksheets.

Key questions

What is the structure of the ILO RAP model?
What are the main sources of historical data and projections?
Dealing with POP:
- How to project the population?
- How to calculate survivors, newborns and migrant population?
Dealing with EAP and LPR/AR:
- What are the parameters of the labour market?
- How to project labour market data and unemployment rate?
Dealing with ECO:
- How to project GDP and the GDP deflator?
Hands-on exercises

Takeaway message

To fill in the POP, EAP, ECO, and GGO worksheets of the RAP model, it is necessary to collect historical data on population, labour force participation rate and EAP, employed and unemployed persons, unemployment rate, GDP at constant and current prices, productivity, consumer price index, and so on. It is also necessary to get projections for this data or make the projections, if the available data is unavailable or unreliable. It is important to understand the indicators and their interrelationships, in order to be able to collect and project the data, and check its coherence.

Master module 12: Understanding how to input data into the RAP worksheets (advanced session)

Modules prepared for other countries >>

Presentations

Asia: Advanced Session on using the RAP

Myanmar - Introducing the Rapid Assessment Protocol: Facilitator Training

Presentation for other countries >>

Didactical material

Instruction sheet: Hands-on advanced RAP exercises

Exercises (in Excel) and solutions

Videos

Part 1. Collecting POP and EAP data

Part 2. Exercises No. 1 to 3

Part 3. ECO worksheet and exercise No. 4

To participate, you have to log in first

In Myanmar, a training on advanced RAP features was organized prior to the national dialogue workshop on costing for a small group of key facilitators. This process highly contributed to smooth the national dialogue on costing and help national constituents to better understand the model with facilitators in each group (health, children, active age, old age).

08.01.2015 - Lou Tessier

General: Module 12 (input data) should come before Module 11 (calculating the cost)

12.02.2015 - Loveleen De

General: Results of the costing should not be given only through the additional cost to complete a social protection floor, but should give an estimate of how much it would cost in total to achieve a social protection floor (including already committed social protection expenditures). As a leader of the process, it is important to find key benchmark to compare the cost of a social protection floor with comparable indicator, for instance current or past social protection expenditures, international benchmarks, etc¿ For this the World Social Protection Report can be useful source of information. In Mongolia, after comparing the low and high scenarios, the national dialogue agreed on a social protection floor definition, i.e. only final SPF package. For this reason, the conclusions of the ABND report only emphasize on one cost.

25.05.2015 - Céline Peyron Bista