Inspiration
UniPlanner was born from the frustration of navigating the complex college admissions landscape as a high school student. Traditional tools offered fragmented solutions—spreadsheets for grades, separate apps for test scores, and generic advice that didn't account for individual circumstances. We envisioned a comprehensive platform that would empower students with data-driven insights and AI-powered guidance, transforming the stressful college application process into a strategic, informed journey.
The inspiration struck when we realized that modern students have access to unprecedented amounts of data about their academic performance, yet lack the tools to synthesize this information meaningfully. What if AI could analyze a student's entire academic trajectory—from freshman year course selections to senior year test scores—and provide personalized recommendations? What if we could predict university acceptance likelihood with mathematical precision? UniPlanner emerged as the answer to these questions.
What it does
UniPlanner is an AI-powered university application portfolio management system that serves as a student's comprehensive academic companion. At its core, the platform enables students to:
- Track Academic Performance: Maintain detailed records of courses, assignments, grades, and standardized test scores with real-time GPA calculation
- Analyze Academic Trends: Visualize grade progression over time and identify performance patterns across subjects
- Predict University Acceptance: Use machine learning models to estimate acceptance likelihood at target universities based on comprehensive profile analysis
- Receive AI Recommendations: Get personalized course suggestions, extracurricular guidance, and portfolio optimization advice
- Compare University Fit: Evaluate how student profiles align with university requirements and admission standards
- Discover Opportunities: Browse scholarships, programs, and internships tailored to academic profiles
The platform integrates optical character recognition (OCR) technology to digitize report cards and assignments, making data entry seamless and accurate.
How we built it
UniPlanner was constructed using a modern, scalable architecture designed for performance and maintainability:
Frontend Architecture:
- Framework: Next.js 14 with App Router for optimal performance and SEO
- Language: TypeScript for type safety and developer experience
- Styling: Tailwind CSS with custom design system and dark mode support
- UI Components: Radix UI primitives with custom component library
- Animations: Framer Motion for smooth, professional interactions
- Charts: Recharts for data visualization and academic trend analysis
Backend & Database:
- Database: Supabase (PostgreSQL) with 12+ interconnected tables
- Security: Row Level Security (RLS) policies ensuring data isolation
- API Layer: Repository pattern with type-safe database operations
- Authentication: Supabase Auth with protected routes and user sessions
AI Integration:
- AI Provider: Grok API for natural language processing and recommendations
- Features: Course recommendations, acceptance prediction, grade analysis, portfolio advice
- Data Processing: Complex algorithms for GPA calculation, risk assessment, and comparative analysis
The system implements sophisticated mathematical models for academic evaluation:
GPA Calculation: $$GPA = \frac{\sum_{i=1}^{n} (grade_i \times credits_i \times weight_i)}{\sum_{i=1}^{n} (credits_i \times weight_i)}$$
Where $weight_i$ includes bonuses for Advanced Placement (+1.0) and Honors (+0.5) courses.
Acceptance Prediction Model: The AI analyzes multiple variables including GPA, test scores, course rigor, and extracurricular depth to generate acceptance likelihood estimates with confidence intervals.
Challenges we ran into
Building UniPlanner tested our technical limits and problem-solving abilities:
Complex Data Modeling: Designing a relational database schema that accurately represents academic hierarchies—from individual assignments to university-wide comparisons—required careful normalization and relationship mapping. The challenge of maintaining data integrity across 12+ tables while supporting real-time calculations proved particularly demanding.
AI Integration Complexity: Implementing reliable AI features required sophisticated prompt engineering, error handling, and response validation. The system needed to process diverse inputs (course transcripts, test scores, university data) and generate actionable recommendations while maintaining user privacy and data security.
Real-time Performance: Achieving responsive GPA calculations and comparative analysis with large datasets demanded optimized database queries, efficient caching strategies, and careful state management. The platform handles complex aggregations across multiple academic years while maintaining sub-second response times.
OCR Accuracy: Integrating Tesseract.js for document scanning introduced challenges with handwriting recognition, varied document formats, and error correction. Building robust validation and fallback mechanisms was crucial for reliable data extraction.
Scalability Concerns: As the platform grew, we faced challenges with API rate limiting, database connection pooling, and memory management. Implementing proper indexing and query optimization became critical for maintaining performance.
Accomplishments that we're proud of
Despite the challenges, UniPlanner represents several technical and product achievements:
Comprehensive Academic Tracking: We built the most detailed academic portfolio system available, tracking not just final grades but individual assignments, grade history, and performance trends over time.
Sophisticated AI Models: The acceptance prediction engine achieves remarkable accuracy by analyzing hundreds of variables simultaneously, providing students with data-driven insights that rival professional college counseling.
Seamless User Experience: The platform combines complex functionality with intuitive design, enabling students to manage their entire college application process from a single, beautiful interface.
Mathematical Rigor: Every calculation—from weighted GPA to university compatibility scores—is mathematically sound and transparent, giving students confidence in the platform's recommendations.
Security-First Architecture: Implementing Row Level Security across all database operations ensures that sensitive academic data remains private and protected.
What we learned
UniPlanner taught us invaluable lessons in software development and product design:
Technical Skills:
- Advanced database design and optimization techniques
- AI prompt engineering and response processing
- Real-time data aggregation and caching strategies
- TypeScript's power for complex domain modeling
- Performance optimization for data-intensive applications
Product Insights:
- The importance of mathematical transparency in educational tools
- How AI can augment rather than replace human judgment in admissions
- The value of comprehensive data collection for meaningful analysis
- User experience principles for complex, data-heavy applications
Engineering Philosophy:
- The repository pattern's effectiveness for complex domain logic
- Benefits of API-first development for feature evolution
- Importance of comprehensive testing for mathematical functions
- Value of iterative development with user feedback
What's next for UniPlanner
The roadmap ahead focuses on expanding UniPlanner's capabilities and reach:
Enhanced AI Features:
- Personality assessment integration for more nuanced recommendations
- Essay feedback and writing assistance tools
- Predictive modeling for optimal course scheduling
Social Features:
- Anonymous profile comparison and benchmarking
- Mentorship matching with alumni
- Study group formation based on academic profiles
Mobile Experience:
- React Native app for on-the-go portfolio management
- Camera integration for instant document scanning
- Push notifications for academic milestones
Advanced Analytics:
- University admission trend analysis
- Career pathway recommendations based on academic performance
- Scholarship matching algorithms
Enterprise Solutions:
- School district partnerships for cohort management
- Integration with existing student information systems
- Analytics dashboard for educational institutions
UniPlanner represents more than just a tool—it's a comprehensive solution that democratizes access to sophisticated college planning resources, empowering the next generation of students to make informed decisions about their academic futures.
Built With
- css
- heroui
- lucidereact
- next-themes
- next.js
- radixui
- react
- recharts
- sonner
- supabase
- tailwind
- tesseract.js
- typescript
- zod
Log in or sign up for Devpost to join the conversation.