Job and Internship Tracker for Google Sheets

Improved prompt:

Act as a Professional Career Planner. Your mission is to architect a Google Sheets career tracking template tailored to a specific individual, optimizing it for managing job and internship applications across diverse industries.

Your deliverable:

• Develop a spreadsheet framework that includes the following structured sections:

1. Application Tracker:

   • Column Headers: "Company Name", "Job Title", "Location", "Application Date", "Contact Information", "Application Status" (dropdown with options: "Applied", "Interview Scheduled", "Offer Received", "Rejected"), "Notes/Comments", "Required Skills", "Follow-Up Tasks"
   • Customize formatting: Apply conditional formatting to highlight upcoming deadlines and significant status changes in bright colors for quick visibility.

2. Networking Database:

   • Column Headers: "Contact Name", "Company/Organization", "Contact Title", "Contact Method" (email, LinkedIn, phone), "Relationship" (colleague, mentor, alumni), "Next Follow-Up Date"
   • Include a dedicated sheet for tracking professional connections and follow-up actions.

3. Customization Area:

   • Create a "Profile" section to store key variables:
     • Graduation Date: December 2026
     • Major: Computer Engineering
     • Minor: Chinese, Robotics
     • Primary Interests: AI/ML, Computer Vision, Defense and Futuristic Warfare Applications
     • Secondary Interests: Cybersecurity, Data Science, Emerging Technologies

4. Sample Data:

   • Populate the Application Tracker with a sample row:
     • Company Name: "Innovative Defense Systems"
     • Job Title: "AI Research Engineer"
     • Location: "Remote"
     • Application Date: "2023-11-05"
     • Contact Information: "lisa.johnson@innovativedefense.com"
     • Application Status: "Interview Scheduled"
     • Notes/Comments: "Appeal to experience in deep learning and drone technology"
     • Required Skills: "Python, PyTorch, Object Recognition, Autonomous Systems"
     • Follow-Up Tasks: "Send follow-up email - 2023-11-10, Prepare for technical interview - 2023-11-12"

5. Instructions:

   • The template should be visually appealing and intuitive to use, with clear headers and sufficient spacing between sections.
   • Ensure the structure remains consistent across sheets, using a standard font and color palette for a professional appearance.
   • Provide a "Quick Start" guide on the first sheet, explaining how to add new rows and modify existing data.

Output Format:

• A link to a Google Sheets file hosting the final template, with all the described features implemented.
• A text summary describing the key features and customizations made to suit the individual's profile.

Your goal:

• Create a comprehensive, user-friendly career management system that allows seamless tracking of applications, networking efforts, and follow-up tasks for a computer engineering student with a focus on AI/ML and defense-related roles.