CONSTRUCTION OF A BIOKINEMATIC SCHEME OF PHYSICAL EXERCISE USING MICROSOFT EXCEL

Abstract

A biokinetic scheme of physical exercise is a basic tool of biomechanics that allows you to visually display the spatial-temporal organisation of human movements, determine the position of the body, the trajectories of its segments, the angles in the joints, and the sequence of phases of the exercise. Traditional methods of constructing such schemes are based on the use of specialized software or manual graphic constructions, which provide high accuracy but require significant time and special training [2-6]. This limits their widespread use in the educational process and practical activities of trainers and researchers. There is a pressing need to find universal and accessible computer tools that allow the process of constructing biokinematic schemes to be automated, ensure their clarity and accuracy, and make them suitable for use in distance learning and rapid movement analysis.

The purpose of the article is to propose an algorithm for creating a template for constructing a biokinematic scheme of a physical exercise for students studying the discipline of biomechanics of motor activity, researchers and trainers, using the capabilities of Microsoft Excel 2019 software. The methodology is based on the analysis of educational and methodological sources and software capabilities, the integration of biomechanical methods with mathematical approaches, and the use of computer technologies and modelling.

Scientific novelty. Based on the functionality of Microsoft Excel 2019, a template has been developed that allows you to fully automate the construction of a biokinetic scheme without using additional graphic editors. The advantage of the proposed tool is the ability to continuously reproduce all the biolines of the athlete's body, automatically determine the midpoints of the shoulder and hip girdles, check the correctness of the entered data and quickly correct it. This increases the accuracy and reduces the time required to build the scheme, as well as makes the process accessible to students and researchers.

Conclusions. The template for constructing a biokinematic scheme of a physical exercise presented in the article makes it possible to quickly and objectively analyse the athlete's movements. It allows students to reduce the time spent on practical work, improve the quality and accuracy of technique analysis, and develop skills in working with modern computer technologies. The widespread use of Microsoft Excel in this process opens up prospects for applying the method in distance learning, scientific research, and the practical activities of coaches and specialists in physical culture and sports.