Lida Africa set to offer an Executive Workshop at the 9th Africa Evaluation Association (AfrEA) International Conference, 11-15 March 2019 in Abidjan, Cote D’Ivoire

Lida Africa is pleased to offer an Executive Workshop at The 9th AfrEA International Conference, 11-15 March 2019, in Abidjan, Cote D’Ivoire. Organised by the African Evaluation Association (AfrEA), the AfrEA International Conference 2019 will attract delegates from world over. The conference is the premier event in the African Evaluation sector and acts as the foundation for promoting and advocating AfrEA’s “Made in Africa” approach, and allows knowledge sharing, collaboration and networking with a wide range of international organisations and individuals.

The theme for the 2019 conference is Accelerating Africa’s Development: Strengthening National Evaluation Ecosystems”

Lida Africa will be presenting a half day pre-conference workshop on Qualitative Data Management and Analysis Using NVIVO on 13th March 2019 .  The workshop is ideal for  delegates that are seeking to integrate the sophisticated analysis of qualitative data, with quantitative data and simplify analysis of text-based research data and interpretation with in their interventions.

You can register for the workshop as you register for the conference from the AfrEA website https://afrea.org/2019conference/registration/

afrea 2019 3

Details about our session are below;

Pre-Conference Workshop: Qualitative Data Management and Analysis Using NVIVO on Wednesday, 13th March 2019

The use of qualitative data in decision making has been ineffective simply because M&E professionals are afraid of the process to summarize or find relevant quotes in substantial amounts of qualitative data thus finding themselves incapable of working in fields that entirely deal with qualitative data. NVIVO is the leading tool for Computer Assisted Qualitative Data Analysis (CAQDAS). The use of NVIVO to eradicate this fear will enable M&E professionals to code, explore qualitative data and run visualizations.

Specifically, the workshop will:
i. Improve participants knowledge & understanding of Qualitative data
ii. Improve practical skills for qualitative data management, analysis and Visualization Using NVIVO
iii. Share knowledge and experiences in qualitative M&E data analysis

The training will cover three sessions;
Session 1 – Introduction to NVIVO & its concepts
• Qualitative Data and Methods
• Installation of NVIVO software
• NVIVO Key terms, interface, workspace and ribbons

Session 2: Importing, Coding Documents and Categorizing Data
• Importing documents
• Creating ‘nodes’ and type of nodes to collect data to support the themes, topics or ideas you identify in the data
• Creating memos and links
• Creating Attributes within NVivo and importing Attributes from a Spreadsheet
• Getting Results; Coding Query and Matrix Query

Session 3: Visualizing NVIVO project
• Display data in charts
• Creating models and graphs to visualize connections
• Tree maps and cluster analysis diagrams
• Display your data in charts
• Create models and graphs to visualize connections
• Create reports and extracts

Participants are required to have access to computers. Lida Africa will provide training datasets & online materials at no cost. During the training we shall be using a trial version of NVIVO. The sessions will be delivered through English.

Advertisements

Lida Africa set to offer an Executive Workshop during The 7th Uganda Evaluation Week (UEW), 11-15 February 2019

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 weekVisit 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:

  1. Improve participants’ knowledge & understanding of Evaluation data
  2. Improve participants’ practical skills of Data Management, Analysis and Visualization through use of advanced functions in Ms excel
  3. 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.

uea yee lida

National Evaluation Talk – M&E Data Visualization Using Advanced Excel, 31st January 2019, 2pm-4pm

Lida Africa is proud to collaborate with the Uganda Evaluation Association (UEA) in hosting the The January 2019 National Evaluation Talk (NET) on Monitoring and Evaluation Data Visualization Using Advanced Excel on Thursday, 31st Januray 2019 from 2:00PM-4:00PM. The FREE TO ALL NET, which will be facilitated by Ronald Waiswa, our Director Research and Training, will be held at Uganda Management Institute in Kampala, Uganda. 

This National Evaluation Talk (NET) will provide a brief understanding of data visualization process using advanced features of EXCEL to contribute to faster decision making through creating a bridge between complicated statistical analysis and use of data in decision making.

The Session will cover;

  • What is Data visualization and Why it matters?
  • The Principles of Visualizations
  • Elements of a good Excel Visuals
  • Choosing the right visual for your data.
  • Creating the visuals using Excel
    • Comparison Visuals
    • Composition Visuals
    • Distribution Visuals
    • Relationship Visuals

​NB: This is a practical session. Carrying a laptop installed with EXCEL 2016 is recommended.

Visit the Uganda Evaluation Association (UEA) website for more details about the event.

uea yee lida

Karamoja Executive Training (KET) Opportunity, 18th Feb – 2nd March 2019 – Advanced Excel+M&E

Lida Africa is proud to invite managers and researchers from international development organizations, foundations, governments and non-governmental organizations from around Africa, as well as trained M&E professionals to participate in our Executive Training programs;

  1. Data Management, Analysis & Visualization Using Advanced Microsoft EXCEL (Content here)
  2. ​​Monitoring and Evaluation – Planning & Practice (See content here)

These programs will provide a thorough understanding of data management process, and pragmatic step-by-step training for conducting data analysis and development of databases and data collection. While the programs are centred round the above, they will also impart insights on the rationale & designing​of impact oriented M&E systems.

Courses are available on Evening (Monday – Friday) and on Saturday at Royal Madiba Apartments, Near Moroto Full Gospel Church running from Monday 18th February 2019 till Saturday 2nd March 2019.

Admission to these courses is very competitive. Interested applicants must complete the Online Application Form for Karamoja Executive Training (KET) 2019 by Thursday, 14th February 2019.

​​Participation fees are: Excel only = UGX 300,000, M&E only= UGX 250,000, Two courses attract a discount of UGX 50,000.

Course participants will be expected to pay for their travel & accommodation. All admission decisions will be made on a rolling basis, and participants are encouraged to apply by completing the Karamoja Executive Training (KET) 2019 – Application Form​ (Online – here)​. 

​​For more information, Please Call: +256703 096203 or +256 773 384364 or send an email to lida@lidaafrica.org or lidaafrica2013@gmail.com

NB: Do you need technical M&E support or executive capacity building for your team? Explore our “In-house” package where your staff can receive “tailored” training to maximise their impact potential. We train the use of software like Advanced Excel, STATA, SPSS, NVIVO, ATLAS.ti, ODK, SURVEY CTO, MWATER, TABLEAU, DHIS2, COMCARE, EVIEWS, EPIDATA, EPI-INFO, ACCESS etc!, Contact us today

Executive Training Opportunity, February 2019 – Advanced Excel, ODK, STATA + M&E

​​Lida Africa is proud to invite managers and researchers from international development organizations, foundations, governments and non-governmental organizations from around Africa, as well as trained M&E professionals to participate in our Executive Training programs;

  1. Data Management, Analysis and Visualization Using Advanced Microsoft EXCEL (Content here)
  2. Mobile Based Data Collection Using Open Data Kit (ODK) (Content here)
  3. ​​Monitoring and Evaluation – Planning & Practice (See content here)
  4. Data Management, Analysis and Statistical Data Modelling using STATA (See content here)

These programs will provide a thorough understanding of data management process, and pragmatic step-by-step training for conducting data analysis and development of databases and data collection. While the programs are centred round the above, they will also impart insights on the rationale & designing​of impact oriented M&E systems.

Courses are available on Weekend (Saturday) only at Lida Africa Training Centre, Located near Kyambogo University running from Saturday, 16th February to ​Saturday, 9th March 2019.

Admission to these courses is very competitive. Interested applicants must complete the Online Application Form (February 2019) by Thursday, 14th February 2019.

​​Participation fees are: Excel only = UGX 300,000, M&E only= UGX 250,000, Mobile Data Collection only = UGX 250,000, STATA only = UGX 250,000.  Two courses attract a discount of UGX 50,000.

Course participants will be expected to pay for their travel & accommodation. All admission decisions will be made on a rolling basis, and participants are encouraged to apply by completing the February 2019 – Executive Training Application Form​ (Online – here)​. 

​​For more information, Please Call: +256703 096203 or +256 773 384364 or send an email to lida@lidaafrica.org or lidaafrica2013@gmail.com

Do you need technical M&E support or executive capacity building for your team? Explore our “In-house” package where your staff can receive “tailored” training to maximise their impact potential. We train the use of software like Advanced Excel, STATA, SPSS, NVIVO, ATLAS.ti, ODK, SURVEY CTO, MWATER, TABLEAU, DHIS2, COMCARE, EVIEWS, EPIDATA, EPI-INFO, ACCESS etc!, Contact us today.

Vacancies at Lida Africa – 20 Digital Field Enumerators Needed

Lida Africa is a social enterprise founded in 2013 and registered with the government of Uganda. Driven by the vision of creating a world where organizations effectively and efficiently utilize M&E information for achieving maximum impact, Lida Africa is committed to building organizational capacity to monitor and evaluate for sustainable development.

Lida Africa is recruiting enumerators to implement a Mobile Phone Based survey on a Water, Hygiene and Sanitation (WASH) project that is implemented by one of our clients.

The roles of Digital Field Enumerators include;
1) Community engagement – Work with community leaders to explain the study and its purpose, Conduct interviews with community leaders.
2) Survey Administration – Thoroughly understand and adhere to study protocol including sampling methodology, and Administer survey to participants using a smartphone/tablet. Submit data to online database
3) Team work – Attend daily evaluation team meeting and data cleaning meetings.

Employment terms: The survey is planned to run for 10 days from Saturday 15th December- Monday 24th December 2018. A daily competitive honorarium rate will be paid.

How to Apply: Apply by filling the Online Enumerator’s Application by Midnight, THURSDAY 13th December 2018

For any inquiries, please email us at lida@lidaafrica.org (please don’t send your CV and academic documents to this email). Only fill the Online Enumerator’s Application.

Executive Training Opportunity, November 2018 – Advanced Excel, ODK, NVIVO, M&E, SPSS +STATA

​​Lida Africa is proud to invite managers and researchers from international development organizations, foundations, governments and non-governmental organizations from around Africa, as well as trained M&E professionals to participate in our Executive Training programs;

  1. Monitoring and Evaluation – Planning & Practice (See content here)
  2. Data Management, Analysis & Visualization Using Advanced MS EXCEL (Content here)
  3. Mobile Based Data Collection Using Open Data Kit (ODK) (Content here)
  4. ​​Qualitative Data Management and Analysis using NVivo (See content here)
  5. Data Management, Analysis and Statistical Data Modelling using SPSS (Content here)
  6. ​​Data Management, Analysis and Statistical Data Modelling using STATA (Content here)

These programs will provide a thorough understanding of data management process, and pragmatic step-by-step training for conducting data analysis and development of databases and data collection. While the programs are centred round the above, they will also impart insights on the rationale & designing​of impact oriented M&E systems.

Courses are available on Weekend (Saturday) only at Lida Africa Training Centre, Located near Kyambogo University running from Saturday, 3rd  November  to ​Saturday, 24th  November 2018. Admission to these courses is very competitive. Interested applicants must complete the Online Application Form (November 2018) by Thursday, 1st November 2018. Each Saturday, Excel, STATA & NVIVO will run from 8am-1pm, then M&E, SPSS & Mobile data collection will run from 2-5pm concurrently with the exception of 17th November where M&E will run for a whole day

​​Participation fees are: Excel only = UGX 300,000, M&E only= UGX 250,000, Mobile Data Collection only = UGX 250,000, NVIVO only = UGX 250,000, SPSS only = UGX 250,000 STATA only = UGX 250,000.  Two courses attract a discount of UGX 50,000. Course participants will be expected to pay for their travel & accommodation. All admission decisions will be made on a rolling basis, and participants are encouraged to apply by completing the November 2018 – Executive Training Application Form​ (Online – here)​. 

​​For more information, Please Call: +256703 096203 or +256 773 384364 or send an email to lida@lidaafrica.org or lidaafrica2013@gmail.com

N​B: Organizations​ can benefit from our “In-house” package where their staff undertake a “tailored” training usually held at premises of the organization.

Executive Training Opportunity, September 2018 – Advanced Excel, ODK, NVIVO + M&E

 

Lida Africa is proud to invite managers and researchers from international development organizations, foundations, governments and non-governmental organizations from around Africa, as well as trained M&E professionals to participate in our Executive Training programs;

  1. Monitoring and Evaluation – Planning & Practice (See content here)
  2. Data Management & Analysis Using Advanced Microsoft EXCEL (Content here)
  3. Mobile Based Data Collection Using Open Data Kit (ODK) (Content here)
  4. ​​Qualitative Data Management and Analysis using NVivo (See content here)

These programs will provide a thorough understanding of data management process, and pragmatic step-by-step training for conducting data analysis and development of databases and data collection. While the programs are centred round the above, they will also impart insights on the rationale & designing​of impact oriented M&E systems.

Courses are available on Weekend (Saturday) only at Lida Africa Training Centre, Located near Kyambogo University running from Saturday, 1st   September  to ​Saturday, 22nd  September 2018.

Admission to these courses is very competitive. Interested applicants must complete the Online Application Form (September 2018) by Thursday, 30th August 2018.

​​Participation fees are: Excel only = UGX 350,000, M&E only= UGX 300,000, Mobile Data Collection only = UGX 300,000, NVIVO only = UGX 300,000.  Two courses attract a discount of UGX 50,000.

Course participants will be expected to pay for their travel & accommodation. All admission decisions will be made on a rolling basis, and participants are encouraged to apply by completing the September 2018 – Executive Training Application Form​ (Online – here)​

​​For more information, Please Call: +256703 096203 or +256 773 384364 or send an email to lida@lidaafrica.org or lidaafrica2013@gmail.com

Organizations​can benefit from our “In-house” package where their staff undertake a “tailored” training usually held at premises of the organization.

Executive Training Opportunity, June 2018 – Advanced Excel, Open Data Kit (ODK) & M&E

Lida Africa is proud to invite managers and researchers from international development organizations, foundations, governments and non-governmental organizations from around Africa, as well as trained M&E professionals to participate in our Executive Training programs;

  1. Monitoring and Evaluation – Planning & Practice (See content here)
  2. Data Management & Analysis Using Advanced Microsoft EXCEL (Content here)
  3. Mobile Based Data Collection Using Open Data Kit (ODK) (Content here)

These programs will provide a thorough understanding of data management process, and pragmatic step-by-step training for conducting data analysis and development of databases and data collection. While the programs are centred round the above, they will also impart insights on the rationale & designing​of impact oriented M&E systems.

Courses are available on Weekend (Saturday) only at Lida Africa Training Centre, Located near Kyambogo University running from Saturday, 2nd June to ​Saturday, 23rd June 2018.

Admission to these courses is very competitive. Interested applicants must complete the Online Application Form (JUNE 2018) by Thursday, 31st May 2018.

Participation fees are: Excel = UGX 300,000, M&E = UGX 2​50,000, Mobile Data Collection = UGX 250,000, M&E and Excel=UGX 500,000, Mobile Data Collection and Excel = UGX 500,000.

Course participants will be expected to pay for their travel & accommodation. All admission decisions will be made on a rolling basis, and participants are encouraged to apply by completing the JUNE 2018 – Executive Training Application Form​ (Online – here)​.

For more information, Please Call: +256703 096203 or +256 773 384364 or send an email to lida@lidaafrica.org or lidaafrica2013@gmail.com

Organizations​can benefit from our “In-house” package where their staff undertake a “tailored” training usually held at premises of the organization.

3rd SAMEA Webinar – Evaluation Data Visualization Using Advanced Excel, Friday 4th May, 4-4:40pm (EAT)

Lida Africa is proud to collaborate with the South African Monitoring & Evaluation Association (SAMEA) in hosting the 3rd SAMEA Webinar on Evaluation Data Visualization Using Advanced Excel on Friday, 4 May 2018 from 3:00PM-3:40PM ( South African Time) or 4-4:40pm (EAT). This webinar will provide a brief understanding of evaluation data visualization process using advanced yet simplified features of EXCEL. While the webinar is centered on the above, it will also impart insights on the types of evaluation data, importance of data collection, key performance indicators and data quality control and assurance.

You can join this Webinar by Sending an email to: info@samea.org.za by 02 May 2018 and log in details & guidelines will be forwarded to you.

SAMEA_Webinar_3_Evaluation_Data_Viz_using_Excel_4_May_2018_3pm_to_3-40pm

The Webinar will be facilitated by our Co-founder and Executive Director, Mr. Victor Kiwujja. Victor holds a Masters of Public Health & a Masters of Project Monitoring and Evaluation. Victor has used Excel for M&E data management and analysis for the last 8 years. In 2017, Victor held executive workshops on Advanced Excel at the 8th AfrEA International Conference and the 6th SAMEA Biennial Conference.