利用Excel探究中职数学中的线性规划问题

Using Excel to Explore the Linear Programming in Secondary Vocational Mathematics

线性规划问题常用来描述和解决一些实际问题,是中职数学中一个重要的教学内容。文章介绍了如何使用Excel软件来探索和求解简单的线性规划问题,对更复杂和一般的多目标线性规划问题进行了探讨。结合实际问题为相关具体的应用提供了若干操作简便的范例。

Linear programming is often used to describe and solve some practical problems,so it is an important teaching content in secondary vocational mathematics.This paper first introduces how to use Excel software to explore and solve simple linear programming problems,and then discusses more complex and general multi-objective linear programming problems.In the end,some simple and convenient examples are provided for the practical application.