mcpField
O
obe-excel-dashboard-builder

obe-excel-dashboard-builder

github.com/lensetekOther013 installsUpdated 1d ago
Repository

About obe-excel-dashboard-builder

A skill that automates Excel dashboard creation for Outcome-Based Education assessment. It organizes course and student results into linked worksheets with formulas, attainment measures, and charts.

Key features

  1. 01Executive course summary worksheet
  2. 02CPMK-to-assessment mapping
  3. 03Formula-based individual results
  4. 04CPL attainment calculations
  5. 05Grade distribution charts and formatting

Use cases

  1. 01Measuring course learning outcome attainment
  2. 02Mapping assessment weights to CPMK
  3. 03Reviewing student results and remediation needs
  4. 04Preparing spreadsheet-based accreditation reporting

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/lensetek/course-agent-skills --skill obe-excel-dashboard-builder

After installing, type/obe-excel-dashboard-builderin Claude Code to confirm it loaded.

Details

From the project README

OBE Excel Dashboard Builder 📈

obe-excel-dashboard-builder mengotomatisasi pembuatan berkas spreadsheet Excel berstandar akreditasi (seperti BAN-PT, LAM-PT, LAM-INFOKOM, ABET) untuk mengukur capaian pembelajaran berbasis luaran (Outcome-Based Education / OBE).

📑 Lembar Kerja (Worksheet) yang Dihasilkan

Sebuah berkas Dashboard_OBE_Kelas.xlsx memuat sheet-sheet terintegrasi:

  1. Sheet 1: Ringkasan_Eksekutif:
    • Persentase mahasiswa yang memenuhi standar ketercapaian minimum CPMK (Target ketercapaian kelas, misal min. 75% mahasiswa bernilai $\ge 70$).
    • Indikator Nilai Rata-rata Kelas, Standar Deviasi, Nilai Tertinggi, Nilai Terendah.
    • Grafik Sebaran Nilai Huruf (A, AB, B, BC, C, D, E).
  2. Sheet 2: Matriks_CPMK_vs_Asesmen:
    • Pemetaan bobot instrumen evaluasi (Tugas Sesi 1–14, Kuis, Praktikum, UTS, UAS) terhadap masing-masing CPMK.
  3. Sheet 3: Nilai_Individu_dan_Ketercapaian:
    • Daftar seluruh nama dan NIM/NISN mahasiswa.
    • Kolom nilai terformat dengan Formula Excel Otomatis (SUMPRODUCT, AVERAGE, VLOOKUP, IF).
    • Conditional Formatting (Warna hijau untuk tuntas, warna kuning/merah untuk butuh perhatian/remedial).
  4. Sheet 4: Ketercapaian_CPL:
    • Menghitung kontribusi mata kuliah ini terhadap Capaian Pembelajaran Lulusan program studi secara holistik.

📐 Standar Kualitas Formula & Tampilan

  • Zero-Broken Formula: Semua formula menggunakan sintaks baku Excel yang kompatibel dengan Microsoft Excel 2016+, Office 365, Google Sheets, dan LibreOffice Calc.
  • Tampilan Terformat Rapi: Menggunakan skema warna korporat yang elegan (Navy Slate & Emerald Green), header tebal, freeze panes, dan gridlines aktif.

Comments

Markdown supported