by Laksmi Setiawati

linkedin.com/in/laksmi-setiawati

​

EVALUATION

ELEMENTARY SCHOOL

of

in DKI Jakarta year 2018

• To evaluate the number of students and the number of teachers whether it is proportional to the number of schools.

​

• To evaluate whether the distribution of elementary schools is proportional in each sub-district.

​

• To evaluate environmental condition of schools.

​

• To evaluate how many schools that accredited or have low accreditation.

Objective

Methodology

Data

Gathering

Data

Cleaning & Analyst

Data

Visualization

Insights &

Recommendation

Gathering datasets from Jakarta Open Data

Change data types, remove irrelevant values, EDA and analyst using Looker

Creating dashboard using Looker for data visualization

Provide insights & recommendations

Dataset Overview

2,923

Elementary

Schools

Teachers

40,765

Students

815,389

Countries

6

Subdistrict

44

Data Source: https://data.jakarta.go.id/dataset/data-sekolah-sd-dki-jakarta

Number of Schools

• 27.47% schools are placed in Jakarta Timur, 22.67% is Private School and 77.33% is Public School. But Jakarta Barat have the highest Private School 28.61% of 846 total Private Schools.
• Meanwhile Kepulauan Seribu doesn’t have Private School. 0.67% of 2,923 are Public Schools.

Ratio of Schools, Students & Teachers Each City

• Number of students and teachers are not in proportion with number of schools.
• East Jakarta has the most students but the number of teachers and the number of schools is not equivalent to the number of students

Break Down Number of School

• Cengkareng have 4.48% (131) of the total number of school
• Cengkareng become the highest total school

Break Down Number of Student

• Cengkareng have 5.22% (42,572 Student) of the total number of student
• Cengkareng become the highest total student

Break Down Number of Teacher

• Duren Sawit have 4.66% (1,900) of the total number of teacher
• Duren Sawit become the highest total teacher

School Accreditation

• 2.77% schools are unaccredited
• Need further investigation to 4 schools that the accreditation is unknown
• 42.08% schools must improve accreditation

please refer to https://tinyurl.com/mvpc6588 to see list of unaccredited schools

School Environmental Conditions

• 30% schools have bad environment condition. 20.32% densely packed with students or seedy and 9.68% the neighborhood floods in the rainy season
• Need further investigation to 2 schools that the environment condition is unknown

please refer to https://tinyurl.com/mvpc6588 to see list of schools with bad environmental conditions

Recommendation

Unaccredited schools must be starting to register the school for accreditation

Because schools with accreditation are more trusted by the public to be able to provide good performance and quality education.

​

Schools with B and C accreditation must improve accreditation

By improving accreditation, schools also improving the quality of education and the quality of graduates.

​

The mayor must pay attention to sub-districts where flooding is still occurring

Students and teachers will feel uncomfortable if the school environment is flooded. Activities will also be disrupted.

​

The governor of DKI Jakarta must pay attention to the distribution of students and teachers so that it is proportional with the number of schools

East Jakarta has the most students but the number of teachers and the number of schools is not equivalent to the number of students

Recommendation

Need further investigation why some schools are densely packed with students

Schools with many students will slow down the teaching and learning activities because the teacher have to teach too many students in one class and will could be difficult for teachers to pay attention to many students.

​

Need further investigation why some schools are in seedy condition

Seedy environment condition will makes students and teachers will feel uncomfortable.

Dashboard

Screenshot

​

​

https://lookerstudio.google.com/u/0/reporting/7a5e7bd2-6631-413b-ac7c-506d6042183b/page/63LjD

Thank You