The âStrength in Numbersâ motto adopted by the Golden State Warriors beautifully represents the organization at multiple levels. The most obvious manifestation of this motto can be found immediately upon opening their app or visiting theirÂ website where they proudly post their current win-loss record along with an abundance of other team stats. Wouldnât it be great if ourÂ educational districts, schools, and charters in Santa Clara County proudly pronounced their own strength in numbers by posting comprehensive win-loss records as evidenced by the percentage of students who meet or exceed on standardized tests?
Sadly, when we visit our school district, county, or state websites, we often do not see how the children are performing academically. I have had the opportunity to work with school districts across the country for over 45 years. Most recently, I have engaged in conducting surveys and focus group meetings with students to find out what is important to them as we initiate strategic planning processes in school districts in the states of Washington and New York. For the most part, students want their teachers to treat them well and to respect them. Most importantly, though, they want their teachers to prepare them for their future college and career goals. As we subsequently engage with parents and community members, we find great concordance with the student aspirations.
It is my belief that students, parents, community members, teachers, and administrators should be able to access and interpret comprehensive and complete data visualizations of student academic performance. The interpretation of these data visualizations should help develop student goals for the district and schools that will ultimately support most students in achieving their dreams of being successful in college and career.
To this end, I have begun to build data visualizations of student academic performance for English and mathematics atÂ sipbigpicture.com. This will be a herculean task but hopefully not a Sisyphean one. Please visit the site, get some data, and cheer me on!
At this site, you will find a math data visualization for San Jose Unified School District (SJUSD), among others. You will find two heat mapped tables for student performance. The first table provides a comprehensive view of student performance on the state math test for three years. The table is organized by grade and by year. The color continuum goes from red (low performance) to green (high performance). The state math test is aligned with the Common Core state standards in math, which identify what students should know and be able to do in math in order to be on track for college and career. Viewing the table, you can begin to answer the following fundamental questions:
- Is there overall improvement in grade-level student performance over time?
- Is there subgroup improvement in grade level student performance over time?
The colored heat maps make it easy to see patterns and to develop findings for these key questions. Overall, student performance is low (yellow) with most grades consistently scoring under 50 percent meeting or exceeding math standards. There has been some modest improvement at each grade level over three years. (with the exception of 11thÂ grade) The Asian subgroup demonstrates consistent high (green) performance over time while the English learner subgroup demonstrates low (red) performance over time.
The table on the second page shows student performance by year by grade level. Viewing this table, you can begin to answer the following questions.
- Is there overall grade-level improvement in student performance within a given year?
- Is there subgroup grade level improvement in student performance within a given year?
Within any year, there is no improvement in math performance as you go from thirdÂ to 11thÂ grade in any given year. In fact, there is a drop in performance every year between student math performance in thirdÂ grade compared with student math performance in 11thÂ grade. (Yellow to Red). The Asian subgroup demonstrates consistently high performance (green) across grade levels within any of the three years while students with disabilitiesÂ show consistently low (red) performance across grades within a given year.
You can see that using the colored heat maps. it is easy to discover patterns and findings of student performance. Wouldnât it be nice to be able to access data visualizations of this kind for your school district and school? Regrettably, neither the county nor the state offer any real help in producing easy to interpret data visualizations. In fact, the state has been complicit in obfuscating student performance by developing an Academic Indicator Dashboard that contributes to the fog of education.
The state system works like this. If the low end of the scale score band for Level 3 (meeting standards) is say 100 scale score points and student A scores 90 scale score points on the math state test for their grade level, and student B scores 110 scale score points, and student C scores 115 scale score points, the system subtracts each student scale score from 100 arriving at derived values of -10, +10, and +15. Tallying these values gives you +15 and then dividing by 3 students gives you +5. This value is slightly positive but would receive a green color or a high performance on the academic indicator.
This is a flawed process because it is merely a redistribution of excess scale score points and does not give you a true reflection of actual student performance. It masks the fact that Student A is not scoring within the proficient band by redistributing scale score points from students B and C to student A. Unfortunately, students B and C will probably not be able to follow student A to college to help remediate issues he may be having with college level math. This would be like the NBA allowing teams to takeÂ extra points from their wins and then distributing them to their losing scores to bolster win-loss records!
Interestingly, the state does not include 11th grade students in this process and builds a second indicator for 11th graders called college and career. Could it be that there is not enough extra scale score points to spread around for 11th graders?
SJUSD reported the positive picture that they were a green school district for the state academic performance indicator on their state mandated Local Control Accountability Plan (LCAP). From the previous data visualizations and interpretations, you can see that SJUSD is not yet a highly proficient district as it relates to student math performance.
So rather than helping school districts visualize a comprehensive, open, and transparent performance on state tests as an academic accountability indicator, the state obfuscates performance using a spreading-the-scale-score-points gambit. Of course, the districts and schools love this system because of its simplicity and ability to mask actual poor performance. The state loves it because it artificially supports their LCAP system as "getting" student results. The adults are saved with this system while the students, parents, and community wait for a true picture of student performance
If you are interested in viewing a comprehensive and easily interpretable data visualization of your school or districtâs student academic performance in math, please visit my web site at sipbigpicture.com. If you do not see your school or district data visualization, please send me a note and I will hasten the development of your report.
We need to support our school districts in becoming more like sports teams such as the amazing Golden State Warriors, whichÂ has well-defined goals, metrics to gauge success, and a theory of action to achieve those results. Letâs help our school districts follow a similar path to success. A little competition is a good idea!
Dr. Bill Conrad is an educator who has provided several decades of teaching, administrative, and consulting support to school districts and schools within Santa Clara County and throughout the nation. He specializes in strategic planning and implementation, accountability, assessment, and science education.Â Opinions are the authorâs own and do not necessarily reflect those of San Jose Inside.