Implementasi Pivot Table Untuk Penilaian Berbasis Capaian Pembelajaran Mata Kuliah
Keywords: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.
https://www.sqlshack.com/dynamic-pivot-tables-in-sql-server/ (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
Copyright (c) 2023 Katon Wijana, Yetli Oslan, Harianto Kristanto
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors who publish articles in JUTEI agree on the following rules:
1. The author grants non exclusive royalty free rights, and is willing to publish articles online and complete (full access). With such rights JUTEI reserves the right to save, transfers, manages in various forms, maintains and publishes articles while keeping the author's name as the copyright owner.
2. Each author contained in the article has contributed fully to the substance and intellectual, and is accountable to the public. If in the future there is a copyright infringement notification then this will be responsibility of the author, not JUTEI.