Attendance and Student Engagement Analysis

Overview

Attendance and engagement analysis helps administrators understand how actively students are participating in their courses. The attendance table tracks whether students attend sessions and how much time they spend in class.

By analyzing attendance data, you can identify:
• Attendance patterns across students
• Levels of engagement based on time spent
• Students with consistent absence
• Overall participation trends

These insights are important for early intervention, improving student success, and monitoring course engagement.

---

The Basic Pattern

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

---

Examples

Example 1 — Total Minutes Attended by Student

Example 2 — Average Attendance Time by Status

Example 3 — Count of Attendance Records per Enrollment

---

Practice Tasks (Your Turn!)

Task 1

Find the total number of minutes attended for each attendance status.

Task 2

Find the maximum minutes attended recorded for each enrollment.

Task 3

Count the number of attendance records for each attendance date.