|
Year 6 use Publisher
Year 6 use Excel
| |
Year 6 have been modelling with excel to find area of rectangles. Using
formulas and changing data. We found that by using formulas would could
continually change data and excel would work out the area.
| Shape |
Length |
Width |
Formula |
Area |
| Green |
12 |
8 |
=B3*C3 |
96 |
| Pink |
6 |
14 |
=B4*C4 |
84 |
| Light
blue |
7 |
18 |
=B5*C5 |
126 |
| Purple |
11 |
7 |
=B6*C6 |
77 |
| Brown |
15 |
9 |
=B7*C7 |
135 |
| Orange |
4 |
8 |
=B8*C8 |
32 |
Length
 Width
| Shape |
Length |
Height |
Formula |
Area |
| Blue |
7 |
6 |
=(B21*C21)/2 |
21 |
| Red |
6 |
12 |
=(B22*C22)/2 |
36 |
| Orange |
9 |
7 |
=(B23*C23)/2 |
31.5 |
| Green |
15 |
15 |
=(B24*C24)/2 |
112.5 |
Height
Length
| Name |
Height |
Length of
Jump |
| David |
138 |
207 |
| Mark |
144 |
216 |
| Abigail |
139 |
199 |
| Ishmail |
148 |
255 |
| Tariq |
149 |
300 |
| Zenna |
142 |
222 |
| Ben |
129 |
213 |
| Sam |
134 |
201 |
| Mary |
140 |
234 |
| Becky |
146 |
215 |
| Alison |
133 |
205 |
| Neal |
140 |
215 |
| Masako |
139 |
228 |
| Jill |
140 |
235 |
| Louise |
135 |
202 |
| Total |
2096 |
3347 |
| Average |
139.7 |
223.1333333 |
 
|
