Data Science to Identify Inequalities in CPS
Session Number
Project ID: BHVSO 04
Advisor(s)
Dr. Angel Alvarez; Northwestern University, Feinberg School of Medicine
Discipline
Behavioral and Social Sciences
Start Date
19-4-2023 9:05 AM
End Date
19-4-2023 9:20 AM
Abstract
This project aims to understand and address the unequal distribution of resources within the Chicago Public School System. We have conducted various analyses using data science techniques such as Microsoft Excel functions, SQL, and Tableau. Our data sources are publicly available datasets under the Freedom of Information Act (FOIA) from CPS and the Illinois State Board of Education, including transfer records, truancy records, and selective enrollment test scores. Data also includes FOIA records from the Illinois District Attorney’s office, which allow us to see how these records are being processed. These analyses reveal patterns of inequality between different schools and neighborhoods within Chicago. By presenting this data and the trends it outlines at board meetings, we are able to propose and implement changes that will lead to a more equitable education system for all students.
Data Science to Identify Inequalities in CPS
This project aims to understand and address the unequal distribution of resources within the Chicago Public School System. We have conducted various analyses using data science techniques such as Microsoft Excel functions, SQL, and Tableau. Our data sources are publicly available datasets under the Freedom of Information Act (FOIA) from CPS and the Illinois State Board of Education, including transfer records, truancy records, and selective enrollment test scores. Data also includes FOIA records from the Illinois District Attorney’s office, which allow us to see how these records are being processed. These analyses reveal patterns of inequality between different schools and neighborhoods within Chicago. By presenting this data and the trends it outlines at board meetings, we are able to propose and implement changes that will lead to a more equitable education system for all students.