Baseline study on Early Grade Reading Assessment

Description

Analysis of data collected for a baseline survey on Early Grade Reading Assessment for kids in the province of Xiengkhouang, Laos.

Technologies

Analysis and visualisations were done with Power BI.

What did I do?

I cleaned the data, calculated indicators and created visualisations.

Period

February 2019

Process

Input

Data consisted in three spreadsheets where each row was the test result for one kid.

Cleaning data

First step was to concatenate the different spreadhsheets. Headers were in lao language so I created my own headers based on translation that were header friendly (no spaces, consistent namings accross questions). Many answers were in lao language with inconsistencies, different words were used depending on the person who did the test (correct was written differently for instance).

After loading and cleanign the data, we had a nice square raw data.

Calculating indicators

I then spent time to with the project manager to understand each test and the metric they wanted to get from them. I needed to have a clear understanding on how tests were supposed to be rated to implement the indicators.

Output

After calculating indicators, I created summary tables and graphs so the project manager could include in the baseline study report.

How can I help?

Whether you already know about your data pain points or just want to have a friendly conversation, send me a message.