Build with AI and data

Data for M&E: Kobo, Excel and Power BI

The monitoring and evaluation toolkit NGOs in northern Ghana ask for in job adverts: mobile data collection, clean spreadsheets and dashboards that report themselves.

Length
6 weeks
Teaching
About 24 hours
Level
Some experience
Device
Laptop required

Free to register. We send the syllabus, fee and start date.

What you learn

  1. Weeks 1 and 2: Collect

    Indicators, survey design, XLSForm and KoboToolbox, tested in the field on phones.

  2. Weeks 3 and 4: Clean and analyse

    Excel for survey data: cleaning, pivot tables, lookups and the monthly indicator table.

  3. Weeks 5 and 6: Report

    Power BI dashboards, telling the story to a donor, and a final project on a realistic dataset.

You leave with

  • XLSForm surveys built and deployed on KoboToolbox
  • Excel pivot tables, lookups and data cleaning for survey exports
  • A Power BI dashboard connected to live survey data
  • Data protection basics for working with personal information

Who it is for

NGO, health and district assembly staff, and graduates aiming for M&E jobs.

Questions about this course?

Ask, and get an answer now

Our assistant knows this course and the rest of the catalogue. Tap a question, or ask your own. For fees and dates, it will hand you over to our team on WhatsApp.

Common questions

How long is Data for M&E: Kobo, Excel and Power BI?

6 weeks: 12 evening sessions of 2 hours, about 24 hours of teaching in total.

Who is this course for?

NGO, health and district assembly staff, and graduates aiming for M&E jobs.

Do I need experience?

It is set at "Some experience" level. If you are unsure, ask us on WhatsApp and we will tell you honestly whether it fits.

What device do I need?

Laptop required.

How much does it cost, and when does it start?

We send the fee, the start date and the venue with the syllabus when you register interest on WhatsApp. Registering is free and commits you to nothing. A class runs once enough people have registered.

Do I get a certificate?

A Scaffold Academy certificate of completion. It records what you did on the course; it is not an accredited qualification.

Where are classes held?

Classes at a venue in Bolgatanga, confirmed when you register. Team training at your premises.

Join Data for M&E

Register your interest on WhatsApp and we will send the syllabus, the fee and the start date. Registering costs nothing.