2020 National High School Graduation Examination Analysis
CONCEPT
CONCEPT
The National High School Graduation Examination (NHSGE) is considered the most critical exam of high-schoolers in Vietnam. It serves two purposes, high school graduation, and university entrance. The subjects are Maths, Literature, English, Physics, Chemistry, Biology, History, Geography, and Civic Education. This project helps journalists analyze and discover some insight into the NHSGE's result in 2020.
DATA
The raw data, scrapped from diemthi.hcm.edu.vn, the official website of the Vietnam Ministry of Education & Training, is processed to be a clean dataset.
The clean dataset includes Registration Number, Date of Birth, and the scores of subjects. The maximum score is 10, and the minimum is 0. If a student does not take or register for a subject, the score will be -1.
In the web scrapping phase, some Registration Numbers are invalid. The simple technique of try-except solved the problem. I got the list of invalid Registration Numbers then eliminated it from the process.
In the cleaning phase, because the raw data results from the web scrapping, I cleaned it based on HTML knowledge. For students with maximum scores, I need to handle some exceptions.
The student's name is Vietnamese, so I have decoded it for readability.
PROCESS
In order to analyze the NHSGE data and generate insights out of it, I followed the process:
- Scrapped the data from web
- Cleaned and handled anomalies and exceptions
- Performed Exploratory Data Analysis using Python
- Draw some interesting insights
INSIGHTS
- The oldest test-taker was born in 1963(Pic #1).
- There is no considerable gap between the average performances of older test-takers and grade-12 students(Pic #2).
- The most popular last name of student is Nguyễn(Pic #3).
- Vietnamese Students perform Maths better than English(Pic #4).
Bar chart showing the year of birth distribution
Avarage Score by Age Group
WordCloud of Student's Last Name
Stacked Distribution of Maths and English Scores