Student Performance Analysis Using Grades and Final Outcomes

Overview

Student performance analysis focuses on understanding how well students are doing academically using grade data and final course outcomes. The grades table captures scores and letter grades, while the enrollments table provides final outcomes such as Completed, Withdrawn, or In Progress.

By analyzing these tables, administrators can evaluate:• Overall academic performance• Distribution of grades• Success and failure rates• Patterns in course completion

These insights help identify strong and struggling students, evaluate course difficulty, and support academic decision-making.

---

The Basic Pattern

SELECT column_name, aggregate_function(column_name)
FROM table_name
GROUP BY column_name;
  

---

Examples

Example 1 — Average Score by Letter Grade

Example 2 — Count of Final Outcomes

Example 3 — Average Score by Assessment Type

---

Practice Tasks (Your Turn!)

Task 1

Find the highest score achieved for each assessment type.

Task 2

Count the number of students who received each letter grade.

Task 3

Find the lowest score recorded for each enrollment.