Applying Algebra

In maths so far this term we have been learning about expressions and formulae in algebra. This week we applied our learning to creating spreadsheets. Students were required to use formula to create their spreadsheets rather than manually entering their data. This was a challenge for many, but once we had completed a few, most were impressed with the convenience and ease that calculations and tables can be created. Early finishers also explored how tables of data can be transformed into informational graphs.
We used real life problems and dilemmas as a basis for our spreadsheet creations.
Here is an example of one Lucy created- she was solving the problem of which saving behaviour would be the most successful when analysed over a period of time, and if slight chances were made in individual saving choices, the impact this would have on achieving their personal targets.  .

week	bill	mandy
0	86	47
1	95	58
2	104	69
3	113	80
4	122	91
5	131	102
6	140	113
7	149	124
8	158	135
9	167	146
10	176	157
11	185	168
12	194	179
13	203	190
14		201