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

'indigenized' curriculum

Denver doesn’t graduate half of its Native American students. This charter school wants to change that.

PHOTO: Melanie Asmar
Tanski Chrisjohn gets help adjusting the microphone at a school board meeting from Denver Superintendent Tom Boasberg.

The Denver school district is not serving Native American students well. Fewer than one in four Native American sixth-graders were reading and writing on grade-level last year, according to state tests, and the high school graduation rate was just 48 percent.

Even though that percentage is lower than for black or Latino students, educator Terri Bissonette said it often feels as if no one is paying attention.

“Nobody says anything out loud,” said Bissonette, a member of the Gnoozhekaaning Anishinaabe tribe who graduated from Denver Public Schools and has worked in education for 20 years as a teacher and consultant. “We’re always listed as ‘others.’”

Bissonette aims to change that by opening a charter school called the American Indian Academy of Denver. The plan is to start in fall 2019 with 120 students in sixth, seventh, and eighth grades and then expand into high school one grade at a time. Any interested student will be able to enroll, no matter their racial or ethnic background.

The Denver school board unanimously and enthusiastically approved the charter last week – which is notable given enrollment growth is slowing districtwide and some board members have expressed concerns about approving too many new schools.

But the American Indian Academy of Denver would be unlike any other school in the city. The curriculum would focus on science, technology, engineering, art, and math – or STEAM, as it’s known – and lessons would be taught through an indigenous lens.

Bissonette gives a poignant example. In sixth grade, state academic standards dictate students learn how European explorers came to North America.

“When you’re learning that unit, you’re on the boat,” Bissonette said. “I’d take that unit and I’d flip it. You’d be on the beach, and those boats would be coming.”

Antonio Garcia loves that example. The 17-year-old cites it when talking about why the school would be transformational for Native American youth, a population that has historically been forced – sometimes violently – to assimilate into white culture. For decades, Native American children were sent to boarding schools where their hair was cut and their languages forbidden.

Garcia is a member of the Jicarilla Apache, Diné, Mexikah, and Maya tribes. A senior at Denver’s East High School, he recalls elementary school classmates asking if he lived in a teepee and teachers singling him out to share the indigenous perspective on that day’s lesson.

“Indigenous students don’t have a place in Denver Public Schools,” Garcia said. “We’re underrepresented. And when we are represented, it’s through tokenism.”

According to the official student count, 592 of Denver’s nearly 93,000 students this year are Native American. That’s less than 1 percent, although Bissonette suspects the number is actually higher because some families don’t tick the box for fear of being stigmatized or because they identify as both Native American and another race.

The district does provide extra support for Native American students. Four full-time and three part-time staff members coordinate mentorships, cultural events, college campus visits, and other services, according to district officials. In addition, five Denver schools are designated as Native American “focus schools.” The focus schools are meant to centralize the enrollment of Native American students, in part so they feel less isolated, officials said.

But it isn’t working that way. While the number of students at some of the schools is slightly higher than average, there isn’t a large concentration at any one of them. Supporters of the American Indian Academy of Denver hope the charter will serve that role.

“It’s very hard being the only Native person that my friends know,” second-grader Vivian Sheely told the school board last week. “It would be nice to see other families that look like my own.”

That sense of belonging is what Shannon Subryan wants for her children, too. Subryan and her daughters are members of the Navajo and Lakota tribes. Her 7-year-old, Cheyenne, has struggled to find a school that works for her. Because Cheyenne is quiet in class, Subryan said teachers have repeatedly suggested she be tested for learning disabilities.

“Our children are taught that listening before speaking is more valued than speaking right away,” Subryan said. “She understands everything. It’s just a cultural thing.”

After switching schools three times, Cheyenne ended up at a Denver elementary with a teacher who shares her Native American and Latina heritage. She’s thrived there, but Subryan worries what will happen when Cheyenne gets a new teacher next year. As soon as Cheyenne is old enough, Subryan plans to enroll her at the American Indian Academy of Denver.

In addition to the school’s “indigenized” curriculum, Bissonette envisions inviting elders into the classrooms to share stories and act as academic tutors, exposing students to traditional sports and games, and teaching them Native American languages. Above all, she said the school will work to hire high-quality teachers, whether they’re Native American or not.

The school is partly modeled on a successful charter school in New Mexico called the Native American Community Academy. Opened in 2006, it has a dual focus on academic rigor and student wellness. Last year, 71 percent of its graduates immediately enrolled in college, school officials said. In Denver, only 38 percent of Native American graduates immediately enrolled.

Several years ago, the New Mexico school launched a fellowship program for educators who want to open their own schools focused on better serving Native American students. Bissonette will be the first Colorado educator to be a fellow when she starts this year.

She and her founding board of directors are hoping to open the American Indian Academy of Denver in a private facility somewhere in southwest Denver. That region is home to the Denver Indian Center and has historically had a larger population of Native American families.

However, she said she and her board members realize the Native American population isn’t big enough to support a school alone. More than half of all Denver students are Latino, and they expect the school’s demographics to reflect that. Many Latino students also identify as indigenous, and Bissonette is confident they’ll be attracted to the model.

“This really is a school from us, about us,” she said.

COUNTING TNREADY

School boards across Tennessee scrap TNReady scores from students’ grades

PHOTO: J. Zubrzycki

As the school year comes to a close following the standardized testing debacle that concluded in Tennessee this month, many school districts have decided the scores won’t count toward students’ final grades.

Shelby County Schools, the state’s largest district, will take up the issue Tuesday when the school board meets in a work session.

Earlier this year, the district was one of about half of the state’s school systems that reported to the state it likely would not use the scores because the results were not expected to be received at least five school days before the end of the year. But that early tally was unofficial.

“The survey was just to let us know what they were planning for so we could have a sense of what districts were planning on doing, but it was not binding in any way,” said Sara Gast, a spokeswoman for the state Department of Education.

Now, one by one, a growing number of districts are opting not to count the scores against students whenever the results are released.

This year’s online testing was plagued with a series of testing snafus, including login troubles, an apparent cyberattack, a dump truck cutting a fiber optic line and the wrong test being issued to some students. It’s the third year in a row that TNReady testing has gone wrong.

Bartlett City Schools decided during a special school board session last week not to use the scores on high school report cards after previously saying it would. So did the Franklin Special School District. The week before, Williamson County, Blount County, and Collierville school board members voted the same.

Millington Municipal Schools also will not be using the scores in that district’s final grades. But the district decided in December not to include the scores, said Stacy Ross, a spokesperson for the district.

“The decision was made because the scores from testing would not be back in time for final report cards,” Ross said in a statement to Chalkbeat.

It’s unclear of the 71 school districts that had initially said they planned to count the scores, how many have changed their minds.

Greene County is one of a few districts that has decided to count the scores as 15 percent of students’ final grades.

Before this year’s testing challenges, state law had required that the high school end-of-course exams count for 15 percent of a high school student’s final grade unless the scores came in too late for report cards.

But after the testing snafus, legislators left it in the hands of school boards to decide how much to count TNReady scores — if at all — toward students’ grades.

High school raw scores are expected to be delivered electronically to districts by May 22 and grades 3-8 scores are expected to be available by June 15, according to the state.