Explain these icons
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.
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 PDF
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
- 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.
Entire 11 to 16 Topics collection
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
- 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
Entire Pure Mathematics collection
Probability & Statistics • Simulations
Entire Probability & Statistics Sampling collection
Probability & Statistics • 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
Entire Probability & Statistics Sampling collection
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
Spreadsheet Workshop
Spreadsheet files used in the Spreadsheet Workshop
- Adding Fractions Investigation
- Car Data
- Find the Rule
- Magic Square
- Population 1
- Population 2
- Sequences
- Target
- Three Numbers
- Wall
Entire Spreadsheet Workshop collection
Virus-Checked
Please Note: these files have been virus-checked and are 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 but are required for them to perform as intended.
