Implementasi Pivot Table Untuk Penilaian Berbasis Capaian Pembelajaran Mata Kuliah


  • (*) Katon Wijana,  Program Studi Sistem Informasi,Universitas Kristen Duta Wacana
  • Yetli Oslan,  Program Studi Sistem Informasi,Universitas Kristen Duta Wacana
  • Harianto Kristanto,  Program Studi Sistem Informasi,Universitas Kristen Duta Wacana

(*) Corresponding Author



Pivot table, generator, capaian pembelajaran lulusan


Accreditation is an assessment activity in accordance with predetermined criteria based on the National Higher Education Standards (SNDikti). Graduate competency standards are minimum criteria regarding the qualifications of graduates' abilities which include attitudes, knowledge, and skills stated in the formulation of graduate learning outcomes (CPL). CPL are still general in nature, must be translated into a more specific form, namely course learning achievement achievements (CPMK), each subject must have a CPMK that refers to CPL. In assigning grades to the CPMK, the number of grades entered for each course is different, therefore the CPMK values ​​for each course will be stored in the form of score records. To summarize the CPMK values ​​in the form of rows, a pivot table can be made in the form of columns, but in a university, each study program has a different variety and number of CPMK, therefore it is not possible to create a specific pivot table for the variety. and a certain number of CPMK, so a pivot table must be made that is flexible in terms of variety and amount. In this study, an application program is created that can be used to measure CPL based on learning outcomes for CPMK courses using a pivot table generator so that it can be flexible both in terms of the variety of CPL and the number of CPL study programs.


Coronel, Morris and Rob, “Database systems design, implementation ana management,” Cengage Learning. Boston, pp. 11-13, 2013.

Mark Spenik and Orryn Sledge, “Microsoft SQL Server 2000 DBA Survival Guide,” Sams Publishing. Indianapolis, pp. 559-574, 2001. (Oktober 2021) (Oktober 2021)

Kenneth E. Kendall and Julie E. Kendall, “System analysis and design,” Prentice Hall. Upper Suddle River, New Jersey, pp. 555-556, 2006.

Raharjo Budi, “Mudah belajar C#,” Penerbit Informatika. Bandung, pp. 2, 2015.

H.M. Dietel, P.J. Dietel, J.A. Listfield, T.R. Nieto, C.H. Yaeger and M. Zlatkina, “C#: A Programmer's introduction,” Prentice Hall. Upper Suddle River, New Jersey, pp. 361, 2003.

Direktorat pembelajaran dan kemahasiswaan direktorat jenderal pendidikan tinggi kementerian pendidikan dan kebudayaan, "Panduan penyusunan capaian pembelajaran lulusan program studi" , 2014

Program Studi SI UKDW, "Dokumen akademik perubahan kurikulum pada program studi sistem informasi Universitas Kristen Duta Wacana Yogyakarta", 2019

Syamsul Arifin, "Desain Pembelajaran & Penyusunan RPS Pendidikan Tinggi Blended Learning", 2019



How to Cite

K. Wijana, Y. Oslan, and H. Kristanto, “Implementasi Pivot Table Untuk Penilaian Berbasis Capaian Pembelajaran Mata Kuliah”, JUTEI, vol. 6, no. 2, pp. 103–110, Oct. 2022.

Most read articles by the same author(s)