What Makes A Good Education?

Examining the Results and Opportunity for Further Research in the Teen Education Poll

Analysis by: Justice Murray

Last Updated: 8/8/2023

Table of Contents

Purpose (What are we talking about?)

​

The Story (What does the data say?)

​

Conclusion��

Purpose - Intro to the Data

Over 54,000 high school students responded to a poll on the After School app, “Are you getting a good education?”��Students were also asked why they felt like they were or were not getting a good education.

​

Teen Education Poll���

Initial Data

From these pie charts it is clear that teachers can make or break a student’s education. The next two largest factors are motivation and other.

Objective

We have a chance to design a more effective survey, getting students to identify what motivates them. When we tap into meaningful relationships and motivation for students, that contributes to 60% of factors impacting student perception of education. This provides an opportunity to make a big impact.

​

Is there a correlation between the percent of students naming Motivation and the Good Education percent by state?

Limitations

• Student data is not attached to a unique identifier, it is all grouped by state and yes or no. This means that we can’t examine relationships with specific student demographics(i.e. Grade, Gender, Social-Economic Status, Race)

​

• The ‘other’ and ‘motivation’ categories are broad. We want to understand what contributes to the motivation and what the possibilities in the ‘other’ category are. Give students an opportunity to define what motivates them and what contributes to their success. There could be an option to write in why they are checking other in their answer.

​

​

The Story - Digging Into the Data

1st step

Mapping Students who answered Yes to a Good Education by state - are there regional trends?

​

​

2nd step

Charting the percent of Good Education students who named Motivation as a factor

​

​

Access the interactive Tableau dashboard here

4 states with the Highest Good Education Percent

​

The percent of students who mentioned motivation is between 37% - 47%

​

​

​

Access the Tableau visualization here

4 states with the Lowest Good Education Percent

The percent of students who mentioned motivation is between 32% - 41%��This is a lower range than the Highest 4 states

37% - 47%

​

​

Access the Tableau visualization here

​

Correlation between Motivation and Good Education

A correlation is measuring the statistical relationship between two variables. In this case how the percentage of motivation relates to each state’s percent of students who feel they are getting a good education. The closer the correlation is to 1, the stronger the relationship

Correlation: 0.36��There is a moderate correlation between Motivation % and Good Education % by state.

Conclusion - Where do we go from here?

With the moderate correlation between motivation and a good education, it is worth investigating further. What motivates students? Is it relationships? School environments? �Understanding motivation and the impact of teachers can help make significant gains in creating a good education for all students.

Appendix

Data Source: Teen Education Poll ���Data Workbook: Teen Education Factors Data���Tableau Workbook: Relationship Between Good Education and Motivation���R- Markdown: Good Education Capstone.rmd���SQL Queries: SQL Queries used in BigQuery Analysis��