Developing Distance Learning Monitoring Dashboard with Google Sheet: An Approach for Flexible and Low-Price Solution in Pandemic Era

Abstract

The Covid-19 pandemic has prompted many colleges and students to conduct distance learning (PJJ), unprepared. Thus, it is necessary to carry out continuous evaluation and improvement in a faster period, monthly or weekly. Therefore, an approach is needed to help the campus stay on track, and still maintain the quality of learning. It is performance monitoring. However, building a monitoring dashboard requires many resources. This study proposes a design solution using Google Sheet, which is flexible, easy to custom, and does not require extensive resources in terms of human resources and costs. The dashboard must provide information that can guide the campus to optimize the distance learning process. Therefore, this study adopts Objective Key Results (OKR), a performance measurement concept using a clear and transparent set of goals, future-oriented, but still realistic. The research consisted of five steps: determining the research scope, OKR analysis, determining the type and mechanism of data input, designing a dashboard, and evaluation. The analyzed OKR consists of 4 objectives and 27 key results (KR). Those KRs are then shown in a monitoring dashboard design based on Google sheet, consisting weekly, semester, and student dashboard. The results of this design will then be used as a monitoring guide for the implementation of distance learning at STT Terpadu Nurul Fikri in the following semester.

Response of learning analytics to the online education challenges during pandemic: Opportunities and key examples in higher education

“…During COVID-19 pandemic, empirical studies have shown that poor quality Internet access and less digital literacy skills were associated with lower use of the Internet for educational purposes (Van Deursen, 2020). Similarly, in the current review, we reported students' digital inequalities to properly access learning content and lack of digital skills to utilize online environments as two important challenges (e.g., Günther, 2021;Rahmah et al, 2020).…”

“…For instructors, this may be due to the decreased chance/opportunity for real time monitoring of learners. Similar to students, higher education instructors were not ready for online learning; therefore, we found that instructors were far from delivering best quality online lecture pedagogically and technically (e.g., Rahmah et al, 2020).…”

Covid-19 Variants of Concerns Tracking: How We Eased Out the Whole Process Through Open-Source Software in Madhya Pradesh, India

“…Hence, an open-source software -Google Sheets was utilized. Google Sheets is an opensource cloud-based online application that allows working with other people in unison [14,15]. The application helps in creating and formatting spreadsheet documents in cloud space using the internet [16,17].…”

Sistem Monitoring Stok dan Penjualan Minuman pada Vending Machine berbasis Internet of Things (IoT) Menggunakan Google Sheets dan Kodular

“…Sistem monitoring berbasis Google Sheets telah dilakukan pada berbagai jenis perangkat IoT [15], [16], [17]. Dengan menggunakan media Google Sheets, monitoring akan lebih mudah dan dapat dipahami secara umum karena dapat diatur seperti menggunakan program Microsoft Excel yang didalamnya sudah memiliki sistem komputasi dasar yang cukup familiar [18], [19], [20].…”