All Projects

Student Performance Analytics

Aayush-Sigdel / StudentPerformanceAnalyticsSystem
2026Backend

A C# console application for managing student data and analyzing academic performance. Features full CRUD, GPA calculation, rankings, failing reports, and department analysis using Entity Framework Core and MySQL.

Screenshots

About This Project

Student Performance Analytics is a console-based system for academic institutions to manage and analyze student records. Built with C# and Entity Framework Core, it connects to a MySQL database for persistent storage.

Key Features:

  • Full CRUD operations for student records
  • GPA calculation with customizable grading scales
  • Class rankings and top-performer reports
  • Failing student identification and reports
  • Department-wise performance analysis
  • CSV export for reports

Technical Highlights:

The application follows a layered architecture with separate data access, business logic, and presentation layers. Entity Framework Core handles ORM with MySQL as the database. The console UI uses spectre.console for rich text formatting, tables, and progress bars.

This was a university project that I expanded beyond the requirements. It taught me about database design, ORM patterns, and building maintainable C# applications.

Technologies

c-sharpdotnetmysqlentity-framework