Make a donation to encourage me to continue developing materials.

Mike's Excel and Maths Files.     Home

Materials for AS, A level and GCSE  Maths teachers and students.

Quick Navigation

Contact me : .

I would be glad to receive comments, suggestions or offers of work!

Excel Files Menu

GCSE Files

A/AS Pure Files

A/AS Mechanics Files

A/AS Statistics Files

Other Files

The following files can be downloaded.

Scroll down or use the menu on the left to jump to a section.

If you like you can look at the ScreenShot picture first to get an idea of what they do.

It is best to download the files first and then open them in Excel rather than open them in a browser window.

To download right click on the link and chose
"Save Target As".

I will be adding to and updating the files gradually and adding notes on using them.

For news of new and updated files see the changelog.

In theory the sheets should resize themselves on opening according to your screen resolution.
If this does not happen for some reason the situation is easily remedied:

  • On the View menu, click Zoom.

  • Set an appropriate magnification factor.

Important!: The files will not work correctly unless you first set up Excel according to the following instructions:

Nearly all the workbooks use macros. In order to enable the macros you will need to set the security level to medium or zero in Excel
(go to Tools/Macros /Security).

You may also need to install and enable the Excel optional add-ins Analysis ToolPak and Analysis ToolPak VBA; follow these instructions:

  • On the Tools menu, click Add-Ins.

  • If the add-in you want to use is not listed in the Add-Ins available box, click Browse, and then locate the add-in. If the add-in is not installed on your computer, you can install it (you may need your Office installation disk).

  • In the Add-Ins available box, select the check box next to the add-in you want to load.

  • For more detail type "Install add-in" into the Excel help Answer Wizard.

 

To view the maths on a few of the notes pages with Internet Explorer 5.5 or later, you may need a plugin such as Design Science's MathPlayer.
To install MathPlayer, click here:
mathplayer

For Firefox you may need to install some extra fonts. See here

Direct download of fonts for windows here

GCSE:        Some files in the Statistics section may also be useful.
Back to Top 
ScreenShot
Grid.xls
Notes
ScreenShot
NumberSequences.xls
Notes
ScreenShot
Percentages.xls
Notes
ScreenShot
Percentages2.xls 
Notes
ScreenShot
Sohcahtoa.xls
Notes
ScreenShot
QTimer.xls
Notes
See Above
QTimer97.xls
Version for Excel97 users.
See above
ScreenShot
Factorising.xls
Also useful for AS level students!
ScreenShot
StLines.xls
Notes
ScreenShot
Trial and Error1dp.xls
Notes
ScreenShot
Trial and Error2dp.xls
Notes
ScreenShot
Pythagoras2k.xls
This version works on Excel 2000 and 97

Notes

See above
PythagorasXP.xls
This version works on Excel XP or 2003
See above
ScreenShot
Averages.xls
Notes
ScreenShot
 Primes.xls
Notes
ScreenShot
PrimeFactors.xls
Notes
ScreenShot
Coords.xls
Notes
ScreenShot
EqSolver.xls
Notes
ScreenShot
LCM.xls 
Notes
ScreenShot
HCF.xls
See LCM Notes
ScreenShot
Transform.xls
Notes
ScreenShot
SimEq.xls
Notes
ScreenShot
CompoundInterest.xls
Notes
ScreenShot
NegativeNumbers.xls
Notes
ScreenShot
DecPlaces&SigFigs.xls
Notes
ScreenShot
Bearings.xls
Notes
ScreenShot
StandardForm.xls    updated 12/06
Notes
ScreenShot
GraphTable.xls
Notes
ScreenShot
PieChart.xls 
Notes
 A/AS level Pure:
Back to Top
ScreenShot
BasicTrigEqnSolv.xls
Notes
SinEqnSolv.xls
Similar to BasicTrigEqnSolv but deals with Sin(ax+b).

CosEqnSolv.xls
Ditto for Cos(ax+b).

Trig.xla
An Add-in to enable the use of trig functions in degrees.

Notes
ScreenShot
Ineq.xls
Notes
ScreenShot
Polymult.xls
The grid method for multiplying Polynomials.
 
ScreenShot
GPSum.xls
Notes
ScreenShot
Complex.xls
Notes
ScreenShot
ComplexRoots.xls
Notes
ScreenShot
MatrixTrans.xls
Notes
ScreenShot
TrapRule.xls
Notes
ScreenShot
TrigGraphs.xls
Notes
ScreenShot
CompleteTheSquare.xls
Notes
ScreenShot
SinGraph.xls
Notes
ScreenShot
Pascal.xls
Notes
A/AS Level Mechanics:
Back to Top
ScreenShot
BungeeDuck.xls
Notes
ScreenShot
Vertical Motion.xls
Notes
ScreenShot
Notes
ScreenShot
Resolving.xls
Notes
ScreenShot
Friction1.xls
Notes
ScreenShot
Friction2.xls
Notes
A/AS Level Statistics:
Back to Top
ScreenShot

BinHyp.xls
Critical values for Hypothesis testing with Binomial Distribution.

 
ScreenShot
PoiBinNorm.xls
 Compare the three distributions.
 
ScreenShot
StDev.xls
Coding method for calculating mean and Standard Deviation.
ScreenShot
StDevCoding.xls
 Updated version of the above file using the new definitions.
Notes
ScreenShot
DiceGame.xls
Starter for the idea of Expectation.
ScreenShot 
Correlation.xls
 Guess the value of the correlation coefficient from the scatter diagram.
ScreenShot
BoxPlotDynamic.xls
Notes
ScreenShot
MovingAverages.xls
Notes
ScreenShot
MedianQuartiles.xls
Notes
ScreenShot
StandardDeviation.xls
Notes
Other Files:
Back to Top
ScreenShot
Hangman.xls
Notes