A complete web application for managing internship applications strategically with intelligent analytics, real-time tracking, and data-driven insights.

Internship Application Tracker helps students and freshers manage their internship applications efficiently by providing:

• ✅ Centralized application tracking dashboard
• ✅ Real-time status updates and timeline visualization
• ✅ Skill matching analytics and gap analysis
• ✅ Company intelligence and performance insights
• ✅ Smart recommendations engine
• ✅ Advanced filtering and search with MongoDB aggregation pipelines
• ✅ Mobile-responsive UI with vanilla JavaScript
• ✅ Complete RESTful API with MongoDB backend

• Node.js (v14+)
• MongoDB (local or cloud - MongoDB Atlas)
• npm or yarn
• Modern web browser

cd project

npm install

cp .env.example .env

Edit .env file:

MONGODB_URI=mongodb://localhost:27017/internship-tracker
JWT_SECRET=your-secret-key-change-in-production
PORT=3000

# Windows
mongod

# macOS/Linux
mongod --dbpath /path/to/data

npm start
# or for development with auto-reload
npm run dev

Backend will run on: http://localhost:3000

# Open browser and go to:
http://localhost:3000/frontend/index.html

# Or open directly:
frontend/index.html

project/
├── frontend/
│   ├── index.html                 # Dashboard (home page)
│   ├── pages/
│   │   ├── tracker.html           # Application tracker
│   │   ├── analytics.html         # Analytics dashboard
│   │   ├── add-application.html   # Add/Edit application
│   │   ├── profile.html           # User profile
│   │   └── login.html             # Login/Signup
│   ├── css/
│   │   ├── styles.css             # Global styles
│   │   ├── dashboard.css          # Dashboard styles
│   │   ├── tracker.css            # Tracker styles
│   │   ├── analytics.css          # Analytics styles
│   │   ├── form.css               # Form styles
│   │   ├── profile.css            # Profile styles
│   │   └── auth.css               # Auth page styles
│   └── js/
│       ├── api.js                 # API calls & helpers
│       ├── auth.js                # Authentication logic
│       ├── dashboard.js           # Dashboard functionality
│       ├── tracker.js             # Tracker table logic
│       ├── analytics.js           # Analytics charts
│       ├── form-handler.js        # Form submission
│       └── profile.js             # Profile management
├── backend/
│   ├── server.js                  # Express server with all routes
│   └── sampleData.js              # Sample data for testing
├── package.json                   # Dependencies
├── .env.example                   # Environment template
└── README.md                      # This file

Email: demo@example.com
Password: demo123

Or create a new account during signup.

• Quick metrics cards (Total apps, Success rate, etc.)
• Status distribution pie chart
• Recent activities feed
• Upcoming interviews list
• Application trend chart

Access: http://localhost:3000/frontend/index.html

• Table view of all applications
• Advanced filters (status, salary, skill match, date range)
• Real-time search
• Inline bulk actions
• Export to CSV
• Sort by any column

Access: Tracker → Tracker page

• 6 key metrics cards
• Status distribution pie chart
• Company-wise success rate chart
• Timeline trend analysis
• Salary distribution
• Skills demand analysis
• AI recommendations
• Performance insights

Access: Tracker → Analytics page

• Comprehensive form with validation
• Auto skill match calculation
• Company notes and recruiter info
• Interview scheduling
• Tags and status management

Access: "Add Application" button

• User profile management
• Skills management (add/remove)
• Preferences (salary, roles, companies)
• Account settings
• Password management

Access: Profile → Profile page

{
  "_id": ObjectId,
  "name": "Student Name",
  "email": "student@example.com",
  "password": "hashed_password",
  "profile": {
    "bio": "About me",
    "location": "City",
    "yearsOfExperience": 0
  },
  "skills": [
    { "name": "Java", "proficiency": "Advanced", "yearsOfExperience": 2 }
  ],
  "preferences": {
    "salary": { "min": 25000, "max": 50000 },
    "workMode": "Remote",
    "targetRoles": ["Backend Engineer"],
    "targetCompanies": ["Google", "Microsoft"]
  }
}

{
  "_id": ObjectId,
  "userId": ObjectId,
  "company": "Google",
  "jobTitle": "Backend Engineer Intern",
  "location": "Bangalore",
  "appliedDate": ISODate,
  "currentStatus": "Interview Scheduled",
  "statusHistory": [
    { "status": "Applied", "date": ISODate, "notes": "..." }
  ],
  "skillsRequired": ["Java", "MongoDB", "REST APIs"],
  "skillMatchPercentage": 85,
  "salary": { "min": 50000, "max": 70000 },
  "companyNotes": { "cultureFit": "...", "recruiterName": "..." },
  "timeline": { "interviewDate": ISODate },
  "notes": "Good opportunity",
  "tags": ["Dream Company", "High Priority"],
  "rating": 4.5
}

POST   /api/auth/signup          # Create account
POST   /api/auth/login           # Login
GET    /api/auth/me              # Get current user
PUT    /api/auth/profile         # Update profile
POST   /api/auth/change-password # Change password

GET    /api/applications         # List all applications
GET    /api/applications/:id     # Get single application
POST   /api/applications         # Create application
PUT    /api/applications/:id     # Update application
DELETE /api/applications/:id     # Delete application
PATCH  /api/applications/:id/status # Update status
DELETE /api/applications/bulk/delete # Bulk delete

GET    /api/analytics/metrics         # Key metrics
GET    /api/analytics/status-distribution # Status breakdown
GET    /api/analytics/company-success # Company success rates
GET    /api/analytics/trend           # Application timeline
GET    /api/analytics/skills          # Skills analysis
GET    /api/analytics/recommendations # AI recommendations
GET    /api/analytics/insights        # Performance insights

// Find top trending skills in applications
db.applications.aggregate([
  { $match: { userId: ObjectId("...") } },
  { $unwind: "$skillsRequired" },
  { $group: { _id: "$skillsRequired", count: { $sum: 1 } } },
  { $sort: { count: -1 } }
])

// Smart filtering with multiple criteria
db.applications.find({
  userId: ObjectId("..."),
  currentStatus: { $in: ["Applied", "Shortlisted"] },
  skillMatchPercentage: { $gte: 75 },
  appliedDate: { $gte: new Date(Date.now() - 30*24*60*60*1000) }
})

db.applications.createIndex({ userId: 1, currentStatus: 1 })
db.applications.createIndex({ userId: 1, appliedDate: -1 })
db.applications.createIndex({ skillMatchPercentage: -1 })

db.applications.aggregate([
  { $group: {
      _id: "$company",
      total: { $sum: 1 },
      offers: { $sum: { $cond: [{ $in: ["$currentStatus", ["Offer Received"]] }, 1, 0] } }
    }
  },
  { $project: { company: "$_id", successRate: { $divide: ["$offers", "$total"] } } }
])

db.applications.aggregate([
  { $unwind: "$skillsRequired" },
  { $match: { "skillsRequired": { $nin: userSkills } } },
  { $group: { _id: "$skillsRequired", count: { $sum: 1 } } },
  { $sort: { count: -1 } }
])

1. 0:00-1:00 - Show Dashboard with metrics
2. 1:00-2:00 - Search/Filter with MongoDB aggregation
3. 2:00-3:00 - Show Analytics and insights
4. 3:00-4:00 - Add application demo
5. 4:00-5:00 - Explain technical excellence

• Backend running on port 3000
• MongoDB connected
• Sample data loaded
• All pages tested
• Network tab shows API calls
• Analytics rendering correctly

• ✅ Complex MongoDB aggregation pipelines
• ✅ Real-time data synchronization
• ✅ Advanced filtering with multiple criteria
• ✅ Responsive mobile design
• ✅ Performance optimized with indexes
• ✅ Production-ready code architecture
• ✅ Complete user authentication
• ✅ Practical, immediately useful application

Edit frontend/css/styles.css:

:root {
    --primary-color: #6366f1;  /* Change primary color */
    --secondary-color: #f59e0b;
    ...
}

1. Create new route in backend/server.js
2. Add corresponding API call in frontend/js/api.js
3. Create display function in frontend/js/analytics.js

Edit frontend/pages/add-application.html and update backend validation in server.js

The application is fully responsive:

• ✅ Mobile (320px+)
• ✅ Tablet (768px+)
• ✅ Desktop (1024px+)

Test with Chrome DevTools responsive design mode.

Solution: Ensure MongoDB is running
- Local: mongod command
- Atlas: Check connection string in .env

Solution: Change PORT in .env
PORT=3001

Solution: Check CORS and API_BASE_URL
Edit frontend/js/api.js:
const API_BASE_URL = 'http://localhost:3000/api';

Solution: 
1. Check browser console for errors
2. Check network tab for API calls
3. Verify MongoDB has data
4. Check JWT token in localStorage

• ✅ Database indexes on frequently queried fields
• ✅ Aggregation pipelines for complex analytics
• ✅ Frontend caching with localStorage
• ✅ Lazy loading for charts
• ✅ Efficient DOM manipulation

• ✅ JWT-based authentication
• ✅ Password hashing with bcryptjs
• ✅ CORS enabled
• ✅ Input validation on backend
• ✅ Protected routes with auth middleware

1. Push to GitHub
2. Connect to deployment platform
3. Set environment variables
4. Deploy

1. Update API_BASE_URL to production server
2. Deploy static files
3. Enable HTTPS

1. Create free cluster
2. Get connection string
3. Update MONGODB_URI in .env

• Resume version tracking
• Interview preparation module
• Email notifications
• Google Calendar integration
• AI-powered suggestions
• Mobile app (React Native)
• Video interview practice
• Salary negotiation tips
• Real-time collaboration
• Export analytics as PDF

Feel free to enhance this project:

1. Add new features
2. Improve UI/UX
3. Optimize queries
4. Add tests
5. Fix bugs

MIT License - Use freely for learning and projects

For issues or questions:

1. Check troubleshooting section
2. Review API documentation
3. Check MongoDB logs
4. Check browser console

This project demonstrates:

• ✅ Full-stack development skills
• ✅ Database design expertise
• ✅ Frontend development proficiency
• ✅ API architecture knowledge
• ✅ Real-world problem solving
• ✅ User-centered design

Happy coding! 🚀

Version: 1.0.0
Created: December 2025
Status: Hackathon Ready ✅