Spreadsheets and Spreadsheeting
I found that our work on spreadsheets was extremely useful and gave me better understanding of how spreadsheets work as well as being fun and enjoyable. I also got a better understanding of how formulas work in excel too.Jarrod C
Spreadsheeting often fits in with the maths department of a school which is understandable with so many great mathematical niceties. BUUUUTTTT spreadsheeting is so useful in other subjects and is an essential skill for all! Spreadsheeting can be done with a number of different tools including Microsoft Excel software, Excel Online, Google Sheets and Numbers. The online versions allow collaboration and edits without any software on any device.
A spreadsheet to build spreadsheet skills:
Over many years this spreadsheet exercise has grown to be in the state that it is now where it starts from scratch and teaches a whole lot of spreadsheeting fun. It is a great progression with enjoyable challenges with the goal to do the sheets as efficiently as possible.
The sheet covers:
– patterns and filling cells with patterns
– writing “functions”
– relative referencing of cells
– absolute referencing of cells
– functions for statistics – quantitative and qualitative data!
– Queries and problem solving
Follow up spreadsheets are to have graphing and charting – check back later!
Get your copy:
It is shared as an excel online sheet at As a Excel Online sheet here! Whoohoo! Just save a copy to open in excel or excel online or Google Sheets or Numbers or. . .. . .. .. and it is yours! Please share the spreadsheets joy!
Note: a Google Spreadsheets version is down below if you prefer. Whoohooo!
Alternatively if you prefer to do it online as a Google Sheet for now at bit.ly/spreadsheets101 A screenshot of the Google spreadsheet is below.
We hope you find the sheet really really nice. Please share the page with others to share the Spreadsheeting joy. We would also love to hear from you in the comments section below.