Case study: Interactive spreadsheets

Abstract

This paper describes how the Department of Statistics at the University of Cape Town (UCT) currently uses interactive spreadsheets to assist students in analysing and preparing summaries of data. It explores some of the potential benefits of making such resources more freely available to others as Open Educational Resources (OER), and outlines the key issues which would need to be resolved in order to do so. To this end, this paper discusses the pedagogical needs that led to the lecturers using the spreadsheet program MSExcel to encourage students to engage actively with statistical processes. It describes how the lecturers and students use these interactive spreadsheets and examines how well these interactive spreadsheets seemed to have worked, so that others who may have similar pedagogical needs can be alerted to the advantages and disadvantages of using this type of technology. In addition, this paper explores the possibility of these interactive spreadsheets being offered as OER first to other departments at UCT and then to a broader community.