CPiE Secondary Data Review (SDR)[1]
This note needs to be used together with the Generic CPiE SDR template in Annex I.
- INTRODUCTION
- What is a SDR?
-SDR is one of several existing methods for obtaining information during a needs assessment;
-A SDR is a review and compilation of data collected by someone other than the user in contrast with the primary data collection.
- When to conduct a SDR?
-Ideally a SDR should be initiated during the preparedness phase but otherwise it could be initiated at any time;
-A SDR would be carried-out during the whole emergencybut could also be continued during the early recovery phase.
- Why conduct a CPiE SDR?
-A SDR provides basic information quickly allowing to highlight CP from the on-set of the emergency;
-A SDR provides a baseline with which to compare your primary data collection;
-A SDY, by making good use of existing information, saves time, and reduces primary data collection fatigue;
-A SDR allows identifyinggaps in knowledge and defining the most appropriate method including subsequent primary data collection phase.
- Who should conduct a CPiE SDR?
-Carrying-on a SDR is one of the functions of the CP Sub-cluster at country level;
-Support can be requested or provided by the Global CPWG. The review would then be conducted in coordination with the country;
-In-country, the Information Management Officer (IMO) of the CP sub-cluster would be the person that supports this process that should maintain contact with ACAPS.
- How to conduct a CPiE SDR?
-Common sources of secondary data for social science include censuses, organisational records and data collected through qualitative methodologies or qualitative research. Practically, for the CPiE SDR, review (if available in the country context) CPRA report, Press articles, Assessment reports, SRSG CAAC Report, Child Protection Systems Mapping, International Crisis Group Report, Reports from Human Rights Watch / Amnesty International, Demographic and Health Survey, Documents about similar emergencies, etc.;
-If there is alreadya CP Desk Review,either the current document is used and updated or the SDR template is used where pre-existing information can be imported into it;
-If no CP desk review exists, data on the CP situation prior to the emergency should also be includednevertheless priority should be given to post crisis data and if there is time, relevant and most recent pre-crisis data should be reviewed;
-Ensure sign-off by the national CP sub-cluster coordinator.
- How to use the generic CPiE SDR template‘column by column’
This section covers the adaptation of options in the dropdown menus, how to fill the template (as defined in the generic model) and how to analyse/use for analysis the data compiled in the SDR.
While this section provides explanation on each column starting from column A, it is important to remember thatthe firstthing you need to do is to select the CPiE data from different sources of information. It is important that each piece of information covers only one CP issue at the time but can cover one of more aspects regarding risks, needs, capacities and responses. This SDwill be copy/paste in column E.Only then, you will fill all other columns of the row in relation to this SD.
Column A: # (SD number)
How to adapt the template: N/A
How to fill: The SD number needs to be typed. The first SD will be given #1 and so on.
Examples on how to analyse the data / use for analysis purposes: This can be useful to design several snapshots – when a snapshot based on the SD collected at a specific time (ex. with 23 records) is designed and this snapshot is later updated based only on the new SD (ex. the matrix has now 43 records, so the update can be done on records 24 to 43).
Column B: Date of the event
How to adapt the template: N/A
How to fill: The date of the event needs to be typed. The format to be used is DD-MM-YY. When the event doesn’t have a specific date, the date of publication of the information can be used as a proxy ex. the SD is extracted from MICS 2010, the date would be 01-01-10.When the SD has occurred over a period of time, the end date will be used as a proxyex. ‘child marriage has increased in this area between1st of September and 31stDecember 2012’ and is extracted from an article published on March 2013, the date will be 31-12-12.
Examples on how to analyse the data / use for analysis purposes:A timeline of events can be designed based on this column; Allows to identify gaps of information in terms of key dates/period; If so, lookingactively for sources to fill these gaps.
Column C: 1stAdministrative level
How to adapt the template: The dropdown menu options needs to be revised to include all the 1stAdministrative level in the country ex. regions or prefectures. All Admin 1 in the country should be included and each Admin 1 will be an option. Two additional options can be included in the menu such as ‘national level’ and ‘all affected regions by crises’. To modify the list of Admin 1, select the tab “LISTS” and modify the list of Admin 1. Please contact the Global CPWG Information Manager for further information and support.
How to fill: Select the appropriate option from the dropdown menu. If the information applies to 2 regions, each region will need to be presented on a separate row. If the information is a general one without geographical specification ex. for ‘thee number of CAFAAG in the country is estimated’ to 3,000 children’, the option ‘national’ will be selected. If the information relates to all the affected area such as ex. ‘Changes in children’s behaviour have been documented in the areas affected by the crisis’, the option ‘entire affected areas by crisis’ will be selected.
Examples on how to analyse the data / use for analysis purposes:Maps can be developed to show SD geographical presence;Allows identifyinggaps of SD by geographical coverage of Admin 1.
Column D: 2nd Administrative level
How to adapt the template: The dropdown menu options needs to be revised to include all the 2nd Administrative levels in the country ex. provinces or sub-prefectures. For each ‘Admin 1’ mentioned in Column C, all the related ‘Admin 2’ will be included in addition to ‘all affected Admin 2’ in Column D where each ‘Admin 2’ will be an option.For option ‘National level’ in Column C, include only the option ‘National’ in Column D. For option ‘all affected Admin 1’in Column C, include only the option ‘all affected Admin 2’ in Column D.To modify the list of Admin 1, select the tab “LISTS” and modify the list of Admin 2 and the related Admin 1. Please contact the Global CPWG Information Manager for further information and support.
How to fill: Select the appropriate option from the dropdown menu. See Column C for more directives.
Examples of how to analyse the data / use for analysis purposes:Maps can be developed to show SD geographical presence;Allows identifying gaps of SD in term of geographical coverage of Admin 2.
Column E: CP Data
How to adapt the template: N/A
How to fill: The SD should be types or copied/pasted from the document.The SD on each row should cover only one CP issue ex. ‘we estimate that 6,000 children are at risk of being recruited by armed groups and we have concern of child marriage’ should be broken-down in two row; 1st row: ‘6,000 children are at risk of being recruited by armed groups’ and 2nd row: ‘concern of child marriage’. On each row of Column E, it is possible to include data on risks, needs, capacities and/or responses if they address the same CP issue.
Examples of how to analyse the data / use for analysis purposes:This is the most useful column and can be crossed-analysed with data from all the other columns.
Column F: CP Domain
How to adapt the template: The domains are related to the Minimum Standards 7 to 14. The dropdown menu options will need to be modified only when there is one or more options that are missing. There is no need to modify the list when there are options that are not relevant to your context. To modify the list, select the Tab ‘LISTS’ and modify the column DOMAIN by adding or deleting options
How to fill: Select the appropriate domain from the dropdown menu.
Examples of how to analyse the data / use for analysis purposes:SD can be filtered and sorted by domain in orders to show SD available and gaps of SD by domain.
Column G: CP Risk/Need
How to adapt the template: N/A
How to fill: Select the appropriate option from the dropdown menu. Select if the SD referred a) only to a riskor b) only to a needor c) to risk and need together ord) not a risk and not a need.
Examples of how to analyse the data / use for analysis purposes:SD can be filtered and sorted by menu options in orders to show SD available and gaps of SD.
Column H: CP Capacity
How to adapt the template: N/A
How to fill: Select the appropriate option from the dropdown menu.If the SD refers to a capacity, select if the SD mentions an improvement of capacities or braking-down/insufficiency of capacities. If the SD does not refer to capacity, select N/A.
Examples of how to analyse the data / use for analysis purposes:This column can provide information on trends and gaps in terms of capacities specifically but also in relation to affected geographical areas as well as to risks/needs.
Column I: CP Humanitarian response
How to adapt the template: N/A
How to fill: Select the appropriate option from the dropdown menu. If the SD refers to a response, select if the SD shows a need of response or a response to date. If the SD does not refer to a response, select N/A.
Examples of how to analyse the data / use for analysis purposes:This column can provide information on trends and gaps in terms of CP response specifically but also in relation to affected geographical areas as well as to risks/needs.
Column J: Levels of CP Capacity/Response
How to adapt the template: N/A
How to fill: Select the appropriate option from the dropdown menu.If the SD refers either to a capacity or a response or both, select if this capacity and/or response relates to a) international level, b) national levelc) community level d) all these levels. If the SD in Column E doesn’t refer to a capacity or a response, select N/A.
Examples of how to analyse the data / use for analysis purposes:This column can provide information on trends and gaps in terms of levels of capacity/response in relation to the crisis specifics.
Column K: Timeline
How to adapt the template:N/A
How to fill:Select the appropriate option from the dropdown menu.Select if the SD makes reference to the pre-crisis, the post-crisis or a similar crisis. The date between pre-crisis and post-crisis should be defined with the field based coordination group in country. This is especially the case for countries affected with recurrent emergencies.
Examples of how to analyse the data / use for analysis purposes:Helpful to compare baseline data (pre-crisis) and post crisis data and describe the evolution of the situation in terms of CP risks/needs but also capacities and response.
Column L: Sex disaggregated data
How to adapt the template: N/A
How to fill: Select the appropriate option from the dropdown menu.Select if the SD is sex disaggregated (Yes/No). Examples of sex-disaggregated data are the following: ‘The crisis had a huge impact on physical violence, particularly for girls’ or ‘it is estimated that the crisis affected 15,600 children, among them 48% are boys`.
Examples of how to analyse the data / use for analysis purposes:Filter data to keep only the disaggregated ones and see if girls or boys are more affected and what are the specific CP issues that affect more girls as well as boys. Filter data to keep only the non-disaggregated ones and define how to advocate with actors to include and collect data based on disaggregated indicators.
Column M: Age disaggregated data
How to adapt the template: N/A
How to fill: Select the appropriate option from the dropdown menu.Select if the SD is age disaggregated (Yes/No). The option Yes will be selected for the SD ‘Mostly children over 15 years old have been seen at checkpoints’and the option Nowill be selected for the SD ‘Girls are particularly vulnerable to child labour’.
Examples of how to analyse the data / use for analysis purposes:Filter data to keep only the disaggregated ones and see if some ages are more affected than others and what are the specific CP issues that affect different ages. Filter data to keep only the non-disaggregated ones and define how to advocate with actors to include and collect data based on disaggregated indicators.
Column N: Hyperlink
How to adapt the template:N/A
How to fill: Copy/Paste the hyperlink of the document from which the SD is extracted. IF the document is not available online and is publically available, a drop box hyperlink can be created.
Examples of how to analyse the data / use for analysis purposes:N/A
Column O: Source
How to adapt the template: N/A
How to fill: The information about the source needs to be typed (title, organisation and date (MM/YY)).
Examples of how to analyse the data / use for analysis purposes:N/A
Column P: Type of source
How to adapt the template: N/A
How to fill: Select the appropriate option from the dropdown menu
Examples of how to analyse the data / use for analysis purposes:Filter per type of sources to identify the gaps of coverage and/or material included in the SDR.
Column Q: Comments
How to adapt the template: N/A
How to fill: Type in any additional useful comments or notes
How to analyse the data / use for analysis purposes:N/A
In general, single column or cross analysis of Secondary Data (SD) are worthy evidences to define/design advocacy with HC, donors, or other humanitarian actors as well as programming prevention and response.
[1]For more information on SDR, consult the ‘Summary on the Secondary data review and needs assessment’, June 2011, ACAPS