BPCLEtool is able to produce a number of reports from your completed assessment, which can be downloaded. All BPCLEtool reports can be downloaded as PDF documents; the data reports can also be downloaded as comma-separated value (CSV) files. There are presently four reports that are automatically generated:
This report presents the rating scores assigned to the map nodes (in the preliminary assessment and detailed assessment steps) in two formats:
- Pie chart –these charts show the proportion of nodes in each map that were rated “Does not exist”, “Average or below”, “Above average”, or “Not Applicable”. There is also a pie chart for the overall assessment. There is also a pie chart for the overall assessment. The pie chart view allows you to determine at a glance which element your organisation has the most/least problems that need to be addressed.
- Bar chart – these charts show the rating given to each item within each map, presented in a linear array. Since the linear array roughly represents the map items from top to bottom, left to right, this view allows you to see whether there are regions of the map that are particularly problematic. This view is also useful for comparing two different assessments. The data that was used to generate the charts can be downloaded as a PDF or CSV file. The CSV data can then be imported into Excel to conduct further analysis.
This report presents all information entered for each of the node cards included in the action plan, which can then be downloaded as a CSV file.
This report presents the list of indicators that were selected by your organisation. If you have not made any changes to the indicator recommendations made by BPCLEtool, then this report will reflect the original list; otherwise, the list will reflect your selections. The report also includes the summary tables showing the indicators you have selected by category and by type. The report can be downloaded as a PDF or CSV file.
Completed Program Logic Maps
This report shows the completed maps for each element of the framework, including the results of the rating steps. This report can only be downloaded as a PDF file and needs to be printed on A3 paper (or larger).
Watch the video tutorial for a demonstration of how to use the assessment report functionality of BPCLEtool.
How to open CSV files in Microsoft Excel
BPCLEtool reports in CSV format can readily be opened in Microsoft Excel, which will allow you to further work with the data, to create your own graphs, or to compare assessments.
If Microsoft Excel has been installed on your computer, a CSV file should open automatically in Excel when the file icon is double-clicked. If you are getting an “Open With” prompt when opening the CSV file, choose Microsoft Excel from the available programs to open the file with.
Alternatively you can open the Microsoft Excel application and then click File>Open, and select the .CSV file. If the file is not listed, make sure to change the file type to be opened to Text files (.prn, .txt, *.csv).