Overview and key findings: Data dashboards

Written by Mica Pollock, Jedd Cohen, Josh Wairi, and Seth Woodworth for the dashboard project.

Click here for the Summary on this project; click here for the Expanded story on this project.

Communication we hoped to improve

What aspect of existing communication did we try to improve, so that more people in Somerville could collaborate in young people's success? How’d it go?

(Who was involved in the project and how was time together spent? What did the project accomplish?)

In an era when you can log on to any computer and get quick updates from friends, there’s no reason why all the people who need to know basic info in order to serve young people can’t know it immediately! Quantitative measures or summary data about young people (e.g., a report card) never show "the whole child" (eportfolios can help with that!), but they still provide information crucial to the process of tracking student progress, and they do tend to predict important events like “dropping out.”

Unfortunately, access to the data systems needed to provide this info varies widely among districts. Those that can afford it are increasingly investing in sophisticated data systems. Lower income districts can’t afford to. And when districts do have online data display tools, called “data dashboards,” they typically aren't designed by educators or parents.

We - local technologists, teachers, and researchers - have been working with families, afterschool providers, principals, and central administration in the Somerville School District to meet the need for a user-friendly, affordable way to view lots of student data in one place. The result of our work is a suite of three “data dashboards” - open source web applications designed to link the family, teachers, principal, and afterschool providers in communication about student data to support each student’s success.

Considering who usefully sees what data on children has been core to the dashboard project. Guided by a collaborative design process that drew on representatives of all the community stakeholders above, Somerville technologists Seth Woodworth and Evan Burchard created three views: an “admin view” for principals, which shows data on all students in the school; a “teacher view,” which shows a teacher data on the students in his or her class; and an “individual view,” designed to link teachers, afterschool providers, and families in communication about the details of an individual student’s profile. We’ll pilot each of these views at Somerville’s Healey School this fall: We’ll pilot the individual and teacher views with 5th grade teacher (and author) Josh Wairi and his students, and we’ll pilot the admin view with Principal Purnima Vadhera.

We felt that it was crucial to collaborate with the Somerville community to design open-source educational tools that link the partners in young people’s education in regular communication about their learning. Here are the main reasons:

A gap in student data equals a gap in service.

Principals Vadhera and DeFalco, teacher Josh Wairi, and various students we talked to in our other pilots all mentioned instances where a student “fell through the cracks” because of a piece of missing data -- for example, a student who received an unexpectedly poor grade at the end of the semester, with the parent, the homeroom teacher, or the administrator surprised by the news. These main partners also described how seeing new patterns, and faster, could support timely interventions -- from MCAS accommodations to targeted academic support.

One-Stop Shopping: It is crucial to be able to see different kinds of student data at the same time, in a single display.

Lots of people in Somerville talked about the need to improve data display for parents and students, teachers, afterschool providers, and administrators. To clarify: A typical district has a “student information system” - a database that stores or “warehouses” student information. However, many districts do not have any easy tools for quickly displaying that information to multiple partners at once or letting them sort the data for patterns.

In Somerville, administrators had to send data analysis requests to a central office (filled with great staff!) and the staff would send patterns back to them. Or, teachers had to create their own Excel spreadsheets or printouts and analyze them by hand. The data was inaccessible for other reasons, too: People had a hard time understanding the way the system displayed data, the data is only in English, and viewers cannot comment ON the data.

Administrators also told us of time wasted in meetings as staff flipped through multiple folders or drawers to find data; further, staff wasted lots of time preparing for meetings by trying hand-analyze patterns across such data sources.

Open source data tools could save schools across the country significant costs, if tech support for open source tools were available locally.

We decided to develop an open source solution for one simple reason: Open source tools can save districts lots of money. With open source, districts don’t have to buy the product itself or renew the license to use; they only have to pay for services (upkeep and troubleshooting the tool), which can be a fraction of the cost. Our technologist Seth put it this way: “Take the quarterly profit of a company like Blackboard INC (Quarter 1, 2010) and break it down into services and license fees. In just one quarter, Blackboard made only $7.3 million in services [tech support], but made $93.7 million dollars in 'product revenues' (licenses to run their software). In the K-12 context, a freely available and documented open source competitor to store-bought communication tools would free up a lot of money back to US schools.”

Based on a model created in Excel by Healey parent Greg Nadeau, and designed in partnership with Principals Jason DeFalco and Purnima Vahdera, and teacher Josh Wairi during the 2010-2011 school year, the admin dashboards provide quick views for teams of teachers and administrators to compare students in a group and discern patterns. All data fields are visible on one screen, so there is no need to click through multiple windows to view the desired data. Viewers can sort up to three columns at a time simply by clicking at the top of each while holding down the shift key. Whereas the admin view lists all students in the school, the teacher view presents similar information for a single class of students. Here is the admin view, with fictional data to maintain confidentiality:

NewAdminDash.jpg

Our individual view (below) complements this with additional student data that was identified by parents, students, afterschool providers, and teachers as being especially relevant to their communications with each other. This view also gives parent and afterschool provider viewers the chance to comment on the data and send these comments to the teacher, sparking an exchange that can continue over email or in person. Here is the individual view’s final page, where viewers can review and submit their comments:

Note the tabs for viewing other pages at the top of the screenshot. The images below show the pages connected to each of these tabs:

Our work, and our ¡Ahas!

What was the basic groundwork needed to support the current work? How did the project change and grow over time? At this point, what are our main ¡Ahas! about improving communications in public education? What communication and implementation ¡Ahas!, and turning points, did we have over time?

Communication and implementation ¡Aha!s, and turning points!

We had many ¡Aha!s in sequence on this project over two years. To read the full story of the efforts that gave us these ¡Ahas!, click here!

Our ¡Aha!s about data dashboards included the following.

Technological how-tos

Here's where we describe "how to" use every tool we used, so that others could do the same. We also describe "how to" make every tool we made!

Click here for the Summary on this project; click here for the Expanded story on this project.