Student Stats Dashboard

by Shri Harri Priya Ramesh

⚡ Tech Skills

React.js
Next.js
FastAPI
Node.js
Django
Python
TypeScript
SQL
MongoDB
AWS
Docker
Kubernetes

📊 Undergraduation CRM Dashboard

A lightweight internal CRM dashboard for managing student interactions on undergraduation.com.

Introduction

This project aims to build a basic internal-facing CRM-style web dashboard to help the Undergraduation team manage student interactions, track their progress, and log communication history. This will provide a centralized view of each student’s journey on the platform.

Objective

  • Track every student’s engagement
  • Monitor application progress
  • Log and view communication history
  • Take actions (send follow-ups, notes, etc.)

Features

Student Directory View:

  • Table view of all students with filters/search
  • Key columns: Name, Email, Country, Application Status, Last Active
  • Ability to click and open an individual student profile

Student Individual Profile View:

  • Basic Info (name, email, phone, grade, country)
  • Interaction Timeline
  • Communication Log
  • Internal Notes
  • Current progress bar

Communication Tools:

  • Log communications manually
  • Trigger follow-up email (mock only)
  • Schedule reminders/tasks

Insights & Filters:

  • Quick filters (e.g. “Not contacted in 7 days”)
  • Summary stats
  • Bonus: AI Summary

Domain Info

Students can write essays with AI, select colleges by preferences (budget, major, state, class size), and log exam scores (SAT, etc.).

Tech Stack

  • Frontend: Next.js with TypeScript
  • Backend: FastAPI
  • Database: Supabase
  • Auth: JWT

Resources Used

This project builds on top of the nextjs-fastapi-template, an open-source starter kit.

Deliverables

  • Working web app locally hosted
  • GitHub repository with code
  • README file explaining setup