Data Collection Plan

Help Greater Ishpeming Commission on Aging identify their program’s success metrics and teach them how to collect and analyze data to regularly measure the effectiveness and impact of their programs.
Greater Ishpeming Commission on Aging
Ishpeming, MI, USA
Log in to follow
Greater Ishpeming Commission on Aging
Ishpeming, MI, USA


Live Projects


Matched Projects

Posted September 19th

Share this project:

Project details

What we need
  • A set of key metrics to regularly track
  • Spreadsheet tool to collect data on key metrics with accompanying tables and graphs for analysis
  • Training for best practices on data collection
  • Training on how to use the spreadsheet and analyze key metrics
  • Note: This project does not include data entry or analysis
Additional details

I am new to our non-profit. I have taken on a position that has to collect and report data back to funders for payment. What I have inherited are a collection of different excel spreadsheets that have formulas that are not collecting the true data we are looking for. I am looking to create a cleaner and more efficient process for data collection. This will help reduce the amount of work we do right now for reporting out results.

What we have in place
  • We currently have Microsoft 365 and use Excel for all data collection, which should make it easy for you to get started. We also have Access to help us hopefully create a cleaner process, and the ability to provide any other information you need.
How this will help
This project will save us $6,868 , allowing us to better serve our current population and report to our donors a more accurate depiction of the true number of clients we are serving.

Right now we have to report the total clients served and the unique number of clients along with the total number of units we provided serve for. This comes to myself the ED from multiple reports that I then hand enter into and excel spreadsheet that then goes into another spreadsheet. I am hoping to achieve a cleaner more efficient process to reduce time and a more accurate report.

Project plan

Prep: Initial Conversation, Defining Success & Goal Setting
  • Volunteer Manager shares relevant materials describing their programs
  • Professional facilitates conversation with Volunteer Manager to determine what constitutes program success
  • Professional and Volunteer Manager agree on goals, timeline, and next steps for the project
Milestone 1: Professional Identifies Key Metrics
  • Professional comes up with a set of key metrics to track
  • Professional outlines how to track each metric, including frequency of measurement and unit of measurement
Milestone 2: Data Collection & Analysis Tool Created
  • Volunteer Manager provides feedback on the suggested metrics
  • Professional incorporates feedback into final set of metrics
  • Professional creates a spreadsheet for Organization to collect data, along with relevant tables and graphs to help analyze data
Milestone 3: Team Training Session
  • Professional trains team members how to collect the data points and enter them into the tool
  • Professional trains team members how to run reports and use them for analysis
Show more

About the org

Greater Ishpeming Commission on Aging
Posted by
Ashley R.

Executive Director

Our mission

The Greater Ishpeming Commission on Aging is a private non-profit corporation that advocates for and provides services to those sixty years and older who reside in the city of Ishpeming, and the townships of Ishpeming, Ely, Tilden, Humboldt, Champion, Michigamme and Republic.

What we do

The goal of our services and programs is to promote the independence, safety, dignity, and well-being of older adults. Services are provided to allow them to remain living independently in their homes and avoid or delay unnecessary placement in long term care facilities.
Case Worker Services
Transporation assistance
Medicare and Medicaid Assistance Program
Outreach work
Homemaking and Chores services
Activities in the center include: Cribbage, Mahjong, Pinochle, coffee clutch, Congregate Meals, Art Club, Chair Yoga, Senior Aerobics and more!

The pixel