Project: Compute Student CGPA
Calculate cumulative performance using semester-wise SGPA records.
In this project, you’ll compute each student’s CGPA (Cumulative Grade Point Average) based on their SGPA across multiple semesters. This is a common real-world use case in education analytics and reporting systems.
Database schema
You’ll work with these two tables:
1. students table
ID | Name | Class |
1001 | James | 9A |
1002 | Olivia | 9A |
1003 | Ethan | 9B |
1004 | Sophia | 9A |
1005 | Liam | 9B |
2. semesters table
StudentID | Semester | SGPA |
1001 | 1 | 3.8 |
1001 | 2 | 3.6 |
1002 | 1 | 3.9 |
1002 | 2 | 4.0 |
1003 | 1 | 3.0 |
1004 | 1 | 3.7 |
1004 | 2 | 3.9 |
1004 | 3 | 3.8 |
...