Excel Aides:-
Interactive Excel files
Lower School (S1 to 3)
- Circle - area and circumference
Interactive sheets to see the effect a change in radius has on the area and circumference of a circle.
The last page tests your ability to calculate area and circumference. -
pie charts
An interactive sheet to draw pie charts. - fractions, decimals, piecharts
Interactive link between fractions ,decimals, percentages and piecharts - fractions, decimals and
percentages Excel 1997-2003 file
Interactive tests - rounding to nearest ...
Interactive tests - rounding to decimal places
Interactive tests
Upper School (S4 to 6)
- Graphs of functions
Interactive sheet allowing you to see the Graphs of Functions
y = f(x+a),y = -f(x),y = kf(x),
y = f(x)+a, y = f(-x), y = f(kx)
y = kf(x)+a, y = kf(x+a) - Exponential / log functions - graphs
Interactive sheet allowing you to see the Graphs of Functions
y=ax , y=logax, y=loga(1/x)
log y = b log x + log a and y = axb - Indices
A quick test of the 5 rules of indices. - Finding roots of quadratics
Interactive sheet which draws quadratics and calculates roots where they exist. - Finding limits Interactive sheet
- Straight lines, gradients and the
y-intercept
Interactive pages to let you plot straight lines, play with gradients, see the effect of the gradient formula and use y=mx+c - CAST
Click to see which quadrant an angle lies in.
- See how trig graphs
are affected by a change in amplitude or phase angle.
y=ksinx,y=sin(x+b),y=k + sinx
y=kcosx ,y=cos(x+b),y=k + cosx
y=sinax,y=sin(x-b),y=ksin(ax±b)
y=cosax,y=cos(x-b),y=kcos(ax±b) -
cumulative frequency (ogive)
An interactive sheet to draw cumulative frequency diagrams. -
relative frequency
An interactive sheet to draw relative frequency diagrams.
- line of best fit An interactive sheet to draw the line of best fit.
-
scattergraphs
An interactive sheet to draw scattergraphs. -
standard deviation and box plot
An interactive sheet to calculate standard deviation draw box plots.(Excel 2003)
(Excel Cloud) version -
Simultaneous equations
An interactive sheet to simultaneously solve two sets of equations. -
Surface area of a cylinder
An interactive sheet to work out the surface area of a cylinder with a given volume. -
Gaussian elimination
An interactive sheet to simultaneously solve three sets of equations. (Excel 2003)
(Excel Cloud) version
© Alexander Forrest