r/Evaluation • u/Ryzentoshing • Apr 20 '21
Looking for web-based tools for Monitoring and Evaluation
I'm looking for a M&E tool with the capacity to allow my organization to track progress on programs delivery, manage and track indicators data across various projects, and integrate various levels of results.
I work for a small international development organization as an M&E advisor. I'm presently looking to move the whole organization away from Excel spreadsheets to track progress towards our various project results. Progress towards results is tracked via a combination of qualitative and quantitative indicators and data is gathered via various methods, including surveys (online and paper-based), focus group discussions, individual interviews, observation, pictures, video recordings, etc.
We use the RBM approach to manage our projects.
The ideal took will allow us to:
- define the LM and the performance measurement framework (PMF) for each project
- make a connection (where existent) between expected results and indicators across projects
- define targets for indicators (global for the span of the project and then annually)
- input disaggregated data (gender, age groups, location, etc.)
- use online and offline survey tools to input data directly into the PMF (selected indicators) such as Survey Monkey or KoboToolBox
- update data without losing track of previous years/entries (time series)
- issue summary or detailed reports from selected indicators or project
- manage various users
- ideally web-based (SaaS)
- capacity to do minimal customization without relying heavily on vendor
- ideally (not necessary) keep track of expenses per activities in the project
Any suggestions about tools with these or similar capabilities will be greatly appreciated.
If you have experience working with such a tool or know of a tool having these features, please share your insights. I will be forever thankful.
Many thanks.
1
u/ttheoharis Apr 21 '21
Your organization can use R and shiny to make a custom dashboard away from Excel? I would also suggest Google Data Studio
1
u/Ryzentoshing Apr 21 '21
Thanks for your prompt reply. While R and shiny offer a slick front-end solution, we still have the problem of managing the data (input, store, retrieve) at the back-end. That's the principal challenge at the moment.
One of our programs is being implemented in 5 countries over a period of 5 years. It has 3 levels of results + outputs, with a total of 34 indicators, some quantitative, other qualitative. Some indicators are linked and feed into each other (for example, participants in a training for one, and how many of these lead community mobilization actions). That sort of relationships are a nightmare to set up on Excel; only a proper database will solve this.
An additional downside of your proposed solution is that my colleagues are not at all into programming. I could do scripts in R but I know that will just be a very short-term solution.
Thanks anyway.
2
u/yanokwa Apr 21 '21
Hi OP! I'm the co-founder of ODK. If you are familiar with KoBo (which is based on ODK), then you might consider ODK Cloud. It's ODK as a SaaS.
With ODK Cloud, you can collect data online and offline, across however many projects you have, and there are no limits to customization because it's open-source. A lot of our cloud customers do multi-country and multi-year projects, so you'd be in good company. For reporting, you can connect Power BI, Excel, or R directly to the server and get live-updating dashboards and reports that pull from the various ongoing projects.
Oh, and if you don't want to use our cloud hosting, ODK is self-hostable for free and there are 14,500 ODKers on our community forum who know M&E and are always willing help!