How Academic, Enrollment, Attendance, Advising, and Tuition Systems Store Data

Overview

Education data is generated from different systems, each responsible for a specific part of institutional operations. These systems store data in structured tables that can be connected for analysis.

Academic systems store course and program information. Tables such as courses, programs, and sections record what is being taught, how courses are structured, and when they are offered.

Enrollment systems manage student registration. The enrollments table captures which students are registered in which sections, along with enrollment status and outcomes.

Attendance systems track student participation. The attendance table records whether students attended classes, how often, and for how long.

Advising systems capture student support interactions. The advising_sessions table stores information about advising meetings, session types, and whether follow-up is required.

Tuition systems manage financial records. The tuition_payments table stores billing amounts, payments made, and outstanding balances.

All of these systems are connected through shared keys such as student_id, section_id, term_id, and program_id. Together, they provide a complete view of a student’s academic journey and administrative records.

---

The Basic Pattern

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

---

Examples

Example 1 — Count Enrollments by Status (Enrollment System)

Example 2 — Count Attendance Records by Status (Attendance System)

Example 3 — Count Advising Sessions by Type (Advising System)

---

Practice Tasks (Your Turn!)

Task 1

Count the number of tuition payments by payment method.

Task 2

Count the number of sections by delivery mode.

Task 3

Count the number of students by student status.