ACADEMIC DASHBOARD DESIGN TO IMPROVE THE EFFECTIVENESS OF STUDY PLANNING

International Journal of Computer Science (IJCS) Published by SK Research Group of Companies (SKRGC)

Abstract

Student success in their studies cannot be separated from the accuracy of decision making in preparing learning plans each semester. Taking the right courses will be able to prepare students' abilities to the maximum. Obstacles that are often experienced by students when preparing study plans and monitoring studies are students' ignorance of what specializations exist, what each student's strengths are, poor communication with academic supervisors, unclear graduation status for a subject. according to predictions. These obstacles will have an impact on the choice of major to be taken next, so that students are sometimes forced to choose a makeshift major where their class quota still remains. This can certainly be detrimental to students, especially if the student already has a dream field of work or is currently doing an internship and will become a permanent employee after graduating from school. By designing a dashboard using Microsoft Excel and Power BI [5], it is hoped that students can carry out consultations more interactively and have their tracks recorded, making it easier for the school to determine major policies, additional lessons, or suggest other short courses that can support learning outcomes and achieve specialization dreams. according to the student's talents. The use of Excel as source data is because the Reform Vocational School stores all data in Excel form, so this alignment does not require additional effort. The aim of creating a dashboard is to increase the efficiency of student study monitoring and study planning strategies, as well as a visual representation of key metrics and conditions. By analyzing this information, schools, students and academic advisors can collaborate better and make it easier to make major decisions for each student.

References

[1] Yalida A. Faktor-Faktor Yang Mempengaruhi Pemilihan Jurusan Peserta Didik Di Kelas X Sma Negeri 1 Balantak Kabupaten Banggai. Jurnal Sociohumaniora Kodepena (JSK). 2024 Jan 3;4(2):263–70.

[2] Brotherton HB, Manning JA, Orr MK. Design of the Academic Dashboard: A Tool to Enhance Students’ Efficacy in Decision-Making (WIP). American Society for Engineering Education. 2022 Jun 26;

[3] Orr, M. K., & Ehlert, K. M., & Rucks, M., & Desselles, M. (2018, June), Toward the Development of a Revised Decision-Making Competency Instrument Paper presented at 2018 ASEE Annual Conference & Exposition , Salt Lake City, Utah. 10.18260/1-2--31149

[4] Ding DK. Power BI First Report. Apress eBooks. 2023 Jan 1;1–22.. Libby T, Schwebke J, Goldwater P. Using data analytics to evaluate the drivers of revenue: An introductory case study using Microsoft Power Pivot and Power BI. Issues in Accounting Education. 2022 May 9;37(4).

[5] Rhodes JM. Using Power BI to Find Inconsistent Data between Excel Spreadsheets. Apress eBooks. 2022 Jan 1;251–64.

[6] Brotherton HB, Manning JA, Orr MK. Design of the Academic Dashboard: A Tool to Enhance Students’ Efficacy in Decision-Making (WIP). American Society for Engineering Education. 2022 Jun 26;

[7] Pangrazio L, Selwyn N, Cumbo B. A patchwork of platforms: mapping data infrastructures in schools. Learning, Media and Technology. 2022 Feb 2;1–16.

[8] Rawis ProfJoulandaA M., Kaligis JN. Management of Character Education in School-Based Quality Improvement (a case study at the YAYASAN EBEN HAEZER MANADO school) [Internet]. https://cejsr.academicjournal.io. MIDDLE EUROPEAN SCIENTIFIC BULLETIN; 2021.

[9] McWayne CM, Melzi G, Mistry J. A home-to-school approach for promoting culturally inclusive family–school partnership research and practice. Educational Psychologist. 2022 Aug 23;57(4):1–14.

[10] Hidayat A, Dila AS. DATA VISUALIZATION WITH BI TOOLS (STUDI KASUS PADA PERUSAHAAN PT. Liputan Enam Dot Com). JUTEKIN. 2023;11(2).

[11] Dwiyansaputra R, Wijaya IGPS, Bimantoro F, Agitha N, Mardiansyah AZ. Pengembangan Dashboard Berbasis Website Untuk Monitoring dan Evaluasi Di Program Studi Teknik Informatika Universitas Mataram. Journal Begawe Teknologi Informasi. 2023 Mar 31;4(1).

Keywords

Akademik, Business Intelligence, POWER BI, Dashboard, Analysis Data.