The COVID-19 crisis has significantly affected the education sector across all regions.

The closing of schools has interrupted the functioning of the system, reducing student learning, and restricting the activities of education authorities, parents, and decision-makers.

As the pandemic progresses, many important decisions need to be made based on a systematic understanding of deployed policies up to date.

The Ask

What countries had the highest school population?

What educational styles were used and overall usage?

What were the school population by country?

What was the rate of school closures vs partially open?

What was the school population status from 2020 - 2022?

Why

We can know what countries still decided to have schools open.

The educations style which are effective other than physically being in school.

We can find out rate of which a school would close.

We can find out the school population status in the span of 2 years.

Stakeholders

• Education System
• Parents
• Students

Tools used

• Excel for Domain knowledge and identifying which columns I would use.
• SQL Big Query for data manipulation and transformation
• Tableau for analysis and vizuals

Data Source and Collection

The data was sourced from kaggle and from world bank. It was multiple excel files which I used SQL to join tables to create and combine into one table. Then proceeded to export it as a csv.

Exploratory Data Analysis

I used SQL to do my data exploration. I found the following facts:

• India and China Countries with the average students.
• The most used form of education was TV, Radio and online learning.
• By Year 2022 Average School population was 90,570,893,178.

Visualizations

I used Tableau for visualizations. You can check out the dash board at School Closures During Covid-19

Presentation

You can check out the presentation that is saved as a PDF in this repository.