data-driven

How New York City is using Google Drive to revamp its struggling schools

PHOTO: Patrick Wall
The attendance team at Juan Morel Campos Secondary School projected a new student-data tool onto a white board at a recent meeting.

When the Juan Morel Campos Secondary School attendance team met last Friday to figure out why so many students were missing class, their secret weapon glowed on the wall behind them.

The image on the screen looked like a basic spreadsheet created with Google Drive, the free online software. Actually, it was a powerful tool that helps schools transform the contents of several clunky education department databases into an intricate picture of student behavior. Now, school staffers can dig deep into the records of individual students or zoom far out to find school-wide patterns.

In September, the city rolled out the tool in its new “community schools,” where students and their families receive an array of social services, and in low-performing “Renewal” schools like Campos, an East Williamsburg school that serves grades 6-12.

The spreadsheet projected on the wall at Campos Friday showed the number of days each student had been late or absent this year, and how those numbers compared with last year. The team zeroed in on students who had missed multiple days in recent weeks — a group of more than 100 students in a school of about 630.

Soon, the screen revealed staff members’ notes that told the stories behind the numbers: One girl had just given birth. Other students had moved or been suspended. One truant boy had a habit of staying up late to play video games, while a couple was undergoing relationship turmoil (“Romeo and Juliet gone bad — real bad,” a guidance counselor told the group). The notes described steps the school had taken to intervene, such as counseling sessions, parent calls, and home visits.

Line by line, the new data tool highlighted the many obstacles the school will face as it tries to get more students to class. (Last year, 45 percent of Campos students missed an alarming 20 out of 180 school days, according to Principal Eric Fraser.) But it also revealed progress, as when Fraser asked to see the table sorted by students with improved attendance.

“Those are huge,” he said, going through the names. “We have to celebrate these guys early to keep that gain.”

The city has promised the 94 schools in its Renewal program nearly $400 million in new support. That includes everything from teacher training to health clinics and free eyeglasses. But after analyzing the schools, officials found that many struggle to take advantage of one engine of school improvement already available to them — the vast supply of data the city collects about students’ backgrounds and academic records.

To address this, the city called on New Visions for Public Schools, a nonprofit known for helping schools harness the power of student data. The group’s solution was simple: feed the information from the city’s different databases into easy-to-use spreadsheets, then teach schools how to use them to track student performance and make plans to help.

Fraser, the Campos principal, said the tool has already spared his staff from printing out reams of reports from different data systems and scouring them for patterns.

“It’s pulling up data from tens of reports and putting them on one line of a spreadsheet for each kid,” he said. That saves the school “some really intensive time that was spent cross-referencing printouts of things that are now right at our fingertips.”

The city’s school-data systems are not typically known for being user friendly. The attendance database known as ATS is a decades-old program resembling MS-DOS that users navigate by typing four-letter codes. Even veteran school workers can struggle to pull useful information out of the system.

Francisco Hicks, the attendance coordinator at New Directions Secondary School in the Bronx, said that if he wanted to track a student’s attendance over time, “I’d probably have to print out a report daily and compare it sheet by sheet.”

Schools confront similar challenges when using a separate program, called STARS, which records student grades and tracks credits. High school guidance counselors often print out student transcripts and manually compare them, highlighters in hand, to state graduation requirements.

PHOTO: Patrick Wall
The new attendance-tracker tool is color-coded to show when students were present, late, or absent. It can be sorted to show which students are most at risk of being “chronically absent.”

These technical difficulties are especially worrisome at Renewal schools, where the average attendance rate is nearly seven points below the city average, according to the city’s Independent Budget Office. The four-year graduation rate at Renewal high schools is nearly 19 points behind the average city school.

Education department officials are convinced that Renewal schools could narrow these gaps by keeping closer tabs on student attendance and academic performance, but they’ve struggled in the past with making that data easily accessible.

Last spring, for example, department officials had hoped to send schools detailed lists of seniors who needed additional credits to graduate. They didn’t manage to get those lists out until late May, just weeks before the end of classes. Even then, the lists only came together with last-minute help from New Visions.

The nonprofit, which helps manage about 80 public schools across the city, is known for providing its schools with tools and training to help make sense of student data. It signed a one-year, $2 million contract with the city in July to share its data tools with the 130 city schools that are part of the Renewal and community school programs, and to provide training in how to use them. (Chalkbeat shares a board member with New Visions.)

PHOTO: Patrick Wall
Katie Hahn, who works for the nonprofit Grand St. Settlement, is Campos’ new service coordinator. The city made a point of giving the coordinators access to the new data tools.

The tools, which were made using Google Sheets, allow schools to view information from different parts of their data systems in single spreadsheets that can be easily sorted in ways that city systems cannot. For instance, a school can pull up a list of seniors who still must pass their English Regents and quickly see whether those students have enrolled in Regents-prep classes and when they are scheduled to retake the test.

At Campos, staff members have used the academic-tracking tool to target students who need Regents tutoring during lunch or free periods. They’ve used the attendance tool to target students for phone calls or rewards. Eventually, they plan to use the tools to identify subjects that are tripping up many students so they can offer those classes during the extra period that is required in all Renewal schools.

Staff members can input the interventions they’ve tried, such as art therapy or tutoring. They can add details about which staffer is responsible for monitoring each student’s progress. And the information is now in one place where key staff members, from the principal and guidance counselors to new service coordinators, can see it.

The city made a point of giving access to the service coordinators, who are technically employees of the partner agencies that are helping community and Renewal schools manage all the new services they are adding. The coordinators, whose official title is “community school director,” had to sign confidentiality agreements in order to access the data tools. In the past, service providers often had to ask school employees to print out student records from restricted databases.

“There was always a pretty significant lag time,” said Katie Hahn, Campos’ service coordinator who works for the social-service agency Grand St. Settlement.

Now, said Hahn, who ran Friday’s attendance meeting, the data is “right at my fingertips.”

Chris Caruso, the education department’s executive director of community schools, said it is crucial that schools and their new partners “have access to the same data at the same time.”

“This a push to make data more friendly,” he said, “and to help schools make decisions based on data in a more efficient way.”

Idea pitch

Despite concerns, Jeffco school board agrees to spend $1 million to start funding school innovations

Students at Lumberg Elementary School in Jeffco Public Schools work on their assigned iPads during a class project. (Photo by Nicholas Garcia, Chalkbeat)

Jeffco school employees can apply for a piece of a $1 million fund that will pay for an innovative idea for improving education in the district.

The school board for Jeffco Public Schools on Thursday approved shifting $1 million from the district’s rainy day fund to an innovation pool that will be used to provide grants to launch the new ideas.

The district will be open for applications as soon as Friday.

The board had reservations about the plan, which was proposed by the new schools superintendent, Jason Glass, in November, as part of a discussion about ways to encourage innovation and choice in the district. The board was concerned about how quickly the process was set to start, whether there was better use of the money, and how they might play a role in the process.

Glass conceded that the idea was an experiment and that pushing ahead so quickly might create some initial problems.

“This effort is going to be imperfect because it’s the first time that we’ve done it and we don’t really know how it’s going to turn out,” Glass said. “There are going to be problems and there are going to be things we learn from this. It’s sort of a micro experiment. We’re going to learn a lot about how to do this.”

During the November discussion, Glass had suggested one use for the innovation money: a new arts school to open in the fall to attract students to the district. He said that the money could also be used to help start up other choice schools. School board members balked, saying they were concerned that a new arts school would compete with existing arts programs in Jeffco schools. The board, which is supported by the teachers union, has been reluctant to open additional choice schools in the district, instead throwing most of their support behind the district-run schools.

Board members also expressed concerns about what they said was a rushed process for starting the fund.

The plan calls for teachers, school leaders and other district employees to apply for the money by pitching their idea and explaining its benefit to education in the district. A committee will then consider the proposals and recommend those that should be funded out of the $1 million.

Board members said they felt it was too soon to start the application process on Friday. They also questioned why the money could not also help existing district programs.

“I think a great deal of innovation is happening,” said board member Amanda Stevens.

Some board members also suggested that one of them should serve on the committee, at least to monitor the process. But Glass was adamant.

“Do you want me to run the district and be the superintendent or not?” Glass asked the board. “I can set this up and execute it, but what you’re talking about is really stepping over into management, so I caution you about that.”

Glass later said he might be open to finding another way for board members to be involved as observers, but the board president, Ron Mitchell, said he would rather have the superintendent provide thorough reports about the process. The discussion is expected to resume at a later time.

Stevens said many of the board’s questions about details and the kind of ideas that will come forth will, presumably, be answered as the process unfolds.

“Trying is the only way we get any of that information,” Stevens said.

Future of Schools

Indiana’s graduation rate has barely changed in 6 years while most of the nation is on the rise

PHOTO: Meghan Mangrum
Mbeomo Msambilwa walks down the hallway at the newcomer school

Indiana has failed to significantly increase the number of students who finish high school even as it leads the nation in embracing school choice policies that have been praised by some education advocates across the nation.

From 2007 to 2011, Indiana’s graduation rate steadily climbed from 78 percent to 87 percent. But since 2011, it has risen just one-tenth of one percentage point. Data released by the state this week showed 87 percent of students graduated in 2017, down slightly from 89 percent in 2016.

That’s a sharp contrast with trends across the country. The most recent national graduation rate was lower than Indiana’s, but it increased by about 5 percentage points between 2011 and 2016. The rate is calculated by dividing the number of students who graduate after four years by the number in a high school cohort.

While Hoosier graduation rates have remained stagnant over the past six years, state education policy has been in upheaval.

Since 2011, Indiana policymakers have limited the power of teachers unions, changed how teachers are evaluated, created an A-F grading system for schools and began taking control of schools with poor performance. They vastly expanded the state’s charter school system and established a statewide program where some students could get public money to pay for private school tuition.

Although politicians at the time did not promise that these changes would guarantee widespread higher academic performance, it was part of their arguments in advancing the new policies. But graduation rates have barely budged.

“We recognize there is still work to be done, and will continue to partner with local districts to ensure every student graduates prepared for life beyond high school,” state Superintendent Jennifer McCormick said in a statement.

The picture is more positive in Marion County, with notable gains in some schools and districts. Wayne Township’s Ben Davis University High School graduated 100 percent of its seniors, the highest in Marion County.

At the district level, Franklin Township had the highest graduation rate (97 percent). Beech Grove Schools, which enrolls just over 3,000 students, made the biggest jump of any district in the county, increasing 8 percentage points to 95 percent.

Indianapolis Public Schools also made gains in graduation rates for the second year in a row. Eighty-three percent of students graduated, up 6 percentage points from 2016. The improvement significantly narrowed the gap between the district and the state average. The increase this year is especially notable because there was also a decline in the number of graduates who earned diplomas without passing state tests. Indiana requires students to pass state tests to graduate unless they can get a waiver by meeting other criteria.

The district has made increasing the number of students who graduate a priority in recent years, including by hiring high school graduation coaches who are tasked with helping students get to the finish line.

In IPS, most of the gains were at schools slated to close at the end of this year. The only campus with a substantially higher graduation rate that will remain open is Arsenal Technical High School. The district’s highest graduation rate was at Broad Ripple High School (98 percent), which will close.

Across the state, Asian (88 percent) and white (89 percent) students, and students who do not come from families that are poor enough to qualify for free or reduced-price lunch (95 percent) have the highest graduation rates. Black students and kids with special needs had graduation rates below 80 percent.

The biggest change was among students who are learning English as a new language. They had a graduation rate of 61 percent, down 14 percentage points from last year.