Job and Internship Tracker for Google Sheets

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"