This Excel-based tool helps a PPD secretariat or in dependent evaluator create an Evaluation Wheel (with a score from 1 to 10) along the 12 key processes that matter to a PPD.
On the same Excel-based tool, you will find the Reform Process Table which measures the impact of the PPD along the reform process in a given country, based on a score from 0 to 3.
The Evaluation Tool
This evaluation tool is designed to be used o a regular basis (every six months or so) by PPD facilitators to measure the effectiveness of the partnership on the three levels defined in the PPD M&E framework: 1- Organizational effectiveness, 2- Impact on the reform process.
It is based on Excel and is hence usable on any computer without the use of extra software. The tool will enable you to record a number of information in pre-formatted spreadsheets. In return, the system will generate automatically a number of visuals such as the evaluation wheel, the colored reform process table, etc. To start using the M&E tool, follow these easy steps:
The Evaluation Wheel
1. Download, save and open the Excel file called “PPD Evaluation Tool_2010.xlsx”. It will open on the first tab “PPD Evaluation Wheel”.
2. For Organizational Effectiveness, fill in the evaluation table with scores from 0 to 10 for each of the indicators. The evaluation wheel will automatically display.
The Reform Process Table
3. For the Reform Process tables, assess if the Private sector and the Government meet the pre-conditions for the steps of the reform process (1. Diagnostic – 2. Solution Design – 3. Advocacy and Handover to Public Sector – 4. Legislative and/or Executive Process – 5. Implementation, M&E, Follow-up) and to what extent the PPD has an impact on those steps (scale from 0 to 3). Do it for each reform, where ratings are function of scores given for private sector capacity, confidence and access and government capacity, willingness and opportunity.
4. Use this table to compare the score of each reform on each 5 steps. These scores are automatically fed from the previous reform process tables. Colors will be applied automatically depending on the score, from 0 to 3. The colored map is thus automatically generated and also provides the average score of the PPD for reform process impact.