Journal archive

Abstract: This article shows the potential of Excel table editor as a medium for creation the interactive teaching tasks used for training. An idea on such teaching tasks as reconstruction the stanza model of A. Pushkin’s novel «Eugene Onegin» is realized in this article, and the accessibility of such digital resources constructing for philology teachers, not being professional programmers, is demonstrated. A scenery of the program was suggested by Yu. Shatin in his article published in 1987. The students must reconstruct the first strophe of the first chapter as a most known one, and then they compose a stanza formula which becomes a basis for reconstruction the other stanzas taken from the middle of the novel and not so well-known. In this variant of the program realized in Excel the students are to put lines given in disorder, using letter indexes with which the lines are marked. As a column is filled with lines the program signalizes the errors of lines’ order. After correction the errors, program will print the message «Lines are composed correctly!» To make stanza formula, the stanza is divided into four parts containing 4–4–4–2 lines, in correspondence with rhyming. Students elect a rhyming model for every fragment and correctly elected models become parts of stanza formula. After successful perfection this task, the program prints: «Formula is correct» and offers to begin next task. Process of solving these ones does not technically differ with reconstruction first stanza but from the position of intrinsic labor being made by students, it is a competition and cocreation with the great Russian poet.This program may be used in teaching process with a group of students or as an individual training dependently on teacher’s intention.