🎯 Objective:
To provide a comprehensive overview of course participation, instructor involvement, and academic outcomes such as average grades and pass percentages across various departments and semesters.
Get the Dataset here: https://www.kaggle.com/datasets/slidescope/university-courses-performance-dataset-slidescope/
📊 KPI Cards (Top Metrics):
- Avg Grade (2.94)
- Represents the average GPA across all courses (on a 0.0–4.0 scale).
- Indicates overall academic performance.
- Total Course Hours (7512)
- Sum of instructional hours delivered across all courses.
- Helps understand faculty workload and curriculum intensity.
- Students Enrolled (17K)
- Total number of student registrations across all courses.
- Measures student engagement at scale.
- Avg Pass Percentage (79.79%)
- Mean percentage of students passing their respective courses.
- Reflects overall course success and effectiveness.
📘 Visuals Breakdown:
1. Students Enrolled by Course Type (Bar Chart)
- Compares total enrollment across different course types: Seminar, Lab, Theory, and Project.
- Seminar courses appear to be the most popular.
2. Students Enrolled & Course Count by Department (Combo Chart)
- Dual-axis view:
- Bar (left): Total students enrolled in each department.
- Line (right): Number of courses offered by each department.
- Insight: Humanities has the highest enrollment but not the highest number of courses—suggesting larger class sizes or fewer but highly attended courses.
3. Students Enrolled by Instructor (Tree Map)
- Visualizes which instructors are handling the largest student volumes.
- Example: Michael Smith and Mark Clark are teaching high-enrollment courses.
4. Students Enrolled by Semester (Donut Chart)
- Breaks down enrollment trends across Spring and Fall semesters (2023 & 2024).
- Fall 2024 shows the highest enrollment, indicating a possible surge in course offerings or student intake.
🎛️ Slicers (Right Panel Filters):
Allows users to filter the entire dashboard based on:
- Course Type
- Department
- Instructor
- Semester
This makes the dashboard interactive and ideal for drill-down analysis.
✅ Overall Impact & Use:
Supports data-driven decisions in faculty workload planning and semester scheduling.
Helps academic administrators, deans, and curriculum planners identify high-demand courses and top-performing instructors.