Home Page      

Spreadsheets For Mathematics

These spreadsheets were prepared for year 5 (9-10 years) ICT (computing) in a UK primary school.

Open each of these spreadsheets and save into another folder which you can call "Spreadsheets" then open the required spreadsheet from your new folder. Do not forget to save your work regularly!

Microsoft Excel 97-2003 Version

Microsoft Excel 2010 Version

Spreadsheet New 1

Spreadsheet New 1

Spreadsheet New 2

Spreadsheet New 2

Spreadsheet New 3

Spreadsheet New 3

Spreadsheet New 4

Spreadsheet New 4

Spreadsheet New 5

Spreadsheet New 5

Spreadsheet New 6

Spreadsheet New 6

Spreadsheet New 7

Spreadsheet New 7


NOTES ON THE SPREADSHEETS

New Spreadsheet 1

The heading of the first column is given the title 'X' . Any of the numbers in this column belong to X.

A spreadsheet formula is to be set up in cell B2 adding 2 to the number 5. The cell B2 is highlighted and the mouse pointer moved to the bottom left hand corner of the cell where it becomes visible as a small black cross. Clicking and dragging the mouse pointer downwards over the cells below will paste the formula into them which will result in the answers to the sum 15+2, 25+2 etc becoming visible in the cells.

If you have fully understood the above, then creating formulae in the remaining cells B2, C2, D2, E2, and F2 will be done without any trouble.

To do these, you must have previously mastered the skills of adding, subtracting, multiplying and dividing numbers in spreadsheets. If you are uncertain of this, you should do the various exercises in "Spreadsheets Calcs. Practice". Spreadsheets New 1 is in many ways an extension of this preliminary exercise. It aims to introduce you to the use of 'X' in a calculation.

New Spreadsheet 2

Please carefully note how the column headed by "Write X and Y as a Fraction (X/Y)" is to be used. You are to enter all the numbers in column X and Y separately and not attempt to add a formula to divide X by Y. If you try this, it will not work because I have set it up to only display the numbers as a fraction.

However, the column headed "Divide X by Y to give a Decimal" is to be used in a normal way. You will enter into cell D6 the formula "=A6/B6 [ENTER]" and then copy this formula into all the relevant cells below.

New Spreadsheet 3

In this spreadsheet, various (ordinary) numbers are placed in column X.

In column "X% (X divided by 100)" you are required to use the spreadsheet to convert the numbers in column X into percentages. To do this you merely divide (for example) 7 by 100 so that it becomes 7%. As before enter the formula into cell B4 and then paste the formula into all the cells below.

In column "X% of Y (X% times Y)" you will multiply each percentage by the corresponding (or associated) value of Y.

New Spreadsheet 4

Please note that MX means M times X. In Algebra, the times sign is removed since it will be mixed up with any Xs that are present.

Copyright © Mr M. Alder 2013. The "(MX) + C" column merely uses a spreadsheet formula to add the contents of the "MX" column to the contents of the "C" column.


New Spreadsheet 5

A new symbol is used "^" which I call a "Mountain Top" This is how Excel deals with

X2 in Mathematics or X times X. You could have used X*X but I wanted you to get used to the "^" symbol. Remember in Mathematics that 2X means X times X. Also remember that Excel often requires you to enter things in a different way as they are written in Mathematics.

New Spreadsheet 6

Column "3X2 + 5X + 3" can most easily be entered into Excel in stages.
First the "
X" column is created, then the "X^X" column. Then a new "3 times X^X"
column. Next a "
5X" column is created. To create the final "3X2 + 5X + 3" column you merely have to add the contents of the "3X2" column to the contents of the "5X" column
you have already created and add a further 3. Don't forget when you first create the new
"
3X2 + 5X + 3" column you must type in an "=" sign.



New Spreadsheet 7

1) Log onto your class and open Spreadsheets 7 which is located in your "Spreadsheets" folder. Immediately save this to your own folder.

2) Use the methods you have previously learnt to fill the empty cells using spreadsheet formulae.

3)Start off with [1] Since Y = X use a formula to fill the empty cells of the "Y" column.

4) Once you have correctly filled the empty cells, save your work and highlight the "X" and "Y" columns by clicking on the "X" data first, press [Control] and then also click on the "Y" data.

5) Click on the insert tab.

6) Click on "Scatter (Charts)"

7) Click on top right diagram which is labelled "Scatter with Smooth Lines and Markers".

8) Your graph will now appear.

9) Save your work and repeat what you did in 3) above with
[2]. You will be now filling the Y = 2X column. When you have finished this, save your work.

10) Repeat the above with [3], [4] and [5] taking care to save your work when you have finished.


Version: 22nd July 2013



Home Page