Optimization problem in financial resource management in profiled information technology education
DOI:
https://doi.org/10.55630/mem.2026.55.255-264Keywords:
optimization problem, Excel Solver, AI, mathematics education, information technology and economicsAbstract
The article examines opportunities for software-based solving of economic problems by students at the upper-secondary level. A financial resource management problem and its optimal solution are presented. The problem is solved by different groups of students using traditional software methods, and the use of artificial intelligence (AI) is introduced to support the development of students’ analytical skills. For this purpose, Excel Solver and generative artificial intelligence (AI) are used. The application of these methods in the educational process is presented, taking into account the level of mathematical knowledge of the students in the respective grade.
References
K. Ivanova, T. Atanasova, Linear optimization. Mathematical methods in economics. Graduate School of Telecommunications and Posts. ISBN: 978 954 9332-93-3. (2015) (in Bulgarian)
P. A. Kirschner, J. Sweller, R. E. Clark. Why minimal guidance during instruction does not work. (2006).
R. Luckin, W. Holmes, M. Griffiths, L. B. Forcier. Intelligence Unleashed: An argument for AI in Education, pp. 23-30. Pearson. (2016)
V. Tchernogorov. 2012. Solving linear optimization tasks with MS Excel 2010, Sofia University
Resolution No. 84 of June 6, 2025 on amendments and supplements to regulatory acts of the Council of Ministers, Republic of Bulgaria
