Performance Analysis & Visualization of High School/College Student's Data
AN ANALYSIS TO ASCERTAIN THE FACTORS AFFECTING THE ACADEMIC PERFORMANCE OF HIGH SCHOOL/COLLEGE STUDENT'S
A portfolio project involving a detailed analysis of 37,997 high schools/colleges student records to showcase key insights through the aid of effective visualizations and report aimed at evaluating the factors affecting student's academic performance in high school and colleges in the US.
The project was carried out using SQLite online where the dataset was uploaded to create a database by joining four tables of csv files of student data obtained for this analysis, using the database which served as our reporting table to create additional tables for the purpose of answering the research questions on the student data and to ascertain some factors that had an effect on student's academic performance in USA high schools/colleges.
The analysis attempted to find answers to the following questions through a root cause analysis process:
What are the proportion of educated students by ethnicity?
How can we evaluate the Cost of college tuition against household income?
What is the effect of a student's parents education on the education of the student?
Is location of school a determinant on tuition?
What are the differences in student's performance with respect to where the school is location?
Which ethnic group has a higher performance rate in schools and which gender performs better on average?
Does the age of a student have an effect on their academic performance in school?
See project report here or on GitHub