69传媒

The is trying to make its way through the data maze.

For years, much of the school system鈥檚 data on attendance, academic performance, and student behavior has been stuck in silos, where few teachers and administrators could access it, much less make practical use of it.

And when data is available in the district, too often it鈥檚 out of date, and administrators have questioned its validity and accuracy.

Another complication: When the district has purchased new tech products in the past, it鈥檚 had to figure out if they mesh with existing data systems鈥攁nd if they don鈥檛, there鈥檚 a scramble to create a workaround.

Now, San Francisco district officials have set out to end those disconnects through the pursuit of 鈥渋nteroperability,鈥� a strategy for making data more useful and accessible鈥攁nd a driver of classroom improvements, rather than an impediment.

Melissa Dodd, the San Francisco district鈥檚 chief technology officer, is running the point on those efforts. Now in her third year in the 57,000-student district, Dodd and other administrators are trying to build a system that churns out actionable data that helps the district reach its . Those goals include creating personalized academic pathways for students, finding new ways to motivate them, integrating technology throughout the school day, and re-imagining how space can be used in school buildings.

Education Week Associate Editor Sean Cavanagh recently interviewed Dodd about her district鈥檚 pursuit of interoperability and what other districts can learn from it.

This interview has been edited for brevity and clarity.

Where is the San Francisco district in its efforts to move toward interoperability?

We鈥檙e beyond exploring, and we鈥檙e at a stage of implementation. The journey started before I arrived, in terms of identifying the pain points that teachers, principals, and our senior leadership team were experiencing around data and information. Interoperability gives us a framework and a terminology to describe what we鈥檙e all attempting to do鈥攚hich at the end of the day is to make all of our data and information meaningful to our communities.

What鈥檚 the core problem you are trying solve?

When I started in San Francisco, one of the first things I heard was that we had a lot of data, but it was in a lot of different places and systems, and that made it not user-friendly. A new system would come online, and we鈥檇 say, OK, let鈥檚 figure out how to make our student information system talk with that system. Or how to get another system to talk with this other system. We didn鈥檛 have a comprehensive, coherent, systematic approach for how we were going to integrate data and make it easily accessible to the end-users.

So where did you begin, in terms of trying to fix the situation?

We鈥檙e approaching it from a cultural/organizational transformation, as well as from a technology-technical transformation. I don鈥檛 want to say the technology side is easy, because none of it is really easy. But the harder part is building a common vision, understanding, approach for what we want our end goal to be and how we organize ourselves as a district to enable that. It was really focused on the cultural aspect, the change management that鈥檚 needed for interoperability to take hold.

We started by looking at building coherence across ourselves as an organization. We formed a data-governance committee, and implemented stronger technology governance, so that when we were interested in bringing a data system online, we asked questions first. One question: Do we have a system that can already serve this purpose and need? If we鈥檙e bringing in another system, how are we integrating data and making it interoperable with our existing system. These are questions we didn鈥檛 necessarily ask beforehand.

And what stage of the journey are you at now?

Now we鈥檙e at the second part鈥攖he technical transformation. We鈥檙e really building in the technical infrastructure to support this work moving forward. Part of it is we鈥檝e been consolidating our systems down to an essential few and then implementing data standards, and a technology infrastructure that will help make our data interoperable across all of our systems.

In pursuing interoperability, are you following one standard?

We鈥檙e implementing the . We鈥檙e a part of the alliance. We鈥檙e in year one of a three-year partnership with the Michael and Susan Dell Foundation to help us implement our Ed-Fi standard and to start up an operational data store, as well as a data vault in the cloud. We鈥檙e starting with our core student data and building out from there, then bringing in our education human-resources data, then ultimately bringing in our operational and financial data.

How long will it be before you get where you want to go?

This year, we鈥檙e focused on setting up the infrastructure, the environment. That鈥檚 about a four-month process. But in terms of bringing all of our data in, we鈥檝e mapped that out over a three-year period. We鈥檙e also looking how we serve up and make accessible that data and the practices and culture through which we use that data.

What鈥檚 an example of how data in your district ends up isolated and of little use, and how interoperability might help?

Here鈥檚 a great example: Two of our schools recently went through school board-approved name changes. We need to have a common and consistent way of applying the names of those schools into our core data systems. Right now, we鈥檇 have to do that manually, because a data field in one system doesn鈥檛 speak to a data field in another.

How would interoperability improve your use of attendance data?

Our attendance data starts with a teacher or school clerk entering data into our system. And there can be multiple pieces of attendance data assigned to that student on any given day. Our students typically start the day in our system as 鈥減resent鈥� and our teachers have to take a step to change that to 鈥渁bsent鈥� or 鈥渢ardy.鈥� And then at the secondary level, we鈥檙e taking attendance for each period.

The data resides within our student information system, and it then gets sent out to various other systems we have. For instance, we have another system that makes attendance calls at a certain time of day, which notifies the parent whether their child is in school that day. It goes to our behavioral system so interventions can take place for that student. And then various reports are run at a school level, at a student level, and at an aggregate level鈥攕uch as showing us the percentage of all students who are chronically absent over a period of time. All of those things require that data from one system gets to another. Currently, to get data from our SIS to our behavior system, there鈥檚 a 24-hour lag time. And right now, if two people are running an attendance report and doing a report from the start of school to a specific date, then their report is going to be different, because the data is not real-time. Data is more accurate in one system than in another. So having data interoperable means that our codes, our logic, our definitions are consistent across systems, so that it鈥檚 apples to apples.

Are there multiple ed-tech vendors that operate those data systems, and what will you need them to change?

Yes, we鈥檙e working with our student information system [that is produced by a vendor]. They鈥檒l be adopting and implementing Ed-Fi standards, just as we are as a district. Because of how the information flows out of our SIS and into other systems, we can write the interfaces, but we need the core SIS in place and to have an API [Application Programming Interface] in place to pull the data out in a consistent way and into our other systems.

Is that approach similar to how you will try to make interoperability happen through other data systems?

The approach we look for in our data systems is that they either have open systems or APIs in place that can allow districts to extract the data and interact with other systems. We鈥檙e extracting information from our core SIS. We鈥檙e then bringing it into an operational data store. And then we鈥檙e serving it up into the other systems we use. So we get away from having to create separate interfaces between systems. We want one interface where all the data comes in and we can then push it out.

How do you believe your interoperability efforts will help teachers and students in the classroom?

That鈥檚 ultimately who we鈥檙e serving. We want to make it easier and less burdensome at the school site and in the classroom for our principals and teachers. We want to leverage so that we鈥檙e not sending them through so many systems to get information on their students. They should be able to access information through databoards and make meaning out of it. We want the data they have to be more accessible and accurate, and more real-time. They shouldn鈥檛 have to wait for us to generate some big report for them, so that it鈥檚 a month or two later and it鈥檚 hard for them to make meaning from it.

Where is the San Francisco district when it comes to 鈥渟ingle sign-on鈥�?

We do have single sign-on. All users鈥攕tudents and adults鈥攈ave an SFUSD ID and password and our core systems all have single sign-on.

For our teachers, we leverage the same ID and password for the most part. We do that for security purposes. We don鈥檛 want to have too much access if a teacher steps away from their laptop [in terms of what someone else] would be available to access.

What concerns have you heard from education companies about your interoperability efforts?

Honestly, the vendors we鈥檝e been working with have been stepping up to the plate, because we鈥檙e clear on what our expectations are and what we need to have in place to do business with them. There has been more of a shift with vendors in that it requires them to rethink their technology and how they play with other vendors. I think groups like , , and are pushing the vendors in a way that makes it clear this is the new normal for districts.

You mentioned your district is using Clever. What is your relationship with that company?

We use Clever for instant log-in, and rostering of digital learning applications and tools for students. We pass data from our SIS and class rosters so that if a teacher is using a particular math digital learning tool, they don鈥檛 have to set up their classes as well. It comes from their master schedule from our SIS. There鈥檚 interoperability around student information. It鈥檚 really to relieve the burden and extra steps on teachers and for students, and they鈥檙e going to one place鈥攚e call it our digital backpack鈥攚here they can access our learning tools that they use in our classrooms.

One concern we鈥檝e heard from districts about interoperability is a fear that if they go with one data standard, such as Ed-Fi or IMS Global, they might be prevented from using an innovative e-tech product down the road. Is that a worry for you?

It鈥檚 definitely a factor, but I鈥檇 also say we have a pulse and a check on the likelihood of that in the timeframe we鈥檙e focused on. We didn鈥檛 feel that it was reason enough to not go with the Ed-Fi standard. Our goal is to be as flexible and adaptable as possible, because technology changes and evolves. But the reality for us is that to bring out some new platform or new tool, with our governance process, our intake process, and our decisionmaking, we take a 12-18 month view. We鈥檒l work with vendors to integrate them into our environment.

Also, districts have been talking about interoperability for many years now. What I see now, with the districts that are part of the Ed-Fi alliance鈥攕imilar to IMS Global鈥攁re the economies of scale. More of us are harnessing our buying power and the influence we have to push the technology sector to make the shift with us.