Using+Excel+to+Solve+Equations

Presenter: Trina Hess Manheim Township trina_hess@mtwp.net

Linear Equations--Day One--Introduced LP
 * Problem 1 as example
 * Problem 2, 3 as homework

Day Two--groupwork Day Three--Introduce Excel (problem 1) Day Four--Student work on Excel (Problems 2, 3, 4) Open Excel Click on the ? help button to locate how to install the solver. On the Mac it is located under the tools menu. On the PC you will probably have to install the solver. Use the help function to find the instructions how to install the solver.

Students were given a colored coded template that was placed on Moodle so students could follow along with Mrs. Hess. The colored coded template really helped the students locate appropriate cells when doing the problems the first few times in class. The students learned the process of setting the problems up in the excel spreadsheet in a table, as well as using the solver to determine the answer to the problem.

Documents will be posted below: [| linear programming excel instructions.doc] [| page 1-3.pdf] [| page 2.pdf] [| linear programming questions.doc] [| alg2template.xls] [| alg2template2.xls] [| alg2answers.xls] [| alg2answers2.xls]
 * Linear Programming Instructions**
 * Problems given to students**
 * Linear Programming Questions**
 * Algebra Template**
 * Answers**