Completing The Square & Quadratic Formula

Interactive macro-enabled MS-Excel spreadsheet. Contents: Use a visual method to derive the completing the square formula. Rewrite a given quadratic expression ax² + bx or ax² + bx + c. Solve quadratic equations writing x as a decimal or in surd form. Write a graph’s equation as y = (x + p)² + q & find turning point P. Write a graph’s equation as y = a(x + p)² + q & find turning point P. Write a graph’s equation as y = x² + bx + c using its minimum P. Write a graph’s equation as y = −x² + bx + c using its maximum P. Write p & q in terms of a, b & c then use them to find the roots & P. Use completing the square to derive the quadratic formula. Use the quadratic formula to solve a quadratic equation. Use the quadratic formula to solve a graph of a quadratic equation. Write formulae for the sum & product of the two roots & evaluate. Evaluate the golden ratio as a surd & decimal using a rectangle.