Claim Missing Document
Check
Articles

Found 13 Documents
Search

PELATIHAN PENGINPUTAN DATA SECARA OTOMATIS DI MICROSOFT EXCEL MENGGUNAKAN DATA FORM DAN MACRO VBA (BASIC FOR APLICATION) DI SMA IT UNGGUL AL-MUNADI MEDAN Siregar, Elida Tuti; Alfina, Ommi; Puspita, Dahlia; Safii, M.
Jurnal Pengabdian Pada Masyarakat METHABDI Vol 3 No 2 (2023): Jurnal Pengabdian Pada Masyarakat METHABDI
Publisher : Universitas Methodist Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.46880/methabdi.Vol3No2.pp150-154

Abstract

Automatic data input using Microsoft Excel as a number processor or application for automatically processing data such as numerical values, mathematical formulas and making financial reports hone students' skills in knowledge of the use of computer technology, which is a basic need nowadays to operate a computer, a skill that students must master in the future world of work. because computer operating skills are really needed by companies, especially the Microsoft Excel application to process technology-based company data in determining decision makers in a company. This training will produce graduates who can operate computers and input data automatically. This activity provides skills and knowledge to students at SMA IT Unggul Al Munadi Medan using Microsoft Excel to process and input data automatically with Visual Basic forms and macros (VBA)
Klasifikasi Pola Konsumsi Energi Rumah Tangga Menggunakan Algoritma Machine Learning untuk Mendukung Implementasi Smart City Alfina, Ommi; M. Safii
METHOMIKA: Jurnal Manajemen Informatika & Komputerisasi Akuntansi Vol. 9 No. 2 (2025): METHOMIKA: Jurnal Manajemen Informatika & Komputersisasi Akuntansi
Publisher : Universitas Methodist Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Population growth in urban areas drives a significant increase in household energy consumption. This condition poses a major challenge for the implementation of the smart city concept, particularly in achieving energy efficiency and sustainability. This study aims to classify household energy consumption patterns based on household power consumption data to support intelligent decision-making in urban energy management. The research method includes data preprocessing, data cleaning, and aggregation of daily energy consumption by utilizing key attributes such as Global Active Power, Voltage, Global Intensity, and three sub-metering variables. Consumption pattern categories are formed using the tertile method into three classes: Low, Medium, and High. Several machine learning algorithms are applied to build the classification model, including Logistic Regression, K-Nearest Neighbors (KNN), Random Forest, and Gradient Boosting. The test results show that the Random Forest model with hyperparameter adjustments produces the best performance with an accuracy value of 0.98 and an F1-macro value of 0.98, surpassing other models. These findings indicate that the ensemble learning approach is able to capture the complexity of household energy consumption patterns more effectively than conventional linear models. The contribution of this research lies in the development of a machine learning-based predictive model to support adaptive energy consumption monitoring and control systems in smart city implementations.
Pelatihan Mengenal dan Mengoptimalkan Prompt GPT untuk Pembelajaran Digital di SMK PAB 8 Sampali Alfina, Ommi; Syahputri, Nita; Lahilote, Abqoriy Hisan; Rustam, Muhammad Taufiq; Safii, M.
Jurnal Pengabdian Pada Masyarakat METHABDI Vol 5 No 1 (2025): Jurnal Pengabdian Pada Masyarakat METHABDI
Publisher : Universitas Methodist Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

The training program titled "Introduction and Optimization of GPT Prompts for Digital Learning at SMK PAB 8 Sampali" was conducted as an effort to enhance digital literacy and technological skills among teachers and students. In the era of Education 4.0, artificial intelligence (AI) technology, particularly Generative Pre-trained Transformer (GPT), holds great potential to support teaching and learning processes, including generating exam questions, summarizing materials, and planning lessons. This training aimed to provide basic understanding of GPT concepts and practical skills in crafting effective prompts for various educational purposes. The implementation method employed hands-on practice and real-life case studies within the SMK environment. The results showed an improvement in teachers' and students' abilities to utilize AI technologies, as well as increased awareness of the importance of ethical and creative use of technology in digital education. Through this training, SMK PAB 8 Sampali is expected to become a pioneer in the application of AI in vocational secondary schools in Medan.