Certified Trainings on Results-based Monitoring and Excel in Kigali!

Rating: 
Average: 4.8 (26 votes)

Certified Trainings on Results-based Monitoring and Excel in Kigali!

The One-Stop-Monitoring-Shop Kigali is inviting you to join its certified hands-on trainings “Theory of Change and Results-based Monitoring” and “Excel Tools for Results Monitoring” in Kigali! Book the two-weekend sessions separately or as a discounted package. The training is meant for M&E professionals and professionals-to-be in the nonprofit sector, or those concerned with results-based management, project planning, data analysis, and reporting. It's time to upgrade your M&E skills to 2.0!

Summary

Theory of Change and Results-Based Monitoring

Saturday, 27 April 2019, 8.00 – 16:30

Sunday, 28 April 2019, 8.00 – 16:30

Excel Tools for Results Monitoring

Saturday, 11 May 2019, 8.00 – 16.30

Sunday, 12 May 2019, 8.00 – 16.30

Both trainings will take place at Business Heights Center in Kacyiru, Kigali. Directions will be provided in the confirmation e-mail. Participants will receive a certificate to confirm their completion of the trainings.

Content

Theory of Change and Results-Based Monitoring

DAY 1

  • Problem-and-solution case study
  • Principles and elements of Theory of Change (ToC)
  • Examples of ToC
  • Group work case study with discussion
  • The context of ToC: Theory of Change, results chain, log frame

DAY 2

  • Key concepts and functions of results-based monitoring
  • Indicators
    • Theory and examples
    • Hands-on exercise
  • Five steps to build a results-based monitoring system
  • Case study group work
  • IT tools for results monitoring
    • Selecting the right toolset for data collection, analysis, visualization, and monitoring management.
    • Comparison of software approaches, including Excel
  • Discussion and takeaways

Excel Tools for Results Monitoring

DAY 1

  • Presentation of sample Excel tools with dashboards
  • Structure and philosophy of smart Excel tools
  • Hands-on exercise on data entry
    • Data validation
    • Protection of cells and sheets
    • Data importing
  • Hands-on exercise for data analysis
    • Comparisons and sums
    • Functions: IF, SUMIF, COUNTIF
  • Recap, Q&A

DAY 2

  • Presentation & discussion: Options for building dashboards: Manual, Pivot and Power Bi
  • Hands-on exercises on visualization
    • Conditional formatting
    • Traffic lights
    • Diagrams
  • Master piece: Building a dashboard
  • Discussion: Strengths and weaknesses of Excel for monitoring and reporting
  • Other software options for managing M&E data
  • Takeaways

Registration and Fees

Please use the following links to sign up for the trainings:

  1. Theory of Change and Results-Based Monitoring:
  2. Excel Tools for Results Monitoring

Participants who book both trainings will receive priority. There are no participation requirements for monitoring training. But the Excel training requires basic Excel skills (please see sign-up form). Participants are expected to bring their own laptops with Excel 2010 or a later version installed.

Each of the trainings costs 55,000 RWF per person. If both trainings are booked as a package, you pay a discounted fee of only 100,000 RWF. The fee covers:

  • 2 bottles of water per day
  • Lunch
  • Certificate of attendance
  • Training materials
  • VAT

Please note that payment must be received no later than 19 April 2019 and that the registration is only considered confirmed after payment is made. Payment details will be sent upon registration. Please read our cancellation policy here.

Trainer and Language

The training is given by Melanie Uhlen, the Country Director of energypedia consult Rwanda. Please read more about her here. The language of instruction and materials is English.

Contact

If you have any inquiry regarding the content or logistics of the training, or your registration status, please contact Ms. Sandrine Sangwa at s.sangwa@energypedia-consult.com or (+250) 0782491154

About Us

energypedia consult Rwanda is a branch of energypedia consult headquartered in Germany, which has been running since 2012 and has carried out different IT and Monitoring and Evaluation consulting projects for organizations in the international developing sector in Germany and internationally.

Since March 2018, its first East African branch in Kigali focusses on the One-Stop-Monitoring-Shop Kigali including:

  • WebMo - Monitoring and collaboration software
  • Monitoring consultancy
  • Monitoring and Evaluation capacity building
  • Monitoring with Excel
  • App-based surveys.