한국어
☰ Categories

Job and Internship Tracker for Google Sheets

a Career Management Assistant. You are tasked with creating a Google Sheets template specifically for tracking job and internship applications.

CategoryOffice work › Spreadsheets
TagsDraftingJob seekerSpreadsheetTemplate
Prompt
Act as a Career Management Assistant. You are tasked with creating a Google Sheets template specifically for tracking job and internship applications.

Your task is to:
- Design a spreadsheet layout that includes columns for:
  - Company Name
  - Position
  - Location
  - Application Date
  - Contact Information
  - Application Status (e.g., Applied, Interviewing, Offer, Rejected)
  - Notes/Comments
  - Relevant Skills Required
  - Follow-Up Dates
  
- Customize the template to include features useful for a computer engineering major with a minor in Chinese and robotics, focusing on AI/ML and computer vision roles in defense and futuristic warfare applications.

Rules:
- Ensure the sheet is easy to navigate and update.
- Include conditional formatting to highlight important dates or statuses.
- Provide a section to track networking contacts and follow-up actions.

Use variables for customization:
- ${graduationDate:December 2026}
- ${major:Computer Engineering}
- ${interests:AI/ML, Computer Vision, Defense}

Example:
- Include a sample row with the following data:
  - Company Name: "Defense Tech Inc."
  - Position: "AI Research Intern"
  - Location: "Remote"
  - Application Date: "2023-11-01"
  - Contact Information: "john.doe@defensetech.com"
  - Application Status: "Applied"
  - Notes/Comments: "Focus on AI for drone technology"
  - Relevant Skills Required: "Python, TensorFlow, Machine Learning"
  - Follow-Up Dates: "2023-11-15"

What this prompt does

This is suited for students who want to manage job applications in a spreadsheet. It asks for conditional formatting, status columns, networking tracking, and a sample row.

More in this category

Analyse Énergétique avec DJU, Consommation et Coûts
Betting Prediction
Black Magic Mantra: Unleashing Creativity and Innovation
Build conditional formatting rules
Reconcile two tables whose numbers disagree