project-team_dd

We are looking into school diversity in order to determine which type of school district has the greatest diversity and which has the least. We also compare diversity in two school years.

View on GitHub

School diversity across different school districts and in different school years ================ by Team DD

Summary

We researched diversity across different school districts and in different school years. We used a TidyTuesday dataset. The data comes from The Washington Post and the analysis used the Common Core of Data from the National Center for Education Statistics (NCES). We worked with a data frame with 27,944 rows and 15 variables where each row represents a school district for each school year that we analysed. The analysis only looks at US elementary schools. The question that we posed was ‘To identify the most and least diverse type of school district and to compare the changes in school diversity of the school years 1994-1995 and 2016-2017’. Before carrying out any analysis we hypothesised that large cities would have the greatest diversity and remote rural areas would have the least diversity. We also hypothesised that there would be more diversity in school districts in the school year 2016-2017 compared to 1994-1995. Our reasoning behind using these specific school years is that the school year 1994-1995 is the earliest near-comprehensive data and the dataset used the school year 2016-2017 as it was the latest available data. We decided to use these years as it allows us to compare the change in diversity after a large time period. The variable which we used to compare the diversity was diverse which was measured as follows:

Firstly, we decided to investigate which school district types were most and least diverse. We found that cities were the most diverse school district type as they had the greatest proportion of school districts with a ‘Diverse’ rating. We also found that rural school districts were the least diverse as they had they greatest proportion of schools with an ‘Extremely Undiverse’ rating and the lowest proportion of schools with a ‘Diverse’ rating. We then decided to look closer into the characteristics of each type of school district. This allowed us to gain a better understanding of the diversity in each school district type. Midsize cities were most diverse as they had the largest proportion of school districts with a ‘Diverse’ rating. We also found that distant rural districts were least diverse as they had the greatest proportion of school districts with an ‘Extremely Undiverse’ rating and the lowest proportion with a ‘Diverse’ rating. Both results contradicted our hypothesis, so we looked further into the reasons why. Firstly, we looked at why rural-remote districts were more diverse than rural-distant districts. Although this result contradicted our hypothesis, the diversity for both school district types was very similar so our prediction wasn’t vastly off. We investigated many possible reasons that we thought would cause this however we couldn’t reach a concrete conclusion. When looking into the reasons why midsize cities were more diverse than large cities, we compared the school year 1994-1995 and 2016-2017. We found that there was a large increase in the diversity of small districts in 2016-2017 compared to 1994-1995. This increase was smaller for midsize cities and even smaller for large cities, indicating that immigrants find small cities preferable to large cities. We found that there is a trade-off between lower cost of living and the desired ‘city-buzz’ in small and large cities, possibly explaining why midsize cities are preferable to immigrants and consequently explaining why these school districts are most diverse. Comparing the two school years, we found that the school year 2016-2017 was more diverse than 1994-1995. We concluded this because the proportion of school with a ‘Diverse’ rating was higher for every school district type in 2016-2017. Possible reasons explaining this were improved transportation and improvement in the education system. Based on our findings we thought that it would be interesting to find out which specific school district types had the greatest and least increase in diversity when comparing the two school years. We found that small city districts had the greatest increase. This could be because cities have a large availability of jobs and small cities have a low cost of living compared to larger cities. We also found that rural-distant and rural-remote districts had the smallest increase in diversity. This could be due to the lack of home and jobs available in these areas.

Presentation

Our presentation can be found here. Our recorded presentation can be found here.

Data

TidyTuesday, 2019, School Diversity, electronic dataset, GitHub, viewed 22 October 2020, https://github.com/rfordatascience/tidytuesday/tree/master/data/2019/2019-09-24

Rabinowitzn, K, Emamdjomeh, A, Meckler, L, 2019, How the nation’s growing racial diversity is changing our schools, The Washington Post, 12 September, viewed 22 October 2020, https://www.washingtonpost.com/graphics/2019/local/school-diversity-data/

National Center for Education Statistics (2017) Public Elementary/Secondary School Universe Survey Data, Available at: https://nces.ed.gov/ccd/pubschuniv.asp (Accessed: 22 October 2020)

References

Weinstein, D., E., 2014, Are big cities always more expensive?, World Economic Form, 07 November, viewed 25 November 2020, https://www.weforum.org/agenda/2014/11/are-big-cities-always-more-expensive/

Wodke, G. T, 2014, ‘The Impact of Education on Inter-Group Attitudes: A Multiracial Analysis’, Soc Psychol Q., Viewed 1 December 2020, Available at: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3883053/

Kolodner, M, 2015, Can better transportation increase diversity on college campuses?, The Hechinger Report, 04 November, viewed 1 December 2020, Available at: https://hechingerreport.org/can-better-transportation-increase-diversity-on-college-campuses/

National Center for Education Statistics (2006) Rural Education in America - Definitions Available at: https://nces.ed.gov/surveys/ruraled/definitions.asp (Accessed: 30 November 2020).

Rabinowitzn, K, Emamdjomeh, A, Meckler, L, 2019, How the nation’s growing racial diversity is changing our schools, The Washington Post, 12 September, viewed 22 October 2020, https://www.washingtonpost.com/graphics/2019/local/school-diversity-data/