Preview

Informatics in school

Advanced search

NUMERICAL SOLUTION OF NONLINEAR EQUATIONS IN ELECTRONIC TABLES AND VISUAL BASIC FOR APPLICATIONS

https://doi.org/10.32517/2221-1993-2020-19-6-51-57

Abstract

The article discusses some methods for numerically finding the roots of nonlinear equations, which are determined by numerical methods using the construction of a spreadsheet Microsoft Excel and an application in the Visual Basic for Applications environment. The simplest methods are used: the binary division method and the chord method. The article presents the construction of spreadsheets, the algorithm, the method of creation the VBA application, and the text of the corresponding procedures. The material of the article can be used in informatics courses, both at school and at university, for the development of interdisciplinary connections between informatics and mathematics and expanding ideas about the possibilities of spreadsheets. The problems presented in the article were successfully solved by 10th grade students (profile "Mathematics. Informatics") and first-year students of pedagogical university of the profiles "Physics. Mathematics", "Physics. Informatics". The article reflects the author's personal experience of teaching the course "Informatics" at South Ural State University of Humanities and Education and at school.

About the Author

A. l. Korolev
South Ural State University of Humanities and Education
Russian Federation
Chelyabinsk


References

1. Зенков А. В. Численные методы: учебное пособие. Екатеринбург: Изд-во Урал. ун-та, 2016. 124 с.

2. Калинин И. А., Самылкина Н. Н. Информатика. 10 класс. Углубленный уровень: учебник. М.: БИНОМ. Лаборатория знаний, 2019. 256 с.

3. Лапчик М. П., Рагулина М. И., Хеннер Е. К. Численные методы: учебное пособие. М.: Академия, 2004. 384 с.

4. Поляков К. Ю., Еремин Е. А. Информатика. 10 класс. Базовый и углубленный уровни: учебник. В 2 ч. Ч. 2. М.: БИНОМ. Лаборатория знаний, 2016. 352 с.

5. Сайт Константина Полякова. http://kpolyakov.spb.ru/school/ppt.htm

6. Сайт MathCAD. https://www.mathcad.com/ru

7. Сайт MathWorks. https://www.mathworks.com

8. Справочник по VBA для Office. https://docs.microsoft.com/ru-ru/office/vba/api/overview/

9. Угринович Н. Д. Информатика и информационные технологии: учебник для 10–11 классов. М.: БИНОМ. Лаборатория знаний, 2003. 512 с.

10. Хемминг Р. В. Численные методы для научных работников и инженеров. М.: Наука. Главная редакция физико-математической литературы, 1972. 400 с.


Review

For citations:


Korolev A.l. NUMERICAL SOLUTION OF NONLINEAR EQUATIONS IN ELECTRONIC TABLES AND VISUAL BASIC FOR APPLICATIONS. Informatics in school. 2020;(6):51-57. (In Russ.) https://doi.org/10.32517/2221-1993-2020-19-6-51-57

Views: 324


Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.


ISSN 2221-1993 (Print)