Most Certified Public Manager® Programs include a "Capstone Project" that is typically a real 

world problem faced in the student's home agency that would benefit from a systematic application of the principles taught in the classroom.

The American Academy of Certified Public Managers (AACPM) has been recognizing the best to these projects over the years with the George C. Askew Awards.  You can view descriptions of the award winners here to get an idea of the types of projects undertaken.