Google Sheets Research Articles

The Physics Laboratory Works – Individualized Computer Simulations

The physics laboratory-works creating and operating computer simulations experience is described. A significant amount of laboratory works can be classified as a “black box”. The studied physical phenomenon is hidden from direct observation, the control is carried out by means of electrical measuring devices. It is difficult to distinguish physical reality from its imitation when performing such work, so the virtualization of this one does not require realistic images. The schematic representation of the laboratory installation greatly simplifies the process of creating a simulator. A unique set of installation parameters is formed for each student performing laboratory work on the simulator, which contributes to the independence of the student's work. These parameters are stored in Google Sheets. Their transfer to the laboratory work’s html-template is carried out in encrypted form through the Google Apps Script service. Virtual laboratory work is implemented as a cross-platform web application.

Онлайн-сервіси і програмне забезпечення для обробки даних педагогічних і соціальних досліджень

In the presented article, an attempt was made to present a conditional set of services and programs that allow the collection, systematization, statistical processing of data and presentation of results, including visualization (graphs, tables of results, charts, etc.). It is noted that the main trend in the development of modern services is their complexity. As a rule, several operations can be performed using one service (data collection, their primary mathematical processing, visualization, etc.). Therefore, all classifications of such services are rather conditional. A review of certain online services and software packages for capturing, processing and storing data from pedagogical and social research was carried out: Google Sheets, Google Forms, Microsoft Office Excel, STATISTICA, SPSS, online calculators, etc. The advantages and disadvantages of using these services are outlined. It is noted that the use of ICT in pedagogical and social research improves their quality and compliance with modern requirements for the processing of experimental data.

Deliberate practice of spreadsheet skills when using copiable, randomized, and auto-graded questions within an interactive textbook

Spreadsheets are a core computational tool for practicing engineers and engineering students. While Microsoft Excel, Google Sheets, and other spreadsheet tools have some differences, numerous formulas, functions, and other tasks are common across versions and platforms. Building upon learning science frameworks showing that interactive activities are advantageous, an interactive textbook from zyBooks was created to […]

A Qualitative Analysis of Local Health Departments' Experiences With Contact-Tracing Tools in Response to COVID-19.

A Qualitative Analysis of Local Health Departments' Experiences With Contact-Tracing Tools in Response to COVID-19.

Orthodontics on sale: fixed appliances on E-commerce platforms

Abstract Introduction The sale of orthodontic materials, considered as medical devices, is regulated in order to protect patients. The availability of orthodontic products on e-commerce platforms, however, may go unregulated and compromise patient safety. Objective The present study aimed to investigate the sale of fixed orthodontic appliances on a local and global e-commerce platform. Materials and Methods A cross-sectional analysis of orthodontic materials sold on Shopee and Amazon was conducted using a specific keyword search for brackets, arch wires and ligatures. After deleting duplicates and irrelevant search results, the top 50 products for each keyword search were analysed. Product name, the type of product, seller, cost, star rating, the number of reviews, the number of sales, shipping location and brand identification were recorded. Brand registration with a medical device regulatory authority was checked. Collected data were tabulated in Google (spread)sheet to derive descriptive statistics and frequency tables. Results A total of 800 search results were screened. Three hundred and forty-eight relevant results were identified, approximately two-thirds of which originated from Shopee. Ligatures generated the highest search outcome in both Shopee (39%) and Amazon (80%). Fixed orthodontic materials sold on Shopee resulted in a larger number of reviews, higher star ratings and a lower cost per item compared to those supplied by Amazon. Products on Amazon were more likely to have brand identification (97%) compared to Shopee (5%). None of the identifiable brands on Shopee were registered with regulatory bodies, whereas eight products listed on Amazon were registered. A large portion of shipping locations originated from China for both e-commerce platforms. Conclusions Orthodontic brackets, arch wires and ligatures are more readily available on Shopee compared to Amazon. The quality and safety of these products cannot be assured as the majority of the products were either not clearly labelled or their registration was not identified under the regulation of medical devices.

The dermatological presentation of COVID-19 among GCC population: a perception study

Background: Coronavirus disease-2019 (COVID-19) is an RNA SARS virus that has become an emerging global threat. Since its initial appearance within December 2019, many issues related to the topic have been investigated. It proved to affect many-body systems. However, dermatological complication still pauses an enigma as a clinical presentation for this disease. COVID-19 dermatological manifestations could be helpful to early indicators of detecting the disease. The present study was aimed at assessing the dermatological presentation of COVID-19 among Gulf Cooperation Council (GCC) population Methods: An anonymous questionnaire-based study was performed; the questionnaire was distributed through an online google sheet and was carried out in Saudi Arabia, Bahrain, United Arab Emirates, Oman, and Qatar (GCC countries). Results: One thousand and eight hundred forty-eight participants responded to the study. The majority of the participants were females 1,246 (67.3%), in contrast to males 602 (32.7%), with a ratio of ≈2:1. Saudi nationals constitute more than half of the respondents 942 (50.9%), followed by other GCC nationals 906 (49.1%). The majority of the volunteers were highly educated. Most of the participants, 1,412 (76.3%), believed that COVID- 19 to be a life-threatening condition. Conclusion: Our study confirms the results of several local studies that the general awareness toward the newly emerging virus (COVID-19) is sufficient among the populations of GCC countries. However, the perception and awareness about the cutaneous and dermatological presentations of COVID-19 still pause an obstacle for most of the representative sample. Therefore, further studies are required to investigate the actual deficient in the educational programs provided by the GCC ministries of health.

Cholera outbreak in Kamarhati municipality of West Bengal: Secondary data analysis of a rapid epidemic response

Introduction: In September, 2021, an outbreak of acute diarrhoeal disease affected different wards of Kamarhati municipality of West Bengal. An epidemic investigation was conducted with the objective of identifying the time, place and person distribution of the epidemic. Methods: In this institution based cross-sectional study, an epidemic response team of College of Medicine and Sagore Dutta Hospital (CoMSDH) visited the patients admitted in the infectious diseases ward of the institute and enquired them using a pre-designed proforma. Stools samples were collected and sent for analysis to National Institute of Cholera and Enteric Diseases (NICED), West Bengal. The team also visited the affected wards and collected water samples for laboratory investigations. Collected data were collated in Google sheets and requisite analyses were done in Google sheet, online spreadsheet software. Spatial distributions of cases were shown using QGIS v2.38.Results: 208 patients admitted in infectious diseases ward of CoMSDH, Kamarhati, Kolkata in between 2nd - 13th September, 2021 were interviewed. The epidemic curve showed a rapid rise on 07th September, 2021 (57 cases) followed by a gradual fall over next 5 days. Majority of cases were clustered in Ward 1,2 and 3 of Kamarhati municipality. The attack rate was highest among the geriatric age group (≥60 years) followed by 19-60 years age group. Abdominal Pain (35.71%) and vomiting (28.57%) were commonly associated symptoms. Majority of the respondents (172, 87.76%) used intermittent tap water supply from local municipalities, followed by purchased mineral water (20, 10.20%) and water from Tala tank (4, 2.04%) for their drinking purpose. Stool and water samples revealed the presence of Vibrio Cholerae, O139 ogawa serotype. Conclusion:On the basis of the interim analysis, health education was initiated on the domestic treatment of water by boiling or using chlorine solution. Additionally, steps were taken for water treatment at the water treatment plants. This assisted in controlling the outbreak.

The summary lesson on the theme "number systems" in the web quest format

The theme "Number systems" is one of the basic in the school informatics course. The material of this theme is present in the tasks of the Main State Examination and the Unified State Examination, therefore it is very important to timely and efficiently consolidate the basic algorithms to convert numbers from one number system to another. The article provides a variant of such a summary lesson on the theme "Number systems" for the 8th grade in the format of web quest. The quest was developed in the Thinglink environment and contains several locations, each of which is associated with the convertion of numbers between different number systems. The tools for solving the quest tasks are Google Sheets and the LearningApps service, in which the author of the article has developed his own educational resources, as well as the Geogebra environment for performing constructions in one of the tasks. The presented quest can also be carried out in a computer-less form

Attitude and Views towards Mental Health among Dental Students

Introduction: Stress can be a feeling of emotional or physical tension. It can come from any event or thought that can make us feel frustrated, angry, or nervous. Stress is your body's reaction to a challenge or demands.
 Aim: The aim of the study is to assess attitude and views towards mental health and psychiatry among dental students.
 Materials and Methods: Study Setting is prospective observational study.The advantages of this study was economical, easy to create, wide reach, and gathering larger data Quick Interpretation . It was approved by the scientific review Board Saveetha Dental college Chennai .Number of participants involved in this study are 138 college students .The responses from the google sheet were transferred into excel. Inferential statistics was done using Chi square test and exported to SPSS software, version 25
 Results: From the survey conducted among dental students on mental health and psychiatry.Majority of dental students were female participants compared male participants.Interpretation was based on a p value less than 0.05, which was considered to be statistically significant.
 Conclusion: The findings of the present study proves that the majority of dental students have awareness of attitudes and views of mental health .Among dental students, females are the major participants compared to males. In order to develop psychiatric and mental health services, public acceptance is necessary.

Prevalence of Fatigability in Undergraduate Dental Students: A Survey

Introduction: High levels of stress and fatigue are associated with decreased academic success, well-being, and quality of life. The objective of this research was to quantify levels of perceived stress and fatigue among dental students to identify sources of and student coping mechanisms for perceived stress and fatigue and to identify the relationship between students' perceived stress and fatigue.
 Materials and Methods: A total of 102 responses were tabulated and analyzed using statistical analysis. This study was conducted to acknowledge the effect of stress and fatigability and the different ways it affects the health of dental students. The obtained data was collected and tabulated in Google sheets, analyzed statistically with descriptive statistics using SPSS software version 23.
 Results: Respondents have faced a feeling of fatigue in their working environment and some have experienced visual fatigue due to excessive screen time.
 Conclusion: The survey concludes that respondents have moderate awareness about the prevalence of fatigability in dental students.

Translating TDWG Controlled Vocabularies

Users may be more likely to understand and utilize standards if they are able to read labels and definitions of terms in their own languages. Increasing standards usage in non-English speaking parts of the world will be important for making biodiversity data from across the globe more uniformly available. For these reasons, it is important for Biodiversity Information Standards (TDWG) to make its standards widely available in as many languages as possible. Currently, TDWG has six ratified controlled vocabularies*1, 2, 3, 4, 5, 6 that were originally available only in English. As an outcome of this workshop, we have made term labels and definitions in those vocabularies available in the languages of translators who participated in its sessions. In the introduction, we reviewed the concept of vocabularies, explained the distinction between term labels and controlled value strings, and described how multilingual labels and definitions fit into the standards development process. The introduction was followed by working sessions in which individual translators or small groups working in a single language filled out Google Sheets with their translations. The resulting translations were compiled along with attribution information for the translators and made freely available in JavaScript Object Notation (JSON) and comma separated values (CSV) formats.*7

Comparison of spreadsheet-based optimization tools applied to construction site layout problem

This paper compares different spreadsheet-based optimization tools applied to a practical example of a construction site layout problem. The objective of the optimization is to minimize the total time of material transportation by optimal positioning of tower crane and work facilities on the construction site with repetitive operations. Computer programs, such as MS Excel, LibreOffice Calc, and Google Sheets can be applied as modeling tools for a variety of construction optimization problems in addition to their usual functionalities. In this study, LibreOffice Calc Solver, MS Excel Solver, along with other MS Excel add-ins, i.e., OpenSolver, Evolver, and What’sBest, are analyzed. The capabilities of optimization tools mentioned above are examined on the problem of optimal positioning of tower crane and work facilities on the construction site. The results obtained by optimization tools are noted and discussed. The paper ends with conclusions and recommendations for further research.

Diet and Health Implications of Night Shift Nursing

The nursing profession is heavily saturated with long hours and night shifts. Oftentimes new nurses spend months to years working on the night shift which influences biological processes such as the circadian rhythm. Their eating habits, digestion, sleep, and metabolism are all affected. Using the platform Google Forms, night shift nurses from the past and those currently working the night shift were questioned on their night shift experience, focusing on their diet and dietary habits. After the data collection was analyzed in Google Sheets, I drew conclusions and found trends among the participants. There were forty participants due to method limitations, but the participants showed many negative implications of being a night worker. In order to evaluate multiple perspectives from the participants, there were two groups of participants. The first consisted of nurses currently working the night shift, and the second group had nurses that have worked the night shift in the past but no longer do. Current night shift nurses were negatively impacted the most, but to my surprise, there were still dietary implications for those who do not work the night shift currently. For the most part, both groups of participants’ diets and overall health had declined; something needs to be done to help those helping us.

Creating Single-Subject Research Design Graphs with Google Applications.

The visual analysis of graphically displayed data is an essential skill for behavior analysts across a range of settings. Although there are several computer-based applications that facilitate the production of simple, consistent, and visually coherent graphs, these applications have several limitations, including cost. An alternative to using these applications is using free and widely available Google Sheets and Google Slides to produce high-quality clinical and research graphs. We provide a step-by-step pictorially supported task analysis for a system for creating graphs for a variety of single-subject research designs and clinical applications using Sheets and Slides. We also discuss the advantages and limitations of using Google applications to create graphs for use in the practice of applied behavior analysis.

Status of self-esteem in medical students at a college in Kathmandu: A descriptive cross-sectional study

Background: Self-esteem is vital to living a happy, confident and content life. Medical students experience various forms of stress due to academic, financial and social pressures which could affect their levels of self-esteem. This study aims to study the status of self-esteem among undergraduates of a medical college at Tribhuvan University, Nepal. Methods: After receiving the ethical approval from the Institutional Review Committee (IRC) of NAIHS; we conducted a descriptive cross-sectional study among the first- to fifth-year medical students from December 2020 to April 2021. 190 were selected for the study using a stratified random sampling technique. This study used the Rosenberg self-esteem scale to measure self–esteem of the participants. A Google Forms questionnaire was sent to the participants via email. Then, the data obtained were entered in the Google sheet and later analyzed using SPSS 27. A Chi-square test was used to identify potential differences in self-esteem scores among different variables. A p-value of < 0.05 was considered statistically significant. Results: This study included a total of 180 participants, among which, 18.9% (13.19% to 24.61%; at 95% CI) students showed low self -esteem. 74.4% (68.02% to 80.78%; at 95% CI) students had normal self-esteem and 6.7% (3.05% to 10.35%; at 95% CI) students had high self-esteem. The mean self-esteem score was 19.19 (15.01 to 23.37; at 95% CI). Female participants suffered more than males from low self-esteem, and third-year students had the highest percentage of low self-esteem (30.77%). Conclusion: The majority (74.4%) of medical students had normal self-esteem. However, 18.9% students had low self-esteem, among which, third-year students suffered the most (30.77%). Likewise, females exhibited higher prevalence of low self-esteem compared to males. Interventions to boost the level of self-esteem should be carried out to help medical students become confident and efficient doctors.

Willingness of Nepalese medical and nursing students to volunteer during COVID-19 pandemic: A single-centered cross-sectional study

BackgroundMedical students, being more familiar with medical situations, can play a vital role as volunteers during medical crises like mass casualty emergencies and epidemics. This study was conducted to know the willingness of medical and nursing students to volunteer during the coronavirus disease-19 (COVID-19) pandemic. Materials and methodsThis cross-sectional study was conducted among undergraduate medical and nursing students of a medical college in Kathmandu. A proportionate stratified random sampling technique was used. A pretested, self-administered questionnaire was emailed to participants and the data were collected from 8th July to July 29, 2021 via the Google forms, extracted to the Google sheets, and then analyzed using Statistical Package for Social Sciences (SPSS) version 16. ResultsOut of 288 randomly selected participants, a total of 261 valid responses were obtained, giving a response rate of 90.6%. The majority (n = 203, 77.8%) of the participants were willing to volunteer. The most preferred area of work during volunteering was clinical care of the COVID-19 patients (n = 74, 36.5%), followed by involvement in health education and awareness-raising activities (n = 63, 31%). Among those not willing to volunteer (n = 58, 22.2%), the most commonly reported reason was the lack of adequate training and skills (n = 23, 40%). ConclusionSince the majority of medical and nursing students were willing to volunteer during the times of COVID-19, they can be of great help as a human resource in case of shortage of healthcare professionals. As lack of training and adequate skills was the main reason for those not willing to volunteer, we recommend the provision of adequate training and skills before deploying students as volunteers during health crises like COVID-19.

How To Moderate a Hosted Collection: 2nd, Complete Your Google Sheets File &amp; Follow Each Author

How To Moderate a Hosted Collection: 2nd, Complete Your Google Sheets File &amp; Follow Each Author

Internet-based temperature monitoring system for hydroponic

This study presents a monitoring system to provide real-time measurement data of hydroponic that is accessible from anywhere through internet. Temperatures of nutrient solution and ambient air are of concern in the monitoring system. The system is developed through the following steps: design, implementation, and experimental test. The system is built by applying a NodeMCU ESP-12 as the microcontroller and two temperature sensors DS18B20 The NodeMCU ESP-12 is to collect measurement data of both temperature sensors and send the data to a cloud server through a WiFi internet communication. The Google Sheets is applied as the cloud server to store the measurement data and provide the data to users. Using the Google Sheets, the data is presented in a table as in the Microsoft Excel which is very convenience for processing and analyzing the data. Experimental test results show that the system is able to provide real-time and reliable data of the hydroponics temperatures that can be accessed from anywhere through the internet. The monitoring system has a delay about 3 to 6 seconds in presenting the measurement data. This delay is quite small compare to the temperature change period and therefore is negligible. Moreover, the monitoring system is built at cost USD 6.0 which is quite cheap.

Developing Empathy with STEAM Learning in Grade VIII SMP Lazuardi Al-Falah Depok

Empathy (Burns and Lesseig, 2017) is a skill that is rarely discussed in planning mathematics lessons. The objective of this research is to initiate and explore how mathematics learning can develop empathy skills to students using STEAM based project. This research use qualitative method, in which the observation was executed when students were developing until launching the application prototype to a limited audience. The application created with Google Sheets was called Your Energy Counter, intended to count the energy gathered from the food consumed by the user. This research revealed how empathy was formed during the project execution and how students are able to reflect on themselves being empathetic to others during mathematics lessons.

Status of self-esteem in medical students of a college in Kathmandu: A descriptive cross sectional study

Background:Self-esteem is vital to livingahappy, confident and content life. Medical students experience various forms of stress due to academic, financial and social pressureswhich could affect their levelsof self-esteem. This study aims to study the status of self-esteem among undergraduates of a medical collegeatTribhuvan University, Nepal. Methods:After receiving the ethical approval from the Institutional Review Committee (IRC) of NAIHS; we conductedadescriptivecross-sectionalstudy among the first-to fifth-year medical students from December 2020 to April 2021. 190 were selected for the study usingastratified random sampling technique. This study used the Rosenbergself-esteem scale to measure self-esteem of the participants.AGoogle Formsquestionnairewas sentto the participants via email. Then, the data obtained were entered in the Google sheet and later analyzed using SPSS 27.AChi-square test was used toidentify potentialdifferences in self-esteem scoresamong different variables. A p-value of < 0.05 was considered statistically significant. Results:This study included a total of 180 participants, among which, 18.9% (13.19% to 24.61%; at 95% CI) students showed low self -esteem. 74.4% (68.02% to 80.78%; at 95% CI) students had normal self-esteem and 6.7% (3.05% to 10.35%; at 95% CI) students had high self-esteem. The mean self-esteem score was 19.19 (15.01 to 23.37; at 95% CI). Female participants suffered more than malesfrom low self-esteem, and third-year students had the highest percentage of low self-esteem (30.77%). Conclusion:The majority (74.4%) of medical students had normal self-esteem. However, 18.9% students had low self-esteem, among which, third-year students suffered the most (30.77%). Likewise,females exhibited higher prevalence of low self-esteem compared to males. Interventions to boost the level of self-esteem should be carried out to helpmedical studentsbecome confident and efficient doctors.