variables. Now we are going to use Excel to solve real world problems of the same style." Questions: If Excel has not been used in the classroom before: "How many of you are familiar with Excel?" "Have you used Solver before?" Explore List activities, key questions, specific examples, and assessment strategies. – Objective Code (C1, Time Learning Activities (What and How) Purpose (Why) C2 or L1, L2) 20 min C2 Optimization "workbook" Includes an excel file which every student will Allow students C3 complete. (file can be found at the opportunity -under Algebra 2, Optimization in Excel, be sure to separate the to work through answer key from the student pages prior to giving to students.) a problem where the information has been given Make sure all students have found solver on their version of Excel and that to them. Here the instructions for use are on the board. Go to File, Options, Add-ins, look they can learn to for Solver. The button will show up under the Data tab, in the section use excel and Analysis. solver. Using Solver: Explain how to set Objectives in this case maximize profit), which cells represent the variables, and what Constraints are given in the problem. Students should use the Simplex LP method for solving (more instructions in excel file). C2 Rest of "You have been placed Into groups of 3 or 4, please work together to conduct This is a C3 Class, research, solve an optimization problem, write a report, and prepare a Performance C4 and all presentation." Assessment, C5 of next with almost two L1 Topics for research: class days of in class L2 Mixing Problems - Oil, Animal Feed, metal combinations period time to create their own More abstract - factors to influence profit at a concert, minimize expenditures optimization for travel. problem to be Students will pick a topic, identify variable, determine constraints, and solve solved in excel. using solver. Students will then present on Rubric: their project to File (accuracy, research, logical answer) the class. This is an open ended Presentation (neat, free of spelling & grammar errors, all group members project. participate)
variables. Now we are going to use Excel to solve real world problems of the same style." Questions: If Excel has not been used in the classroom before: "How many of you are familiar with Excel?" "Have you used Solver before?" Explore – List activities, key questions, specific examples, and assessment strategies. Time Objective Code (C1, C2 or L1, L2) Learning Activities (What and How) Purpose (Why) 20 min C2 C3 Optimization "workbook" Includes an excel file which every student will complete. (file can be found at -under Algebra 2, Optimization in Excel, be sure to separate the answer key from the student pages prior to giving to students.) Make sure all students have found solver on their version of Excel and that the instructions for use are on the board. Go to File, Options, Add-ins, look for Solver. The button will show up under the Data tab, in the section Analysis. Using Solver: Explain how to set Objectives in this case maximize profit), which cells represent the variables, and what Constraints are given in the problem. Students should use the Simplex LP method for solving (more instructions in excel file). Allow students the opportunity to work through a problem where the information has been given to them. Here they can learn to use excel and solver. Rest of Class, and all of next class period C2 C3 C4 C5 L1 L2 "You have been placed Into groups of 3 or 4, please work together to conduct research, solve an optimization problem, write a report, and prepare a presentation." Topics for research: Mixing Problems - Oil, Animal Feed, metal combinations More abstract - factors to influence profit at a concert, minimize expenditures for travel. Students will pick a topic, identify variable, determine constraints, and solve using solver. Rubric: File (accuracy, research, logical answer) Presentation (neat, free of spelling & grammar errors, all group members participate) This is a Performance Assessment, with almost two days of in class time to create their own optimization problem to be solved in excel. Students will then present on their project to the class. This is an open ended project.
integratedlessonplan.docx