<abstract xmlns="http://www.w3.org/1999/xhtml">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.</abstract>

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.

Using Excel in Teacher Education for Sustainability

Journal of Teacher Education for Sustainability

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

{"article-title":"Using Excel in Teacher Education for Sustainability"}

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...

Using Excel in Teacher Education for Sustainability

Publicado en línea: 30 dic 2016

Páginas: 89 - 104

DOI: https://doi.org/10.1515/jtes-2016-0017

Palabras clave
Teacher Education, ICT, Excel, Statistics, Attitudes

© 2016 Serhat Aydın, published by De Gruyter Open

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Using Excel in Teacher Education for Sustainability

Publicado en línea: 30 dic 2016

Páginas: 89 - 104

DOI: https://doi.org/10.1515/jtes-2016-0017

Palabras claveTeacher Education, ICT, Excel, Statistics, Attitudes

© 2016 Serhat Aydın, published by De Gruyter Open

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Palabras clave
Teacher Education, ICT, Excel, Statistics, Attitudes