Automation of the Workplace of a University Teacher
Abstract
Purpose of research. The information age imposes special requirements on the design and structuring of information in the economy, law and education. This article discusses the possibilities of reducing routine work associated with error-free documentation in the conditions of processing large amounts of information in the educational field. Routine work takes up a lot of time in the work of university teachers and is more tedious than creative work. In addition to errors related to the human factor, in the process of education reform, the forms of documents often change and large volumes of text have to be redone.
Methods. Document management systems do not justify themselves due to the high price, complexity, and require configuration, maintenance, and training of personnel. Therefore, it is preferable to work with well-known software, such as MS Offise (any modification). With the help of a macro, a program is created that, based on the data provided in the EXCEL file, generates exam tickets according to a given template in Word. At the same time, you can flexibly change the number of questions in the tickets, the number of issues in the ticket, and the number of tickets themselves.
Results. The program of questions and tasks allows you to repeatedly reduce the time of creating tickets for exams, does not require training and configuration, and also eliminates errors due to high accuracy of work.
Conclusion. A specialized program for creating exam tickets for disciplines is considered.
About the Authors
L. A. Lisitsin
Southwest State University
Russian Federation
Russian Federation
Leonid A. Lisitsin, Cand. of Sci. (Engineering), Associate Professor of the Department Information Systems and Technologies
50 Let Oktyabrya str. 94, Kursk 305040
A. L. Lisitsin
Kursk State University
Russian Federation
Russian Federation
Alexander L. Lisitsin, Assistant of the Department of Information Security
33 Radischeva str., Kursk 305000
Y. А. Khalin
Southwest State University
Russian Federation
Russian Federation
Khalin Yuri А., Cand. of Sci. (Engineering), Associate Professor of the Department of Software Engineering
50 Let Oktyabrya str. 94, Kursk 305040
References
1. O problemakh sovremennogo obrazovaniya [About the problems of modern education]. Available at: https://trizway.com/art/form/problemy-sovremennogo-obrazovaniya.html. (accessed 11.02.2020)
2. Avtomatizatsiya zadach s pomoshch'yu sredstva zapisi makrosov - Excel [Automation of tasks using the macro recording tool - Excel]. Available at: https://support.microsoft.com/ru-m/office/%D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%B0%D1%82%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F-%D0%B7%D0%B0%D0%B4%D0%B0%D1%87-%D1%81-%D0%BF%D0%BE%D0%BC%D0%BE%D1%89%D1%8C%D1%8E-%D1%81%D1%80%D0%B5%D0%B4%D1%81%D1%82%D0%B2%D0%B0%D0%B7%D0%B0%D0%BF%D0%B8%D1%81%D0%B8-%D0%BC%D0%B0%D0%BA%D1%80%D0%BE%D1%81%D0%BE%D0%B2-%E2%80%94-excel-974ef220-f716-4e01-b015-3ea70e64937b. (accessed 11.02.2021)
3. Bolshakova E. I., Vorontsov K. V., Efremova N. E., Klyshinsky E. S., Lukashevich N. V., Sapin A. S. Avtomaticheskaya obrabotka tekstov na estestvennom yazyke i analiz dannykh [Automatic natural language text processing and data analysis]. Moscow, Publishing House of the Higher School of Economics, 2017. 269 p
4. Karpenko O. M., Fokina V. N., Shirokova M. E., Degtyareva O. A. Robotizatsiya kak obrazovatel'nyi trend [Robotization as an educational trend]. Distantsionnoe i virtual'noe obuchenie = Distance and Virtual Learning, 2017, no. 5 (119), pp. 24-32.
5. Ispol'zovanie shablona [Using the template]. Available at: https://ru.wikipedia.org/wiki/%D0%92%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%A8%D0%B0%D0%B1%D0%BB%D0%BE%D0%BD%D1%8B. (accessed 11.02.2021)
6. Free Excel Pro Templates. Available at: https://exceldatapro.com/templates/educational/. (accessed 11.02.2021)
7. Qasimov H. A. O. Application of rnd function in the process of question choice in electronic exams. European Science Review, 2017, no. 3-4, pp. 94-97.
8. Lapenok M. V., Lozinskaya A. M., Shestakova L. G., Voronina L. V., Zuev P. V., Patrusheva O. M. The methodology of development of electronic educational resources for learning of general Scientific disciplines in non-native language. Smart Innovation, Systems and Technologies, 2019, vol. 144, pp. 127-137.
9. Lapko A. N., Kutsakin M. A., Klochkov O. I., Nozdrachev P. V., Semenov D. V. Avtomatizirovannaya sistema komplektovaniya ekzamenatsionnykh bile-tov (ticketgen) [Automated system for completing exam tickets (ticketgen)]. Patent RF, no. 2019611753, 2019.
10. Shmalts T. A. [Creating a program for generating tickets for the exam]. Problemy sovremennykh integratsionnykh protsessov i poisk innovatsionnykh reshe-nii: sbornik statei Mezhdunarodnoi nauchno-prakticheskoi konferentsii [Problems of modern integration processes and the search for innovative solutions. Collection of articles of the International Scientific and Practical Conference]. Ufa, 2020, pp. 93-99. (In Russ.)
11. Starostina A. K. Avtomatizatsiya protsessa sozdaniya ekzamenatsionnykh biletov [Automation of the process of creating exam tickets]. Nauchno-prakticheskie issledovaniya = Scientific and Practical Research, 2017, no. 8 (8), pp. 143-145.
12. Khasukhadzhiev A. S. A., Akhmadova L. L., Bikaev I. M., Khalieva H. S. Avtoma- tizirovannoe rabochee mesto prepodavatelya kafedry vuza [Automated workplace of a teacher of the university department]. Patent RF, no. 2016610660, 2016.
13. Glazov A. B., Gaidarzhi G. Kh. On the functions of the specialized program Teacher's Calendar. Pedagogical Informatics, 2011, no. 3, pp. 58-65.
14. GOST 19.701-90 (ISO 5807-85). Edinaya sistema programmnoi dokumenta-tsii [State Standard 19.701-90 (ISO 5807-85). Unified system of program documentation]. Available at: https://docs.cntd.ru>document/8041994. (accessed 11.02.2021)
15. Zarezina A. S., Lappa A. V. [Experience of using the electronic exam for the course "probability theory" for physicists]. Sovremennye obrazovatel'nye tekh-nologii kak sredstvo razvitiya nauchno-pedagogicheskogo potentsiala: sbornik [Modern educational technologies as a means of developing scientific and pedagogical potential. Collector]. Chelyabinsk, Printing Yard Publ., 2018, pp. 73-76. (In Russ.)
16. Kak napisat' makros v Excel [How to write a macro in Excel]. Available at: https://exceltable.com/vba-macros/kak-napisat-makros. (accessed 11.02.2021)
17. Tkachenko V. Ya. Osobennosti komp'yuternogo testirovaniya i praktika primeneniya [Features of computer testing and application practice]. Sistemnyi analiz v nauke i obrazovanii = System Analysis in Science and Education, 2018, no. 4, pp. 101-107.
18. Artamoshina M. N. Promezhutochnaya attestatsiya uchashchikhsya s ispol'zova- niem informatsionnykh tekhnologii [Intermediate certification of students using information technologies]. Professional'noe obrazovanie = Professional Education, 2007, no. 1, pp. 15-16.
19. Gusarova N. F. Strukturirovanie uchebnoi informatsii pri ee komp'yuternom pred- stavlenii [Structuring of educational information in its computer representation]. Telekommunikatsii i informatizatsiya obrazovaniya = Telecommunications and Informatization of Education, 2002, no. 2, p. 4.
20. Abakumov E. M., e. a. Avtomatizirovannaya sistema podgotovki dannykh [Automated data preparation system]. Patent RF, no. 2016615723, 2016.
Review
For citations:
Lisitsin L.A., Lisitsin A.L., Khalin Y.А. Automation of the Workplace of a University Teacher. Proceedings of the Southwest State University. Series: IT Management, Computer Science, Computer Engineering. Medical Equipment Engineering. 2021;11(2):97-107. (In Russ.)
Views:
171
Email this article 