Keyword: «spreadsheets»

The main objective of the electronic distance learning course (ECDI) is the organization of the educational process, which provides effective learning in a distance learning environment. The specificity of this type of training is that it is mainly based on self-study. That is, it is necessary to organize training in such a way that students can independently (and most importantly - want) to learn. This condition is basic, since unlike traditional education, where a teacher can interest students with his story, or force him to do something, it is much more difficult to do it in distance learning. According to the requirements of the GEF, it is the formation of students' desire to learn, is the main task of modern education. Therefore, the implementation of effective distance learning is one of the possibilities to realize this task. The basic means of distance learning are information and communication technologies (ICT). Learning with their help is called electronic learning. The absence of such interactivity eliminates the importance of using these technologies. In this regard, interactivity in distance learning is one of the essential requirements that can improve not only the effectiveness of training, but also the motivation to learn.

The article is about the use of Python libraries for processing spreadsheets and creating a user interface for automating the creation of a progress report. Using this method instead of writing macros allows you to simplify data processing and make creating a report independent of the type of installed office software package.

Work programs in mathematics and natural science disciplines at all levels of education from basic general to higher use such sections of algebra as the study of functions, solving equations, solving inequalities, solving systems of equations and inequalities, plotting and analyzing graphs. At the same time, the potential of a tabular processor is being studied within the framework of the subject "Computer Science". However, the requirements and recommendations of the federal state educational standards do not integrate spreadsheets and classroom math classes. The aim of this study is to develop a methodological approach to using the LibreOffice Calc spreadsheet software to solve algebraic problems that require calculating the value of a function and providing its graphical interpretation. Publications by domestic and foreign authors devoted to modern trends in mathematical education and the development of the field of using spreadsheets were studied in the course of the work. Based on textbooks and work programs in algebra, a selection of lesson topics was made from thematic plans, which the author suggests conducting not only in the form of a traditional lesson, but also with the use of a computer. Such lessons can be combined into a computer math workshop. The article provides examples of performing exercises using LibreOffice Calc tools on the following topics: "Calculating function values by formula", "Graph of a function", "Algebraic and graphical methods for solving systems of equations" and "Simplest trigonometric equations". The pedagogical experiment was conducted on the basis of the Moscow Academy of Jazz, where two groups of students were tested: the first group studied without using spreadsheets, the second group with their use. A comparative analysis of the obtained performance indicators demonstrates a significant increase in the second group compared to the first. The theoretical significance of the research is as follows: the elements of thematic planning of work programs are identified, where it is possible to increase the degree of clarity of the learning process; a way is shown to strengthen the interdisciplinary links between mathematics and computer science through a tabular processor. The practical significance of the study is determined by the fact that the approach proposed by the author can be used in the development of new algebra classes at a higher level of digitalization.