Mini-Project 3: A Grant Pipeline & Deadline Tracker
Build a grant tracker covering real FRC grant programs with deadlines, eligibility, status, and amounts so you apply on time and never repeat a rejected application blind.
Sign in to track progress, earn XP, and save lessons.
Grants are free money with one catch: hard deadlines. Miss the window and you wait a year. This project builds a tracker that keeps every opportunity visible and every application accountable.
Step 1 — Seed it with real programs. Create a Grants tab and pre-load the recurring FRC grant programs so you never miss the obvious ones:
| Program | Typical amount | Notes |
|---|---|---|
| NASA Robotics Alliance Project FRC Sponsorship Grant | Covers first event registration; applied as a credit to your FIRST account | Apply via NASA's RAP grant portal (frc-grants.arc.nasa.gov/rap-portal); recently rookie-prioritized; deadline historically late September; competitive |
| Gene Haas Foundation | $3,000 (FRC) | 2026/2027 season applications accepted after May 1, 2026; for entry fees, travel, parts, tooling; cannot be spent on Haas-manufactured products |
| FIRST Team Grant Opportunities portal | Varies | Centralized listing FIRST curates for registered teams |
Always confirm current amounts and dates on each program's official page — grant terms change season to season.
Step 2 — Status and columns. Headers: Program, Amount, Open date, Deadline, Eligibility check, Owner, Status, Submitted date, Decision, Award amount, Reporting deadline, Link. Use a Status dropdown: Watching → Eligible → Drafting → Internal review → Submitted → Awarded → Declined.
Step 3 — Countdown column. Add a Days left column that makes urgency unmissable:
Days left (M2) = IF(D2="", "", D2 - TODAY())
where D2 is Deadline. Conditional-format: red under 14 days, orange under 30. Sort ascending by Days left at every meeting.
Step 4 — Eligibility gate. Before anyone drafts, the Eligibility check column must say yes. Many teams burn hours on grants they cannot win (wrong region, wrong nonprofit status, wrong age range, or — as with the NASA grant in recent cycles — a veteran team in a rookie-only year). A 10-minute eligibility read saves a 10-hour wasted application.
Step 5 — Close the loop with reporting. Awarded grants almost always require a report. The Reporting deadline column is as important as the application deadline — missing it can disqualify you from future cycles. NASA-funded teams, for example, are required to complete surveys and an annual report essay documenting how funds were used. Add those report dates the moment you are awarded.
Step 6 — Build a reuse library. Add a Boilerplate tab with reusable paragraphs: mission statement, team history, demographics, impact numbers, budget summary. Most grant questions repeat across applications; a maintained boilerplate turns a 6-hour application into a 90-minute customization job.
This tracker pairs directly with the sponsor CRM: grants are the institutional half of your funding mix, sponsors the corporate half, and your budget's committed-income line is fed by both.
Key takeaways
- Pre-seed the tracker with recurring programs like the NASA Robotics Alliance Project FRC grant and the Gene Haas Foundation ($3,000 for FRC) so the obvious money is never missed.
- A days-left countdown with conditional formatting turns deadlines into something the whole team sees, not a date buried in an email.
- Run an eligibility gate before drafting — the NASA grant, for instance, has prioritized rookie teams in recent cycles — to avoid pouring hours into grants you cannot win.
- Track reporting deadlines (NASA requires surveys plus an annual report essay) as rigorously as application deadlines, and maintain a boilerplate library to cut application time dramatically.
Go deeper
Lesson quiz
RequiredAnswer all 3 questions correctly to complete this lesson.
1.Many FRC-relevant grant programs (such as the NASA Robotics Alliance Project) open and close within fixed annual windows. What does this imply for a grant pipeline and deadline tracker?
2.A grant tracker should model each opportunity moving through stages. Which sequence best represents a typical grant pipeline?
3.Why is it useful for a grant tracker to record both the amount requested and the amount awarded for each grant?
Answer every question to submit.