Open AccessUse of popular electronic resources to improve the visibility of the course solving tasks in preparing students for USE in computer science
Author(s) -
O D Lyubutov,
O Yu Zaslavskaya
Publication year - 2020
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1691/1/012091
Subject(s) - computer science , visibility , task (project management) , process (computing) , resource (disambiguation) , certification , state (computer science) , visual basic , macro , quality (philosophy) , multimedia , software , programming language , computer network , physics , management , law , political science , optics , economics , philosophy , epistemology
Currently, the main way to check the quality of education in schools in the Russian Federation is the state final certification, conducted in the format of a unified state exam. The unified state exam in computer science includes 27 tasks of various levels of complexity. Analysis of statistics on the success of various tasks shows that students experience the greatest difficulties when solving task number 23. To increase the visibility of the process of solving this task, you can use the well-known electronic resource MS Excel, which is part of the Microsoft MSOffice package. This electronic resource has a built-in programming language Visual Basic for Application, with which you can significantly expand the functionality of MS Excel. Written in Visual Basic for Application, the macro allows the student not only to get the correct answer, but also to view the problem solution tree, compare it with their own solution, and identify errors in their solution if there is a discrepancy. This article is devoted to the methodology of using this electronic resource in the process of preparing students for the unified state exam in computer science.