Posted on: Thursday 7th December 2023

Year 6 have started their Computing topic - spreadsheets.

After recapping on our prior knowledge of spreadsheets (what they are used for and what they can do), we learnt that everything in a spreadsheet goes into a cell (like a box in a grid) & each cell is named by the row and column in which it is located. We also found out that cells can be formatted to look clearer or more interesting, similar to word processing or desktop publishing. We established that one advantage of spreadsheets is the ability to do calculations quickly, like a calculator. We began by completing simple formulas, beginning with just number addition, typing any numbers into cells and then using the SUM function to add the contents of two cells (e.g. =SUM(B5+B6). Then, we extended to calculations for subtracting, multiplying and dividing