While obtaining my Master’s in Public Administration, I had the pleasure of taking on a project for a local non-profit. The Executive Director was tasked with creating a program evaluation tool for the board to use for annual summative assessment purposes.
I created a simple spreadsheet for the board to use to evaluate several parameters in 10 program areas, personnel/board, and revenue. I analyzed the program reports and interviewed the staff to determine what to measure. Using that information I created a tab for each sheet for each program. The program sheets contained quantifiable data with conditional formatting to visually track changes over time, and qualitative questions to direct further research.
This is a sample sheet:
Program evaluation is an important tool that nonprofits and governments can use to measure outcomes. Contact me today for assistance in this endeavor!