data-driven

How the city is using Google Drive to revamp its struggling schools

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.

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. (Disclosure: Chalkbeat shares a board member with New Visions.)

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.
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.”

men of color

New York state charges forward with its ‘My Brother’s Keeper’ initiative

When young men of color enter high school, they often do so with the deck stacked against them. That’s what a panel of young men from Ithaca and Albany told a room of education policy officials and lawmakers on Friday.

“There’s a mold for us that they want us to fit in,” one student said.

“No one realizes how much potential, not only white students have, but every student has,” another added.

New York state’s top education leaders convened in Albany Friday to tackle the problem posed by these young men: How can the state raise educational achievement for boys and young men of color?

Only about 68 percent of black and Hispanic students graduate on time, while 88 percent of their white counterparts do, according to state graduation rates released last week. Male students fare worse than female students, with a 76 percent graduation rate compared to 83 percent for female students.

The conference is part of the state’s My Brother’s Keeper Initiative, modeled on President Barack Obama’s national program geared toward boosting opportunities for young men of color. Policymakers spearheading New York’s initiative scored a big victory last year, securing $20 million from the legislature and officially becoming the first state to accept Obama’s challenge.

Though the political winds in Washington have changed since then, Friday’s conference sent a clear message that, if the state’s top education officials have anything to do with it, this strand of Obama’s legacy will live on in New York.

Attendees included State Education Commissioner MaryEllen Elia, Regents Chancellor Betty Rosa and assorted lawmakers and superintendents.

“For me, this is the end of the beginning,” said Stanley Hansen, the State Education Department assistant commissioner who runs the program. “We will start today: Staff will be contacting your schools and communities, and we will be out there in force.”

So far, the state has split the $20 million into grants that encourage the recruitment of a diverse pool of high-quality teachers, along with family and community engagement, and programs focused on college and career success. The department is pushing for another $20 million in this year’s budget.

But Regent Lester Young, who is leading the effort on New York’s education policymaking board, reminded the crowd that it will take more than funding to radically change outcomes for young men of color.

“This is not about $20 million because this problem, this challenge, is not going to be solved with $20 million,” Young said. “This will be solved when we decide to change the narrative.”

turnaround time

This Harlem school has one of the highest dropout rates in New York City. Meet the principal working to turn it around.

PHOTO: Alex Zimmerman
Geralda Valcin, principal at Harlem's Coalition School for Social Change

Just two months after becoming principal, Geralda Valcin’s plan to reduce her school’s dropout rate landed her in a parking lot at Rikers Island.

One of her students at the Coalition School for Social Change had been incarcerated, so she made the trip — with a care package of clean t-shirts and socks in tow — to convince the jail’s staff to enroll him in a U.S. history class, one of the only courses he needed to earn a diploma.

“The principal at Rikers was like, ‘You really came up here to do this?’” Valcin recalls. “It fell on deaf ears.”

The jail wouldn’t let her visit the student or place him in the class Valcin requested, but that was only part of the reason for the trip. “He totally appreciated us for it,” she said. After his release about six months later, the senior returned to school and is on track to graduate this year.

Valcin chalks this up as a success story, but acknowledges she has many other students who need that type of support. At her Harlem school, more than a quarter of the ninth-graders who started in 2012 dropped out at some point during their high school careers, meaning they left without enrolling in another school. Only a handful of other traditional high schools in New York City had higher dropout rates, according to new statistics.

Valcin, who became principal last March after more than five years as assistant principal at Bronx High School for Law and Community Service, says she’s ready for the challenge.

She has spent much of the past year reinforcing systems to identify students early who are at risk of dropping out, and working with her school’s nonprofit partner to intervene. And the stakes are high: Coalition is one of 86 schools in the city’s “Renewal” program for low-performers, which offers schools extra social services and academic support, but which must show signs of progress in return.

Though her previous school wasn’t in the program, it also struggled with low graduation rates. It was “pretty much in the same predicament,” she said. That school boosted graduation rates by almost 20 points during her tenure, eventually besting the current citywide average of 72 percent.

Though graduation rates at her new school have started to climb, Valcin isn’t sanguine about the work ahead of her. For one thing, her students — roughly 92 percent of whom are black or Hispanic — often arrive far behind grade-level. Three-quarters come from poor families; 35 percent have disabilities.

Valcin isn’t willing to speculate about why Coalition’s dropout rate is higher than other schools with similarly high-need populations, and is careful not to assign blame. “The numbers spoke for themselves,” she said. “Coalition hasn’t graduated 50 percent of its students in six years or more. A lot of the work probably wasn’t happening.”

Soon after arriving, she launched a “Saturday academy” to help students stay on track and prepare for the state’s exit exams, and began carefully watching students who had attendance or disciplinary problems early on. “If that pattern begins, you’re almost doomed,” Valcin said.

That’s why, before students start classes in the fall, school staff review their middle school records and conduct home visits, so they can talk about previous problems before they crop up again.

“From the beginning of the year, we have highlighted a cohort of kids that without significant additional support wouldn’t cross the finish line,” said Derek Anello, a program director at Partnership with Children, the school’s nonprofit community partner. “We’re starting with ninth-graders before they’re even in the building.”

PHOTO: Alex Zimmerman
Coalition School for Social Change

The school zooms in on students who don’t earn passing grades during the first few months of school, and offers extra academic help. (Valcin keeps a color-coded spreadsheet on her desk that tracks student progress toward graduation.)

If a student is showing up late — or not at all — they’ll likely get a knock on their door, sometimes from Valcin herself, or from a staff member at Partnership with Children. And if they’re routinely showing up late to class due to an extra-long commute, school officials might help the family find a school that’s closer to home.

City officials are expecting those efforts to produce significant results this year. Under the benchmarks assigned to the school through the Renewal program, its graduation rate should increase to 63 percent this school year, up from 46 percent. The education department considers graduation rates in decisions about whether to close or merge schools in the program.

Partnership with Children’s Anello is optimistic about meeting that goal partly because of Valcin’s embrace of his community organization. “Not every principal allows the [nonprofit partner] to be their right hand,” he added. “That’s not consistent across Renewal schools.”

But the school faces strong headwinds that make it hard to attract students who are more likely to graduate, including intense academic segregation. Among last year’s ninth-graders, for instance, fewer than five students had passed either their eighth-grade math or reading tests.

The school’s inclusion in the Renewal program, historically low graduation rate, and sagging enrollment have also signaled to prospective families that the school doesn’t have a strong track record.

In fact, Valcin has been reluctant to aggressively market the school. “I don’t want to go on the street and say, ‘Hey send your kids to this school’ given the condition we’re in currently.”

But she’s banking on this year’s graduation rate changing that calculation.

“The day after graduation, I’ll be on the corners passing out fliers,” she said.