# College Application Dashboard

## 1️⃣ Overview & Quick Start  
A single‑page hub that lets you **track every college‑application component**, see upcoming deadlines at a glance, and share a **read‑only parent view**. All data lives in linked databases, so updates ripple automatically.

> 💡 Tip: Duplicate this page for each applicant (e.g., “Alex – 2027 Apps”) and rename the databases via the page title – Notion will keep the relations intact.

---

## 2️⃣ Applications Tracker (Master Database)  
| Application | College | Program | Application Type | Deadline | Status | Decision |
|-------------|---------|---------|------------------|----------|--------|----------|
| APP‑001 | University of Washington | Computer Science (BS) | Early Decision | 2024‑11‑01 | In Progress | — |
| APP‑002 | Stanford University | Electrical Engineering (MS) | Regular | 2025‑01‑15 | Ready | — |
| APP‑003 | MIT | Mechanical Engineering (PhD) | Rolling | 2025‑03‑01 | Late | — |

**Key properties (create as Notion columns):**  
- **Application** (Text, unique ID)  
- **College** (Select)  
- **Program** (Text)  
- **Application Type** (Select: Early Decision, Early Action, Regular, Rolling)  
- **Deadline** (Date)  
- **Status** (Formula) – `if(prop("Deadline") < now(), "Late", if(empty(prop("Essays")) and empty(prop("Recommendations")), "In Progress", "Ready"))`  
- **Decision** (Select: Accepted, Waitlist, Rejected, Pending)

> 💡 Tip: Turn the **Deadline** column into a reminder by enabling “Remind me on the day” in the column settings.

---

## 3️⃣ Essays & Personal Statements  
| Essay ID | Application | Prompt | Word Count | Draft Status | Link |
|----------|-------------|--------|------------|--------------|------|
| ESS‑001 | APP‑001 | “Why UW?” | 500 | Draft 1 | https://drive.google.com/… |
| ESS‑002 | APP‑002 | “Impact at Stanford” | 650 | Final | https://docs.google.com/… |
| ESS‑003 | APP‑003 | “Future at MIT” | 750 | In Review | https://notion.so/… |

**Properties:**  
- **Essay ID** (Text)  
- **Application** (Relation → Applications Tracker)  
- **Prompt** (Text)  
- **Word Count** (Number)  
- **Draft Status** (Select: Idea, Draft 1, Draft 2, Final, In Review)  
- **Link** (URL)

> 💡 Tip: Use the **Rollup** property on the Applications Tracker to show the highest‑status essay (e.g., “Final”) for each application.

---

## 4️⃣ Recommendations  
| Rec ID | Application | Recommender | Relationship | Sent? | Received? | File |
|-------|-------------|------------|--------------|-------|-----------|------|
| REC‑001 | APP‑001 | Ms. Patel (Counselor) | Counselor | ✅ | ✅ | https://drive.google.com/… |
| REC‑002 | APP‑002 | Prof. Liu (Research) | Research Mentor | ✅ | ❌ | — |
| REC‑003 | APP‑003 | Dr. Gomez (Professor) | Academic | ✅ | ✅ | https://notion.so/… |

**Properties:**  
- **Rec ID** (Text)  
- **Application** (Relation → Applications Tracker)  
- **Recommender** (Person)  
- **Relationship** (Select)  
- **Sent?** (Checkbox)  
- **Received?** (Checkbox)  
- **File** (File & media)

> 💡 Tip: Add a filtered view “Pending Recommendations” that shows only rows where **Received?** is unchecked.

---

## 5️⃣ Test Scores & Scholarships  
### 5A – Test Scores  
| Test ID | Application | Test Type | Score | Test Date | Submitted? |
|---------|-------------|-----------|-------|-----------|------------|
| TS‑001 | APP‑001 | SAT Math | 750 | 2024‑09‑15 | ✅ |
| TS‑002 | APP‑002 | GRE | 330 | 2024‑10‑02 | ✅ |
| TS‑003 | APP‑003 | TOEFL | 112 | 2024‑08‑20 | ✅ |

### 5B – Scholarships  
| Scholarship ID | Application | Name | Amount | Deadline | Awarded? |
|----------------|-------------|------|--------|----------|----------|
| SCH‑001 | APP‑001 | UW Merit | $5,000 | 2024‑10‑15 | ❌ |
| SCH‑002 | APP‑002 | Stanford Need‑Based | $10,000 | 2025‑01‑05 | — |
| SCH‑003 | APP‑003 | MIT STEM Grant | $7,500 | 2025‑02‑20 | — |

**Properties for Test Scores:**  
- **Test ID**, **Application** (Relation), **Test Type** (Select), **Score** (Number), **Test Date** (Date), **Submitted?** (Checkbox)

**Properties for Scholarships:**  
- **Scholarship ID**, **Application** (Relation), **Name** (Text), **Amount** (Number, $), **Deadline** (Date), **Awarded?** (Select: Pending, Awarded, Declined)

> 💡 Tip: Create a **Rollup** on the Applications Tracker that sums all scholarship amounts per application – great for budgeting.

---

## 6️⃣ Parent Portal (Read‑Only View)  
1. Duplicate the **College Application Dashboard** page.  
2. In the duplicate, click **Share → Share to web**, toggle **Allow editing** **off**, and enable **Allow comments** if you want parents to ask questions.  
3. Copy the public link and send it to parents.  
4. (Optional) Add a filtered view “Parent Overview” that only shows **College**, **Program**, **Deadline**, **Status**, and **Decision** columns – hide internal notes.

> 💡 Tip: Use the **“Hide from view”** option on sensitive columns (e.g., internal notes, draft essays) so they never appear in the parent view.

---

## How to import into Notion  
1. **Create a new page** in your workspace where you want the dashboard.  
2. Click the three‑dot menu → **“Import”** → select **“Markdown & CSV”**.  
3. Upload this `.md` file. Notion will render the headings and tables.  
4. For each table, click the **“Convert to database”** button that appears at the top‑right of the table.  
5. Rename each database as shown (e.g., “Applications Tracker”).  
6. Re‑create the **Relation** and **Rollup** properties as described in each section to link the databases together.  
7. Set up **Formula** columns (copy the exact formula strings) and enable **Date reminders** on deadline fields.  
8. Follow the **Parent Portal** steps to generate a read‑only share link.  

Your fully functional College Application Dashboard is now ready! 🎉