Capstone Project: Exploring Student Performance

In Capstone project, we have received Dataset of the Watertown district public schools. In the dataset, 5 public school in that district are included which are operated under the supervision appointed committee and a superintendent of Watertown district by government bodies of the Massachusetts. The 5 school in the Watertown district are came under municipal government. The 5 schools are as follows

1. Cunniff Elementary
2. Hosmer Elementary
3. James Russel Lowell Elementary
4. Watertown Middle School
5. Watertown High School

The purpose of these capstone project is to build an interactive data dashboard to student performance and professional qualification of the teacher. With help of these, District public School will develop an annual report card of the student and show it to parent.

In this capstone project, I am concentrating on Watertown middle school data in the year 2013 and 2014 and Student Athletics data for the year 2017/18 for all 5 school which is covered under Watertown district.

In the figure 1,2 and 3, I am showcasing Number of enrolled in math, English and Algebra related subjects in the year 2013 and 2014 of the Watertown Middle school.

In the figure 4, The Graph shows that how many student in Watertown middle school get what percentage of marks in the year 2013 and 2014 both year of all subjects which are taught in school in all grade.

In the figure 5,6, and 7, I have done in-depth analysis of the Watertown middle school student. I have built the graph of the student performances in grade 6,7, and 8 for example how many students got A in Grade 6, 7 and 8 A or A- and so on.

In the below figure 8 and 9, The Charts build on different Sports played by male and Female in terms of count. Whereas in graph 10 is combination of graph 8 and 9, But I have also added the grade filter in the graph which represent that how many male or female students played in specific grade for example 10 Male students played Baseball from grade 7. Which will reflect in same colour in lighter shades.

In the above Chart is combination of the two datasets which MCAS and I-Ready. I have made inner join between two different datasets based on Student ID (SASID). There are total 1139 student enrolled in 5 different school in the year 2017-18. This graph shows that out of 1139 student in Watertown district public schools how many students are white, how many are African American means black, Hispanic or Latino etc. We have analysed this information through provided data from the superident of the Watertown district Ms Deanne Galdston.

In these capstone project of the Watertown District, our group has bifurcated the data between 4 of us. I am analysing dataset of Watertown middle school area and Athletic data of 5 public schools in the Watertown district area.

In the Last Graphs, I have combined two datasets which is MCAS – I-ready Equivalent based on Student Id which is also known as SAS ID.

Conclusion

In conclusion, the findings of this capstone project provide valuable insights for the superintendent of the Watertown district to assess school achievements and effectively track various data elements. By creating an interactive data dashboard, the district public schools can develop comprehensive annual report cards for students, enhancing communication with parents and stakeholders.

This project focused on analyzing data from Watertown Middle School for the years 2013 and 2014, along with student athletics data for the academic year 2017/18 across all five schools in the Watertown district. Through detailed analysis and visualization, key metrics such as student enrollment in different subjects, academic performance, and participation in sports were examined.

By merging datasets such as MCAS and I-Ready, a broader understanding of student demographics and academic performance was achieved. This comprehensive analysis, combined with the development of a user-friendly data dashboard, enables district stakeholders to make informed decisions and comparisons with other public schools in Massachusetts.

Moving forward, the strategic structural design of this analysis will be instrumental in addressing the diverse interests of educational organizations, including district, school, and government bodies. By linking various data elements effectively, this project lays the foundation for ongoing assessment and improvement in student outcomes and educational practices within the Watertown district public schools.

Reference

1. 2018 Accountability Data - Boston (00350000). (n.d.). Retrieved from http://profiles.doe.mass.edu/accountability/report/district.aspx?linkid=30&orgcode=00350000&orgtypecode=5&
2. Massachusetts Department of Elementary and Secondary Education. (n.d.). DistrictReportcard. Retrieved from http://reportcards.doe.mass.edu/2018/DistrictReportcard/03140000?Length=8
3. Watertown Middle School. (n.d.). Retrieved from https://wms.watertown.k12.ma.us/parent_resources/principal_bulletin/principal_bulletin_archives