Leanne M. Avery

Excel as a Qualitative Data Analysis Tool

Qualitative research seeks to examine the interconnections in rich, complex data sources. The statistical tools of quantitative methods separate out pieces of data in a manner that defeats the purpose. But, like quantitative researchers, qualitative researchers often still find themselves overwhelmed by the amount of data and equally in need of tools to extend their human senses. This has led the development of a number of software packages designed for this purpose. An often overlooked option, however, is Microsoft Excel. Excel is generally considered a number cruncher. However, its structure and data manipulation and display features can be utilized for qualitative analysis. In this article, the authors discuss data preparation, analysis, and presentation, including discussion of lesser known features of Excel.

An Analysis of Knowledge Structure, Diversity and Diagnostic Abilities Among Pre-Service Science Teachers Within the Domain of Oxidation and Reduction Chemistry

The purpose of this study was to investigate the development of preservice science teachers’ knowledge structures in the domain of oxidation and reduction chemistry. Knowledge structures were elicited through video-recorded semi-structured interviews before and after the unit of instruction, and analyzed using a visual flow map representation. Paralleling these interviews, the preservice teachers were tasked with diagnosing middle school students’ scientific understandings. Data analyzed quantitatively and qualitatively showed large variation in knowledge structure complexity across the preservice teachers, strong correlations between measures of knowledge structure and diversity (as defined by the Shannon Wiener diversity index), and the development of more balanced knowledge structure representations. For most preservice teachers, their diagnostic scores of the middle school students showed a small increase.

A third use of sociology of scientific knowledge: a lens for studying teacher practice

Over the last two decades, science educators and science education researchers have grown increasingly interested in utilising insights from the sociology of scientific knowledge (SSK) to inform their work and research. To date, researchers in science education have focused on two applications: results of sociological studies of science have been used to define new areas of content, generally referred to as Nature of Science (NOS). This has included research into students’ understanding of the NOS, teachers’ understanding of the NOS, and inclusion (or exclusion) of NOS themes in curricula. A second vein of inquiry has been investigations that consider the classroom as a microcosm of scientific discourse and inquiry. Such research has included investigations of student‐to‐student and student‐to‐teacher interactions. In this paper, we present a third application for educational research – the investigation of teacher knowledge and practice as sociological phenomena. In addition to supporting scholarly research, we believe it can be a useful tool for illuminating the complexities of teaching that needs to be taken into account by policy makers and practitioners. In this paper, we provide a thematic review of concepts from the sociology of scientific knowledge, and their application to a case of teacher work.