PhD, Associate Professor Abrashina I.V.
Pushkin Leningrad State University, St. Petersburg

Abrashin D.G.
The Bonch-Bruevich Saint Petersburg State University of Telecommunications, St. Petersburg

Objective of the study is to create, develop and implement a computer model for calculating and analyzing competition results with the function of converting primary data into a point system using Microsoft Excel software.
Methods and structure of the study. The study was conducted at the Faculty of Physical Education of Leningrad State University named after A.S. Pushkin. The technical conditions for the developed program included: the ability to simultaneously record results in nine disciplines; automatic conversion of time and quantity indicators into points and calculation of the average value with rounding to an integer; taking into account the gender and age of participants in calculations; preventing accidental changes to the original data in the "Standards" section; providing the user with the ability to enter only general information about the participants and the actual competition results.
Results and conclusions. The results of the work demonstrate that the proposed method for processing competition results in Microsoft Excel makes it possible to register them for several types at once, taking into account gender and age characteristics; automatically converts results from time and number categories into points and calculates the arithmetic mean, rounding to an integer; prevents accidental changes to the original data; can be adapted for various sports due to the ease of changing the information on the "Standards" sheet. The product was successfully tested from 2021 to 2024 at the A.S. Pushkin Leningrad State University during entrance exams in the subject of "Physical Education" with the registration of results in nine types.

Keywords: information systems, software product, software, Microsoft Excel, physical education, sports, competitions.

References

1. Abrashina, I. V., & Sofoshin, D. S. (2024). Informacionnye texnologii v fizicheskoj kulture i sporte [Information technologies in physical education and sports]. In Physical education and sports in the post­industrial era: Problems and solutions: Proceedings of the All­Russian Scientific­Practical Conference (pp. 5­7). Leningrad State University named after A.S. Pushkin.
2. Lukyanov, A. B., Lukyanov, B. G., Stepanov, V. S., et al. (2022). Avtomatizirovannaya informacionnaya sistema dlya provedeniya sudejstva sorevnovanij v silovyh vidakh sporta [Automated information system for judging competitions in strength sports]. In Actual problems of physical education, sports and tourism: Proceedings of the XVI International Scientific­Practical Conference (pp. 393-­398). Ufa State Aviation Technical University.
3. Ryabchuk, V. V., & Poddubnaya, T. V. (2024). Sudejstvo sorevnovanij po armejskomu rukopashnomu boyu s ispolzovaniem sovremennyh tekhnologij [Judging competitions in army hand­to­hand combat using modern technologies]. Scientific Notes of P.F. Lesgaft University, 7(233), 170-­173.
4. Ryazanov, V. N., & Zvezdov, A. D. (2019). Evolyuciya programmnogo obespecheniya pri provedenii sorevnovanij po pauerliftingu [Evolution of software for powerlifting competitions]. In Life safety, physical education and sports: Current state and prospects: Collection of scientific works (pp. 93-­98). Pacific State University.
5. Savkina, N. V., & Savkin, A. N. (2014). K probleme programmnogo obespecheniya pri provedenii vstupitelnyh ispytanij po discipline «Fizicheskaya kultura» [On the problem of software for conducting entrance examinations in the discipline "Physical Education"]. Bulletin of Tula State University. Physical Education. Sport, 3, 27-­31.
6. Savkina, N. V. (2015). K probleme programmnogo obespecheniya sudejstva i uskorennogo formirovaniya itogovyh rezultatov sorevnovanij po plavaniyu [On the problem of software for judging and accelerated formation of final results of swimming competitions]. In Features of the formation of a healthy lifestyle: Factors and conditions: Proceedings of the III International Scientific and Practical Conference (pp. 257-­259). East Siberian State University of Technology and Management.
7. Shirobokova, S. N. (2023). O razrabotke informacionnoj sistemy obrabotki rezultatov sportivnyh sorevnovanij na platforme «1S: Predpriyatie» [On the development of an information system for processing the results of sports competitions on the 1C: Enterprise platform]. Engineering Bulletin of the Don, 9(105), 59-­65.
8. Shirobokova, S. N., & Gafarov, V. V. (2024). Ob integracii Telegram­bota v informacionnuyu sistemu obrabotki rezultatov sportivnyh sorevnovanij [On the integration of a Telegram bot into the information system for processing the results of sports competitions]. Engineering Bulletin of the Don, 6(114), 329­-337.