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)

ANZAC data (330 ages) - discussion

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

Data from the exam boards AS and A level 'Large Data Sets':
AQA
OCR

MEI
- Edexcel - YouTube intro video

More Excel on the web:

Excel files for GCSE and A level
from Mike Hadden (out of date)

Automate Excel -
from Steve Ryearson (Austin, TX)

Spreadsheets blog
from Kasper and Mikkel (Denmark)

TrumpExcel,com -
from Sumit Bansal (India)

Deskbright Excel Tutorials -
from Sam MacIntire (San Francisco)

Excel-Easy
from Niels Weterings (Amsterdam)

Mr Excel (Ohio)

Teach Excel: Tutorials (Don)


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.

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

Director: DOUGLAS BUTLER - email