Starter Job hunt skill
Job application tracker
Put the whole job hunt in one tracker.
Build a tracking system with someone running their first job hunt. Untracked applications rot: follow-ups get missed, the same store gets applied to twice, and a callback arrives from a company they cannot place. The bar: a tracker that exists, holds every application they have made so far, and shows them what to do next each time they open it.
Ground rules
- Fit the tool to the person. A spreadsheet is the right answer for almost everyone — ask what they already use (Google Sheets, Excel, Numbers) and build there so it syncs to their phone. Offer a tiny local web app only if they are technical and actually want one; the tracker must never become a bigger project than the job hunt.
- Their data, their hands. They own the file in their own account. Walk them through entering the first rows themselves — the habit of updating it matters more than the artifact.
- The tracker answers one question: "what do I do today?" Every design choice serves that.
Build it
Columns, one row per application:
- Employer, role, and how they applied (online / walk-in / referral / cold message) with link or address
- Date applied and materials sent (which resume version)
- Contact person, if they have a name
- Status — one of: to apply, applied, followed up, interview, offer, rejected, no answer
- Follow-up date, and a notes column for everything else (login created, who referred them, what the manager said)
Add the touches that make it self-running: dropdown for status, color by status, sorted or filtered so overdue follow-ups float to the top. In a spreadsheet a simple conditional-format rule on the follow-up date is enough — past-due turns red. Keep it one sheet; resist tabs.
Load it and set the habit
Reconstruct the history together: everything already sent, walked into, or asked about, from memory and from their sent email. Enter every row, assign every open item a real follow-up date about a week out (follow-up-after-applying owns what happens on that date). Then set the rhythm — a recurring phone or calendar reminder, twice a week, to open the tracker, act on anything red, and add new rows. Run the first review on the spot so they have done it once.
--- name: job-application-tracker category: get-hired description: Put the whole job hunt in one tracker. Every application, status, and follow-up date, kept simple enough to maintain. Use when they say "I can't remember where I applied" or several applications are about to go out. --- # job-application-tracker Build a tracking system with someone running their first job hunt. Untracked applications rot: follow-ups get missed, the same store gets applied to twice, and a callback arrives from a company they cannot place. The bar: a tracker that exists, holds every application they have made so far, and shows them what to do next each time they open it. ## Ground rules - Fit the tool to the person. A spreadsheet is the right answer for almost everyone — ask what they already use (Google Sheets, Excel, Numbers) and build there so it syncs to their phone. Offer a tiny local web app only if they are technical and actually want one; the tracker must never become a bigger project than the job hunt. - Their data, their hands. They own the file in their own account. Walk them through entering the first rows themselves — the habit of updating it matters more than the artifact. - The tracker answers one question: "what do I do today?" Every design choice serves that. ## Build it Columns, one row per application: - Employer, role, and how they applied (online / walk-in / referral / cold message) with link or address - Date applied and materials sent (which resume version) - Contact person, if they have a name - Status — one of: to apply, applied, followed up, interview, offer, rejected, no answer - Follow-up date, and a notes column for everything else (login created, who referred them, what the manager said) Add the touches that make it self-running: dropdown for status, color by status, sorted or filtered so overdue follow-ups float to the top. In a spreadsheet a simple conditional-format rule on the follow-up date is enough — past-due turns red. Keep it one sheet; resist tabs. ## Load it and set the habit Reconstruct the history together: everything already sent, walked into, or asked about, from memory and from their sent email. Enter every row, assign every open item a real follow-up date about a week out (follow-up-after-applying owns what happens on that date). Then set the rhythm — a recurring phone or calendar reminder, twice a week, to open the tracker, act on anything red, and add new rows. Run the first review on the spot so they have done it once. ## Done - Tracker live in their account, on their phone - Every application to date entered, each with a status and a follow-up date - A twice-weekly reminder set, and the first review already done - Rejections and silence get logged too — a full tracker is a record of effort, and watching the rows accumulate is what keeps a long hunt going