Rate this resource

This excel program contains a series of interactive spreadsheets designed to explore the concept of a gradient of a curve.

The first activity illustrates that the gradient of a function, at a point P, is the gradient of a chord PQ as the length of PQ tends to zero. The equation of the quadratic can be adjusted. The summary sheet summaries the findings for a particular example encouraging the student to deduce the formula for the gradient function.

The Function>Gradient activity provides the formula of eight functions, a mix of linear and quadratic, for students to differentiate in order to find the gradient function. Clicking on the empty cell reveals the answer.

The Gradient > Function activity requires the student to work backwards to find the original function given the gradient function.

The final activity provides a further opportunity to explore differentiation from first principles.

The workbook contains a further eight worksheets providing further questions for use in the classroom.

This program was designed to be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on a machine.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Show downloads

Published by


Share this resource