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! |
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 |
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.
|
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 You may also need to install and enable the Excel optional add-ins Analysis ToolPak and Analysis ToolPak VBA; follow these instructions:
|
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. For Firefox you may need to install some extra fonts. See here Direct download of fonts for windows here |
See Above |
QTimer97.xls Version for Excel97 users. |
See above |
Factorising.xls Also useful for AS level students! |
||
Pythagoras2k.xls This version works on Excel 2000 and 97 |
||
See above |
PythagorasXP.xls This version works on Excel XP or 2003 |
See above |
StandardForm.xls updated 12/06 |
||
SinEqnSolv.xls
Similar to BasicTrigEqnSolv but deals with Sin(ax+b). |
||
CosEqnSolv.xls Ditto for Cos(ax+b). |
||
Trig.xla |
||
BinHyp.xls |
||
StDev.xls Coding method for calculating mean and Standard Deviation. |
||
StDevCoding.xls Updated version of the above file using the new definitions. |
||
DiceGame.xls Starter for the idea of Expectation. |
||
Correlation.xls Guess the value of the correlation coefficient from the scatter diagram. |
||