Automating Academic Mark Management: A Case Study of SGPA Calculator using MERN Stack

Abstract: The SGPA Calculator project aims to streamline the process of entering and managing semester marks for university students. Currently, students have to individually enter their marks in an Excel sheet in a computer lab, leading to time consuming delays and inconvenience. Additionally, if a student is absent, the process further gets delayed until they come and enter their marks. In cases where a student is unable to attend college, the attendance personnel have to enter their marks separately. To address these challenges, a website has been developed using the MERN stack. The website allows students to conveniently enter their marks through their web browsers after each semester's results are declared. The system automatically calculates the SGPA, percentage, and result based on the entered marks, which are then securely stored in a database. The stored data can be accessed through a dashboard and can even be downloaded in Excel format. This eliminates the need for students to wait or visit the lab, providing a more efficient and user-friendly solution for managing and maintaining academic records.

Keywords: SGPA Calculator, MERN Stack, Web Application, Mark Management, Automation