2 results
High school algebra 2 handouts for Microsoft Excel
Graphing and Analyzing Functions on a Spreadsheet
This math activity allows students to investigate the behavior of functions (Quadratic, Cubic, Hyperbolic and Exponential) by adjusting the domain over which the functions are viewed. Students are guided with step by step instructions on how to program a blank spreadsheet to graph functions of their choosing over intervals that they specify. Graphs are manipulated and students are guided to look at growth rates of functions and how they behave as they approach larger and smaller values. Real
Subjects:
Grades:
10th - 12th
Types:
The Quadratic Formula and Finding Roots Using Goal Seek on a Spreadsheet
Students will be guided to produce a spreadsheet from a blank Excel workbook that uses the quadratic formula to find the roots of a quadratic equation. They will then be guided to graph the functions and see the intersection points of the graph with the X axis.
Then other nonlinear functions will be solved using Goal Seek. Goal Seek is a trial and error that allows students to solve equations that cannot be solved algebraically. Students will bring all terms of the equation to one side and
Subjects:
Grades:
8th - 12th
Types:
Showing 1-2 of 2 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands