Resources

For Students and Families

Tools

Posts


College Counselors & High Schools

Books

Websites

Tools

Collecting Merit Aid/Scholarship Awards from Seniors

The Google Sheet and Doc above were created to solicit merit aid/scholarship outcomes from seniors at Salem High School. Counselors, feel free to leverage these at your own high school, just be sure to customize the copy and contact info accordingly.

Deploying the survey involves sending the spreadsheet to families of college applicants prefaced with the message in the doc to explain why merit aid data is being requested. (Answer: To make future applicants aware of merit aid award opportunities and help them strategize where they might apply based on what they might expect to receive in aid.) Each student/family who receives the survey makes a copy of the sheet, enters their merit aid scholarships, and sends a link to their sheet back. The aid information returned must then be compiled into a single sheet (or other datastore of your choosing) for aggregation and analysis.

Note: I considered using a Google Form for this effort, but the user experience for students and families with a google sheet seemed more streamlined. If you create a form for this task that proves me wrong, please share it!


Publications

Traditional Outlets

Blogs/Newsletters


Data Sets


Researching Colleges

Books

Websites


Books

Podcasts


College Essays

Books

Websites


Standardized Testing

Books


Financing College

Books

Websites


How Admissions Offices Work

Books

Videos


Getting Value from Your College Experience

Books


Understanding the College Landscape

Books

Podcasts