POSSIBILITIES OF USING MICROSOFT EXCEL FOR DEVELOPMENT OF SOFTWARE TOOLS FOR SOLVING DYNAMIC PROGRAMMING PROBLEMS

Keywords: e-learning resources, electronic manual, dynamic programming, the problem of optimal resource allocation, automatic verification of solutions, multimedia

Abstract

Abstract. The article describes the process of creating and developing an electronic textbook for studying the method of dynamic programming. This method is used to solve some optimization problems and is studied in such disciplines as "Theory of decision-making" and "Methods of optimal solutions". The article highlights the possibility of using the developed manual to solve the practical problem of the optimal allocation of resources between the four companies, determining the maximum income and the amount of funds invested in each company. The article shows how to ensure the uniqueness of job options on each computer. The implementation of automatic verification of the answer entered by the user and display of calculations obtained at different stages of solving the problem in multimedia mode is demonstrated. At problem definition about distribution of resources and carrying out calculations by method of dynamic programming data register in the form of tables. For this reason, a widely used table editor Microsoft Excel was chosen as a software product for the development of the manual. Programming in the environment of VBA Excel is applied to work of the textbook. The formation of the task condition is carried out using the program code that is executed when the manual file is opened. If the user has difficulty in solving the problem, he can see the solution process. The organization of the solution display occurs when you click the buttons located on the Excel sheet. The electronic manual is a complete software product that is successfully used in practical classes. The manual can be used for self-study and distance learning.

Author Biography

Ekaterina V. Arkhangelskaya, Saratov State Law Academy

PhD in Physics & Mathematics, Associate Professor

References

Д. С. Антонюк, “Программно-иммитационные комплексы для формирования экономических компетентностей студентов технических специальностей: критерии и показатели отбора”, Информационные технологии и средства обучения, 2018, T. 64, № 2, С. 73-87.

Р. В. Манн, “Некоторые аспекты использования информационно-коммуникационных технологий в подготовке будущих экономистов”, Информационные технологии и средства обучения, 2018, T. 64, № 2, С. 170-184.

О. В. Дубинина, Л. Д. Грицяк, “Использование информационных технологий в обучении будущих проект-менеджеров”, Информационные технологии и средства обучения, 2018, Т. 63, № 1, С. 107-115.

О. И. Тютюнник. “Методические аспекты проведения лабораторных работ в будущих менеджеров-экономистов средствами системы MAPLE” Современные информационные технологии и инновационные методики обучения в подготовке специалистов: методология, теория, опыт, проблемы: сб. науч. тр. Выпуск 31. Редкол.: И.А. Зязюн и др., 2012, Киев-Винница: ООО Фирма "Планер", С. 482-484.

И. В. Андрощук, И. П. Андрощук. “Технология разработки электронного пособия по дисциплине «Методика трудового обучения»”, Информационные технологии и средства обучения, 2017, Т. 61, № 5, С. 24-35.

В. М. Михалевич, Я. В. Крупський, Ю. В. Добранюк. “Разработка электронных образовательных ресурсов в среде СКМ Maple”, Математика и информатика в высшей школе: вызовы современности: сб. науч. трудов по материалам Всеукр. науч.-практ. конф., 18-19 мая 2017 г.

В. М. Михалевич, О. И. Тютюнник. “Проектирование учебных задач по линейному программированию с использованием систем компьютерной математики”, Информационные технологии и средства обучения, 2013, Т. 38, № 6, С. 123-137.

А. А. Федосеев, “Электронные образовательные ресурсы: эффективность применения”, Системы и средства информатики, 2012, Т. 22, № 2, С. 263–277.

Я. В. Крупский, “Проверка эффективности использования учебных Maple-тренажеров для организации самостоятельной работы студентов”, Информационные технологии и средства обучения, 2012, Т. 27, № 1, С. 13-25.

Н. В. Бахмат, Т. Ю. Дудка, В. В. Любарец. “Использование мультимедийных образовательных технологий как условие качественной подготовки менеджеров социокультурной деятельности”, Информационные технологии и средства обучения, 2018, Т. 64, № 2, С. 98-109.

Е. В. Архангельская, “Об одном программном средстве мультимедийной поддержки учебных курсов по информатике”, Прикладная информатика, 2017, Т. 12, № 4 (70), С. 74–80.

В. Е. Величко. “Создание электронных образовательных курсов средствами свободного программного обеспечения”, Информационные технологии и средства обучения, 2017, Т 60, № 4, С. 128-140.

А. А. Панюкова, Т. А. Макаровских, В. И. Дударева, “Обучение компьютерной графике с использованием свободно распространяемого программного обеспечения”, Прикладная информатика, 2014, № 6 (54), С. 37–46.

Е. В. Архангельская, “Об одной реализации метода динамического программирования для решения задачи о замене оборудования с помощью прикладной программы”, Системы и средства информатики, 2018, Т. 28, № 2, С. 178-188.


REFERENCES (TRANSLATED AND TRANSLITERATED)

D. S. Antoniuk, “Business simulations for the formation of economic competence of technical specialties students: criteria and indicators of selection”, Information Technologies and Learning Tools, 2018, Vol. 64, No 2, p. 73-78 (in Ukrainian).

R. V. Mann, “Some aspects of information and communication technologies application in preparation of future economists”, Information Technologies and Learning Tools, 2018, Vol. 64, No 2, p. 170-184 (in Ukrainian).

O. V. Dubinina, L. D. Hrytsiak, “Use of information technologies in future project managers' training”, Information Technologies and Learning Tools, 2018, Vol. 63, No 1, p. 170-115 (in English).

O. I. Tyutyunnik. “Methodical aspects of laboratory work at future managers-economists by means of the MAPLE system” Modern information technologies and innovative teaching methods in the training of specialists: methodology, theory, experience, problems. Vol. 31. Editorial board: I.A. Zyazyun and others. 2012. Kiev Vinnitsa: Firm "Planer", p. 482-484.

I. V. Androshchuk, I. P. Androshchuk, “Technology for development of electronic textbook on handicrafts methodology”, Information Technologies and Learning Tools, 2017, Vol. 61, No 5, p. 24-35 (in Ukrainian).

V. M. Mykhalevych, Y. V. Krupskyy, Y. V. Dobranyuk. “Development of electronic educational resources in the SCM Maple environment”, Mathematics and Informatics in higher education: challenges of our time: collection of scientific papers on the materials of all-Ukrainian. science.-prakt. Conf., 18-19 May 2017.

V. M. Mykhalevych, O. I. Tyutyunnik. “Design of educational problems on linear programming using systems of computer mathematics”. Information Technologies and Learning Tools, 2013, Vol. 38, No 6, p. 123-137 (in Ukrainian).

A. A. Fedoseev, “Electronic educational resources: efficiency of application”, Systems and Means of Informatics, 2012, Vol. 22, No 2, p. 263–277 (in Russian).

Y. V. Krupskyy. “Check of the efficiency of educational maple-simulators for organization of students independent work”. Information Technologies and Learning Tools, 2012, Vol. 27, No 1, p. 13-25 (in Ukrainian).

N. V. Bakhmat, T. Y. Dudka, V. V. Liubarets, “Multimedia education technologies usage as the condition for quality training of the managers of socio-cultural activity”, Information Technologies and Learning Tools, 2018, Vol. 64, No 2, p. 98-109 (in Ukrainian).

E. V. Arkhangelskaya, “Multimedia software development in the educational process”, Journal of Applied Informatics, 2017, Vol. 12, No 4 (70), p. 74–80 (in Russian).

V. Y. Velychko, “Creating e-learning means of free software”, Information Technologies and Learning Tools, 2017, Vol. 60, No 4, p. 128-140 (in Ukrainian).

A. A. Panyukova, T. A. Makarovskikh, V. I. Dudareva, “On the experience of computer graphics lessons using free software”, Journal of Applied Informatics, 2014, No 6 (54), p. 37–46 (in Russian).

E. V. Arkhangelskaya, “About one implementation of the method of dynamic programming to solve the problem of equipment replacement with the application program”, Systems and Means of Informatics, 2018, Vol. 28, No 2, p. 178-188 (in Russian).

Published
2019-09-21
Section
The methodology, theory, philosophy and history of the use of ICT in education