After careful consideration, the relationship between Toronto schools and the Education Bureau was analyzed for this assignment. The goal is to confirm the quantity and proportion between the Education Bureau and schools by accessing the dataset obtained from the official website of Toronto, to understand whether the various regions of Toronto provide sufficient educational resources.

The first step was to extract two datasets from the official website of Toronto, one labeled all school locations within the city, and the other labeled all education bureau locations. The commonality between these two datasets is that both datasets include municipality. By using Excel spreadsheets for data filtering, a table was finally classified and summarized, which includes the six regions of Toronto and the number of schools and education bureaus. After obtaining the data, I started making bar charts for comparison. In this chart, the number of schools and education bureaus in different regions is compared. The schools in six regions correspond to the education bureaus in six regions. In the data, North York has the highest number of schools, while Scarborough has the highest number of Education Bureau locations. I chose a bar chart to provide a more intuitive comparison of the data, highlighting the gap in educational resources between different regions in Toronto, as well as the gap in the number of schools under the responsibility of the Education Bureau.

In addition, a map I created in Studio Mapbox highlights the geographical locations of the Education Bureau and schools. And color differences were applied to different regions, as well as to education bureaus and schools, to gain a more intuitive understanding of different regions and their distribution. This different visualization can present complex data more intuitively, making it easier for ordinary people to understand such complex information.

In East York, the number of schools is small, but the number of schools that the Education Bureau can handle is relatively small, which allows them to focus more on one school. Regions like North York and Former Toronto have many schools, but the number of schools that the Education Bureau can handle is also high, which distracts their attention and correspondingly reduces efficiency. Compared to using points on a map to represent various schools and education bureaus, charts can more intuitively display differences in data and be better understood.

From this, it can be concluded that an area with a larger number of schools may indicate that students in this area have more choices and more educational resources. Regions with fewer schools have relatively poorer teaching resources. However, having many education bureaus does not necessarily mean that they have high efficiency and energy.