Summary

SIMNA is a web-based application that is used to manage student final grades, made with Laravel and Bootstrap. This application is built to replace the conventional method of managing student grades, which is using Microsoft Excel, and help the teacher to manage student grades more easily and efficiently.

Background

Subah Senior High School is a high school located in the district of Batang, Central Java, Indonesia. The school has a total of ±750 students and ±60 teacher. The school has been using Microsoft Excel to manage student grades. While the method used is effective, it has several problems, such as:

• The teacher has to manually input the student grades into the Microsoft Excel file.
• The teacher has to manually calculate the student grades.
• The report card is not automatically generated.

Final year students grade are calculated with the following formula:

Final Grade = (semester_grade + ((x * School Exam) + (y * National Exam))) / 2
// x and y are the weight of the exam

The component of grading system detailed as follows:

1. Semester Grade
   Semester grade is the average grades of the student in the semester 1-6.
2. School Exam
   School exam is grade obtained by the student in the school exam multiply by x.
3. National Exam
   National exam is grade obtained by the student in the national exam multiply by y.

   x and y are the weight of the exam, where x+y=1

Design Process

Goals

The expected outcome of this project is a web-based application that can be used to manage student grades. The application should be able to:

1. Import student data from Microsoft Excel file.
2. Calculate student grades automatically.
3. Generate report card automatically.

System Specification

The application will be built using Laravel. The application will have two user roles, which are teacher and admin. The application will provide a downloadable excel template that contain a boilerplate for the admin to input student grades. The admin will then upload the excel file to the application. The application will then calculate the student grades and generate the report card.

The admin will also be able to manage user data, such as adding, editing, and deleting teacher and student data, and is able to set the weight of school and national exam while also setting the minimum passing grade the student to graduate.

The teacher will have access to their respective class and download the report card, which consist of two types of report card as follows:

1. SKHU (Surat Keterangan Hasil Ujian)
   SKHU is a report card contain student final grades after the calculation of their semester grade, school exam, and national exam. You can access the sample of SKHU here.
2. SKLU (Surat Keterangan Lulus Ujian)
   SKLU is a report card that determine whether the student is able to graduate or not. The student is able to graduate if their final grade is above the minimum passing grade set by the admin. You can access the sample of SKLU here.

Result

Admin Dashboard

School Exam Grades

Upload Grades