# College Application Command Center

## Overview
A single‑page hub that lets you **track every moving part of the college admissions journey**—applications, essays, recommendation letters, test scores, and scholarships. Built with relational databases, formula‑driven progress bars, deadline alerts, and instant view‑only sharing links, this template turns chaos into a clear, actionable workflow.

> 💡 Tip: Duplicate the template before you start so you always have a clean master copy to revert to.

## Application Tracker
The core database where each row represents a college you’re applying to. Use the built‑in **Progress** formula to see a live bar, and the **Alert** formula to flag upcoming deadlines.

| College | Application Type | Deadline | Status | Submitted? | Progress | Alert | Application Link |
|---------|------------------|----------|--------|------------|----------|-------|------------------|
| Harvard University | Early Decision | 2024‑11‑01 | Researching | ❌ | `prop("Status")` | `if(dateBetween(now(), prop("Deadline"), 7), "⚠️", "")` | https://admissions.harvard.edu |
| MIT | Regular Decision | 2025‑01‑15 | Drafting Essay | ❌ | `prop("Status")` | `if(dateBetween(now(), prop("Deadline"), 7), "⚠️", "")` | https://admissions.mit.edu |
| Stanford University | Early Action | 2024‑11‑15 | Waiting on Rec | ❌ | `prop("Status")` | `if(dateBetween(now(), prop("Deadline"), 7), "⚠️", "")` | https://admissions.stanford.edu |
| University of California, Berkeley | Regular Decision | 2025‑01‑10 | Completed | ✅ | `prop("Status")` | `if(dateBetween(now(), prop("Deadline"), 7), "⚠️", "")` | https://admissions.berkeley.edu |

> 💡 Tip: The **Progress** column uses a formula like `format(round(prop("Completed Steps") / prop("Total Steps") * 100)) + "%"`. Adjust “Completed Steps” and “Total Steps” in the **Application Details** sub‑page.

## Essays & Drafts
A dedicated database for every essay prompt, draft version, and feedback loop. Link each essay to its college via a relation.

| Essay Prompt | College (Relation) | Draft Version | Word Count | Status | Feedback Link |
|--------------|--------------------|---------------|------------|--------|----------------|
| Why you want to study Computer Science | MIT | v2 | 650 | In Review | https://docs.google.com/... |
| Personal Growth Story | Harvard | v3 | 800 | Finalized | https://docs.google.com/... |
| Community Impact Essay | Stanford | v1 | 500 | Drafting | https://docs.google.com/... |

> 💡 Tip: Set a **Due Date** property and enable Notion’s reminder to get a pop‑up 48 hours before the essay deadline.

## Recommendations
Track each recommender, their contact status, and the shareable view‑only link you’ll send them.

| Recommender | Relationship | Email Sent? | Reminder Sent? | Status | View‑Only Link |
|-------------|--------------|-------------|----------------|--------|----------------|
| Ms. Patel (AP Physics) | Teacher | ✅ | ✅ (2024‑10‑10) | Completed | https://www.notion.so/... |
| Coach Rivera (Soccer) | Coach | ❌ | ❌ | Pending | (generate after) |
| Dr. Liu (Research Mentor) | Mentor | ✅ | ✅ (2024‑10‑12) | Completed | https://www.notion.so/... |

> 💡 Tip: Use Notion’s **Copy Link** → **Share to web** → **Allow duplicate** to create instant view‑only links for recommenders.

## Test Scores & Scholarships
One table to log standardized test results and any scholarship applications, with automatic ranking and eligibility checks.

| Test / Scholarship | Date | Score / Amount | Submitted? | Eligibility | Notes |
|--------------------|------|----------------|------------|-------------|-------|
| SAT Math | 2024‑09‑20 | 750 | ✅ | ✅ | Strong score |
| ACT English | 2024‑10‑05 | 34 | ✅ | ✅ |  |
| FAFSA | 2024‑11‑01 | $12,000 | ✅ | ✅ | Federal aid |
| XYZ Merit Scholarship | 2024‑12‑01 | $5,000 | ❌ | Pending (GPA ≥ 3.8) | Deadline 2024‑12‑15 |

> 💡 Tip: Add a formula column **Eligibility** that checks GPA and test thresholds: `if(prop("GPA") >= 3.8 and prop("Score") >= 700, "✅", "❌")`.

## Dashboard & Views
Create the following pre‑built views (add them in Notion after importing the tables):

1. **All Applications – Table** – default view showing all columns.
2. **Upcoming Deadlines – Calendar** – filters `Deadline` within next 30 days, sorted by date.
3. **Progress Overview – Board** – groups by **Status** (Researching, Drafting, Submitted, Completed) with progress bars on cards.
4. **Essay Review – Gallery** – shows each essay’s latest draft thumbnail and status.
5. **Scholarship Tracker – Table** – filters where **Eligibility** = ✅ and **Submitted?** = ❌.

> 💡 Tip: Pin the **Progress Overview** board to the top of the page for a quick visual snapshot of where you stand across all applications.

## How to import into Notion
1. In Notion, click **Import** → **Markdown & CSV**.  
2. Select this `.md` file from your computer.  
3. Notion will create a page with all headings and tables.  
4. For each table, click the three‑dot menu → **Turn into → Database – Table**.  
5. Adjust property types (Date, Checkbox, Formula, URL, Relation) to match the column headers.  
6. Set up the **Relation** fields (e.g., link **Essays** to **Application Tracker** by College).  
7. Add the suggested **Views** (Table, Calendar, Board, Gallery) using the “Add a view” button.  
8. Enable **Reminders** on date properties and **Sharing** on the view‑only link columns.  

Your College Application Command Center is now ready—track, prioritize, and submit with confidence!