14 May 2018

Spreadsheets, statistics, mathematics and computational thinking

We need to teach all our students how to design, create, test, debug and use spreadsheets. We need to teach this integrated with mathematics, statistics and computational thinking. Spreadsheets can be a valuable tool in many other subject areas including biology, physics, history and geography, thus facilitating integrated learning experiences. Spreadsheets are versatile and ubiquitous – and most have errors. A web search on “How many spreadsheets have errors?” gives alarming results. The commonly quoted figure is 88%. These spreadsheets with errors are not just little home spreadsheets for cataloguing your Lego collection or planning your next vacation. These spreadsheets […]
15 May 2012

Excel in Statistics and Operations Research

I love spreadsheets The spreadsheet package is a wondrous thing. It has revolutionized a great many processes in the office, home and scientific research. It has affected the way we think and teach. It has enabled many more people to program and to build models, without even knowing it (and sometimes very badly). And, for better or worse, Excel has become the default spreadsheet package. I love spreadsheets and I love Excel.  I first became acquainted with Multiplan and Lotus-123 in 1984 as part of my graduate degree. It was amazing to see how versatile these spreadsheets were. Since then […]