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”
Leave a Reply