Skip to content

Latest commit

 

History

History
82 lines (58 loc) · 2.68 KB

READMORE.md

File metadata and controls

82 lines (58 loc) · 2.68 KB

Analysis Notes

Three trends based on this dataset:

  1. School size and score results can have a negative effect on student performance. The larger the number of students, the lower success in grades.

  2. The budget per student and spending levels are negatively correlated with scores.

  3. Students from Charter schools perform better than students from District schools. The data shows a significant difference with the overall passing rate among students between Charter and District schools. The largest Charter school has much better scores than the smallest District school. This data only takes into consideration large District and small Charter school size so there is probably a discrepancy with the two types of schools.

District Summary

  • District's key metrics, including:
    • Total Schools
    • Total Students
    • Total Budget
    • Average Math Score
    • Average Reading Score
    • % Passing Math
    • % Passing Reading
    • Overall Passing Rate (Average of the above two)

School Summary

  • Overview table summarizing key metrics about each school, including:
    • School Name
    • School Type
    • Total Students
    • Total School Budget
    • Per Student Budget
    • Average Math Score
    • Average Reading Score
    • % Passing Math
    • % Passing Reading
    • Overall Passing Rate (Average of the above two)

Top Performing Schools (By Passing Rate)

  • Top 5 performing schools based on Overall Passing Rate:
    • School Name
    • School Type
    • Total Students
    • Total School Budget
    • Per Student Budget
    • Average Math Score
    • Average Reading Score
    • % Passing Math
    • % Passing Reading
    • Overall Passing Rate (Average of the above two)

Top Performing Schools (By Passing Rate)

  • This table highlights the bottom 5 performing schools based on Overall Passing Rate. Includes all of the same metrics as above.

Math Scores by Grade

  • This table lists the average Math Score for students of each grade level (9th, 10th, 11th, 12th) at each school.

Reading Scores by Grade

  • This table lists the average Reading Score for students of each grade level (9th, 10th, 11th, 12th) at each school.

Scores by School Spending

  • This table breaks down school performances based on average Spending Ranges (Per Student). Includes the following:
    • Average Math Score
    • Average Reading Score
    • % Passing Math
    • % Passing Reading
    • Overall Passing Rate (Average of the above two)

Scores by School Size

  • This table groups schools based on a reasonable approximation of school size (Small, Medium, Large).

Scores by School Type

  • This table groups schools based on school type (Charter vs. District).

Education

Coding Boot Camp (C) 2018. All Rights Reserved.