Program and Department Performance Reporting

Overview

Program and department performance reporting helps administrators evaluate how different academic units are performing in terms of student outcomes and activity levels. The programs, departments, students, and courses tables provide key insights into academic structure and performance.

By analyzing these tables, you can identify:
• Student distribution across programs
• Program activity levels
• Course offerings within departments
• Department-level academic output

These insights support strategic planning, resource allocation, and program evaluation.

---

The Basic Pattern

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

---

Examples

Example 1 — Total Students per Program

Example 2 — Total Courses per Department

Example 3 — Average Program Duration by Department

---

Practice Tasks (Your Turn!)

Task 1

Find the number of programs offered by each department.

Task 2

Find the maximum duration of programs within each department.

Task 3

Count the number of students admitted in each year.