Article Per Year (5 Year)
p-Index From 2021 - 2026
2.013
P-Index
This Author published in this journals
All Journal BIMASTER POSITIF Indonesian Journal of Applied Statistics Jambura Journal of Mathematics JISKa (Jurnal Informatika Sunan Kalijaga) Majalah Ilmiah Matematika dan Statistika (MIMS) SEMAR Idealis : Indonesia Journal Information System Prosiding Konferensi Nasional PKM-CSR IJCOSIN : Indonesian Journal of Community Service and Innovation Prosiding Seminar Nasional Official Statistics PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON DATA SCIENCE AND OFFICIAL STATISTICS Jurnal Akademik Pengabdian Masyarakat
Andreas Rony Wijaya
Program Studi Sains Data, Fakultas Informatika, Institut Teknologi Telkom Purwokerto
Agriculture, Biological Sciences & Forestry Humanities Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Earth & Planetary Sciences Economics, Econometrics & Finance Education Electrical & Electronics Engineering Environmental Science Industrial & Manufacturing Engineering Languange, Linguistic, Communication & Media Library & Information Science Mathematics Nursing Public Health Social Sciences Other

Published : 13 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 13 Documents
Search

 1   2 
LITERASI STATISTIK DAN IMPLEMENTASINYA PADA OPTIMALISASI MICROSOFT EXCEL DALAM PEMBUATAN DAN PENGELOLAAN BANK SOAL WIJAYA, ANDREAS RONY; Nirwana, Muhammad Bayu; Ferawati, Kiki; Pratiwi, Hasih; Respatiwulan, Respatiwulan; Handayani, Sri Sulistijowati; Susanti, Yuliana; Agustin, Frencilia Paulina; Hartanto, Aqila Khansa; Wardati, Bilqies Syafina
Prosiding Konferensi Nasional Pengabdian Kepada Masyarakat dan Corporate Social Responsibility (PKM-CSR) Vol 8 (2025): Penguatan Ekonomi Masyarakat Berbasis Ekologis untuk Mencapai Keberlanjutan Menuju Ind
Publisher : Asosiasi Sinergi Pengabdi dan Pemberdaya Indonesia (ASPPI)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.37695/pkmcsr.v8i0.2733

Abstract

In today’s digital era, the integration of technology in education has become increasingly important. One key aspect that can be enhanced through technology is its application in teaching and learning activities. The use of technology enables the learning process to become more efficient. One such technology that can be applied is Microsoft Excel. Traditionally, Excel has been widely recognized as data processing software. In Karanganyar Regency, particularly within the Mathematics Teachers’ Working Group Forum (MGMP Matematika), teachers already possess basic skills in using Excel. Strengthening statistical literacy through the use of Excel among teachers is expected to improve the quality of teaching, enabling them to better understand, analyze, and present data. Until now, in the preparation and development of question banks, many teachers have created exam questions manually without taking advantage of technological tools. In fact, Excel provides features that can assist teachers in designing question banks in a more systematic, efficient, and organized manner. These features include the creation, categorization, and analysis of questions. As a discipline focused on data collection, analysis, and data-driven decision-making, statistics plays a vital role in enhancing society’s understanding of quantitative information. To promote statistical literacy, the Statistics and Data Science Research Group in the Field of Environment and Health, Department of Statistics, Faculty of Mathematics and Natural Sciences, Universitas Sebelas Maret, organized a community service program in the form of training for junior high school teachers in Karanganyar through the MGMP Matematika forum. The training aimed to optimize the use of Microsoft Excel in developing question banks, enabling teachers to design and manage questions more systematically and efficiently. Through this training, teachers are expected to apply data-based techniques in test item development to improve the effectiveness of learning evaluation.
Analisis Faktor-Faktor Penyebab Inflasi di Indonesia Menggunakan Regresi Ridge, LASSO, dan Elastic-Net Khoirunissa, Husna Afanyn; Wijaya, Andreas Rony; Isnaini, Bayutama; Ferawati, Kiki
Indonesian Journal of Applied Statistics Vol 7, No 2 (2024)
Publisher : Universitas Sebelas Maret

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.13057/ijas.v7i2.96921

Abstract

The economic condition of a country can be measured using one of the indicators, the inflation rate. Therefore, the inflation needs to be maintained so that its rate can be controlled. To support this, it is necessary to pay attention to several factors that influence the inflation rate. These factors include the amount of exports, imports, narrow money (M1), broad money (M2), the rupiah exchange rate against the USD, interest rates, rice prices in wholesale trade, farmer exchange rates (NTP), world crude oil prices, bank investment credit, GDP, and foreign exchange reserves. In this study, we analyze the significant factors influencing the inflation rate in Indonesia using the best model of the Ridge regression, LASSO regression, and Elastic-Net methods. In this modeling, the γ and λ values from the three methods are optimized first. The data used in this study consist of inflation data in Indonesia and its factors for 2020-2024, sourced from the BPS. Among the three high-dimensional data methods, the LASSO regression is the best method with the smallest MSE for modeling inflation data in Indonesia. The LASSO regression model produces 8 predictor variables that significantly influence inflation data, i.e., imports, M1, interest rates, and world crude oil prices with positive coefficient signs, as well as rice price variables in wholesale trade, NTP, GDP, and foreign exchange reserves with negative coefficient signs.Keywords: inflation; ridge regression; lasso regression; elastic-net.
Pelatihan Penggunaan Excel untuk Evaluasi Pembelajaran bagi Guru Matematika SMP di Kabupaten Karanganyar Respatiwulan, Respatiwulan; Ferawati, Kiki; Nirwana, Muhammad Bayu; Wijaya, Andreas Rony; Nugroho, Elvin Agustiyan; Rahmawati, Aprilia Saniatul
SEMAR (Jurnal Ilmu Pengetahuan, Teknologi, dan Seni bagi Masyarakat) Vol 14, No 2 (2025): November
Publisher : LPPM UNS

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.20961/semar.v14i2.110468

Abstract

Seiring dengan perkembangan teknologi, kebutuhan peneglolaan data dengan cepat dan akurat sangat penting termasuk dalam dunia pendidikan. Banyak perangkat lunak yang dapat digunakan untuk mengelola data termasuk Microsoft Excel. Microsoft Excel adalah program spreadsheet yang dikembangkan oleh Microsoft. Microsoft Excel digunakan untuk perhitungan sederhana, penyimpanan data, mengolah data dalam bentuk tabel, perhitungan matematis, analisis statistik, pembuatan grafik, dan berbagai keperluan administratif lainnya. Bagi guru matematika, Excel adalah alat yang sangat powerful untuk membantu dalam berbagai aspek pengelolaan data, dari mencatat nilai, mengolah statistik, hingga merancang laporan dan perencanaan pembelajaran. Menguasai Excel dapat sangat meningkatkan efisiensi kerja dan kualitas pengajaran. Forum Musyawarah Guru Mata Pelajaran (MGMP) Matematika SMP di Kabupaten Karanganyar berfungsi sebagai tempat bagi guru-guru Matematika untuk saling berbagi pengetahuan dan meningkatkan kompetensi dalam proses pembelajaran. Para guru di forum MGMP Matematika  telah memiliki keterampilan dasar penggunaan Excel. Oleh karena itu pelatihan analisis statistika menggunakan Excel di kalangan guru MGMP Matematika Karanganyar dapat meningkatkan kualitas pembelajaran  sehingga lebih baik dalam memahami, menganalisis, dan menyajikan data. Peningkatan kemampuan analisis statistik ini dapat dilakukan dengan memberikan pelatihan yang mencakup pengenalan data, persiapan data, visualisasi data, analisis dan interpretasi hasil. Pelatihan ini memberikan ruang konsultasi setelah kegiatan sehingga peserta tetap dapat pendampingan belajar dan meningkatkan kemampuannya. Menggunakan Excel untuk mengelola soal dan hasil evaluasi pembelajaran adalah cara yang efisien bagi guru untuk menyajikan hasil belajar untuk keperluan evaluasi hasil pembelajaran.
Co-Authors Aditya Dwi Putro Wicaksono Afni Arifatul Hidayah Agustin, Frencilia Paulina Al Khansa ALIFIA ZAHRA WINESTI Arnella Hayya Amalia Ovin Atika Ratna Dewi Bernadeta Chrisma Damai Saputri DESTY MAYANG PRATIWI Dian Kartika Sari, Dian Kartika Eva Purnama Sari Gita Amalia, Gita Handayani, Sri Sulistijowati Hartanto, Aqila Khansa Husna Afanyn Khoirunissa Irmayatul Hikmah Isnaini, Bayutama Kholidiyah Masykuroh Kiki Ferawati Kusuma, Dewa Adji Lathifah, Ekarini Neti Kurnia Sari Nirwana, Muhammad Bayu Nugroho, Elvin Agustiyan Nur Setyo Jatiningtyas pratiwi, hasih Puspita, Popy Laras Rahmawati, Aprilia Saniatul Respatiwulan, Respatiwulan Ria Novita Awalia Ramadhani Tantyoko, Henri Tegar Adji Syahputra Ulya, Fadilla Zundina Ummi Athiyah Wardati, Bilqies Syafina Widya Putri Haryati Yuliana Susanti, Yuliana