Executive Dashboard
Performance Monitoring & Data Integrity System
KPI 1: Integrity
92%
2% vs last month
KPI 2: Prep
100%
All Materials Ready
KPI 3: Attendance
88%
3 Lateness Issues
KPI 4: Comms
95%
Avg Resp: 4.2h
Critical Alerts
3 New
KPI 1.1 Grading Late
Mr. Budi - Math 7A submitted > 24h
KPI 3.3 Lateness
Ms. Siti arrived late (3rd time)
KPI 2.1 Missing Note
Science 8B: No Differentiation Note
KPI 1: GRADING & DATA INTEGRITY
Priority: High
| Sub-KPI | Tabel Sumber & Kolom | Logika Sistem |
|---|---|---|
|
1.1 Grading 24 Hours Wajib input nilai < 24 jam |
grade_submissions waktu_submit_nilai class_schedules waktu_kelas_selesai student_attendance status_kehadiran_siswa |
1. JOIN tabel berdasarkan class_id. 2. SKIP siswa dengan status 'Sakit/Izin'. 3. CALC (waktu_submit - waktu_selesai). 4. IF > 24 Jam THEN Status = FAIL. |
|
1.2 Zero Unauthorized Edits Tidak boleh ada edit nilai Final |
grade_audit_logs original_teacher_id editor_user_id grade_status |
1. FILTER grade_status = 'Final'. 2. CHECK editor_user_id == original_teacher_id. 3. IF False AND Editor != Admin THEN FAIL. |
|
1.3 Teacher Attribution Submitter harus sesuai pengajar |
substitution_logs actual_teacher_id class_schedules assigned_teacher_id |
1. CHECK is_substituted? 2. SET Validator = Actual OR Assigned Teacher. 3. COMPARE Submitter ID vs Validator. 4. IF Mismatch THEN FAIL. |
|
1.4 Data Quality SLA Resolve isu data < 48 jam |
data_quality_flags flag_created_at flag_resolved_at |
1. CALC (resolved_at - created_at). 2. IF > 48 Jam THEN FAIL. |
KPI 2: PREPARATION
Priority: Med
| Sub-KPI | Tabel Sumber & Kolom | Logika Sistem |
|---|---|---|
|
2.1 Materials D-7 Upload materi H-7 |
lesson_materials material_upload_date class_schedules class_date |
1. CALC Deadline = class_date - 7 Hari. 2. IF upload_date <= Deadline THEN PASS. |
KPI 3: ATTENDANCE & DISCIPLINE
| Sub-KPI | Tabel Sumber & Kolom | Logika Sistem |
|---|