Spreadsheets For Mathematics
These spreadsheets were prepared for year 5 (910 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!
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. 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. 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. 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. A new symbol is used "^" which I call a "Mountain Top" This is how Excel deals with X^{2 }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 "3X^{2} + 5X + 3"
can most easily be entered into Excel in stages.
