Data consisted in three spreadsheets where each row was the test result for one kid.
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.
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.
After calculating indicators, I created summary tables and graphs so the project manager could include in the baseline study report.