Context

The World Bank is an international financial institution that provides loans to countries of the world for capital projects. The World Bank's stated goal is the reduction of poverty. Source: https://en.wikipedia.org/wiki/World_Bank

Content

This dataset combines key education statistics from a variety of sources to provide a look at global literacy, spending, and access.

For more information, see the World Bank website.

Fork this kernel to get started with this dataset.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:world_bank_health_population

http://data.worldbank.org/data-catalog/ed-stats

https://cloud.google.com/bigquery/public-data/world-bank-education

Citation: The World Bank: Education Statistics

Dataset Source: World Bank. This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by @till_indeman from Unplash.

Inspiration

Of total government spending, what percentage is spent on education?

This Public Schools feature dataset is composed of all Public elementary and secondary education facilities in the United States as defined by the Common Core of Data (CCD, https://nces.ed.gov/ccd/ ), National Center for Education Statistics (NCES, https://nces.ed.gov ), US Department of Education for the 2017-2018 school year. This includes all Kindergarten through 12th grade schools as tracked by the Common Core of Data. Included in this dataset are military schools in US territories and referenced in the city field with an APO or FPO address. DOD schools represented in the NCES data that are outside of the United States or US territories have been omitted. This feature class contains all MEDS/MEDS+ as approved by NGA. Complete field and attribute information is available in the ”Entities and Attributes” metadata section. Geographical coverage is depicted in the thumbnail above and detailed in the Place Keyword section of the metadata. This release includes the addition of 3065 new records, modifications to the spatial location and/or attribution of 99,287 records, and removal of 2996 records not present in the NCES CCD data.

This report shares information about school performance, sets expectations for schools, and promotes school improvement. School Quality Report Educator Guides can be found here.

US: Net Intake Rate in Grade 1: Male: % of Official School-Age Population data was reported at 68.707 % in 2015. This records a decrease from the previous number of 71.614 % for 2014. US: Net Intake Rate in Grade 1: Male: % of Official School-Age Population data is updated yearly, averaging 71.855 % from Dec 2002 (Median) to 2015, with 12 observations. The data reached an all-time high of 75.719 % in 2010 and a record low of 68.669 % in 2013. US: Net Intake Rate in Grade 1: Male: % of Official School-Age Population data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s USA – Table US.World Bank: Education Statistics. Net intake rate in grade 1 is the number of new entrants in the first grade of primary education who are of official primary school entrance age, expressed as a percentage of the population of the corresponding age.; ; UNESCO Institute for Statistics; Weighted average; Each economy is classified based on the classification of World Bank Group's fiscal year 2018 (July 1, 2017-June 30, 2018).

This point datalayer shows the locations of schools in Massachusetts. Schools appearing in this layer are those attended by students in pre-kindergarten through high school. Categories of schools include public, private, charter, collaborative programs, and approved special education. This data was originally developed by the Massachusetts Department of Environmental Protection’s (DEP) GIS Program based on database information provided by the Massachusetts Department of Education (DOE). The update published on April 17th, 2009 was based on listings MassGIS obtained from the DOE as of February 9th, 2009. The layer is stored in ArcSDE and distributed as SCHOOLS_PT. Only schools located in Massachusetts are included in this layer. The DOE also provides a listing of out-of-state schools open to Massachusetts' residents, particularly for those with special learning requirements. Please see http://profiles.doe.mass.edu/outofstate.asp for details. Updated September 2018.

To collect feedback on their learning environment from families, students and teachers. Aids in facilitating the understanding of families perceptions, students, and teachers regarding their school. School leaders use feedback from the survey to reflect and make improvements to schools and programs. Each year all parents, teachers and students in grades 6-12 take the NYC School Survey. The survey is aligned to the DOE's Framework for Great Schools. It is designed to collect important information about each school's ability to support student success.

2018 DC School Report Card. The sum of the student group scores using all applicable STAR framework metrics. This is a number from 0 – 100 points. Overall STAR score for the school based on all applicable framework scores and student groups. Star value assigned to the school based on the STAR score.1, 2, 3, 4, or 5. Supplemental:Metric scores are not reported for n-sizes less than 10; metrics that have an n-size less than 10 are not included in calculation of STAR scores and ratings.At the state level, teacher data is reported on the DC School Report Card for all schools, high-poverty schools, and low-poverty schools. The definition for high-poverty and low-poverty schools is included in DC's ESSA State Plan. At the school level, teacher data is reported for the entire school, and at the LEA-level, teacher data is reported for all schools only.On the STAR Framework, 203 schools received STAR scores and ratings based on data from the 2017-18 school year. Of those 203 schools, 2 schools closed after the completion of the 2017-18 school year (Excel Academy PCS and Washington Mathematics Science Technology PCHS). Because those two schools closed, they do not receive a School Report Card and report card metrics were not calculated for those schools.Schools with non-traditional grade configurations may be assigned multiple school frameworks as part of the STAR Framework. For example, a K-8 school would be assigned the Elementary School Framework and the Middle School Framework. Because a school may have multiple school frameworks, the total number of school framework scores across the city will be greater than the total number of schools that received a STAR score and rating.Detailed information about the metrics and calculations for the DC School Report Card and STAR Framework can be found in the 2018 DC School Report Card and STAR Framework Technical Guide (https://osse.dc.gov/publication/2018-dc-school-report-card-and-star-framework-technical-guide).

Data includes: board and school information, grade 3 and 6 EQAO student achievements for reading, writing and mathematics, and grade 9 mathematics EQAO and OSSLT. Data excludes private schools, Education and Community Partnership Programs (ECPP), summer, night and continuing education schools.

How Are We Protecting Privacy?

Results for OnSIS and Statistics Canada variables are suppressed based on school population size to better protect student privacy. In order to achieve this additional level of protection, the Ministry has used a methodology that randomly rounds a percentage either up or down depending on school enrolment. In order to protect privacy, the ministry does not publicly report on data when there are fewer than 10 individuals represented.

* Percentages depicted as 0 may not always be 0 values as in certain situations the values have been randomly rounded down or there are no reported results at a school for the respective indicator. * Percentages depicted as 100 are not always 100, in certain situations the values have been randomly rounded up.

The information in the School Information Finder is the most current available to the Ministry of Education at this time, as reported by schools, school boards, EQAO and Statistics Canada. The information is updated as frequently as possible.

This information is also available on the Ministry of Education's School Information Finder website by individual school.

Descriptions for some of the data types can be found in our glossary.

School/school board and school authority contact information are updated and maintained by school boards and may not be the most current version. For the most recent information please visit: https://data.ontario.ca/dataset/ontario-public-school-contact-information.

The University of Washington - Beyond High School (UW-BHS) project surveyed students in Washington State to examine factors impacting educational attainment and the transition to adulthood among high school seniors. The project began in 1999 in an effort to assess the impact of I-200 (the referendum that ended Affirmative Action) on minority enrollment in higher education in Washington. The research objectives of the project were: (1) to describe and explain differences in the transition from high school to college by race and ethnicity, socioeconomic origins, and other characteristics, (2) to evaluate the impact of the Washington State Achievers Program, and (3) to explore the implications of multiple race and ethnic identities. Following a successful pilot survey in the spring of 2000, the project eventually included baseline and one-year follow-up surveys (conducted in 2002, 2003, 2004, and 2005) of almost 10,000 high school seniors in five cohorts across several Washington school districts. The high school senior surveys included questions that explored students' educational aspirations and future career plans, as well as questions on family background, home life, perceptions of school and home environments, self-esteem, and participation in school related and non-school related activities. To supplement the 2000, 2002, and 2003 student surveys, parents of high school seniors were also queried to determine their expectations and aspirations for their child's education, as well as their own educational backgrounds and fields of employment. Parents were also asked to report any financial measures undertaken to prepare for their child's continued education, and whether the household received any form of financial assistance. In 2010, a ten-year follow-up with the 2000 senior cohort was conducted to assess educational, career, and familial outcomes. The ten year follow-up surveys collected information on educational attainment, early employment experiences, family and partnership, civic engagement, and health status. The baseline, parent, and follow-up surveys also collected detailed demographic information, including age, sex, ethnicity, language, religion, education level, employment, income, marital status, and parental status.

The American Community Survey Education Tabulation (ACS-ED) is a custom tabulation of the ACS produced for the National Center of Education Statistics (NCES) by the U.S. Census Bureau. The ACS-ED provides a rich collection of social, economic, demographic, and housing characteristics for school systems, school-age children, and the parents of school-age children. In addition to focusing on school-age children, the ACS-ED provides enrollment iterations for children enrolled in public school. The data profiles include percentages (along with associated margins of error) that allow for comparison of school district-level conditions across the U.S. For more information about the NCES ACS-ED collection, visit the NCES Education Demographic and Geographic Estimates (EDGE) program at: https://nces.ed.gov/programs/edge/Demographic/ACS

Existing studies from the United States, Latin America, and Asia provide scant evidence that private schools dramatically improve academic performance relative to public schools. Using data from Kenya—a poor country with weak public institutions—we find a large effect of private schooling on test scores, equivalent to one full standard deviation. This finding is robust to endogenous sorting of more able pupils into private schools. The magnitude of the effect dwarfs the impact of any rigorously tested intervention to raise performance within public schools. Furthermore, nearly two-thirds of private schools operate at lower cost than the median government school.

SCHOOL PROFICIENCY INDEXSummaryThe school proficiency index uses school-level data on the performance of 4th grade students on state exams to describe which neighborhoods have high-performing elementary schools nearby and which are near lower performing elementary schools. The school proficiency index is a function of the percent of 4th grade students proficient in reading (r) and math (m) on state test scores for up to three schools (i=1,2,3) within 1.5 miles of the block-group centroid. S denotes 4th grade school enrollment:Elementary schools are linked with block-groups based on a geographic mapping of attendance area zones from School Attendance Boundary Information System (SABINS), where available, or within-district proximity matches of up to the three-closest schools within 1.5 miles. In cases with multiple school matches, an enrollment-weighted score is calculated following the equation above. Please note that in this version of the data (AFFHT0004), there is no school proficiency data for jurisdictions in Kansas, West Virginia, and Puerto Rico because no data was reported for jurisdictions in these states in the Great Schools 2013-14 dataset. InterpretationValues are percentile ranked and range from 0 to 100. The higher the score, the higher the school system quality is in a neighborhood. Data Source: Great Schools (proficiency data, 2015-16); Common Core of Data (4th grade school addresses and enrollment, 2015-16); Maponics (attendance boundaries, 2016).Related AFFH-T Local Government, PHA and State Tables/Maps: Table 12; Map 7.

To learn more about the School Proficiency Index visit: https://www.hud.gov/program_offices/fair_housing_equal_opp/affh ; https://www.hud.gov/sites/dfiles/FHEO/documents/AFFH-T-Data-Documentation-AFFHT0006-July-2020.pdf, for questions about the spatial attribution of this dataset, please reach out to us at GISHelpdesk@hud.gov. Date of Coverage: 07/2020

The 2020-2021 School Neighborhood Poverty Estimates are based on school locations from the 2020-2021 Common Core of Data (CCD) school file and income data from families with children ages 5 to 17 in the U.S. Census Bureau’s 2017-2021 American Community Survey (ACS) 5-year collection. The ACS is a continuous household survey that collects social, demographic, economic, and housing information from the population in the United States each month. The Census Bureau calculates the income-to-poverty ratio (IPR) based on money income reported for families relative to the poverty thresholds, which are determined based on the family size and structure. Noncash benefits (such as food stamps and housing subsidies) are excluded, as are capital gains and losses. The IPR is the percentage of family income that is above or below the federal poverty level. The IPR indicator ranges from 0 to a top-coded value of 999. A family with income at the poverty threshold has an IPR value of 100. The estimates in this file reflect the IPR for the neighborhoods around schools which may be different from the neighborhood conditions of students enrolled in schools.All information contained in this file is in the public domain. Data users are advised to review NCES program documentation and feature class metadata to understand the limitations and appropriate use of these data.

Daily Attendance figures are accurate as of 4:00pm, but are not final as schools continue to submit data after we generate this preliminary report.

This map shows schools, school districts, and population density throughout the US. Click on the map to learn more about the school districts and schools within an area. A few things you can learn within this map:How many public/private schools fall within the district?What type of population density lives within this district? Socioeconomic factors about the Census Tracts which fall within the district:School enrollment of under 19 by grade Children living below the poverty level Children with no internet at home Children without a working parentRace/ethnicity breakdown of the population within the districtFor more information about the data sources:Socioeconomic factors:The American Community Survey (ACS) helps us understand the population in the US. This app uses the 5-year estimates, and the data is updated annually when the U.S. Census Bureau releases the newest estimates. For detailed metadata, visit the links in the bullet points above. Current School Districts layer:The National Center for Education Statistics’ (NCES) Education Demographic and Geographic Estimate (EDGE) program develops annually updated school district boundary composite files that include public elementary, secondary, and unified school district boundaries clipped to the U.S. shoreline. School districts are single-purpose administrative units designed by state and local officials to organize and provide public education for local residents. District boundaries are collected for NCES by the U.S. Census Bureau to support educational research and program administration, and the boundaries are essential for constructing district-level estimates of the number of children in poverty.The Census Bureau’s School District Boundary Review program (SDRP) (https://www.census.gov/programs-surveys/sdrp.html) obtains the boundaries, names, and grade ranges from state officials, and integrates these updates into Census TIGER. Census TIGER boundaries include legal maritime buffers for coastal areas by default, but the NCES composite file removes these buffers to facilitate broader use and cleaner cartographic representation. The NCES EDGE program collaborates with the U.S. Census Bureau’s Education Demographic, Geographic, and Economic Statistics (EDGE) Branch to develop the composite school district files. The inputs for this data layer were developed from Census TIGER/Line and represent the most current boundaries available. For more information about NCES school district boundary data, see https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries.Private Schools layer:This Private Schools feature dataset is composed of private elementary and secondary education facilities in the United States as defined by the Private School Survey (PSS, https://nces.ed.gov/surveys/pss/), National Center for Education Statistics (NCES, https://nces.ed.gov), US Department of Education for the 2017-2018 school year. This includes all prekindergarten through 12th grade schools as tracked by the PSS. This feature class contains all MEDS/MEDS+ as approved by NGA. Complete field and attribute information is available in the ”Entities and Attributes” metadata section. Geographical coverage is depicted in the thumbnail above and detailed in the Place Keyword section of the metadata. This release includes the addition of 2675 new records, modifications to the spatial location and/or attribution of 19836 records, the removal of 254 records no longer applicable. Additionally, 10,870 records were removed that previously had a STATUS value of 2 (Unknown; not represented in the most recent PSS data) and duplicate records identified by ORNL.Public Schools layer:This Public Schools feature dataset is composed of all Public elementary and secondary education facilities in the United States as defined by the Common Core of Data (CCD, https://nces.ed.gov/ccd/ ), National Center for Education Statistics (NCES, https://nces.ed.gov ), US Department of Education for the 2017-2018 school year. This includes all Kindergarten through 12th grade schools as tracked by the Common Core of Data. Included in this dataset are military schools in US territories and referenced in the city field with an APO or FPO address. DOD schools represented in the NCES data that are outside of the United States or US territories have been omitted. This feature class contains all MEDS/MEDS+ as approved by NGA. Complete field and attribute information is available in the ”Entities and Attributes” metadata section. Geographical coverage is depicted in the thumbnail above and detailed in the Place Keyword section of the metadata. This release includes the addition of 3065 new records, modifications to the spatial location and/or attribution of 99,287 records, and removal of 2996 records not present in the NCES CCD data.WorldPop Populated Foorprint layer:This layer represents an estimate of the footprint of human settlement in 2020. It is intended as a fast-drawing cartographic layer to augment base maps and to focus a map reader's attention on the location of human population. This layer is not intended for analysis.This layer was derived from the 2020 slice of the WorldPop Population Density 2000-2020 100m and 1km layers. WorldPop modeled this population footprint based on imagery datasets and population data from national statistical organizations and the United Nations. Zooming in to very large scales will often show discrepancies between reality and this or any model. Like all data sources imagery and population counts are subject to many types of error, thus this gridded footprint contains errors of omission and commission. The imagery base maps available in ArcGIS Online were not used in WorldPop's model. Imagery only informs the model of characteristics that indicate a potential for settlement, and cannot intrinsically indicate whether any or how many people live in a building.

US: Over-Age Students: Primary: % of Enrollment data was reported at 5.447 % in 2015. This records a decrease from the previous number of 5.461 % for 2014. US: Over-Age Students: Primary: % of Enrollment data is updated yearly, averaging 5.564 % from Dec 1975 (Median) to 2015, with 26 observations. The data reached an all-time high of 16.320 % in 1975 and a record low of 4.559 % in 2002. US: Over-Age Students: Primary: % of Enrollment data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s USA – Table US.World Bank: Education Statistics. Over-age students are the percentage of those enrolled who are older than the official school-age range for primary education.; ; UNESCO Institute for Statistics; ;

The Annual Arts Education survey collects information on student participation in and access to arts education at NYCDOE schools.

Please note the following arts-related data are now collected from other sources: The number of certified art teachers and non-certified teachers teaching the arts is collected form the HR and BEDS survey The arts instructional hours provided to elementary students are collected from the Student Transcript and Academic Recording System (STARS) The middle and high school participation in the arts data and the NYSED requirement data are collected form STARS and the HS arts sequence data are also collected form STARS

Overall attendance data include students in Districts 1-32 and 75 (Special Education). Students in District 79 (Alternative Schools & Programs), charter schools, home schooling, and home and hospital instruction are excluded. Pre-K data do not include NYC Early Education Centers or District Pre-K Centers; therefore, Pre-K data are limited to those who attend K-12 schools that offer Pre-K. Transfer schools are included in citywide, borough, and district counts but removed from school-level files. Attendance is attributed to the school the student attended at the time. If a student attends multiple schools in a school year, the student will contribute data towards multiple schools. Starting in 2020-21, the NYC DOE transitioned to NYSED's definition of chronic absenteeism. Students are considered chronically absent if they have an attendance of 90 percent or less (i.e. students who are absent 10 percent or more of the total days). In order to be included in chronic absenteeism calculations, students must be enrolled for at least 10 days (regardless of whether present or absent) and must have been present for at least 1 day. The NYSED chronic absenteeism definition is applied to all prior years in the report. School-level chronic absenteeism data reflect chronic absenteeism at a particular school. In order to eliminate double-counting students in chronic absenteeism counts, calculations at the district, borough, and citywide levels include all attendance data that contribute to the given geographic category. For example, if a student was chronically absent at one school but not at another, the student would only be counted once in the citywide calculation. For this reason, chronic absenteeism counts will not align across files. All demographic data are based on a student's most recent record in a given year. Students With Disabilities (SWD) data do not include Pre-K students since Pre-K students are screened for IEPs only at the parents' request. English language learner (ELL) data do not include Pre-K students since the New York State Education Department only begins administering assessments to be identified as an ELL in Kindergarten. Only grades PK-12 are shown, but calculations for "All Grades" also include students missing a grade level, so PK-12 may not add up to "All Grades". Data include students missing a gender, but are not shown due to small cell counts. Data for Asian students include Native Hawaiian or Other Pacific Islanders . Multi-racial and Native American students, as well as students missing ethnicity/race data are included in the "Other" ethnicity category. In order to comply with the Family Educational Rights and Privacy Act (FERPA) regulations on public reporting of education outcomes, rows with five or fewer students are suppressed, and have been replaced with an "s". Using total days of attendance as a proxy , rows with 900 or fewer total days are suppressed. In addition, other rows have been replaced with an "s" when they could reveal, through addition or subtraction, the underlying numbers that have been redacted. Chronic absenteeism values are suppressed, regardless of total days, if the number of students who contribute at least 20 days is five or fewer. Due to the COVID-19 pandemic and resulting shift to remote learning in March 2020, 2019-20 attendance data was only available for September 2019 through March 13, 2020. Interactions data from the spring of 2020 are reported on a separate tab. Interactions were reported by schools during remote learning, from April 6 2020 through June 26 2020 (a total of 57 instructional days, excluding special professional development days of June 4 and June 9). Schools were required to indicate any student from their roster that did not have an interaction on a given day. Schools were able to define interactions in a way that made sense for their students and families. Definitions of an interaction included: • Student submission of an assignment or completion of an assessment, in whichever manner the school is collecting • Student participation in an online forum, chat log, or discussion thread • Student/family phone call, email or response to teacher email • Phone, email, and/or other digital communication with a family member which confirms student interaction/engagement • Other evidence of participation as determined by the principal. Interactions data are attributed to students' school of record on a given day. A student participating in a Shared Instruction (SHIN) model may have recorded interactions at multiple schools on a given day, but only one record is counted for the interaction rate, attributed to students' school of record for that day. Due to the shift to hybrid learning, attendance data for the 2020-21 school year include both in-person and remote instruction. Total days, days absent, and days present fields include both in-person and remote attendance.

More information on attendance policies can be found here: https://www.schools.nyc.gov/school-life/rules-for-students/attendance

The National Center for Education Statistics’ (NCES) Education Demographic and Geographic Estimate (EDGE) program develops annually updated school district boundary composite files that include public elementary, secondary, and unified school district boundaries clipped to the U.S. shoreline. School districts are special-purpose governments and administrative units designed by state and local officials to provide public education for local residents. District boundaries are collected for NCES by the U.S. Census Bureau to develop demographic estimates and to support educational research and program administration. The NCES Common Core of Data (CCD) program is an annual collection of basic administrative characteristics for all public schools, school districts, and state education agencies in the United States. These characteristics are reported by state education officials and include directory information, number of students, number of teachers, grade span, and other conditions. The administrative attributes in this layer were developed from the 2020-2021 CCD collection. For more information about NCES school district boundaries, see: https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries. For more information about CCD school district attributes, see: https://nces.ed.gov/ccd/files.asp.Notes: -1 or M Indicates that the data are missing. -2 or N Indicates that the data are not applicable. -9 Indicates that the data do not meet NCES data quality standards. All information contained in this file is in the public domain. Data users are advised to review NCES program documentation and feature class metadata to understand the limitations and appropriate use of these data.