Analyzing Enrollments, Class Rosters, Course Offerings, and Teaching Assignments

Overview

In education administration, analysis often focuses on how students are distributed across classes, how courses are offered, and how instructors are assigned. This helps administrators understand class sizes, course demand, and teaching workloads.

The enrollments table shows which students are registered in each section. The sections table shows how courses are offered, including section numbers and delivery modes. The courses table provides course details, and the teaching_assignments table links instructors to sections.

By combining these tables, you can analyze:• Class rosters (which students are in each section)• Course offerings (how many sections are available)• Enrollment distribution (how many students per section)• Teaching assignments (which instructor teaches which section)

These insights help with scheduling, resource planning, and academic decision-making.

---

The Basic Pattern

SELECT column_name, COUNT(*) AS total
FROM table_name
GROUP BY column_name;
  

---

Examples

Example 1 — Count Students per Section

Example 2 — Count Sections per Course

Example 3 — Count Teaching Assignments per Instructor

---

Practice Tasks (Your Turn!)

Task 1

Count the number of enrollments by final status.

Task 2

Count the number of sections by delivery mode.

Task 3

Count the number of teaching assignments by teaching role.