Spreadsheet Files
Spreadsheets such as Excel can be used to produce some very interesting exploratory games.
Here we present a huge collection of spreadsheet files which originally appeared on a CD which was sent, free, to members of ATM. We have now negotiated permission to make them available here.
But, if you’re not a member, please consider joining ATM. Not only will you be supporting the further development of resources such as these but you will also receive the other benefits of belonging to one of the leading professional associations for mathematics educationalists.
Graeme Brown
Email Graeme Brown with any queries or suggestions
Excel for Advanced Users
A PDF file with easy to follow instructions and suggestions for: Key Problem Solving Techniques; Beads; More Beads; Ring on a String; Pythagorean Triples; Sum of Consecutive Numbers; Conditional Formatting; Inserting a Spinner/Scroll Bar; Table of Values for 2 variables.
<< Download Excel for Advanced Users
Douglas Butler
Email Douglas Butler with any queries or suggestions
11-16 Topics
- Rectangular Fencing
- N-sided Fence
- Phone bill
- Pascal’s Triangle
- Introduction to Excel’s features, including exercises and solutions to the exercises
Pure Mathematics
- Geometric Progression
- Gradient of x^2
- Pythagorean Triples
- Numerical Differentiation (Errors from multiple differentiation of sinx)
- Flash tutorial - Creating an Excel Slider Bar
Probability & Statistics
Simulations
Sampling
- Binomial(10,0.5)
- Poisson (2)
- Poisson (60)
- UK Lottery analysis
- Brains and Intelligence
- Time series: moving average
- Binomial Poisson comparison
- Slider-based cumulative frequency
- Normal calculator
Mike Hadden
Email Mike Hadden with any queries or suggestions
11-16 Topics
- Grid with notes
- Percentages with notes
- Q-Timer (Excel 97 version) with notes
- Number Sequences with notes
- SOH-CAH-TOA! with notes
- Trig Functions in Degrees
You can install 6 new functions into Excel: SIND(), COSD(), TAND(), ASIND(), ACOSD(), ATAND(). For example: SIND(90) -=> 1 or ATAND(1) => 45. Download this file and read the notes carefully.
Pure Mathematics
- Basic Trig Equation Solvers: Sin Equation Solver; Cos Equation Solver with notes
- Inequalities with notes
- Complex Numbers with notes
- Complex Roots with notes
- Geometric Progression with notes
- Matrix Transformation with notes
Mechanics
- Bungee Duck with notes
- Friction 1 with notes
- Friction 2 with notes
- Resolving Forces with notes
- Projectiles with notes
- Vertical Motion with notes
Statistics
Geoff Wake
Email Geoff Wake with any queries or suggestions
Beginners Spreadsheet Workshop
Virus-Checked
Please Note: these files have been virus-checked by Norton/Symantec/McAfee and were declared virus-free. Some files contain macros - you may be asked to adjust your computer’s spreadsheet security settings. The macros contained in these files are all harmless. However, for your own peace of mind, we would advise you to check it with your own virus-checker before opening it within Excel.
