The One With The Spreadsheets

Today we continued our work on spreadsheets in Computing. We were taught how to create a table in Google Sheets and write in spelling results for 15 children over a six week period. With all the data put into the table, we were then shown how to use the SUM function to add up the children’s spelling results and to use the AVERAGE function to find an average score for each child. To challenge us further, we were then show how to order columns alphabetically or order totals in ascending/descending order.