Data enthusiasts analyse access to education and facilities in schools across Bengaluru’s constituencies

The data analysts explored these questions: How many students are there per constituency population? Are there staff and facilities in schools?

OpenCity.in, on April 1st 2023, organised a datajam at the Indian Institute of Management (IIM), Bangalore to analyse data of various sectors-education, civic participation, and mobility-for all the 28 Bengaluru Assembly constituencies. The event brought together participants from diverse backgrounds, including urban designers, policy wonks, GIS experts, developers, data scientists, and more.

This article highlights the team’s findings in education.

Problem statement

How many students are there per constituency population? Are there enough staff and facilities in the schools to serve these students?

Background

We started out by asking basic questions on what constitutes education and the basic infrastructure needed for different schools and grades. We obtained this information from the  Unified District Information System for Education Plus(UDISE+) report (see chart below) from the Ministry of Education, Government of India.

graph of what constitutes education and the basic infrastructure needed for different schools and grades
Source: UDISE+ , Ministry of Education, 2021-22
Pre-primary secondary data
Source: National Building Code, 2005; Urban and Rural Development Plans Formulation and Implementation(URDPFI) guidelines

District-wise availability of infrastructure and facilities

We initially looked at the number of schools and who they were managed by in the three districts of Bengaluru rural, Bengaluru North and Bengaluru South.

table of district-wise availability of infrastructure and facilities in bengaluru
Source: UDISE+ dashboard for 2021-2022, report ID 3013

We found that there is a high ratio of private to government schools in urban areas. In stark contrast, the ratio is very small in neighbouring rural areas.


Read more: A few low cost private schools attempt to bridge the learning gap


District-wise infrastructure availability

We created heat maps of common facilities available across school categories in each of the three districts. We express the availability of various facilities like medical checkups, toilets, hand wash areas, ramps, etc, in percentage terms. This availability is colour coded red for 0%, yellow for 50%,and green for 100%. Any number between 0% and 50% is a mix of red and yellow, and likewise a number between 50% and 100% is a mix of yellow and green. This heat map allows us to visually identify the areas requiring attention and improvement.

District wise heat map of common facilities across schools in three districts.
Source: UDISE+ dashboard for 2021-2022, report ID 3013
District wise heat map of common facilities across schools in three districts.
Source: UDISE+ dashboard for 2021-2022, report ID 3013
District wise heat map of common facilities across schools in three districts.
Source: UDISE+ dashboard for 2021-2022, report ID 3013.

We found that many schools don’t have functional toilets/urinals and lack medical check-ups on a regular basis.


Read more: Students in this govt school excel against all odds


Classification of public and private schools 

The constituency-wise distribution of public and private schools is as shown below:

Assembly ConstituencyPrivate SchoolsGovernment schools
B.T.M Layout4822
Bangalore South10338
Basavanagudi506
Bommanahalli10126
Byatarayanapura8245
C.V. Raman Nagar4927
Chamrajapet6330
Chickpet6621
Dasarahalli10430
Gandhinagar5022
Govindarajanagar7319
Hebbal8019
Jayanagar6110
K.R. Puram10060
Mahadevapura4238
Mahalakshmi Layout9613
Malleswaram5118
Padmanabhanagar8415
Pulakeshinagar9219
Rajajinagar7014
Rajarajeshwarinagar11831
Sarvagnanagar9231
Shantinagar3326
Shivajinagar6216
Vijayanagar8517
Yelahanka3021
Yeshwanthpura8446

Access to schools as compared with population

URPFI guidelines provides a recommendation for city planners and administrators on how physical and the social amenities can be planned with respect to the population. Using the same norms, we have tried to understand where each of the wards stand in terms of accessibility to schools and the population it covers. The population data at the ward level is the 2011 Census and the schools’ location datasets are from the KGIS database scraped by OpenCity.in.

URPFI guidelines
Source: URDPFI Guidelines, 2014. Ministry of Urban Development

Primary schools

The analysis revealed that 51 out of the 198 wards had an inadequate number of primary schools with respect to the ward population. Wards such as Basavangudi and Girinagar (deficit of five primary schools each) had the maximum deficit as compared to the other wards. Jakkur ward (surplus of 37 primary schools) had a high surplus of primary schools.

Map of access to primary schools at ward level
Access to primary schools at ward level

Secondary Schools

Similarly, analysis showed that nine out of the 198 wards had inadequate number of secondary schools with respect to their ward population. Wards such as Katriguppe, Subash Nagar and Padarayanapura (deficit of two secondary schools each) had the most deficit. HBR layout ward (surplus of 34 secondary school) had a high surplus.

Map of access to secondary schools at ward level.
Access to secondary schools at ward level

Four wards were found to be having inadequate number of both primary as well as secondary schools: Chalavadipalya (Chamarajpet Assembly constituency (AC), Rajamahal Guttahalli (Malleswaram AC), Shivaji Nagar (Shivaji Nagar AC), and Katriguppe (Basavanagudi AC).

School rating based on amenities

Rating calculation method

All schools were categorized based on availability of three basic amenities – access to water, electricity and toilet facility for girls. The schools were given a higher rating if the access to water was easier (say from a tap) and lesser scores if the access to water was difficult (say from a hand pump or a well or no access at all).

For electricity, schools were given higher scores if electricity was available and lower if not. The number of toilets available for girls was considered as it is.

These scores were added to arrive at an amenities score at the school level. These scores were normalized to bring them on a scale of 0 to 1 for ease of interpretation. Looking at the distribution and using the mean score to divide the data, two sets of categories – high and low – were created to classify schools based on the basic amenities that they provide.

These individual scores for the schools were then added by constituency type and divided by the number of constituencies to arrive at a composite score at the constituency level.

School amenities numbers

Interpretation 

The schools are classified into ‘high’ and ‘low’ based on their performance in the composite amenities score (based on water, electricity and toilet access for girls). The schools that are able to provide all these facilities adequately would have received a higher score. Those that lacked some or all of these facilities (at the desired level) would have received a lower score. Data shows a certain number of schools in each constituency performing ‘low’ on availability of amenities while some fell into the ‘high’ category.

Assembly ConstituencyAssembly ConstituencyAssembly Constituency
B.T.M Layout3931
Bangalore South8259
Basavanagudi2432
Bommanahalli8542
Byatarayanapura8839
C.V. Raman Nagar4432
Chamrajapet5934
Chickpet4344
Dasarahalli9242
Gandhinagar4725
Govindarajanagar6626
Hebbal4950
Jayanagar4328
K.R. Puram8476
Mahadevapura5624
Mahalakshmi Layout6544
Malleswaram3732
Padmanabhanagar5841
Pulakeshinagar6744
Rajajinagar5133
Rajarajeshwarinagar9158
Sarvagnanagar6558
Shantinagar2831
Shivajinagar2949
Vijayanagar6636
Yelahanka3912
Yeshwanthpura9336

The inference from this data is that the local representative of the constituency should focus on those schools in his area which has a lower amenities score and ensure these basic amenities are provided.

table of amenities score by school type

By aggregating schools across all constituencies by type, we can see that 76% of government schools scored low on amenities as compared to 55% of private schools. The amenities score is aggregated at the constituency level to understand which constituencies are performing better or worse than others when it comes to provision of basic amenities in schools.

Amenities score at the constituency level.

Looking at the aggregate constituency level amenities score, it can be observed that Shivajinagar, Basavanagudi and Malleswaram are the best performing constituencies while Byatarayanapura, Yelahanka, Bommanahalli and Mahadevapura are the worst performing ones.

The local administration could target the worst performing constituencies first and then move to those with relatively higher scores so as to improve access to basic facilities in all schools.

GIS map of the constituencies based on their amenities score
GIS map of the constituencies based on their amenities score

It can be seen that schools with better amenities are located in central Bengaluru whereas as one moves outwards from the city center towards the periphery, the schools seem poorly equipped in providing basic amenities of water, electricity and washroom access for girls.

Recommendations 

  1. We suggest that MLAs of the lagging constituencies take up the recruitment of teachers and checking of infrastructure in schools as we return to normal educational delivery.
  2. We also feel that citizens need to be more vocal about the educational needs of their children and push for better physical and technological infrastructure at schools in their wards.

Sources

Also read:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Similar Story

Mumbai ‘leader mothers’ creating milestones in early education programme

Pratham's Mothers Groups for Nipun Maharashtra programme involves mothers to enable children to achieve functional literacy and numeracy.

One of the most important goals under NEP 2020  is to achieve universal foundational literacy and numeracy in primary schools by the year 2025. The Ministry of Education started the National Initiative for Proficiency in Reading with Understanding and Numeracy (NIPUN) Bharat in July 2021. The goal is to enable children to attain basic foundational skills by the time they reach Class III. The Ministry aims to achieve this by 2026-27. Read more: Students detained in spare classroom: Who pays when school fees become unaffordable? Pratham's Leader Mother for NIPUN Maharashtra programme Pratham, an NGO established in 1995, has been working…

Similar Story

“Blood. Sweat. Tears. Repeat”: What NEET aspirants are in for as NTA bungles

The future of 24 lakh students is at stake, and teachers predict a tough next year too. Experts call for urgent reforms in the NEET exam.

What does the National Eligibility cum Entrance Test (NEET) mean to the 23.8 lakh students aspiring to become doctors? "Blood, sweat, tears, repeat" — this is how a second year MBBS student described her years of preparation for the NEET, while studying in classes 11th and 12th. At least a year before that is consumed by anxiety, decision-making, determination and planning for the preparation. And, all this does not include the financial aspect, which amounts to lakhs and sometimes even crores.   Shalmali (name changed) is a second-year MBBS student in the Government Medical College in Dhule. She recounts the long…