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.
% of children of pre-primary age who have three or more children’s books
By sex,age, location, household wealth, 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
Existence of sectoral law/policy that mandates the provision of free pre-primary education before primary school entry
By sector
Teacher training institution(s)/courses include cross cutting content (i.e. on inclusive education pedagogy and practices, gender-equitable and/or responsive pedagogy and practices, school-related gender-based violence, child protection, preparedness, conflict sensitive education, disaster risk reduction, and early warning/early response, climate change)
Disaggregate by institution type, institution ownership
By sector
Existence of one or more national, approved pre-primary curricula available for teachers to use
% of children who play with two or more types of playthings
By sex, age, location, household wealth, sub-national levels
% of pupils who repeat primary grade 1 (proxy indicator)
Percentage of repeaters in Grade 1 of primary education, By sex, household wealth, location, sub-national levels, disability status, other vulnerability characteristics (i.e. includes but are not limited to ethnic or linguistic minority groups, household wealth, refugees, immigrants, internally displaced persons, single-headed households, etc.)
Existence of inclusive education policy to accommodate children with special needs within pre-primary services
By sector
By location, service provider type (i.e. public, private, community-based, refugee camp), sub-national levels, and type of professional development opportunities (i.e. in-person 3-5 day training, online course, etc.)
Existence of one or more national, approved pre-primary curricula which are holistic (i.e. it includes components of socio-emotional learning and play in addition to pre-academic skills)
% of children who are left alone or under the supervision of another child younger than 10 years of age for more than one hour at least once in the past week
By sex, age, location, household wealth, sub-national levels
Existence of inclusive sectoral law/policy that mandates the provision of free pre-primary education before primary school entry for vulnerable children which includes but are not limited to those part of ethnic or linguistic minority groups, refugees, immigrants, and internally displaced persons
By sector, by vulnerability characteristic (i.e. includes but are not limited to ethnic or linguistic minority groups, refugees, immigrants, and internally displaced persons)
% of pre-primary staff who receive continuous professional development opportunities on play-based pedagogies (e.g., courses, workshops)
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.