Practice of Visual Solution of Boundary Value Problems by Running VBA in Microsoft Excel
Main Article Content
Abstract
The article discusses the construction of a visual solution of boundary value problems for a linear differential equation of the second order by the tridiagonal sweep method in VBA in Excel. Creating macros in VBA allows you to visualize solutions to such boundary value problems.
Article Details
References
2. Гарнаев А.Ю., Рудикова Л.В. Microsoft Office Excel 2010: разработка приложений. СПб.: БХВ-Петербург, 2011. 528 с.
3. Ларсен Рональд. Инженерные расчеты в Excel. М.: Изд-во «Вильямс», 2004. 544 с.
4. Марчук Г.И. Сопряженные уравнения и анализ сложных систем. М.: Наука. Гл. ред. физ.-мат. лит., 1992. 336 с.
5. Гайнанова Р.Ш., Широкова О.А. Программирование на Visual Basic for Applications в Excel: учебное пособие. Казань: КФУ, 2012. 153 с.
6. Широкова О.А. Особенности обучения программированию на основе общности и различия принципов // Современные проблемы науки и образования. 2015. № 1. С. 1757. URL: http://www.science-education.ru/121-17896
7. Широкова О.А. Объектно-ориентированные проекты решения математических задач // Материалы XI Международной науч.-практ. конф. «Объектные системы – 2015» (Ростов-на-Дону, 10–12 декабря 2015 г.) / Под общ. ред. П.П. Олейника. Ростов-на-Дону: ШИ (ф) ЮРГПУ (НПИ) им. М.И. Платова, 2015. С. 15–22.
8. Широкова О.А. Объектно-oриентированные проекты с созданием классов для математических объектов // Электронные библиотеки. Тематический выпуск «Математическое образование в школе и вузе». 2020. Т. 23, № 1-2. С. 216–223.
9. Shirokova O.A. Methods of demolition of the boundary conditions by perturbation methods for solving filtration problems with free boundaries // IOP Conference Series: Materials Science and Engineering, 2019.
10. Gainutdinova T.Yu., Denisova M.Yu., Riazanova L.V., Shakirova Z.F., Shirokova O.A. Modelling mathematical structures and object-oriented programming // DILEMAS CONTEMPORANEOS-EDUCACION POLITICA Y VALORES. 2019. Vol. 6. Art. No. 12.
11. Gainutdinova T.Y., Denisova M.Y., Shirokova O.A. The use of digital and information technologies in order to increase the effectiveness of mathematical education // Talent Development and Excellence. 2020. Vol. 12. P. 188–198.
12. Denisova M., Gainutdinova T., Shirokova O. Multimedia technologies as a means of introducing game elements in the process of teaching mathematics, EDULEARN19 Proceedings. 2019. P. 1189–1194.
13. Shirokova O., Gainutdinova T., Denisova M. Interdisciplinary integration as a condition for the modernization of teacher education, EDULEARN19 Proceedings. 2019. P. 1183–1188.
Presenting an article for publication in the Russian Digital Libraries Journal (RDLJ), the authors automatically give consent to grant a limited license to use the materials of the Kazan (Volga) Federal University (KFU) (of course, only if the article is accepted for publication). This means that KFU has the right to publish an article in the next issue of the journal (on the website or in printed form), as well as to reprint this article in the archives of RDLJ CDs or to include in a particular information system or database, produced by KFU.
All copyrighted materials are placed in RDLJ with the consent of the authors. In the event that any of the authors have objected to its publication of materials on this site, the material can be removed, subject to notification to the Editor in writing.
Documents published in RDLJ are protected by copyright and all rights are reserved by the authors. Authors independently monitor compliance with their rights to reproduce or translate their papers published in the journal. If the material is published in RDLJ, reprinted with permission by another publisher or translated into another language, a reference to the original publication.
By submitting an article for publication in RDLJ, authors should take into account that the publication on the Internet, on the one hand, provide unique opportunities for access to their content, but on the other hand, are a new form of information exchange in the global information society where authors and publishers is not always provided with protection against unauthorized copying or other use of materials protected by copyright.
RDLJ is copyrighted. When using materials from the log must indicate the URL: index.phtml page = elbib / rus / journal?. Any change, addition or editing of the author's text are not allowed. Copying individual fragments of articles from the journal is allowed for distribute, remix, adapt, and build upon article, even commercially, as long as they credit that article for the original creation.
Request for the right to reproduce or use any of the materials published in RDLJ should be addressed to the Editor-in-Chief A.M. Elizarov at the following address: amelizarov@gmail.com.
The publishers of RDLJ is not responsible for the view, set out in the published opinion articles.
We suggest the authors of articles downloaded from this page, sign it and send it to the journal publisher's address by e-mail scan copyright agreements on the transfer of non-exclusive rights to use the work.