Progress Report

Custom internal tool to calculate students' grades and marks based on Excel data, and genetate Progress Report Card PDF.

Features

  Calculate based on Raw Excel data

• Excel sheet data viewer for all subjects for each student
• Calculate Attendance
• Calculate Grades
• Highlighter for failed subjects, miscalculated marks and duplicated Names and Id

  Generate Progress Report

• Generate PDF files based on calculated marks, grades and attendance
• Live PDF viewer
• Different background templates for different classes
• Dynamic user input for Academic year, month and date
• Download as Excel or PDF files

  Authentication & others

• Can only login with specific Google accounts
• Save data to database
• Support for all classes from Year-1 to Year-9
• Support for different semester templates

Packages

• Framework- Next.js / React
• Typescript for type safety
• Tailwind CSS for styling
• React-Hook-Form for forms management
• drizzle-orm for Database ORM
• Better-Auth for authentication
• radix-ui for UI components
• zod for schema validation
• @neondatabase/serverless for Database
• @tanstack/react-query for data fetching and caching