Google Sheets Research Articles

Analysis of ease and usefulness of using google sheets in accounting assignment with technology acceptance model approach

Abstrak: Pelaksanaan kegiatan pembelajaran akuntansi saat ini sudah mulai dilakukan dengan berbantuan aplikasi. Aplikasi yang digunakan sebaiknya adalah aplikasi yang dapat diterima oleh seluruh siswa karena hal tersebut akan memudahkan siswa dalam memahami materi pembelajaran. Penelitian deskriptif kuantitatif ini dilakukan dengan tujuan untuk mendeskripsikan tingkat penerimaan siswa terhadap penggunaan aplikasi Google Sheets dalam pembelajaran akuntansi. Sampel yang digunakan adalah sebanyak 143 siswa yang diambil menggunakan teknik sampel jenuh. Metode pengumpulan data adalah menggunakan angket, wawancara, serta dokumentasi yang kemudian dianalisis dengan teknik deskriptif persentase. Hasil penelitian menunjukkan bahwa siswa dapat menerima penggunaan aplikasi Google Sheets sebagai alat bantu mengerjakan tugas akuntansi karena aplikasi ini dinilai mudah dan bermanfaat untuk digunakan. Hal ini telah menyebabkan perolehan hasil belajar siswa menjadi maksimal. Dengan demikian, dapat disimpulkan bahwa penerimaan yang baik terhadap penggunaan suatu alat atau media pembelajaran akan memudahkan dalam pencapaian tujuan pembelajaran.Abstract: The implementation of accounting learning activities has now begun to be carried out with the help of applications. The application used should be an application that can be accepted by all students because this will make it easier for students to understand the learning material. This quantitative descriptive research was conducted with the aim of describing the level of student acceptance of the use of the Google Sheets application in accounting learning. The sample used was 143 students taken using the saturated sample technique. Data collection methods were by questionnaires, interviews, and documentation, which were then analyzed using percentage descriptive techniques. The results of the study show that students can accept the use of the Google Sheets application as a tool for doing accounting assignments because the application is considered easy and useful to use. This has led to the acquisition of student learning outcomes to be maximized. Thus, it can be concluded that good acceptance of the use of a learning tool or media will facilitate the achievement of learning objectives.

The use of Google Sheets for Specimen Tracking, Pathologists’ Requisitions, Quality Control and Data Retrieving for Statistics, Search and Research in Anatomical Pathology Laboratories in the Absence of Barcoding and/or Anatomical Pathology Laboratory Information System

Background: Many Anatomical Pathology laboratories do not have a barcoding system or an anatomical pathology laboratory information system that allow for better workflow by tracking of specimens and orders, quality control documentation, statistics calculation, search and data retrieval for research purposes. Aim: This paper will show how Google sheet can be used as an alternative using the checkboxes, the electronic edit history and other features. Materials and Methods: Google accounts were created then Google sheets were designed with specific details and the daily quality log was designed to show compliances to national and international standards. Results: Descriptive templates allowed for tracking of specimens and pathologists’ requisitions, quality control documentation, statistics calculation, search and data retrieval for research purposes. Conclusion: Google sheet can be used in the absence of barcoding systems or an anatomical pathology laboratory information system for tracking, documentation, search, research and monitoring of all activities by the supervisor as required by some accreditation body.

Development of an Integrated Safety Management System Application in the Workplace

Nowadays, the use of digital is important in meeting the technological needs of the industrial revolution 4.0. The manual HIRARC form is less effective and efficient in terms of filling time. Based on observations, the manual use of the safety log book requires the supervisor to update the content every time. This shows that, filling information physically causes the risk of losing data that has been entered is very high and affects the effectiveness of safety management in the workplace. Therefore, the first objective of this study is to build a security management application and the second objective is to identify the effectiveness of using the application. This application is developed by combining two software namely glides and google sheet. While the second objective instrument is in the form of a likert-scale questionnaire on the effectiveness of using the application to respondents who are workplace users, namely students and lecturers as well as the management of the Occupational Safety and Health Committee and workshop supervisors. The results of the study show that two applications have been built, namely the Integrated Safety Management Application managed by the department management and the Safety Logbook Application used by users at the workplace, ie in the workshop or laboratory where they are combined in an integrated network which is integration and PDCA. While the results of the questionnaire show that the overall mean score is at a high level where this application can facilitate accident complaints to make reports to superiors better by workplace users. In conclusion, this application is flexible and dynamic in use, easy to maintain and suitable for use by organizations or users of different workplaces.

Pengelolaan Invoice dalam Subdivisi Accounts Payables pada PT Vidio Dot Com

The MBKM Program aims to provide opportunities for Indonesian students to gain work experience from quality partners, and improve their competencies so they can compete in the world of work. This final report describes the writer’s experience while participating in an internship at PT Vidio Dot Com as accounts payable intern a subdivision on accounting division. In this MBKM activity the writer is assigned to assist operational activities in the finance and accounting division which will be explained more fully in this report, such as manage invoices, recording of asset number, data recapitulation, reconciliation of E-Commerce SVOD Revenue data, and making Accounts Payable Performance Report. Through this MBKM activity, the writer have the opportunity to improve their skills, for soft skills such as the ability to communicate across functions and organizational levels and presentation skills, for technical skills such as using Microsoft Excel in analyzing data, Google Workspaces (google slides, google sheets, and email), and Smartsheet.

Network Analysis Using the Established Database (K-herb Network) on Herbal Medicines Used in Clinical Research on Heart Failure

Objectives: Heart failure is a chronic disease with increasing prevalence rates despite advancements in medical technology. Korean medicine utilizes herbal prescriptions to treat heart failure, but little is known about the specific herbal medicines comprising the network of herbal prescriptions for heart failure. This study proposes a novel methodology that can efficiently develop prescriptions and facilitate experimental research on heart failure by utilizing existing databases.Methods: Herbal medicine prescriptions for heart failure were identified through a PubMed search and compiled into a Google Sheet database. NetMiner 4 was used for network analysis, and the individual networks were classified according to the herbal medicine classification system to identify trends. K-HERB NETWORK was utilized to derive related prescriptions.Results: Network analysis of heart failure prescriptions and herbal medicines using NetMiner 4 produced 16 individual networks. <i>Uhwangcheongsim-won</i> (牛黃淸心元), <i>Gamiondam-tang</i> (加味溫膽湯), <i>Bangpungtongseong-san</i> (防風通聖散), and <i>Bunsimgi-eum</i> (分心氣飮) were identified as prescriptions with high similarity in the entire network. A total of 16 individual networks utilized K-HERB NETWORK to present prescriptions that were most similar to existing prescriptions. The results provide 1) an indication of existing prescriptions with potential for use to treat heart failure and 2) a basis for developing new prescriptions for heart failure treatment.Conclusion: The proposed methodology presents an efficient approach to developing new heart failure prescriptions and facilitating experimental research. This study highlights the potential of network pharmacology methodology and its possible applications in other diseases. Further studies on network pharmacology methodology are recommended.

Pelatihan Laporan Keuangan dengan Google Spreadsheet dalam Rangka Meningkatkan Pengetahuan UMKM

This activity is motivated by technological developments that demand online activities, so micro, small and medium enterprises (MSMEs) must have a strategy for developing their business, especially starting to improve financial management to see the development and growth of their business in each period. The PKM team conducts training on making financial reports using Google Sheets which provides knowledge and understanding to MSMEs in the city of Padang, so they can manage finances properly. The method used in this training is the lecture method, in which material exposure and training methods are given, where participants are asked to practice preparing their business financial reports, as well as discussion methods, participants and resource persons discuss in solving the problems they face. The results of this activity 1) Participants can find out that their business is included in the small / micro / prevent category from the turnover they get; 2) Participants know that the complete financial statements can help analyze their financial performance, because so far they only record the results of their business with a list of money in and money out books only; 3) Participants gain new knowledge that input using the MS. Excel application can be displayed and controlled online through Google Sheets media, especially if not at the place of business. This activity can make a positive contribution to participants by 80% to their business development.

Dimensional Data Design for Event Feedback Data Warehouse

Data is an important asset and a fundamental requirement for building valuable information for organizations. Association of Information Systems Students of Unsika (Himsika) as a university organization provides many events to develop student’s academic and professional skills. A post-event evaluation through a feedback survey was conducted and stored in Google Sheets spreadsheet format. However, the current analysis process using spreadsheets lacks standardization, making it difficult to compare satisfaction rates over time and between events. Additionally, the lack of standardization leads to semi-structured data on spreadsheets, with varying question formats and meanings. To address these limitations, implementing a centralized data warehouse is proposed as a solution. The data warehouse would provide a structured and standardized approach to analyzing event feedback, enabling better comparisons and evaluation of management quality within Himsika. The research aims to design a data warehouse that supports multidimensional analysis. As a way to simplify and optimize analytical queries, the data structure is standardized in the data warehouse. The Four-step Dimensional Design method is applied in designing dimensional modeling on the data warehouse, consisting of four stages including selecting the business process, declaring the grain, identifying the dimensions, and identifying the facts. The design process resulted in 4 dimensions of events, dim_instances, dim_degree_programs, and dim_professions, and a fact table called fact_rates_by_responses. Overall, the proposed data warehouse and dimensional modeling approach aim to enhance the analysis and evaluation of Himsika’s events.

Lesbian and bisexual women's health beliefs about performing the Papanicolaou’s test

Objective: to identify the health beliefs of lesbian and bisexual women about performing the Papanicolaou’s test. Methods: cross-sectional study developed exclusively online, with fifty-five participants. Google Forms® were used for data collection, with sociodemographic and economic questions, as well as questions related to practices, intention, and beliefs about performing the Papanicolaou’s test. Data were organized in Google Sheets® and analyzed in SPSS® software. Results: it was found that bisexual women believe more in the benefit "when I do the preventive exam, I am relieved" (p=0.047). However, they have higher scores of ashamed for doing the preventive exam (p=0.005). Significant association was identified between having done the exam and perceived benefits (p=0.040); perceived severity and education level (p=0.006); having done the exam (p=0.039); and having fixed partnership (p=0.028). Conclusion: bisexual women believe that performing the exam generates relief, but feelings of shame may hinder adherence to the exam. Lesbian and bisexual women without access to higher education, who never had the exam, and who have multiple sexual partnerships are more vulnerable to cervical cancer. Contributions to practice: reflect on this scenario so that educational strategies are effective for cervical cancer prevention.

SISTEM INFORMASI ONLINE SHOP LABKARA BERBASIS WEB

The web-based online shop Labkara Information System is an application designed to make it easier for customers to place orders for goods and assist owners in recording and managing customer ordering data better. The process of ordering goods at the Labkara online shop still uses the manual method, namely, customers place orders for products by sending messages through social media applications, and managing order data is done by recording it via Google Sheets. This causes an inefficient ordering process at the Labkara online shop. The web-based online shop Labkara Information System has a feature to display product information, which includes names, photos, and prices. In making this application, the Waterfall System Development Life Cycle (SDLC) development methodology is used, which consists of analysis, design, implementation, testing, and maintenance. The database in this application is supported by the MySQL database that is in XAMPP. PHP and HTML are programming languages used to create programs, resulting in a website application that can assist assist Labkara online shop administrator in data processing and makes it easier for customers in placing product orders.

Opinion of first year medical students about their morning lecture pattern

Introduction: With the advent of the new curriculum of medical students (CBME), the role of teachers has now changed from being mere teachers to being considered as facilitators. Teachers are thus required to assist the students in their study. Hence, the student’s point of view of their education pattern has become all the moreimportant. This study was conducted to know the thoughts of first-year medical students about their morning lectures of different subjects. Materials and methods: Fifteen questions pertaining to morning teaching pattern of 1st year MBBS students were formed via Google Sheets. A response link was created and sent to medical students of three batches (1st, 2nd, and 3rd year), when the first yearstudents had completed three months of their course. Results: Approximately half of the students (51.5) favored morning lectures (8am-9am) and majority (76.8%) wanted the first lecture to be Anatomy. Half (50.7%) preferred PPT method while around 40% wanted it to be in chalk and board fashion. Most of the students (90%) wanted a mixed language pattern. More than half (56.6%) agreed for 45 minutes of each lecture duration. Most of the students (86.9%) wanted some gap between two consecutive lectures. Majority of the students (81.6%) did not think the backbenchers to be mischievous and 70% did not advocate for separate rows for girls and boys. Conclusions: Students had a view that Anatomy should be taught as first lecture in the morning and pattern should be mixed with modern audio-visual technologies. Keywords: Opinion, Medical students, Morning teaching, Lectures

Analysis of teachers in the use of digital resources in online teaching and assessment in COVID times

The study considered the use of online learning applications for instructional delivery and assessment purposes in higher institutions of learning that stimulates a new atmosphere where lecturers could utilize these facilities to promote learning. The study also determined the gender difference between lecturers use of online learning applications for instructional delivery and classroom assessment in a post-covid context. The digital applications analyzed in this study include Google classroom, Email, Moodle, Canvas, Google, Microsoft Team, Zoom, Google Meet, Cisco Webinar, Facebook groups, Open Educational Resources (OERs), Google docs, Google slide, WhatsApp and Telegram Channel. At present, however, opinions are divided over the extent to which lecturers utilize these online learning applications in instruction and assessment. A descriptive survey research design was adopted with 152 participants (n = 88 males and n = 64 females) for the study and the instrument used for data collection was Utilization of Online Leaning Applications in Classroom Instruction and Continuous Assessment Questionnaire (UOLACICAQ). On December 2021, the participants completed the Questionnaire. The internal consistency of the instrument was determined using Cronbach’s Alpha and the reliability index of .93 was obtained. Results of the study show a low extent of utilization of online learning applications in classroom instruction and continuous assessment (Canvas, Microsoft Team, Google Meet, Cisco Webinar, OERs, Google slide, Telegram Channel, Facebook groups, Moodle, Google Classroom, learning management systems, Google forms and Google sheet). There was however, a significant difference between male and female lecturers' use of online learning applications for continuous assessment. Lecturers’ utilization of online learning applications in instruction and assessment of learning will expose them to different online learning applications used in delivery instructions and assessing students’ learning. The research supplies good idea of the instrument for measuring those staked learning outcomes in higher institution. However, lecturers do not differ in terms of the extent to which they use online learning applications while delivering instructions in the classroom based on gender.

Design and fabrication of an IoT-based smart electrical meter for residential energy management

<p>Transparency in electricity measurement and efficient use of electricity are issues of concern to households. Electricity customers want to have confidence in their utility company's electricity meters installed at their houses. This study designs and constructs an internet of things (IoT)-based smart electric meter to measure electricity and remotely control domestic appliances. This device can monitor, calculate electricity bills and remotely control the appliances via the internet; electrical quantities are displayed in real-time on the Blynk app, liquid crystal display (LCD) screen and Google Sheet. The device is also capable of emailing the electricity user. The proposed system is designed and developed based on ESP32, a LCD, a PZEM 004T, four relays and a DC source. The results show that the device works stably and the device’s error is less than 5%. This research makes it possible for users to conveniently monitor their power consumption while enhancing their energy-saving awareness.</p>

The impact of supply chain drivers on the performance of Ministry of Health pharmacies in Jordan

For most companies, supply chains have become the most crucial factor in their competition rather than individual competition, enabling any company to gain a competitive advantage against another organization through efficient and effective supply chain management. Supply chain drivers have become one of the most critical potential valuable access to a competitive advantage by enhancing and improving organizational performance. This study aims to explore the impact of the drivers of the supply chain on the performance of pharmacies of the Ministry of Health in Jordan. The study used the descriptive analytical approach and simple random sampling. 300 electronic questionnaires were designed via Google Sheets and sent via email and social media to employees in the Jordanian Ministry of Health pharmacies. The study retrieved 252 questionnaires valid for analysis. SPSS was employed to analyze the data and test the hypotheses. The results showed that the Beta-value is 0.849, T-value is 25.370, at a significance value of 0.000, which means that supply chain drivers affected the Ministry of Health pharmacy’s performance. The estimated regression equation means that any one-unit increase in the level of supply chain drivers will lead to an increase in Ministry of Health pharmacies’ performance by 0.789. Furthermore, the performance of the supply chain drivers was moderate, and the general performance was high. The study recommended that pharmacies focus on employing software and modern technology in inventory control.

Teaching and Learning Eighth Grade Mathematics Integers Using Video Clips: An Action Research

This study investigated the effectiveness of video clips in enhancing the learning achievement of eighth-grade students in mathematics at Sonamthang Lower Secondary School. An experimental method using a pre-test and post-test was employed as the research design. The experimental group comprised 28 eighth-grade students. Data were analysed in two parts: test score analysis and students’ opinion analysis. Paired sample t-test and descriptive statistics were computed using Google Sheets Add-on XLMiner Analysis ToolPak to determine the differences in the pre-test and post-test scores. The results revealed that the pre-test mean was statistically insignificant, while the post-test mean showed a significant difference between the experimental and control group. Therefore, the study concludes that the use of video clips enhances students’ test scores and also increases their ability to solve higher-order thinking questions. Further, students’ opinion analysis indicated a preference for learning mathematics using video clips. As such, it was recommended that teachers use video clips as an instructional tool to enhance students’ academic achievement and foster motivation.

Revolutionizing language processing in libraries with SheetGPT: an integration of Google Sheet and ChatGPT plugin

PurposeThe purpose of this research paper is to explore the significance of language processing in library systems and evaluate the effectiveness of integrating artificial intelligence and generative pre-trained transformer (GPT) technology in modern libraries. Specifically, the paper focuses on SheetGPT, a Google Sheet and GPT Plugin and its impact on language processing in library systems.Design/methodology/approachThis paper adopts a comprehensive analysis approach to evaluate the integration of SheetGPT in library systems. The authors outlined a user-friendly approach for installation and use of SheetGPT using its “beginner plan”, appropriate for personal/student use or extended experimentation. The study includes a quantitative analysis to provide a thorough understanding of the benefits and limitations of SheetGPT in library systems.FindingsThe findings of this research paper suggest that SheetGPT is a highly effective language-processing tool for library systems. Additionally, ChatGPT’s integration with Google Sheets and easy accessibility over Google Marketplace makes it an efficient and user-friendly tool for library professionals. Overall, this study highlights the potential of SheetGPT to enhance language processing in library systemsOriginality/valueThis research paper contributes to the existing literature by providing a comprehensive analysis of the effectiveness of SheetGPT in library systems. The study’s approach is unique in that it evaluates SheetGPT’s impact on language processing and provides insights into its benefits and limitations. The study’s findings are original and provide a valuable resource for library professionals and researchers interested in exploring the potential of SheetGPT to enhance language processing in library systems.

Power Monitoring and control System Using IoT

Internet of things has been a great use in the modern world and the importance of IoT is increasing day by day. The wastage of energy is a very serious concern, and energy consumption of all our appliances are in huge level. So, proper usage of this resource is of immense important. And this increase in power requirement has pushed the researchers and industrialist to design low power systems with smart power management. In this paper, design of a smart system for energy conservation is proposed to reduce the energy consumption which is based on some distributed components like sensors, micro controller and google sheets. The smart power management system can monitor, measure and control electricity usage in real-time. With this proposed system, users can automatically and manually control the unwanted real-time electricity usage, which can also be viewed through graphical representation. Key words: - Sensors, IoT, Arduino IDE, ESP32, Google sheets, Power management system

Epidemiological profile of pesticide poisoning cases in the State of Sergipe, Brazil: a retrospective analysis from 2007 to 2021

We aimed to characterize the epidemiological profile of reported cases of pesticide poisoning in the state of Sergipe between 2007 and 2021. Secondary data were obtained from the National Database of Notifiable Diseases Information System (SINAN) and National Toxicological Information System (SINITOX), through the Department of Informatics of the Unified Health System (DATASUS) and analysis performed using the free tool Google Sheets. During the studied period, 960 cases of exogenous pesticide poisoning were registered in the state. The municipality of Aracaju had the highest percentage of the number of cases. The incidence prevailed in females, in the 20-39 age group, in the brown race and among those with incomplete primary education. The most used toxic agent was rodenticide, suicide attempt predominated as a circumstance of use. Most cases resulted from a single acute exposure, confirmed by the clinical-epidemiological method, and evolved to a cure without sequelae. This study traced the epidemiological profile of the State of Sergipe with regard to the intoxication of the population and, in addition, brought little explored data and information that directly impacts policies aimed at reducing morbidity and mortality resulting from the use of pesticides.

Design and Development a Smart Control System for Temperature and Turbidity of Bio Floc Fish Ponds

Bio floc aquaculture techniques are present as a solution to increase the productivity of fish farming. However, until now there are still problems, namely regarding the quality of the water from the pond. In this study, a monitoring tool was designed using an ESP32 microcontroller with the support of a BME280 sensor, RTD PT100 to measure water temperature and a turbidity sensor to measure floc volume. Furthermore, this sensor is planted on Wi-Fi to be able to connect to the internet network for IoT applications so that it can be monitored in real time. Likewise, the display results from the monitoring of the application system are directly read on the Google sheet display and in real time. From the test results of the system built, obtained the accuracy level of the BME280 sensor is 96.5%, PT100 RTD is 94.6% and for the turbidity sensor is 98%. Meanwhile the observed air temperature value can reach 34.36°C, the water temperature reaches 28.75°C, and the floc ratio reaches 30.15 mL.L-1. From the results shown, it clearly indicates that the water quality monitoring system has been successful and is working very well.

Predicting infection with COVID-19 disease using logistic regression model in Karak City, Jordan

Background: On March 2020, World Health Organization (WHO) labeled coronavirus disease 2019 (COVID-19) as a pandemic. COVID-19 has rapidly increased in Jordan which resulted in the announcement of the emergency state on March 19th, 2020. Despite the variety of research being reported, there is no agreement on the variables that predict COVID-19 infection. This study aimed to test the predictors that probably contributed to the infection with COVID-19 using a binary logistic regression model. Methods: Based on data collected by Google sheet of COVID-19 infected and non-infected persons in Karak city, analysis was applied to predict COVID-19 infection probability using a binary logistic regression model. Results: A total of 386 participants have completed the questionnaire including 323 women and 63 men. Among the participants 295 (76.4%) were aged less than or equal 45 years old, and 91 (23.6%) were aged over 45 years old. Among the 386 participants a total of 275 were infected with COVID-19. The LR chi-square test was used to analyze every demographic characteristic (sex, age, job, smoking, chronic disease, yearly flu injection) in this study to find predictors of the likelihood of COVID-19 infection. The findings indicate that the participants' sex and age are the most important demographic determinants of infection. Cox & Snell R Square (R2 = 0.028) and Nagelkerke R Square (R2 = 0.039) indicators was used to measure model fineness with significant P-value < 0.05. Conclusions: Given a person's age and sex, the final model presented in this study can be used to calculate the probability of infection with COVID-19 in Karak city. This could help aid health-care management and policymakers in properly planning and allocating health-care resources.

Pemanfaatan Google Spreadsheet Untuk Akuisisi Data Online Bagi Guru SMK di Banda Aceh

Data acquisition is the process of collecting data or information from various sources, including sensors, software, hardware, or humans, for use in analysis or decision-making. The purpose of data acquisition is to collect data that is accurate, reliable, and useful for further analysis or decision-making. In introducing the concept of data acquisition, acquisition introduction training was conducted for the teaching staff. Data acquisition training covers the process of transferring data from sensors to Google Sheets. For teaching staff at SMK Negeri 2 Banda Aceh, the use of Google Spreadsheets is still too common. Therefore, the community service team successfully carried out training activities on Wednesday, April 13, 2022. The training included an introduction to the ESP8266 microcontroller, then continued with the introduction of Google Spreadsheets, taught how to assemble hardware in the form of DHT11 sensors and ESP8266 microcontrollers, and carried out the process sending data as well as storing data on Google Sheets. This activity has a positive impact on improving the ability of teaching staff and indirectly can be applied in teaching materials or applied in everyday life.