| 01 · Plan |
Theory-of-change and logframe templates, documents, consultants |
The framework lands in a PDF nobody updates — it never becomes the schema the data is read against |
The framework is the schema — every response is read against it |
| 02 · Collect |
KoboToolbox, ODK, SurveyCTO, CommCare, SurveyMonkey, Google Forms |
Each submission is an independent event; no persistent record across cycles |
One persistent ID per participant at intake — offline, multi-language |
| 03 · Clean |
Excel, OpenRefine, Stata, manual matching |
Participants matched by name or phone — a reconciliation nobody fully trusts |
Deduplicated at the source; every response links to the right record |
| 04 · Analyze |
SPSS, Stata, R for quant; NVivo, ATLAS.ti, Dedoose for qual |
Quant and qual on separate tools, separate teams, separate timelines — they never meet |
AI reads the open text against your framework; story and number on one record |
| 05 · Report |
Word, PowerPoint, Power BI, Tableau, Looker Studio |
Assembled by hand from three to five systems — weeks per cycle, on data already stale |
Generated from the live record, against the framework — in a day |
| 06 · Learn |
Meetings, the next proposal — rarely a tool at all |
The loop restarts before the learning lands; nothing carries forward systematically |
The loop runs continuously — every cycle compounds the last |