College Application Document Tracker System Builder

Create a college application document tracker with deadlines, recommendation letters, essays, transcripts, FAFSA notes, portal tasks, and family reminders.

Prompt Template

You are an academic organization coach helping a student and family manage college application paperwork. Build a document tracker system for:

Student profile: [high school senior, transfer student, international applicant, gap year, first-generation applicant]
Application list: [college names, early action, early decision, regular decision, rolling admission, scholarship deadlines]
Documents needed: [transcript, test scores, recommendation letters, essays, resume, portfolio, financial aid forms]
Portal tasks: [account creation, application status, checklist uploads, fee waiver, interview request, housing form]
Essay workload: [personal statement, supplemental essays, scholarship essays, portfolio notes]
Recommendation workflow: [teacher letters, counselor report, coach, employer, request dates, thank-you notes]
Financial aid context: [FAFSA, CSS Profile, scholarship forms, local aid, family documents, professional questions]
Communication channels: [student email, parent email, school portal, calendar app, spreadsheet, Notion, paper binder]
Support network: [student, parent, counselor, teacher, mentor, independent advisor]
Constraints: [shared custody, travel, limited internet, school breaks, fee concerns, accessibility needs]
Privacy boundaries: [student ownership, parent visibility, financial documents, login sharing rules]
Review cadence: [weekly meeting, daily checklist, counselor check-in, deadline sprint]

Create:
1. Master tracker fields for each school, deadline, requirement, owner, status, and next action.
2. Document inventory checklist with where each item lives and who can access it.
3. Essay tracker with prompt, word count, draft owner, reviewer, due date, and submission status.
4. Recommendation letter workflow from request through confirmation and thank-you.
5. Portal login and status-check routine that avoids storing passwords in plain text.
6. Financial aid task list with placeholders for official deadlines and professional questions.
7. Weekly family review agenda that keeps the student as owner while surfacing blockers.
8. Color or status system for not started, requested, drafted, submitted, verified, and archived.
9. Submission verification checklist for receipts, screenshots, portal confirmations, and follow-up dates.
10. Risk checklist for missed deadlines, duplicate files, outdated essays, hidden portal tasks, and privacy mistakes.

Do not invent school-specific deadlines, admissions requirements, aid rules, or legal advice. Mark every institution-specific item for verification on the official college, school counselor, or financial aid source.

Example Output

Tracker Fields

| School | Deadline Type | Due Date | Requirement | Owner | Status | Next Action | Verification |

|---|---|---:|---|---|---|---|---|

| North Valley College | Early Action | Nov 1 | Counselor report | Student | Requested | Confirm with counselor Friday | Portal checklist |

| Lakeside University | Scholarship | Dec 5 | 500-word essay | Student | Drafting | Send draft to reviewer | Submission receipt |

Weekly Review Agenda

1. Check the next 14 days of deadlines.

2. Review blocked items and who owns them.

3. Verify submitted items in official portals.

4. Update essay and recommendation status.

Password Rule

Store portal names and recovery emails, not passwords. Use the family password manager or the student's chosen secure method.

Tips for Best Results

  • 💡Use official portals as the source of truth for submitted status.
  • 💡Track recommendation requests separately from recommendation submissions.
  • 💡Build review meetings around blockers and next actions, not long lectures.
  • 💡Keep financial aid documents private and verify every deadline with official sources.