KERNEL: Jurnal Riset Inovasi Bidang Informatika dan Pendidikan Informatika
Vol 6, No 2 (2025)

Perancangan Sistem Database Kinerja Penelitian Menggunakan Excel Macro di LP2M Politeknik Jambi

Saputra, Muhammad hadi (Unknown)
Kurniawan, Sigit (Unknown)
Distriyan, Febri (Unknown)



Article Info

Publish Date
31 Dec 2025

Abstract

The Research and Community Service Institute (LP2M) of Politeknik Jambi is responsible for managing the research performance of lecturers and students. The manual data management process often leads to delays in report preparation, reduced data accuracy, and difficulties in analysis. This study designs a research performance management system using Excel Macro as a simple and lightweight solution that does not require complex database software. The method consists of requirement analysis, data structure design, development of automated input forms, and macro modules for validation, recapitulation, and report generation. The implementation results show that the system can automatically generate performance reports, accelerate the recapitulation process by up to 60%, and reduce data entry errors. The novelty of this research lies in the use of Excel Macro as an alternative tool for managing research performance in higher education institutions, where such systems are typically built using web-based applications or dedicated database platforms. This system proves to be more efficient and user-friendly, thereby improving the effectiveness of research performance management at LP2M Politeknik Jambi.

Copyrights © 2025






Journal Info

Abbrev

kernel

Publisher

Subject

Computer Science & IT Other

Description

1. Teknologi Informasi 2. Rekayasa Perangkat Lunak: a. Rekayasa Kebutuhan b. Pengembangan Game dan Realitas Virtual c. Management Proyek Perangkat Lunak d. User Interface / User Experience 3. Jaringan Komputer: a. Sekuritas Jaringan b. Internet Of Things c. Wireless Network d. Cloud Computing e. ...