EPA 302 - Projections and Simulation Models: Methods and Techniques

9 April 2018 to 20 April 2018
Application deadline: 
15 January 2018
Training location: 
Paris (France)

Course objectives

To offer an advanced level of specialization in projection and simulation models techniques in order to support educational planning and formulation of educational strategies. 

At the end of the course, participants should be able to:

  • Explain the different concepts and projection techniques commonly used in educational planning;
  • Use techniques and methods required to construct simulation models containing the basic data, the projection framework and the functions needed to calculate projection;
  • Revise simulation models according to various changes of the education policies.


  1. Key concepts and use of projections and simulation models in educational planning: This component explains the usefulness of projections and simulations for educational planning and management and in informing policy dialogue; and discusses the current concepts and different simulation models. (1 day)
  2. Building a simulation model: projecting enrolment and human, physical and financial requirements: The component presents how: to organize the essential steps of projection of future enrolments and of the human, physical and financial needs at all the levels of education; to build and manage the simulation model, based on an Excel file, containing the basic data and the projection framework; to make and apply calculation formulas and use the computerised functions needed to calculate enrolment projection and human, physical and financial needs. (5 ½ days)
  3. Modifying and updating a simulation model: Simulation models in educational planning need not only to be yearly updated, but to be also often adapted to changes in educational policy objectives. Participants will learn how to keep a simulation model up-to-date and still relevant after changes in educational policy or organization of the educational system. (3 ½ days)


Master Excel workbook environment