当前位置: X-MOL 学术Journal of Education for Business › 论文详情
Our official English website, www.x-mol.net, welcomes your feedback! (Note: you will need to create a separate account there.)
Online software using randomization and automated grading to help teach linear programming with Excel and Solver in business courses
Journal of Education for Business Pub Date : 2020-09-24 , DOI: 10.1080/08832323.2020.1821345
Kurt Hozak 1
Affiliation  

Abstract

This article describes a web-based application that can be used to help teach linear programming (LP) using an active learning approach in business courses such as management science and decision analysis. The software asks 42 integrated questions that guide students in creating product mix models and performing related analysis in Excel with Solver. Automated grading and extensive commentary provide fast feedback and help students more holistically understand topical relationships. Humor helps make learning the material more engaging and fun. The application uses randomized data and cell layout locations to encourage academic integrity and make repeated practice more value-adding. Assessment results suggest that the application offers challenges and supports learning.



中文翻译:

使用随机化和自动评分的在线软件,帮助在商业课程中使用 Excel 和 Solver 教授线性编程

摘要

本文介绍了一个基于 Web 的应用程序,该应用程序可用于在管理科学和决策分析等商业课程中使用主动学习方法来帮助教授线性规划 (LP)。该软件提出了 42 个综合问题,指导学生使用求解器在 Excel 中创建产品组合模型和执行相关分析。自动评分和广泛的评论提供快速反馈并帮助学生更全面地理解主题关系。幽默有助于使学习材料更具吸引力和乐趣。该应用程序使用随机数据和单元格布局位置来鼓励学术诚信并使重复练习更具附加值。评估结果表明该应用程序提供了挑战并支持学习。

更新日期:2020-09-24
down
wechat
bug