Lida Africa is set to present at the 7th Uganda Evaluation Week (UEW) from 11-15 February 2019. Organised by the Uganda Evaluation Association together with the Office of the Prime Minister, the event’s objective is to review policy, programmatic and operational developments in Uganda’s evaluation community and development evaluation in general.
The UEW is organised annually since 2013. It is used for sharing knowledge, skills and practices on evaluation trends, developing networks for capacity development and learning.
This year’s event with a theme “From evidence generation to utilization” will be held at Hotel Africana. It will start with pre-conference trainings on Development Evaluation from the 11th-12th February, 2019, followed by a three-day conference from the 13th – 15th February 2019.
Lida Africa will be presenting a pre-conference workshop on “Evaluation Data Management, Analysis and Visualization Using Advanced Excel as highlighted in programme for the evaluation week. Visit the Uganda Evaluation Association (UEA) website for more details about the event and registration.
Details about our session are below;
Evaluation Data Management, Analysis and Visualization Using Advanced Microsoft Excel
Evaluation statistics are an imperative component in everything pertaining life, useful in development-policy making processes of organizations but also in evaluating the eco-system. However, a substantial gap still exists between the demand for the evaluation statistics and the ability of most organizations to routinely provide it through credible evaluations using various methodologies like RCTs, Propensity score matching etc. The use of such statistics by various populations especially the local community or even local governments in Africa is still a challenge. Evaluators are hence faced with a challenge of breaking down such superior results into simplified visuals. Microsoft Excel has powerful tools that can enable evaluators to set up simplified data management, analysis and visualization systems to enable users to make timely decisions, taking corrective actions and become result based.
This workshop is ideal for managers and researchers from development organizations, foundations, governments and non-governmental organizations, as well as M&E professionals and students. It’s for people wanting to use more complex functions within Excel to automate and hence simplify data analysis, visualization and interpretation with in their interventions.
Specifically, the workshop will:
- Improve participants’ knowledge & understanding of Evaluation data
- Improve participants’ practical skills of Data Management, Analysis and Visualization through use of advanced functions in Ms excel
- Enable participants share knowledge and experiences in evaluation data management using MS ExcelThe training will cover three sessions;
Session 1 – Evaluation Data analysis and interpretation using PIVOT tables
• Understanding Evaluation Data
• Introduction to Pivot tables
• Conducting Univariate analysis
• Conducting Bivariate analysis
• Multivariate analysis
• Updating & formatting Pivot Tables
Session 2 – Evaluation Data Visualization Using Excel
• Introduction to data visualization
• Elements of a good Excel Visual
• Creating visuals on comparison data
• Developing visuals on composition data
• Creating visuals on distribution data
• How to visualize data on relationships
Session 3: Linking & Automating Data analysis for simplified Evaluation data analysis
• Introduction to linking sheets in same or different workbooks
• Using COUNT, COUNTIF & COUNTIFS function
• Using the SUMIF and SUMIFS functions
• Using the AVERAGEIF and AVERAGEIFS functions
• Creating automated graphs
This 1 day hands-on workshop will be facilitated by Ronald and Victor from Lida Africa. Lida Africa has over 6 years of experience in statistical software and M&E trainings. We have empowered over 600 professionals through our routine executive training sessions and tailor made on-site trainings. Recently Ronald and Victor held a similar Executive Workshop at the 8th AfrEA International Conference where over 65 participants from 23 countries attended. While in October 2017, The South Africa Monitoring and Evaluation Association invited Victor to provide a similar workshop to over 32 delegates at the 6th SAMEA Biennial Conference.
Participants are required to have access to computers installed with Microsoft office version 2010/2013/2016 (2016 is preferred). Lida Africa will provide training datasets & online materials at no cost. A Lida Africa Excel Manual will be provided at a cost.