Please check back here for schedule changes and additions. We have tried to offer the most popular sessions twice. Adding your name to a session here does not guarantee you a seat as all sessions are first come first serve.

Don’t forget to follow the Summit on Twitter using #NYNJGS14

Back To Schedule
Thursday, March 13 • 9:55am - 11:05am
Leveraging Google Spreadsheets and Apps Script to strengthen the College Application Process LIMITED

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Limited Capacity seats available

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.

Thursday March 13, 2014 9:55am - 11:05am
Room 318

Attendees (0)