1 of 6

SAT scores

Kashfia Faruque

2 of 6

What questions are the data answering?

My hypothesis

Do schools have a role in the performance of students in SAT exams?
If students study more in terms of time, do they get higher score?

Schools have a role in the performance of students in SAT exam. So students attending certain schools have a higher probability of performing better in the exam
The score of students is proportionate to the time they spend preparing for the exam.

2

3 of 6

Process for evaluating the data

Used SQL to extract the percentage of students from each school who scored equal to or greater than 1550
compared across the schools based on the student’s percentage.

**I used 1550, as according to the College Board, students who score 1550 out of 2400 have a 65% likelihood of achieving a B- average or higher during their freshman year. So I took that as the cut off for good score **

3

Visualization created using excel-clustered column charts.

**used dataset from modeanalytics: tutorial.sat_scores. Dataset had 135 students**

4 of 6

Process for evaluating the data (contd)

Used SQL to calculate total score
determined the number of hours a student studied to arrive to their total score.

Cannot really see the hypothesized increasing trend in scores with more hours.

4

Visualization created using excel-scatter plot.

5 of 6

Conclusion

Students of certain schools (in this case Petersville HS, St John’s) tend to perform better in SAT than other schools. So schools might have a role in a student’s performance in SAT.
Studying for longer hours for SAT doesn’t necessarily translate to higher score.

For definitive conclusion for these hypothesis, students of more schools needs to be considered.

Link to github for the SQL code: https://github.com/Kashfia18/sat_scores

5

6 of 6

Websites used

6