Friday, 14.00-15.00 (Balcony E)

Excel and mobile collection: The 20 skills that solve 80% of M&E problems. Leslie Sage, DevResults
As use of mobile collection tools has grown, so have the snags in linking data sources to indicator results. These hurdles can be addressed before data is ever collected with a few design considerations in mind. Participants will walk away with understanding of the 10 most common pitfalls in designing M&E plans and tools, plus expertise in the 10 most useful Excel skills for managing data. This collection of tips and tricks comes from years of experience in helping scores of projects re-organize their data and structure their surveys. Anyone can implement these few practices to cut time spent on data wrangling, to reduce human errors, and to make data more useful for decision-making. Whether the goal is to manage data in Excel, ArcGIS, DevResults, or any other platform, these skills and concepts will save time and streamline the path from survey to insight. This hands-on session is suitable for any beginner- or intermediate-level practitioner who uses spreadsheets, or anyone who makes beneficiary surveys or reporting templates for data. If you don’t learn something useful, you’ll be refunded two chocolate bars for your time. 

Session Level:

Beginner, Intermediate

Session Details:

As use of mobile collection tools has grown, so have the snags in linking data sources to indicator results. These hurdles can be addressed before data is ever collected with a few design considerations in mind. Participants will walk away with an understanding of the 10 most common pitfalls in designing M&E plans and tools, plus expertise in the 10 most useful Excel skills for managing data. This collection of tips and tricks comes from years of experience in helping scores of projects re-organize their data and structure their surveys. Anyone can implement these few practices to cut time spent on data wrangling, to reduce human errors, and to make data more useful for decision-making. Whether the goal is to manage data in Excel, ArcGIS, DevResults, or any other platform, these skills and concepts will save time and streamline the path from survey to insight. This hands-on session is suitable for any beginner- or intermediate-level practitioner who uses spreadsheets, or anyone who makes beneficiary surveys or reporting templates for data. If you don’t learn something useful, you’ll be refunded two chocolate bars for your time.

Session Resources:

Session Leads:

Dr. Leslie Sage, Director of Data Science, DevResults. As the Director of Data Science at DevResults, Leslie helps organizations create or refine systems for turning development work into organized, accessible, meaningful data. In her previous life, she earned a PhD in microvascular physiology at the University of Bristol in England. Tired of rain, she headed home to serve as Deputy Director of Data for the 2012 Obama campaign in Iowa. In the last four years at DevResults, Leslie has trained folks in data management in 15 countries on 5 continents, ranging from small NGOs with a handful of staff to billion-dollar USAID missions. With this breadth of exposure to challenges in data management and analysis, Leslie has assembled the key concepts and skills that individuals can employ in organizations of any size to work faster and smarter with M&E data. She’s passionate about inflicting them on anyone who will look at her spreadsheets. More about Leslie here and at DevResults.