Google Sheets Research Articles

Choice of data visualization tool: FRED or spreadsheets?

We study the impact that the choice of data visualization tool has on student ability to create a graph and interpret the information contained in it. We use a systematic random assignment approach and control for student demographic and academic characteristics. We compare the use of spreadsheets to the use of FRED (Federal Reserve Economic Data) among 471 undergraduate students of statistics for business and economics. We find that although there is no statistical difference between groups in the number of started assignments, the number of completed FRED assignments is significantly larger than the number of completed Google Sheets assignments. With that caveat, we find no association between the choice of data visualization tool and the proportion of correctly built graphs, average frustration, and perceived difficulty reported by students when building the graph. We document lower confidence in the task among female students and students who used FRED.

Learning Analytics on YouTube Educational Videos: Exploring Sentiment Analysis Methods and Topic Clustering

The popularity of social media is continuously growing, as it endeavors to bridge the gap in communication between individuals. YouTube, one of the most well-known social media platforms with millions of users, stands out due to its remarkable ability to facilitate communication through the exchange of video content. Despite its primary purpose being entertainment, YouTube also offers individuals the valuable opportunity to learn from its vast array of educational content. The primary objective of this study is to explore the sentiments of YouTube learners by analyzing their comments on educational YouTube videos. A total of 167,987 comments were extracted and processed from educational YouTube channels through the YouTube Data API and Google Sheets. Lexicon-based sentiment analysis was conducted using two different methods, VADER and TextBlob, with the aim of detecting the prevailing sentiment. The sentiment analysis results revealed that the dominant sentiment expressed in the comments was neutral, followed by positive sentiment, while negative sentiment was the least common. VADER and TextBlob algorithms produced comparable results. Nevertheless, TextBlob yielded higher scores in both positive and negative sentiments, whereas VADER detected a greater number of neutral statements. Furthermore, the Latent Dirichlet Allocation (LDA) topic clustering outcomes shed light on various video attributes that potentially influence viewers’ experiences. These attributes included animation, music, and the conveyed messages within the videos. These findings make a significant contribution to ongoing research efforts aimed at understanding the educational advantages of YouTube and discerning viewers’ preferences regarding video components and educational topics.

Development of an Order Processing System using Google Sheets and Appsheet for a Malaysian Automotive SME Factory Warehouse

The automotive industries in Malaysia have grown well and developed many suppliers in their supply chain including Small Medium Enterprise (SME). The order handling process at a supplier's factory has become one of the most critical areas in the supply chain. Adaptation to technology such as IoT enables the automotive supplier to better manage their customer orders and avoid mistakes that affect the supply chain. In order to improve the order processing activities, a study has focused on developing a mobile device application using Google Appsheet and Google Sheets as a cost-effective system for managing supply orders. A study was conducted in one of Malaysian SME automotive companies, which manages the orders manually by using a log book with a lot of recording and redundant work. By using Google Sheets, all the information and data involved in order processing activities is imported and digitized. Then, a mobile application is created using Appsheet so that the ordering activities and processing can be completed on a mobile device. All information gathered by the mobile app (Google Appsheet) is immediately saved in Google Sheets on an Excel-based database, allowing for further data analysis. The research conducted has managed to integrate these two applications into a system for Malaysia's SME factory to manage the ordering activities in the automotive supply chain. This system enables the user to shorten their order processing time since data is captured in real time and mistakes due to manual error can be avoided.

A Case Study of Tencent Music: Hows the Music Streaming Industry Faring Under Covid-19?

We identified five factors influencing the stock price of Tencent Music at various times in the paper. We used two mathematical techniques by collecting data on these five variables. By calculating the correlation coefficients, we were able to determine the influence of each variable on Tencent Music over different periods. Using the Linest equation in Google Sheets, we then developed a Linear regression model for Tencent Music. We used the regression model to calculate the slope, y-interpret, and predict the quarterly stock price to compare with the actual quarterly stock price. By analyzing Tencent Music's stock, we conclude the article with our perspective on the entire Chinese streaming media industry.

Examining the meaning and methodological characteristics of the systematized review label: A scoping review protocol.

A large portion of published evidence syntheses (ES) do not conform to established standards. There is a growing number of reviews labeled as a "systematized review", but authors do not always identify specific methodological adaptations or specify the biases these may introduce. The objective of this scoping review is to identify which methodological attributes common to evidence syntheses (ES) are implemented or referenced in published systematized reviews. It also aims to 1) identify and collate, where available, the reasons authors characterize their study as a systematized review 2) determine whether any justifications provided were based on resource constraints or research goals, and 3) describe common characteristics of systematized reviews. All articles that are titled as a systematized review, attempt a collocation and synthesis of existing literature, and include some methodology for their review process, will be included. A title search will be conducted for the terms "systematized" or "systematised" in proximity to the term "review" in a selection of scholarly sources that offer broad coverage of literature in many disciplines: Google Scholar, Lens, Web of Science Core Collection (Web of Science platform), Scopus (Elsevier platform), MEDLINE (Ovid platform). Screening and data extraction will be done in duplicate. Screening will be conducted in Covidence. Data extraction will be done in Google sheets. Data extraction elements will include common methodological characteristics relating to various steps of the evidence synthesis process. Descriptive, aggregate statistics, and categorization of reasons for selecting the systematized review type are the primary planned analysis for this review. This is a registered report protocol. The data collected in this research project will be made available in the Borealis repository (https://borealisdata.ca/) upon finalization of the study.

ASSISTANCE IN MAKING DIGITAL FINANCIAL REPORTS AT UD. BEHIND THE NAME

Financial reports are very important for the running of a company. Quality financial reports must be relevant and reliable. In this digital era, financial reports can be easily applied to software that is easily accessible to the general public, such as Google Sheets. UD. Behind The Name is a garment company engaged in the production of clothing so far still uses bookkeeping for financial reports. The application of digital financial reports will make it easier for users, and report readers and will also make it easier to calculate, as well as record. Improperness in writing financial statements can cause errors in the submission of reports that can cause losses due to miscalculations, or unreadable writing. Therefore, digital financial reports are very important, especially in an era that makes it easier for us to use technology. This is the background for the author to carry out service activities in the context of Field Work Practices by assisting the finance staff in making financial reports using Google Sheets.

FACTORS ASSOCIATED WITH DEPRESSION, ANXIETY, AND STRESS AMONG FOOD INDUSTRY WORKERS: A SYSTEMATIC REVIEW

In 2021, food industry workers represented approximately one-tenth of the total labour force in Malaysia. There was an estimated 15% of working-age adults who experienced a mental disorder worldwide in 2019. To make the situation worse, service workers in food retail and food services face tremendous stress and mental health consequences during the COVID-19 pandemic. Various study found that worsening mental health and psychological distress have been accelerated substantially by the pandemic. An unsafe or unhealthy working environment can undermine mental health, as poor mental health can interfere with a person’s ability to work if left unsupported. This systematic review aimed to evaluate findings related to factors associated with depression, anxiety, and stress among food industry workers. Articles related to these factors were collected electronically from two different databases (EBSCOHOST and Scopus). An independent reviewers screened the titles and abstracts of the collected articles from each database, and then stored them in Google Sheet based on the inclusion and exclusion criteria. Next, the included articles were critically appraised to assess the quality of the studies using the Mixed Methods Appraisal Tool (MMAT). Out of the 292 articles identified, four were included in the final review. Sociodemographic characteristics, as well as biological, psychological, and occupational factors were found to be associated with common mental issues among food industry workers. By identifying the risk factors, specific interventions can be implemented by the employers and other relevant parties to prevent, promote, protect, and support the mental health well-being of food industry workers. These findings may be utilised to improve the implementation of key interventions directed to prevent, promote, protect, and support the mental health of food industry workers. Consequently, an enabling environment can be created to address mental health at work, as outlined by the World Health Organization (WHO). Employers may adapt or revamp their work environment to minimise exposure to psychological risks among their workers, which could prevent workers from experiencing adverse mental health conditions. Workers should also be equipped with awareness and skills, as well as opportunities to recognise and act early on mental health issues in order to promote and protect their mental health. Moreover, workers with pre-existing or ongoing mental health conditions should receive support to access job opportunities, or continue working, and thrive at work, since good mental health status at work can improve an individual’s performance and productivity.

Seamless Data Capture: A QR Scanner with Google Sheets Integration

This study presents the development and evaluation of a user-friendly QR Scanner mobile app with seamless Google Sheets integration. The motivation behind the research was to address the limitations of conventional QR scanner apps, which often lack direct integration with data management platforms like Google Sheets. The app development process employed a hybrid methodology, combining prototyping and agile approaches, resulting in an intuitive and well-designed solution. The app allows users to effortlessly scan QR codes and automatically sync the captured data to Google Sheets in real-time, providing immediate access and analysis. Evaluation using the System Usability Scale (SUS) yielded a satisfactory level of usability, with users finding the app easy to use

Visualizing Google Sheets Data in Web Applications with Laravel

The study presents the design implementation of visualizing Google Sheets data in web applications using the Rapid Application Development (RAD) approach. It focuses on integrating Google Sheets data seamlessly into a web application using the Laravel PHP framework and employs effective data visualization techniques. Real-time data access is achieved through the integration of Google Sheets API, while the Google Maps API and High charts Library enabled interactive and informative data visualizations. The result is a user-friendly web application, empowering users to explore data insights and make well-informed decisions with ease

The Characteristics of Eye Diseases at Merpati Eye Clinic Dr Kariadi Hospital Semarang in 2020-2022

Background: The COVID -19 pandemic that has occurred since 2020 has changed and affected all aspects of life. In health services, the pandemic has limited patients from coming to health facilities. Recording of ophthalmology cases in health facilities has an important role in providing information about eye health problems that often occur in the community to identify what are the main challenges faced in the field of eye care.Objective: This study aims to identify the characteristics of eye diseases at the Merpati Eye Polyclinic Dr Kariadi Hospital Semarang in 2020-2022.Methods: This study was a retrospective descriptive study. The clinical characteristic data (gender, age, diagnosis, and Clinic) are retrieved from the medical records of patients suffering from eye diseases who underwent treatment at the Merpati Eye Clinic, Dr. Kariadi Hospital Semarang and was diagnosed in 2020-2022. The data obtained were processed and analyzed using the google sheets program.Results: There were 2961 newly diagnosed patients with the 10 most diagnosed diseases are Refractive disorders (12,87%), Cataracts (11,21%), Glaucoma (10,40%), Diabetic Retinopathy (6,75%), Pseudophakia (5,30%), Papile Atrophy (5,10%), Retinal Vein Occlusion (4,22%), Corneal Ulcer (3,92%), Retinal Detachment (3,71%) and Uveitis (3,51%). Based on age category, the most patients were 51-60 years old (22,29%). Based on gender category, female gender (50,35%) is more than male (49,65%).Conclusion: Of all patients, the 10 most diagnosed diseases were Refractive Disorders, Cataracts, Glaucoma, Diabetic Retinopathy, Pseudophakia, Papillary Atrophy, Retinal Vein Occlusion, Corneal Ulcers, Retinal detachment and Uveitis.

Pembuatan Purwarupa Alat Ukur Konsentrasi CO2 Berbasis NodeMCU ESP8266

Carbon dioxide (CO2) is the largest contributor to greenhouse gas emissions, resulting in an increase in global temperatures. Unfortunately, this knowledge is not yet widely known among the general public. Therefore, providing information on daily CO2 levels can serve as a means to educate and raise awareness about the dangers associated with CO2 levels. To simplify access to CO2 concentration information, a prototype of a CO2 concentration measurement device based on the NodeMCU ESP8266 microcontroller, which can be connected to Wi-Fi, has been developed. To ensure data accuracy, the CO2 measurement device was calibrated using the NodeMCU ESP8266 microcontroller and data from an outdoor CO2 monitoring instrument at the BRIN (BPAA Pontianak) office, with an error value of 4.08%. The collected data from this device can be accessed through the Blynk application or a Google Sheets link. The test results demonstrate that the device can provide CO2 concentration levels with higher readings in areas characterized by high vehicle traffic, smoking, combustion activities, or a crowd of people.

Volunteers as a resource for asset mapping and maintaining a living resource directory: lessons from an academic-community partnership.

Health and social services are fundamental to public and population health, and disruptions can have devastating effects on individuals of all ages. During the first wave of the COVID-19 pandemic, the availability of health and social services rapidly changed. Existing resources experienced changes in operation and mode of service delivery, while new resources emerged to address escalating needs. Both the general public and service providers lacked access to accurate information on availability and access, and existing service directories became obsolete or unreliable. To address this gap, a committee of university students expanded its volunteer base, partnered with a local non-profit organization, and invested in maintaining a centralized, up-to-date resource directory for the region. Student volunteers sourced and consolidated existing county-level directories to curate more than 370 resources across 12 healthcare and social care domains in a Google Sheets platform. This directory was publicly accessible, available in English and Spanish, adjustable to community feedback and needs, disseminated through the local health system intranet, synthesized into paper handouts for food pantries, and utilized to curate a directory aimed toward older adult needs. Students worked in a tiered leadership model and mobilized quickly to respond to immediate community needs. This academic-community partnership engaging student volunteers can be a low-cost, high-value resource to support public health systems meet the information needs of their community, particularly during periods of crisis or rapid changes in service availability.

Investigating Key Determinants of Childhood Diarrheal Incidence among Patients at Hoima Regional Referral Hospital, Western Uganda

This study aimed to analyze the determinants impacting diarrhea incidence among children under five at Hoima Regional Referral Hospital, Western Uganda. Through a cross-sectional investigation, quantitative data was collected via self-administered and investigator-led questionnaires utilizing digital tools such as Google Sheets for both online and offline data collection. From a randomized sample of 323 caregivers selected through convenience sampling, a diarrhea prevalence of 27.3% among children under five was observed at the time of data collection as reported by caregivers. Among the children studied, 136 (43.7%) were male, and 175 (56.3%) were female. The average age of the participants was 2 years with a standard deviation of 1.25 years. The analysis revealed higher rates of diarrhea among children aged 1 and 3 years, constituting 24 (28%) cases in each group, followed by 20 cases (24%) in the 2-year-old group. Additionally, 12 (14%) cases were reported in children aged 6- 11 months, while only 5 (6%) cases were found in 4-year-olds out of the total 85 reported cases of diarrhea. Regarding breastfeeding practices, 11 (3.7%) children were breastfed 1-3 times a day, 77 (26.1%) were breastfed 3-5 times, 150 (50.8%) were breastfed 5-7 times, 34 (11.5%) were breastfed 7-9 times, and 23 (7.8%) were breastfed more than 9 times a day. The introduction of supplementary food varied with 25 (8.0%) initiated at 3-4 months, 80 (25.7%) at 5-6 months, and the majority, 181 (58.2%), introduced to supplementary food after 6 months. The study highlighted maternal occupation influencing weaning practices; 152 (48.9%) of mothers who weaned their children at 2 years were self-employed, followed by 56 (18.0%) engaged in casual labor and 36 (11.6%) in civil service. Merely 6 (1.9%) civil servant mothers, 47 (15.1%) self-employed, and 14 (4.5%) casual laborers practiced weaning at three years of age. The elevated prevalence of diarrhea (27.3%) was associated with factors such as health-seeking behavior, early introduction of supplementary foods, premature weaning, and breastfeeding frequency. Notably, exclusive breastfeeding practices were scarce, with mothers introducing other foods early and weaning their children prematurely. Keywords: Diarrhoea, Children under five, Breastfeeding, Weaning, Supplementary foods.

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.