Generic Module 3 (GNC IM)

The Nutrition Cluster Information Management Training Course requires that all participants have a basic level of theoretical and practical knowledge and skills related to coordination prior to arriving.

We have therefore prepared FOUR modules with accompanying assignments to be completed and submitted according to specified due dates.

Each module will contain a theory-based assignment as well as a practical, Information Management (IM)-based assignment. 

Thanks go to the Global Education Cluster for their support in the development of this training. 

Module 3a (Theory): IASC Reference Module for the Implementation of the Humanitarian Programme Cycle (HPC)

Module 3a (Theory): IASC Reference Module for the Implementation of the Humanitarian Programme Cycle (HPC) DUE: 12 FEB 2016

 

Theory: The Humanitarian Programme Cycle: Reference Module

Assignment:

  1. Read the entirety of the HPC Reference Module (see below or click on the link above)
  2. Complete the following post-reading quiz

 

What is the purpose of the “Humanitarian Programme Cycle (HPC)

  • Jointly define the overall shape of the response and understand what needs to be done at a given moment in line with agreed objectives in order to ensure a more coherent, effective and accountable response
  • Define the roles and responsibilities of international humanitarian actors and the way that they interact with each other, with national and local authorities, with civil society, and with people affected by crises
  • Assist the Humanitarian Coordinator and Humanitarian Country Team to improve the delivery of humanitarian assistance and protection through better preparing, prioritizing, steering and monitoring the collective response through informed decision-making
  • Provide a standard and adaptable set of tools for use in humanitarian crises globally
  • Influence programming and resource allocations of all actors – including United Nations (UN) agencies, non-governmental organizations (NGOs), civil society and governments
  • Ensure that humanitarian response delivers life-saving assistance to those in need
Select all that apply.

The Humanitarian Program Cycle applies to all humanitarian crises (except refugee crisis), but its process, timeline, tools and documents can be used flexibly and be adapted to the circumstances/needs of the particular emergency at hand

  • True
  • False

The Humanitarian Program Cycle distinguishes and provides different flexible timelines of implementation for which two types of emergencies?

  • War and Peace (Война и мир)
  • L3 and L4
  • Natural and man made
  • Response and Recovery
  • Sudden onset/escalations and Protracted
Select the correct answer.

The Reference Module is a protocol developed to support the implementation of which following IASC initiative?

  • COP 21
  • Agenda 2015
  • IASC Transformative Agenda
Select the correct answer.

Which is not an element of the “Humanitarian Programme Cycle (HPC)”?

  • Emergency Response Preparedness
  • Needs Assessment and Analysis
  • Strategic Response Planning
  • Implementation and Monitoring
  • Resource Mobilization
  • Rest and Recuperation
  • Operational Peer Review and Evaluation
Select the correct answer.

Why are the assessment and/or secondary data collection and analysis and the development of the Humanitarian Needs Overview/MIRA Report so important?

  • The HNO/MIRA report will inform objectives, strategies and funding requirements in the HRP, which in turn serves as the basis for implementing and monitoring the collective response
  • The HNO/MIRA report are the primary document utilized for resource mobilization documents and their persuasiveness crucial for the entire funding of the humanitarian response
  • The HNO/MIRA report provides Cluster partners with clear guidance on strategies and activities to implement to address humanitarian crisis.
Select the correct answer.

What is the purpose of the Humanitarian Response Plan (HRP)?

  • To set the direction and strategic objectives of the humanitarian response.
  • To indicate each cluster/sector’s contribution toward meeting the strategic objectives.
  • To provide strategic objectives, indicators and targets for monitoring progress.
  • To ensure the contextual, institutional and programmatic risks to the achievement of the strategic objectives are identified.
  • To link to the existing development plan (if applicable) and indicate how the response will provide a path into recovery and build resilience.
  • To mobilize resources for the humanitarian response
Select all that apply.

What are the different steps of the development of the HRP?

Please match the the descriptions with the order in which the HRP development steps are usually taken.
  • Review the HNO and identify capacities, assets and operational constraints in order to determine how to address needs in a given context.
    Step 1
  • Convene a meeting or workshop of humanitarian stakeholders to review the ‘response analysis’ and lines the boundaries, sets priorities within those boundaries and assumptions. Agree on strategic objectives and indicators
    Step 2
  • Hold cluster/sector meetings to determine cluster/ sector objectives and key activities – in line with the strategic objectives – and then (if applicable) prepare projects according to an agreed process, criteria and a division of labour
    Step 3
  • Draft/compile the humanitarian response plan and circulate it to the HC and HCT for validation
    Step 4
  • Consult government, development actors, civil society and affected people throughout
    Step 5
  • Disseminate the plan broadly to ensure its use in each organization’s programming and fundraising
    Step 6
  • Use the strategic objectives and indicators to develop a response monitoring framework and as the basis of reporting on results in the periodic monitoring report.
    Step 7

What are the Steps of Humanitarian Response Plan Monitoring?

  • Monitoring, Evaluation, Accountability and Learning
  • Inputs, Activities, Outputs, Outcomes, Impact
  • Preparation, Monitoring and Reporting
Select the correct answer.

What are some of the donor considerations to keep in mind as a Coordinator?

  • The credibility and accuracy of assessed needs
  • The strategy and response priorities
  • The perceived reasonableness of funding requirements
  • Perception of the ‘collectiveness’ of engagement under the programme cycle
Select all that apply.

Who is responsible for resource mobilization for the HRP?

  • The Humanitarian Coordinator
  • The Humanitarian Country Team
  • OCHA
  • Clusters/sectors
Select all that apply.

What are some possibilities for resource mobilization?

  • Briefings for donors on needs, strategy and funding requirements
  • Fundraising brochures/pamphlets, infographics, or other documents, which tell a compelling story focused on people in need and the impact of funding/underfunding
  • Live 8 concerts
  • Regular, up-to-date reporting on pledges and contributions
  • Applications to Common Funds (through OCHA)
  • Wait and See
  • Donor pledging conferences
Select all that apply.

What are cross-cutting topics to consider in the Humanitarian Program Cycle to ensure quality and accountability of the response?

  • Accountability to Affected People
  • Minimum Standards
  • Protection
  • Cross cutting issues and Gender Equality
  • Environment
  • Exit and Early Recovery
Select all that apply.

Module 3b (IM): Excel 103

Module 3b (IM): Excel 103

Assignment: Review the lessons, walkthroughs, videos, and challenges in this module and then complete the Exercise at the end of the lesson.  You can access the Exercise by clicking on 'Next' at the bottom of this page.

PLEASE NOTE: If you feel you have already mastered the skills described in a particular lesson within this module, feel free to SKIP IT.  You must, however, complete and submit your completed Exercise.

3.1 Find and replace

How to use ‘Find and Replace’ feature to quickly find specific text and replace it with other text.

3.1. Walkthrough

Video:

 

3.2 Remove duplicates

How to remove duplicate values in a column.

3.2. Walkthrough

Video:

 

3.3 Pivot Tables

How to create and use PivotTables. PivotTables allow you to easily summarize and manipulate your data in order to analyze it. 

3.3. Walkthrough

Videos:

Challenge: Try completing 3.3 Challenge  to try out your new skills

3.4 Creating a chart

3.4.A How to create a static chart

3.4.A Walkthrough

Video:

3.4.B How to create a pivot chart (see 3.3 Challenge to practice making a pivot chart)

3.4.B Walkthrough

Video:

 

3.5 Data visualization

These fantastic presentations show how to very simply and effectively visualize data in charts and tables.

  1. Remove to Improve 
  2. Pie Chart Edition
  3. Clear Off the Table

CLICK ON 'NEXT' TO ACCESS THIS MODULE'S EXERCISE

Module 3b (IM): Exercise

You are working as an IMO for a country level Nutrition Cluster. The Cluster Coordinator asks you to provide disaggregated data per region and per month for your outpatient treatment programme (SAM treatment without complications), namely:

·         Cure rate in OTP

·         Died rate in OTP

·         Defaulter rate in OTP

·         Non-respondent rate in OTP

You already collect this data, in your database in terms of absolute numbers (i.e. columns U, V, W, X provide information on number of cured, died, defaulted and non-respondent children per month per OTP site). You have been informed however by the Cluster Coordinator that the indicators are reported on in percentages and so the data needs further analysis.  

Your task is to prepare a table that gives required information on the percentages of cured, died, defaulted and non-respondent children that is automatically updated once you update the database. To do so you must prepare an analysis table and chart that not only displays the current information but can also be updated easily for monthly analysis and reporting. Using the skills learned in the various lessons of Module 3, follow the steps below to create the analysis tool and the corresponding chart.

1.     Download the Excel file ‘3b_DataBase

2.     Insert a PivotTable (Tip: select all columns A:AC and click on Insert > Pivot table)

3.     From the PivotTable Field List, move  ‘Regions’ field to the ‘ROWS’ area

4. The data you have currently been collecting expresses the cured, died, defaulted and non-respondent outcomes for patients as numbers which together equate to the total exits recorded in Column Y. To meet the reporting requirements of the Cluster performance indicators need to be displayed in %. This should be done using a formula to calculate the percentages in the pivot table. To do this follow the steps outlined below:

  1. Click on ‘PivotTable tools’ > ‘Analyse’ > ‘Fields, items and sets’ > ‘calculated field’
  2. In the window ‘insert calculated field’ and name this accordingly (for example '% Cured')
  3. Double click ‘Cured’ in the ‘Fields’ window
  4. Enter ‘/’to the ‘Formula’ field after ‘Cured’ 
  5. Double click ‘total exits’ from ‘Fields’ to include it in the ‘Formula field’. 
  6. Now you should have formula ‘ = Cured/ 'Total Exits' ’(Tip: this will divide the ‘Cured’ by the 'Total Exits' number)
  7. Repeat the same for the ‘Died’, ‘Defaulted’ and ‘Non-respondent’ fields
  8. Change the values of the pivot table that you have calculated from numbers (parts of one) to percentages with one decimal.

NOTE: Ensure that the targeted/reached fields are displayed as ‘Sum of’ and NOT ‘Count of’

5.     Now that you have your completed pivot table you need to add filters to facilitate the Cluster’s reporting by month and partner. To do this move the ‘Month’ under the ‘FILTER’ area in the PivotTable field. Do the same for the ‘Implementing partner’ field.

6.     Having created filters you now need to create a Pivot chart (‘stacked columns’) for your pivot table, this should be formatted to make it visually appealing. (Tip: Insert > Pivot Chart > Stacked columns).

7.     Save the file as ‘3b_Your surname’ and send to [email protected]

Help?

Watch this video if you would like to receive step-by-step guidance on how to complete the following exercise.

Have you set up and sent your Pivot Tables and Charts to [email protected]?

  • Yes I have!
  • No, no, no...