# THE FORMATION OF THE COMPUTING COMPETENCIES OF FUTURE ECONOMISTS IN THE PROCESS OF USING THE LIBREOFFICE CALC PROGRAM

### Abstract

The paper deals with the formation of computational competencies of future economists in the process of using LibreOffice Calc on the example of solving a division problem in the form of a competency-based problem. A competency-based (complex, integrated) problem is defined as a necessary component of the content of the educational material. One of the hallmarks of the competency-based tasks is the requirement of being modeled in a quasi-real-life situation, quasi-professional situation. The division problem is chosen as the object of consideration as having the named features. The authors describe the corresponding mathematical model and the method of solving problems of this type. The choice of software is determined by the fact that LibreOffice is a multiplatform distributed under the GNU LGPL public license. Thus, LibreOffice can be freely installed and used within the budgetary and commercial organizations, as well as on the home computers and in the educational institutions. Users can download (download address https://libreoffice.su/download), install, use, and learn LibreOffice. Therefore, the use of LibreOffice gives you an opportunity of control and self-development of software solutions, the obtaining of the economic benefits from the introduction and use of the open-source software, as well as an opportunity to adapt more quickly to the conditions of practical activity. On the example of solving of a division problem with the help of LibreOffice Calc, the authors showed the formation of the students’ ability to solve a competency-based problem as the way of mastering the relevant competencies. The ability to apply mathematical methods to solve standard professional problems, to interpret the results obtained using mathematical and computer models, to work on a computer using the modern general and professional application software, providing the formation of professional computing skills become the foundation for the development of higher-level competencies.

### References

Mantusov A.B. Kompetentnostnaya zadacha kak realizatsiya kompetentnostnogo podkhoda [Competency-based task as the implementation of the competency-based approach], deponirovana. Zapis v reestre no. 20659 ot 23 maya 2013.

Novaya filosofskaya entsiklopediya [New philosophy encyclopedia]. Moscow, Mysl Publ., 2010. Vol. 2, 634 p.

Trusov P.V., ed. Vvedenie v matematicheskoe modelirovanie [Introduction to mathematic modeling]. Moscow, Logos Publ., 2007. 440 p.

Aleskerov F.T., Khabina E.L., Shvarts D.A. Binarnye otnosheniya, grafy i kollektivnye resheniya [Binary Relations, Graphs, and Collective Solutions]. Moscow, GU VShE Publ., 2006. 296 p.

Pripoten V.Yu., Ryabenko V.I., Shikov N.N. Impotrance of system for competitiveness management of goods. Sbornik nauchnykh trudov Donbasskogo gosudarstvennogo tekhnicheskogo universiteta, 2015, no. 2, pp. 191–196.

Muedinova A.S., Anafieva E.R. The computational model of formation of competences of junior pupils at the lessons of mathematics. Problemy sovremennogo pedagogicheskogo obrazovaniya, 2016, no. 51-4, pp. 281–289.

Poluektov A.V. The formation of informational and communicative competence of the students of the “Informatics” speciality. Informatsionno-kommunikatsionnye tekhnologii v pedagogicheskom obrazovanii, 2009, no. 3, pp. 8–11.

Glukhova T.V., Bazhanova S.V. ICT-competence in modern education. Integratsiya obrazovaniya, 2013, no. 2, pp. 130–135.

Petrenko M.V. The essence and the structure of the information completence of future specialist. Pedagogika i psikhologiya: teoriya i praktika, 2015, no. 2, pp. 17–23.

Petrichenko E.A. Information and philosophical categories “phenomenon and essence”. Sovremennye problemy nauki i obrazovaniya, 2014, no. 1, pp. 435–442.

Ushakov I.V. Programmno-tekhnicheskie, ekonomicheskie i zakonodatelnye aspekty ispolzovaniya svobodnogo programmnogo obespecheniya [Hardware and software, economic and legislative aspects of application of open-source software]. Tambov, ID Derzhavinskiy Publ., 2018. 123 p.

Reymond E. Magic cauldron. URL: bugtraq.ru/law/articles/cauldron/index.html.

Vanina M.F., Davydova E.V., Erokhin A.G., Frolova E.A. The issues and prospects of using the Russian and foreign open-source software within the educational process at the university. Metodicheskie voprosy prepodavaniya infokommunikatsiy v vysshey shkole, 2018, vol. 7, no. 1, pp. 7–11.

Mantusov A.B. The electronic resource “3D photo robot creation with the help of MAKEHUMAN software”. Khroniki obedinennogo fonda elektronnykh resursov nauka i obrazovanie, 2018, no. 7, pp. 29–30.

Popov A.S. Free mathematical packages within the educational process at the university. Nauka i obrazovanie: novoe vremya, 2014, no. 1, pp. 131–133.

Mantusov A.B. About the determining the number of experts on the basis of Condorcet paradox. Sci-article.ru, 2017, no. 45, pp. 101–108.

Vasilkov A. Ten best packages of office programs. Kopyuterra, 2018, no. 17. URL: computerra.ru/183811/10-best-office-suites/.

Brams S., Teylor A. Delim po spravedlivosti, ili garantiya vyigrysha kazhdomu [The Win-Win Solutions. Garanteeing Fair Shares to Everybody]. Moscow, SINTEG Publ., 2003. 196 p.

Shvarts D.A. Manipulation in the division problem for two players. Automation and Remote Control, 2011, vol. 72, no. 1, pp. 119–128.

Khakhaev I.A., Kuchinskiy V.F. Tekhnologii obrabotki tablichnoy informatsii v LibreOffice [The technology of processing of tabular information in LibreOffice]. Sankt Petersburg, Universitet ITMO Publ., 2016. 177 p.