COVID 19 Impact on Education

Data Visualization Project

In this project we analyze the impact of COVID19 on students who were enrolled at different universities in various countries. Based on their responses we created our own hypothesis which will help redefine education.

Tools used: Python, Tableau, Excel

Step 1

Step 2

Step 3

Step 4

Step 5

View Complete Presentation ->

Finding the data

After hours of searching, we found 2 different files which included survey questions and an excel file with the responses to those questions.

Exploring the data

Initially, it was difficult to understand and interpret the data as the responses were in a numerical format rather than answers to the survey questions.

A few questions from the survey

Screen Shot 2022-06-16 at 4.18.05 PM.png

Responses to the questions asked in the survey.

Screen Shot 2022-06-16 at 4.11.19 PM.png

As you can see, the responses are in float data type and do not contain the actual responses to the questions and every question has different answers. For eg. In question 8, 'What is your gender?', the answers are represented in numerical format

1.0 = Male

2.0 = Female

3.0 = Gender diverse

4.0 = I prefer not to say

Thus making it difficult to interpret the answers for each question.

Mapping and cleaning the data

In order to make the data understandable and organized, me and my team decided to remove a few columns (questions) from the dataset and change the numerical values into actual answers. This process was extremely time consuming and intense.

Because majority of the answers in the dataset were:

Strongly disagree
Disagree
Neutral
Agree
Strongly Agree

we changed all the numerical's in the dataset to these answers and then started modifying these based on the answers in each question.

Replacing all the float values in the dataset by the below given answers because majority of the questions had these answers.

Screen Shot 2022-06-22 at 3.44.31 PM.png

For the questions that didn't have the above given answers in the survey, we manually changed them. For eg. Q3 initially had 1.0 and 2.0, which represents 'Yes' and 'No' as their answers, but through the above code we changed the entire dataset into 'Strongly Disagree', 'Disagree', 'Neutral', Agree' and 'Strongly Agree'. So now, we have to change 'Strongly Disagree' and 'Disagree' into 'Yes' and 'No' which has been done below.

Screen Shot 2022-06-22 at 3.44.50 PM.png

After replacing all the float values with actual answers, this is what our dataset looks like

Screen Shot 2022-06-22 at 3.56.23 PM.png

We will not be removing the NA values because our analysis is going to be based on visualizations and all our data is categorical.

Creating Visualizations and drawing insights from it

Introduction

The responses to the survey were received from the below given countries

Screen Shot 2022-06-22 at 10.46.02 PM.png

Modes of Education changed during COVID

Every mode of education was impacted as schools went hybrid and online, most lives were disrupted
The percentage change in modes of education is shown here

Screen Shot 2022-06-22 at 10.40.28 PM.png

Evaluation of online classes experience based on survey response

Lack of focus during online teaching has taken a toll on the morale and performance of a student as more than 60% of students feel that it is difficult to focus during online classes

Difficult for a student to focus during online teaching.png

Due to the lack of focus, 50% of students have a negative perception regarding their improvement during online classes

Performance of a student has improved since online classes.png

Relationship between Time spent on Online classes and Time spent on Social Media

On average students are spending more time on social media compared to online classes
The Laptop/Desktop (Green) line in the chart is slightly tilted which indicates that students using Laptops/Desktops tend to spend more time on Social media. Because these students are taking classes on their Laptops/Desktops, they have a mobile or some gadget free to use which may increase their time on social media.

An increase in workload due to online classes has had a negative impact on students who are also working. They now have to prioritize between their job and education which could have an adverse effect on their performance at college.

Study workload has increased since online classes.png

Reasons why students haven’t adapted well to the online teaching:

Lack of resources to support online education
Inability to manage between job and education due to the sudden pressure from both areas
Communication gap between students and professors
Unsuitable Environment

Though 44% of students agree that they have adapted well, there are still 28% of students who are neutral and 27% of students who disagree.

Students have adapted well to the new teaching and learning experience.png

Communication with Faculty during online classes

Online interactions are satisfactory as students get one on one attention from the faculty
Students seem comfortable to reach out to their professors
Online communication is conducive to student and professor due to greater flexibility

Screen Shot 2022-06-22 at 11.19.40 PM.png

Responses from our own survey distributed in class

This survey was conducted in our class to understand student activities Pre and Post COVID

Students commute time

Students have moved further away
the overall commute time has increased

Screen Shot 2022-06-22 at 11.20.24 PM.png

Change in Sleeping Pattern

Sleep cycle has been drastically affected in the pandemic.
There have been variations in people’s sleeping patterns
More hours are now allotted to keeping a healthy sleep cycle

Screen Shot 2022-06-22 at 11.20.34 PM.png

Change in Time allotted for Self Care

Increase in hours spent on healthcare.
People have become more health conscious and spend more time on their health.

Screen Shot 2022-06-22 at 11.20.42 PM.png

Access to Technology

Since majority of students have access to their own technology it would be great to have exams online.
Even the ones who don’t can access to technology can get it issued from the college library.