Tool 2.1: Spreadsheet
ECE Data Mapping and Evidence Plan Spreadsheet
This spreadsheet contains two tabs:
- Click on “Tab 1: Data Mapping” for the list of indicators that should form the data and evidence base for ECE in the Education Sector Analysis (ESA).
- Click on “Tab 2: Completed Thematic Studies” for an example of information of a relevant thematic study/report that can complement your evidence base.
- Download the tool (Excel spreadsheet) to fill out the ECE data mapping and information on thematic studies.
- Click on “Guiding Questions: Data Collection Processes” for a checklist of questions on data collection processes and costs, to help you identify the most appropriate/relevant options for filling data gaps.
Tab 1 "Data Mapping and Evidence Planning"
Data Mapping
You may filter by indicator categories from the Build to Last conceptual framework with the drop-down menu of the “Indicators - Conceptual framework” column.
You may filter by learning through play indicators or indicator categories from MOOC Module 3 with the drop-down menu of the “Indicators - Learning through Play or MOOC Module 3 indicator categories” column.
To see priority ECE indicators, click the checkbox of “Priority indicators”.
Click on the eye icon for details on the indicators.
Download the Excel Spreadsheet version of this tool to populate values for indicators with data available. Download and use the Excel version of this tool to map and assess - per indicator - which information is available, unavailable and/or unreliable. Read more tips about how to use the Excel file here.
Proportion of children under 5 years of age who are developmentally on track in health, learning and psychosocial well-being (SDG 4 Indicator)
By sex, age, location, household wealth, sub-national levels
% of pre-primary institutions with approprate learning and teaching materials for children with disabilities
By institution type, sub-national levels
% of pre-primary institutions with appropriate teaching and learning materials as per national standards to support the implementation of the nationally-approved pre-primary curriculum which promotes a play-based approach
By institution type, sub-national levels
% of pre-primary institutions with appropriate learning and teaching materials as per the national standards (i.e. domains and/or thematic content, inclusive, gender-equitable, etc.)
By institution type, sub-national levels
% of pre-primary institutions with accessible classrooms (e.g. physically accessible to children who are wheelchair users, adequate lighting for children who are partially sighted, flexibly organized to accommodate children with hearing impairments)
By institution type, sub-national levels
% of pre-primary classrooms by structure type (e.g., makeshift, semi-solid, etc.)
By sub-national levels, location, institution type (public, private, camp, community-based)
Existence of implementation guidelines for nationally approved pre-primary curricula which promotes a play-based approach
Existence of at least one nationally approved pre-primary curriculum which promotes a play-based approach
Existence of at least one nationally approved curricula or related teaching materials which have been reviewed and revised to reflect inclusion considerations for children with disabilities, ethnic minority groups, refugees, displaced persons, and other marginalized groups as relevant to context
Tab 2
Completed Thematic Studies
This is an example of the information for a thematic study that can complement your evidence base.
Hover over the headings of the columns for information on how to fill the columns.
| Thematic Study Title | Theme/Area of Focus | Year | Rationale | Reliability | Summary of Key Findings | Summarize Key Gaps Identified in the Study | Link |
|---|---|---|---|---|---|---|---|
|
Example: Examining parental engagement in early childhood education in Ghana: Implications for interventions |
Family and community engagement | August 2019 | This is a comprehensive qualitative study examining how Ghanaian parents of pre-primary school-aged children engage in their child’s education. This is relevant to the subsector as family engagement is a core component of quality of ECE services. | Medium. The study was conducted by Innovations for Poverty Action, in collaboration with UNICEF. This study was commissioned by the Ghana Education Service following a subsector diagnostic workshop that revealed family engagement as a key challenge, and the need to identify evidence-based strategies to effectively engage parents in ECE. The research data was collected in 12 schools across three regions in Ghana – Northern, Ashanti, and Greater Accra – with 36 caregivers, 18 teachers, and 6 head teachers (60 participants in total, 20 per region). The study is recent (conducted in July 2019). |
|
|
Provide the hyperlink here, if available |
Supplementary Information
Guiding Questions on Data Collection Processes
As you fill out the Data Mapping tab, it may be useful to consider the following guiding questions on data collection processes and costs, as these can help you identify the most appropriate/relevant options for filling data gaps.
Fill out this checklist of guiding questions to help you reflect on appropriate/relevant options for filling data gaps.
If you wish to use the online format of the tools, you may create an account to save your progress and return to the tool at a later time. You can create an account by clicking on the login icon at the top of the page.