Index
Sheet name Section
Example.xls 1.8
Intro.xls 1.5, 1.8
S_line.xls 2.2
Quadrat.xls 2.3
Poly.xls 2.4
Exp.xls 2.7
Log.xls 2.8,2.9
Roots.xls 3.5
Simul.xls 4.3
Trig.xls 5.3
Vsum.xls 5.6
Triangle.xls 6.3
Polar.xls 6.5
Stats.xls 7.3,7.8
Gauss.xls 7.5
Bfit.xls 7.6
Sterr.xls 7.8
Differentiate.xls 8.4
Integ.xls 9.2-9.4
Underdog.xls
Page 1
Index
Description
Simple spreadsheet example
Introductory sheet showing scientific notation and graphing
Plots staight line given m & c
Plots quadratic function given a, b & c
Plots polynomial function up to n=5.
Plots exponential function for any values of a, b or c.
Plots common, natural and user-defined-base log functions
Calculate roots of quadratic eqn given a, b & c
Solve 2x2, 3x3, 4x4 or 5x5 system of simultaneous linear equations
Solve triangle given 3 pieces of information
Calculate vector sums
Plot data on a triangular diagram
Plot data on equal interval, equal angle and equal area plots
Calculate mean, mode, sample variance, pop variance, st dev and st err for a data list
Calculate and plot a normal distribution and give area under curve between 2 points
Calculate and plot best fit lines given 2 columns of data
Calculate standard error given a standard deviation and number of data points.
Comparison of gradient between two separated points and gradient of tangent.
Comparison of discrete area under curve to integral solution.
A board game for when you're bored with maths.
Page 2