Kia ora, Reader! This week has been pretty interesting—there’s been a lot of testing lately which I’m pretty sure all of NZ is aware of.
For Maths, I focused on working with spreadsheets. On the oxford book it shows us how to use spreadsheets—though, theirs is quite different, the spreadsheet compared to Google Sheets still works similarly, which gave me the same and designed results.
On the bottom, there should be two texts like links; ‘Task’ and ‘Extra’.
Under the heading ‘Task‘, is based off our oxford books. In our books, they show how spreadsheets work by showing us how to solve 7 times tables.
The first thing we had to do was open a new google spreadsheet, then on column A, row 2, we were told to type the number 1, then on the rest of the rows below, we continue 1 to 10, so the number 10 should end up on A11. On row 1, column A, we write ‘7x’.
On column B (Next to column A), it instructed to type in the number 7 from B2 to B11—reason is, we’re going to times numbers 1 – 10 by 7. The easiest way to write numbers down quickly, is to drag it down by the corner and let go on the designated spot.
To solve it 7 x n, on column C, row 2, the column beside the two, you type in “=a2*b2”—writing this would give you the results to “1 x 7”. By dragging the formula “=a2*b2”, all the way to row C11, it’ll provide you with the answers to 7 times 1 to 10.
The sum is 55. How? On column A12, the number 55 is created by typing in =SUM(a2:a11) (Spaces and uppercase letters aren’t necessary.) Then when returning/entering ‘=Sum(a2:a11)’, you’ll be provided with the sum!
–
The other thing our book showed us, pressing the heading, ‘Extra’, our books showed us what to write next, on our table.
I’m not quite sure what points are for, but basically we were told to write the countries from the book, and the points beside it. Under the column ‘Difference’, I wrote a formula, ‘=B2-C2’, which gives you the answer for 210 – 32. By dragging this formula, you’ll get the answer to all of them. Then selecting A1 to D6, click insert, then choose Chart and then choose column Graph, which’ll give you that data thing.
Using spreadsheets helped me realise how important they are, you could use it financially, data wise and personal use—which are important to keep track of.
I really hope you’ve learnt something on this post, if you’re confused about anything or notice my grammar is off, please inform me so I could fix it for future readers!
Question before you go, Have you ever used spreadsheets before? If so, do you use it for school or just in general? Let me know so I could get ideas on what I could use spreadsheets for! Have a nice day.