Summer Program Application Tracker Template

This is a strategic database, not just a to-do list. Use the specific columns below to uncover hidden admissions criteria. Why These Columns Matter:

Program Director: Real people read applications. Knowing the leader (e.g., Dr. Sarah Chen) allows you to build meaningful connection (i.e. true networking) to prove genuine engagement. Admissions officers should be able to recognize your name by the time you apply. LinkedIn Alumni: Don't guess. Look up past winners/attendees to see their actual stats and extracurriculars to gauge your fit. Acceptance Trends: Save time by identifying unwritten rules. (e.g., RSI almost exclusively accepts Olympiad finalists; SSP requires 1550+ SATs). Spike Alignment: explicitly define how this program proves your narrative (e.g., MIT Beaver Works serves as proof of a "CS/Bio" focus). Assignment: Review the Example File: Note how the student tracks "Reaches" vs. "Targets" and manages prerequisites (like LORs). Start Your Tracker: Copy the blank template and add 5 programs. You must fill out the Acceptance Trends and Alumni columns for your top choice.

A 20-row tracker template for managing summer program applications across tiers, with columns for Spike Alignment, Deadline, Cost & Funding, Application Components, Status, Notes, Program Director, Whether Contacted, Alumni Profiles, and Acceptance Trends.

Sample row data (use as a model; replace with your own targets):

• RSI (Tier 1 Reach) — Spike: original mentored research at CS/Biology intersection. Deadline Jan 15. Free. 5 essays + 2 LoRs + transcript + PSAT/ACT + research list. Most admits are USA(J)MO/USAPhO/USACO finalists with arXiv preprints.
• BU RISE (Tier 2 Target) — 6-week research internship; ~$7,800 (need-based aid). Identify 3 BU professors to name-drop in "Why BU?" essay.
• SSP (Tier 1/2 Target) — Astrophysics or Genomics. Deadline Feb 5. ~$8,400, generous aid. Problem sets are critical to the application.
• Local State U Research Internship (Unconventional) — Cold email to Prof. Doe (fMRI lab). No formal program; demonstrate Python + data analysis skills.
• Self-Directed BCI Project (Backup Plan) — ~$300 hardware. Deliverable: GitHub repo, blog write-up, YouTube demo. CS teacher as mentor.
• Simons Summer Research Program (Tier 2) — Stony Brook faculty research, free + stipend. Deadline Jan 31.
• MIT Beaver Works Summer Institute (Tier 1 Reach) — Project-based (Medlytics, Autonomous Systems). Free. Online prerequisite course must be completed by early March.
• NIH SIP (Tier 2) — Tailor a cover letter to each of 5 PIs in computational neuroscience.
• Anson L. Clark Scholars (Tier 1 Reach) — 12 students/year, free + $750 stipend. Interdisciplinary.
• TASP (Tier 1 Humanities Reach) — Pure essay-based admission, no LoRs/grades.
• SUMaC (Tier 1 Math Reach) — ~$8,250 (aid). Application is a hard problem set.
• YYGS (Tier 3 Likely) — ~$6,500 (aid). Innovations in Science & Tech session.
• BoA Student Leaders (Tier 2 Service) — Paid internship at local nonprofit.
• Garcia Summer Scholars (Tier 2) — Polymer/materials science with computational track. Free.
• LaunchX (Tier 2 Entrepreneurship) — ~$9,000 (aid). Application + video essay + project portfolio.
• Girls Who Code Summer Immersion (Tier 3 Likely) — Free. Foundational program; best for younger students.
• AwesomeMath Summer Program (Tier 2 Math) — ~$5,000 (aid). Qualifying quiz; competition-math focused.
• Iowa Young Writers' Studio (Tier 2 Humanities) — ~$2,500 (aid). Portfolio-based admission.
• State Governor's School (Tier 3 Target) — Free/low cost. School nomination required (October).
• CMU AI4ALL (Tier 2) — Free. AI + societal impact focus.

Use the spreadsheet to track which programs you'll apply to, which are submitted, and which need follow-up.