POSSIBILITIES OF USING MICROSOFT EXCEL FOR DEVELOPMENT OF SOFTWARE TOOLS FOR SOLVING DYNAMIC PROGRAMMING PROBLEMS
PDF (Russian)

Keywords

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

How to Cite

[1]
E. V. . Arkhangelskaya, “POSSIBILITIES OF USING MICROSOFT EXCEL FOR DEVELOPMENT OF SOFTWARE TOOLS FOR SOLVING DYNAMIC PROGRAMMING PROBLEMS”, ITLT, vol. 72, no. 4, pp. 1–13, Sep. 2019, doi: 10.33407/itlt.v72i4.2497.

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.

PDF (Russian)

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).

Authors who publish in this journal agree to the following terms:

  1. Authors hold copyright immediately after publication of their works and retain publishing rights without any restrictions.
  2. The copyright commencement date complies the publication date of the issue, where the article is included in.

Content Licensing

  1. Authors grant the journal a right of the first publication of the work under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License (CC BY-NC-SA 4.0) that allows others freely to read, download, copy and print submissions, search content and link to published articles, disseminate their full text and use them for any legitimate non-commercial purposes (i.e. educational or scientific) with the mandatory reference to the article’s authors and initial publication in this journal.
  2. Original published articles cannot be used by users (exept authors) for commercial purposes or distributed by third-party intermediary organizations for a fee.

Deposit Policy

  1. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) during the editorial process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (see this journal’s registered deposit policy at Sherpa/Romeo directory).
  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
  3. Post-print (post-refereeing manuscript version) and publisher's PDF-version self-archiving is allowed.
  4. Archiving the pre-print (pre-refereeing manuscript version) not allowed.

Downloads

Download data is not yet available.