Student Grade Portal Web App

Project roadmap

1. 01

   Set up the project and data model

   ~2h

   Create a Spring Boot project with Spring Web, Thymeleaf, Spring Data JPA, Validation, Spring Security and H2 (or PostgreSQL). Model users (with a role: instructor or student), courses (with an instructor), enrollments, assignments (with a maximum score) and grades (student, assignment and score). Load sample data at startup. Done when: the app starts and the sample data is in the database.

2. 02

   Add login and roles

   ~2h

   Configure Spring Security with form login, passwords stored with BCrypt, and users loaded from the database. Restrict /instructor/** to instructors and /student/** to students, and send each user to their own home page after login. Add logout. Done when: each role can only reach its own pages, and wrong logins show an error.

3. 03

   Build the instructor pages

   ~2.5h

   Build pages for instructors: their courses, a course page with a grade table (students by assignments), and a form to enter or edit grades, validated so a score is between 0 and the assignment's maximum. Check in the service layer that the instructor teaches the course, so changing the URL can't reach another instructor's course. Show validation errors next to fields and a success message after saving. Done when: instructors can enter grades only for their own courses.

4. 04

   Build the student pages

   ~1.5h

   Build a read-only page where students see their courses, each assignment's score and maximum, and their current percentage per course. Always load data for the logged-in student from the security context, never from a URL parameter. Done when: a student sees only their own grades, even if they change URLs.

5. 05

   Add course statistics

   ~1.5h

   Add to the instructor's course page: the average, median, highest and lowest score per assignment, and the distribution of final percentages in letter bands (A, B, C, D and F) shown as a simple bar chart made with HTML and CSS. Compute the statistics in a service with tests. Done when: the statistics match the grades in the table.

6. 06

   Test it

   ~2h

   Write tests with MockMvc and spring-security-test (@WithMockUser or with real users): each role's access, an instructor refused on another instructor's course, a student refused on another student's data, grade validation, and the statistics calculations. Done when: ./mvnw test (or Gradle) passes.

Resources

• DocsSpring guide: serving web content with Spring MVC
• DocsSpring guide: securing a web application
• DocsThymeleaf + Spring tutorial
• DocsSpring guide: validating form input
• DocsSpring Security reference