Tag Archives: Dr. Ouarsas

Collecting Operational Data

One of our three sub projects for ALCS is the program data collection. As a short summary, the “field workers” (the doctors and volunteers who are in direct contact with the target population all over Morocco) collect and report activity specific data, e.g. how many education sessions were held, how many known or new contacts they worked with or how many prevention material for STD (sexually transmitted diseases) they could distribute. This is a good amount of data which get gathered, merged and validated on different organizational levels. Currently, this process is based on Excel sheets and a lot of copy-paste work – obviously with the risk to corrupt data and a long processing time. But to make it clear: even we as IT guys were impressed by the effort, quality and functionality in these files. The macros helped us a lot to understand dependencies and design requirements.

Operational data collection reporting sheet

This is the point where we came into picture. Dr. Ouarsas traveled from Agadir to Casablanca to give us further details and to explain the desired future state. This meeting changed our viewpoint a little – it is not only about setting up a database to replace Excel files, but to give recommendations and a draft for a framework, targeting a configurable and extensible application. Also, we recognized the similarities and dependencies between the budget-related challenges and those of Dr. Ouarsas. We have to think big and to combine our findings in order to be able to provide a sustainable solution for ALCS’ future requirements.

Dr. Ouarsas explaining the requirements

#ibmcsc morocco