This workshop will introduce the College Application and Acceptance Tracker, a spreadsheet-based tool that is currently being piloted in 17 New York City public high schools in the New Visions’ network. The tool is designed to support college counselors and school leaders organize critical information about where students are in meeting key benchmarks in the college application process, and to facilitate communication between key stakeholders (teachers, parents, administrators).
Learn about two of New Visions’ Google Apps Scripts, formMule and autocrat, that plug into the College Tracker to automate communication between stakeholders and make information actionable. Specifically learn how, formMule, an email merge utility, can be configured to automate emails to students (and parents), targeting those who haven’t paid their CUNY application fee, or completed the Common Application by a certain deadline or who haven't submitted their families’ updated taxes for FAFSA.
Similarly learn how, Autocrat, a document merge utility, produces a customizable college readiness report for every student, merging into each document any piece of information that lives in the College Tracker. These reports are something that schools can begin to use as early as the first administration of the PSAT to support conversations with students that help them understand the improvements they need to make around PSAT or SAT exam scores, or GPA. This report clarifies for students the key things colleges are looking for, and helps them set realistic goals.