USING GOOGLE SHEETS FOR PROCESSING AND ANALYZING EXPERIMENTAL DATA

Abstract

The article highlights the relevance of the introduction of cloud technologies in the modern educational space, with a special emphasis on their role in the professional training of future specialists in the field of physical culture and sports. It is emphasized that the intensive development of information technology necessitates the modernization of higher education, which involves the use of the latest digital tools for effective learning and assessment. This modernization involves the active introduction of innovative digital tools that can optimize learning processes, objective assessment of knowledge, and the formation of key professional competencies. A comparative analysis of the capabilities of Microsoft Excel and Google Sheets spreadsheets as tools for processing statistical data is carried out. The specific advantages of Excel are considered, in particular, its tools for performing complex analytical tasks, efficient work with large amounts of information, and ample opportunities for automating routine operations using macros. Attention is focused on the advantages of Google Sheets, including the convenience of organizing real-time collaboration on projects, seamless integration with other Google Workspace services, and an intuitive interface for basic statistical analysis. The methodological aspects of teaching the discipline «Computer processing of experimental research data» at the Kharkiv State Academy of Physical Culture are also discussed. Particular emphasis is placed on the practical application of Google Sheets as an effective tool for processing and visualizing data from sports and pedagogical research. Specific examples of the use of tables for processing anthropometric measurements of students, automated calculation of important indices of physical development (such as the Pinier index and the physique strength index), with the subsequent automatic assignment of qualitative grades based on conditional formatting functions are given. Additional Google Sheets tools are described in detail: working with column statistics, lists of values to optimize data entry, pivot tables, and the function of detailing aggregate results.