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

second chance

An embattled Harlem charter school that serves kids with disabilities will be allowed to keep its middle school — for now

PHOTO: Alex Zimmerman
Opportunity Charter School

A Harlem charter school will be allowed to keep its middle school next school year, despite the fact that top city education officials have repeatedly ruled that it is too low performing to stay open.

That decision offers at least temporary relief for Opportunity Charter School, which has been embroiled in a dispute with the education department since March. The disagreement centers on whether city officials properly took into account the school’s students — over half of whom have a disability — when it judged the school’s performance.

The city’s education department, which oversees the school as its charter authorizer, tried to close the middle school and offered only a short-term renewal for the high school when the school’s charter came up for review earlier this year. The school appealed that decision, and was denied late last month.

But the education department is backing down from its position — at least for now. That reversal appears to be based mostly on logistics: A Manhattan Supreme Court judge has temporarily blocked the closure through at least mid-July in response to a lawsuit filed by the school and some of its parents last month, complicating the process of finding students new schools outside the normal admissions cycle.

“Students always come first, and given where we are in the school year, we will allow the middle school grades to remain open in 2017-18,” education department spokesman Michael Aciman wrote in an email on Thursday. Still, he noted, the department will continue to push to close the middle school in the future.

Kevin Quinn, a lawyer representing Opportunity Charter, said the city’s decision was the only responsible one, given that the school has already held its admissions lottery and made offers to parents.

“This is a wise decision by the [education department],” Quinn wrote in an email, “and [we] appreciate their acknowledgment that placement of this population at this time would be significantly disruptive.”

language proficiency

Educators working on creating more bilingual students worry new state requirements aren’t high enough

A second grade class at Bryant Webster K-8 school in Denver (Joe Amon, The Denver Post).

Colorado educators who led the way in developing high school diploma endorsements recognizing bilingual students worry that new legislation establishing statewide standards for such “seals of biliteracy” sets the bar too low.

Two years ago, Denver Public Schools, Eagle County Schools and the Adams County School District 14 started offering the seal of biliteracy to their students. The three districts worked together to find a common way to assess whether students are fluent in English and another language, and recognize that on high school diplomas. Advocates say the seal is supposed to indicate to colleges and employers that students are truly bilingual.

A bill passed by state legislators this year that will go into effect in August sets a path for districts that want to follow that lead by outlining the minimum that students must do to prove they are fluent in English and in another language.

According to the new law, students must meet a 3.0 grade point average in their English classes and also earn a proficient score on the 11th grade state test, or on Advanced Placement or IB tests. For showing proficiency in the second language, students can either earn proficient scores on nationally recognized tests — or meet a 3.0 grade point average after four years of language classes.

Although educators say the law sends a message of support for bilingual education, that last criteria is one part of what has some concerned.

“It allows for proficiency in a world language to be established solely by completing four years of high school language classes,” said Jorge Garcia, executive director of the Colorado Association for Bilingual Education. “Language classes in one school district may have a different degree of rigor than they do in another.”

The second language criteria should be comparable to the English criteria, several educators said. In the requirements set by Denver, Eagle County and Adams 14, students must at a minimum demonstrate language proficiency through a test score, or in some cases with a portfolio review and interview if a test is not available.

The three districts also catered their requirements based on what each community said was important. In Adams 14 and in Eagle schools, students must perform community service using their language skills. Students also have to do an interview in both languages with a community panel.

“Our school district team developed the community service criteria because we wanted our kids to have authentic practice in their languages,” said Jessica Martinez, director of multilingual education for Eagle County Schools. “We also wanted students to be a bridge to another community than their own. For example, one group of students created academic tutoring services for their peers who don’t yet speak a lot of English. Another student started tutoring her mom and her parents’ friends so they could get their GED.”

The state law doesn’t require students to do community service. But it does allow school districts to go above the state’s requirements when setting up their biliteracy programs.

“Thoughtful school districts can absolutely address these concerns,” Garcia said.

Several school districts in the state are looking to start their own programs. In March, the school board for the Roaring Fork School District in Glenwood Springs voted to start offering the seal. Summit School District also began offering the seal this year.

Leslie Davison, the dual language coordinator for Summit, said that although her program will change in the next year as she forms more clear requirements around some new tests, she will continue to have higher requirements than the state has set.

This year her students had prove proficiency in their second language by taking a test in that language. They also had to demonstrate English proficiency through the ACT. In addition, students did oral presentations to the community in both languages.

“Their expectations aren’t as high as mine are,” Davison said. “We’ll probably stay with our higher-level proficiencies. I do have some work to do in terms of how that’s going to look for next year, but I certainly don’t want to just use seat time.”

Meanwhile, the districts that started the seal are increasing their commitment to biliteracy so as many students as possible can be eligible to earn seals in the future.

The Adams 14 school district in Commerce City is using Literacy Squared, a framework written by local researchers for teaching students to read English by strengthening literacy in the native language. The program is being rolled up year by year and will serve students in 34 classrooms from preschool through fourth grade in the fall.

In Eagle County, Martinez said parents have shown such a strong demand for biliteracy that most elementary schools are now dual language schools providing instruction to all students in English for half of the school day and in Spanish for the other half.

Both districts are also increasing the offerings of language classes in middle and high school. The options are important for students who are native English speakers so they too can become bilingual and access the seal. For students whose primary language is not English, the classes can help ensure they don’t lose their primary language as they learn English.

Of Eagle’s 25 students who graduated with a seal of biliteracy this year, 17 were native Spanish speakers and eight were native English speakers.

“We want all kids to see their bilingualism is an asset,” Martinez said. “It’s huge for them.”