TSM Resources. . . www.tsm-resources.com
 
USEFUL XLS FILES
FOR MATHEMATICS TEACHING

EXCEL

JUNIOR MATHEMATICS TOPICS

Rectangular Fencing
N-sided Fence
Phone bill
Pascal's Triangle


PURE MATHEMATICS TOPICS

Geometric Progression
Gradient of x²
Pythagorean Triples

Creating a slider bar in Excel
- Turorial for Excel

 

PROBABILITY & STATISTICS

Simulations:
-- 1 Die simulation
-- 2-Dice simulation
-- 1-Coin simulation
-- 100 Coins
-- UK Lotto simulation

Sampling
-- Binomial (10,0.5)
-- Poisson (2)
-- Poisson (60)

UK Lotto analysis (240kB)
Lotto Generator
Brains and Intelligence
Time series: moving average
Binomial Poisson comparison
Slider-based cum. frequency
Normal calculator


DATA

Belly Button-Height (185)
World Population (196 countries)
Mayfield High School (1185 Y7-11)

Beijing Olympics (2008)
Sports data (various)
Mile Record (1913-1999)
100m Record (1912-2005)

Oxford Weather (1853-2013)
Reaction Times (200)
Sunrise over Geneva

Weights of Patients
(7562)
Baby Data (1132)
Baby Data (459)

ANZAC data (330 ages) - discussion

43rd Mersenne Prime (9Mb)
+ Mersenne Web site

More Excel on the web:

Excel files for GCSE and A level
from Mike Hadden

Miscellaneous Excel files
from Mark Dabbs
Wakefield Girls High School

Spreadsheets blog -
from Kasper and Mikkel (Denmark)

TrumpExcel,com -
from Sumit Bansal (India)

Deskbright Excel Tutorials -
from Sam MacIntire (San Francisco)

More data:

Sidney Tyrrell's Data page

TSM Maths Links - Data

TSM MAGES page


TSM-DATA (.zip) [rev: Feb 2016]
to import into Autograph:
Sports - weights - babies - weather - population - reaction times - car sales - time series, etc

Please download and "Extract"
to a folder that you have made.


TSM-IMAGES (.zip) [rev: Feb 2016]
to import into Autograph:
Circular, Parabolic, Polygons, 3D, Angles/Lines, Arches, Circular, Reflections, Spirals, Trig, etc

Please download and "Extract"
to a folder that you have made.

Geometer's
Sketchpad


Circle Theorems
Quadrilateral mid-points
Rhombus construction
Ellipse construction

Parabola construction
Engine motion (animation)
The Euler line
9-point circle

Area of rectangle (quadratic graph)
Volume of box (cubic graph)
Falling Ladder (locus)
Sierpinsky Triangle (Iteration)
More GSP on the web:

Miscellaneous GSP files
from Mark Dabbs
Wakefield Girls High School
Cabri 3D

How to create a Tetrahedron by folding a rectangular piece of paper!
[with thanks to Kate Mackrell]

 
CONTACT

iCT TRAINING CENTRE (Oundle)
----PO BOX 46, Oundle, Peterborough PE8 4JX, UK
----Fax: +44 (0)1832 273529
----Director: DOUGLAS BUTLER - email - Mirandanet Profile