Internship Application Tracker

A typical placement season means dozens of applications scattered across spreadsheets, email threads and job portals — and students miss online-assessment deadlines or walk into interviews without their notes. Spreadsheets cannot remind you that an assessment closes tonight, and they cannot show that referral applications convert twice as well as cold ones. This project builds a dedicated internship application tracker: every application is a card with stage, deadlines, contacts, stipend and documents; the board surfaces what needs action today; and analytics reveal which strategies actually work so effort goes where it converts. Timeline entries, checklists and reminders keep every opportunity moving forward.

1. The student logs an application with company, role, location, source, stipend and deadline — it lands in the Applied column.
2. Timeline events (resume shortlisted, assessment link received, interview scheduled) are appended as they happen.
3. Cards are dragged across stages; each move is timestamped in the application's history.
4. Upcoming deadlines appear in the action list with urgency highlighting; reminders go out by email.
5. Prep checklists per application track interview readiness with due dates.
6. The analytics page aggregates the season: funnel from applied to offer, response rate, average time-to-first-response and source performance.

Tech stack:

• Python (Django/Flask) or Node.js backend
• SQLite/PostgreSQL database
• HTML5, CSS3, JavaScript frontend
• Kanban drag-and-drop UI
• Charting library for analytics
• Email service for reminders
• CSV export
• Responsive web UI

• [Kanban pipeline] Drag applications across Applied, Screening, Interview, Offer and Rejected stages with counts per stage.
• [Per-application detail pages] Stage tracker, timeline of events, stipend, contacts, documents and notes — every fact has one home.
• [Deadline reminders] Assessments, HR calls and interviews surface as urgent; overdue items are highlighted automatically.
• [Interview-prep checklists] Per-application task lists (revise DSA, mock interview, research the company) with due dates.
• [Season analytics] Response rate, offer rate, funnel conversion and applications-by-source charts computed from the student's real data.
• [Document management] Attach resumes, cover letters and offer letters to the application they belong to.
• [Season export] One-click CSV export of the full season for personal records or the placement cell.

• Complete internship tracker web application source code
• Database schema and migration scripts
• Kanban board with drag-and-drop stage management
• Analytics dashboards (funnel, sources, timing)
• Reminder scheduling implementation
• Setup and deployment guide
• User walkthrough script for the buyer to validate flows
• Project report PDF (background, data model, workflow design, methodology)
• PPT presentation for final review
• Viva Q&A preparation document (CRUD design, aggregation queries, UX decisions)

• Analytics are descriptive statistics of the user's own data — the system predicts nothing about hiring outcomes.
• Reminders depend on the student entering correct deadlines; the system cannot read recruiter emails.
• Single-user design: there is no team/placement-cell multi-user mode in the base build.
• Drag-and-drop needs a modern browser; keyboard-accessible stage controls are included as fallback.
• Email delivery depends on the configured mail service and spam filtering.
• No integration with job portals — applications are logged manually (browser-extension capture is future scope).