150 likes | 251 Views
USING INNOVATION TO DOCUMENT PROJECT IMPACT IN VOLATILE SITUATIONS. Haron Njiru Kenya Email: haron.njiru@gmail.com. OUTLINE. Somali Puntland project Monitoring challenge E-convenience Conclusion. SOMALI. Semi-arid country ~ 2% arable Irregular rainfall & recurring draught
E N D
USING INNOVATION TO DOCUMENT PROJECT IMPACT IN VOLATILE SITUATIONS Haron Njiru Kenya Email: haron.njiru@gmail.com
OUTLINE • Somali • Puntland project • Monitoring challenge • E-convenience • Conclusion
SOMALI • Semi-arid country ~ 2% arable • Irregular rainfall & recurring draught • Perennial civil war & armed conflicts • Clan allegiances • Competition for resources • => Tension, weak infrastructures… • Dec 2004 massive tsunami - coastal strip of Puntland Somalia
PUNTLAND PROJECT • Communicable diseases prevention and control interventions–Jointly by Merlin, WHO, MoH in 2005 • Epidemic prone diseases identified • Acute watery diarrhea/cholera, bloody diarrhea, malaria, measles and meningitis • Coverage • 32 sentinel sites
Project strategy • Strengthen disease surveillance • Emergency preparedness • Effective response to outbreaks • Quality timely data for decision making • To minimize mortality and morbidity • Reporting key to success • Sentinel sites provided with computers • Local staff trained on case definitions, • Case management & data collection • Weekly compiling of cases & deaths
CONFLICT & MONITORING • Insecurity • No global/comprehensive analysis in 4yrs • 3,244 weekly reports generated by Jun ’07 • Inconsistent formats , Some incomplete • Not all submitted to higher levels in time • No analysis at source, No trends identified • No automation - no formula, no graphs, just numbers • Impossible to detect & respond to outbreaks in time • Case summaries – Dec 2007
Analysis cumulated data – Dec 2007 Cases reports between 2005 and 2007
Site A Sheet 1 Sheet 5 Site B Sheet 2 Sheet 6 Site C Sheet 7 Sheet 3 Site D Sheet 8 Site E Site F Rapid outbreak alert system • Simple Ms Excel database • Standard & compact – ease comparison / sharing Region Sheet 4 Data from all sentinel sites Region Sheet 9(Total for +) 1 workbook
Sentinel sites Region 2 Sentinel sites Region 1 Total all regions
Data entry error reduction • Minimal training – calendar & ‘BLANK’ for missing data • Lean - entries, calculated entries, Auto calendar • Errors – few entries, (protected) formula for data integrity • Paper backup – Just in case
Side benefits • Decentralized decision making • Dse specific hotspots easily identified • Computer lessons • Access to Internet • Easy reporting • Time saving – no arithmetic
CONCLUSION • In volatile situations • Go electronic: e-convenience vs. inconvenience • Automated analysis – tension and inaccuracy • Lean data – collect only essential, 1 e-file • Clean at source – skips & formulas to reduce errors • Empower local staff - Analysis & Decision making
THANK YOU Haron Njiru haron.njiru@gmail.com