From Logframe to Database
Welcome to the course “From Logframe to Database”. This is a series of four sessions addressed to M&E professionals working in the social sector who wish to master the logic behind the transformation of a MEAL plan into a database to support their M&E activities.
These sessions will help you understand key concepts and steps included in the process of transforming a MEAL system into a complete information system based on the relational database model, and including reporting and data analysis components.
Each session focuses on a particular step of this path and is based on a real case example, gracefully provided by an ActivityInfo customer.
It is highly recommended that you join or watch the recordings of all webinars in their consecutive order so as to benefit from the complete course.
These are free training sessions provided by the ActivityInfo team. You can either register and join the live session or watch the recording at your own pace once it becomes available.
Are these sessions for me?
- Are you responsible for creating information systems or M&E systems for your projects?
- Do you wish to improve your data management processes using a secure system?
- Would you like to see practical examples of working with such databases in ActivityInfo?
Then, get started with these sessions!
MEAL plan to Data model
In the first session we explore how a MEAL plan can be transformed into a data model to support the design of a comprehensive database.
In summary, we explore:
- Introduction to the project (FFPr) and Program (USDA)
- The MEAL plan (indicators, data sources, indicator calculation, roles & responsibilities, data use)
- How can we transform the MEAL plan into a comprehensive database? (the role of data model, data flows, data categories, references, and more)
Data model to Database design
During this session, we explore how the data model is associated with the database design. We look at ways to ensure data quality and consistency and how ActivityInfo can be used to achieve that.
We explore:
- Form design for data collection (reference and data collection forms, subforms, reverse reference, calculated fields)
- Anonymous, and offline data collection
- Ensuring data quality (validation rules, keys, translations, and more)
Data & Database management
In the third session, we look at ways to facilitate data access and data management within the database designed in the previous session.
We explore:
- Data access (table view options, translations)
- Data management
- User management (roles, permissions)
- Use monitoring (audit logs)
Data analysis and Reporting
In the last session, we look at ways to enable timely monitoring and evaluation and the options available in ActivityInfo for data analysis and reporting.
We discuss:
- Report design (pivot tables, charts, calculated measures, calculated tables)
- Designing reports for specific use cases (donors, internal, etc.)
- Collaborating internally and externally