Using Excel in Teacher Education for SustainabilityReport as inadecuate

Using Excel in Teacher Education for Sustainability - Download this document for free, or read online. Document in PDF available to download.

Journal of Teacher Education for Sustainability, v18 n2 p89-104 2016

In this study, the feasibility of using Excel software in teaching whole Basic Statistics Course and its influence on the attitudes of pre-service science teachers towards statistics were investigated. One hundred and two pre-service science teachers in their second year participated in the study. The data were collected from the prospective teachers before and after the compulsory Basic Statistics Course. This is a course offered in the third term aiming at introducing the most basic concepts and operations in descriptive and inferential statistics. In the context of this course, it could be argued that in most universities basically four concept groups are addressed: 1) Data and distributions, 2) How values cluster and/or disperse, 3) How variables move, classify or cluster jointly and 4) How the means between different groups differentiate. The statistics course with the content mentioned above is usually handled theoretically and nearly no statistical software is used considering the needs and expectations of pre-service science teachers. In case a software is used, it is generally SPSS in Turkey. SPSS is nearly the standard in the field here and dominates all other software such as SAS etc. On the other hand, Excel with much of its capabilities, accessibility and ease of use, is not considered by most of the academics as sufficient statistical software. In this paper the capabilities, accessibility and practicality of Excel program in teaching most basic statistics course topics to pre-service science teachers were demonstrated and its superiority to other softwares and traditional instruction were discussed. In addition, the positive effect of such an instruction on the attitudes of pre-service teachers towards statistics was shown.

Descriptors: Computer Software, Spreadsheets, Statistics, Preservice Teachers, Student Attitudes, Educational Technology, Technology Uses in Education, Teaching Methods, Science Teachers, Foreign Countries, Instructional Effectiveness, Sustainability, Case Studies, Pretests Posttests, Quasiexperimental Design, Attitude Measures, Control Groups, Experimental Groups, Comparative Analysis

UNESCO Chair on Interplay of Tradition and Innovation in ESD. Parades 1-220, Daugavpils University, Daugavplis LV-5401, Latvia. Tel: 371-6542-5452; Fax: 371-6542-2890; e-mail: unescochair[at]; Web site:

Author: Aydin, Serhat


Related documents