keremtatlisarap/berlin-startchancen-dashboard

The Berlin Startchancen Dashboard is a web application that looks at the ratio of students to teachers in Berlin schools taking part in the Startchancen Program, Germany's largest education funding initiative. The program directs money from the federal government and the states into schools that serve a high number of socially disadvantaged students. The person behind this project believes that money alone does not guarantee good education, and that how many teachers are available per student also shapes how well a school can support its students. This dashboard was built to check whether there are gaps in teacher staffing across Berlin's Startchancen schools, and whether those gaps line up with existing social inequality between districts. The application pulls in official data published by the city of Berlin and presents it through two views. The first view gives a citywide overview, showing the total number of schools, students, and teachers in the program, along with a bar chart comparing the average student to teacher ratio across all twelve Berlin districts, plus a ranking of the ten schools with the highest ratios. The second view lets a user pick a single district and see how it compares to the Berlin average, including a breakdown of teacher gender distribution and a data table that can be filtered and downloaded as a CSV file. The project is built with Python, using Pandas for data handling, Plotly for the charts, and Streamlit for the web interface, with additional libraries for reading Excel files and HTML data. The author notes that generative AI was used to help write and debug the code, but that combining the datasets and checking the results for accuracy was done by hand. All the data comes from Berlin's public open data portal and is released under open government licenses that allow reuse and modification. A live version of the dashboard is linked in the README.