Created as a result of Ryan Wesslen's Visual Analytics course in the Data Science and Business Analytics master's program at the University of North Carolina Charlotte, this app allows policy makers and school officials in the Charlotte region to investigate the student diversity landscape for the area's public school system from 2008 to 2020.
To view the live app go to https://charlottedatalytics.shinyapps.io/CMS-Diversity/
If you wish to run the app from R Studio instead of going to the above link, you can use the following steps:
- Download all items in the CMS_DIVERSITY folder
- Open CMS-Diversity.Rproj in R Studio
- Make sure both .png files are in a folder called www
- Open data_prep2.R and click run
- Open app.R
- Click "Run App" in the upper right corner of the code panel
- (optional) Click "Open in Browser" in the upper left corner of the app window if you wish to view in browser
The file Final-Report.Rmd produces the summary report for this project.
A pdf version of that report has also been uploaded (Final_Report.pdf).
A powerpoint slide deck outlining the app is also included (CMS_Diversity.pptx).
The data used for our analysis was free and made publically availabe by CMS through the following links:
- https://wearecms.edlioschool.com/apps/pages/index.jsp?uREC_ID=1439962&type=d&pREC_ID=1602825
- https://www.wearecms.com/apps/pages/index.jsp?uREC_ID=1628104&type=d&pREC_ID=1768996
- How the nation’s growing racial
diversity is changing our schools,
by Kate Rabinowitz, Armand Emamdjomeh and Laura Meckler, Washington Post, 2019 - The desegregation and resegregation of Charlotte's Schools,
by Clint Smith, The New Yorker, 2016 - Long-run impacts of school desegregation & school quality on adult attainments,
by Rucker Johnson, National Bureau of Economic Research, 2011 - What led to desegregation busing -- and did it work?,
by Lesley Kennedy, History.com, 2019 - North Carolina bustles with people and money,
by Fay Joyce, The New York Times, 1985
- The Problem We All Live With (audio),
by Nikole Hannah-Jones, This American Life, 2015 - The Legacy of School Busing (audio),
NPR Morning Edition, 2004 - The Battle for School Busing | Retro Report (video),
The New York Times, 2013 - Oldest school desegregation program grows in Rochester, NY (video),
PBS NewsHour, 2016