Investigating teaching and learning of Grade 9 Algebra through excel spreadsheets : a mixed-methods case study for Lesotho

[摘要] ENGLISH ABSTRACT: The teaching and learning of algebra in the middle school grades in Lesotho is dominated by the mechanistic approach where learners are drilled on procedures for solving certain types of problems in algebra, without making any connection to the experience learners had with arithmetic. This is one of the sources of learners' difficulties in mathematics. Research indicates that use of spreadsheets such as Excel has a potential of bridging the gap between arithmetic and algebra and thus enhancing the teaching and learning of algebra, making it meaningful to the learners.The study sought to answer the question: How do Grade 9 learners in Lesotho experience teaching and learning of algebra through Excel spreadsheets? The research commenced with a literature review that was followed by the empirical study. The theories of instrumental genesis and instrumental orchestration were identified as the framework for the investigation. Instrumental genesis is the process in which learners develop facility with the artifact as they use it towards achieving lesson objectives; technical (conceptual, mechanical) and personal (attitudes, behavior and preferred learning styles) aspects of learners' experiences were identified. Instrumental orchestration is the steering of learners' instrumental genesis by the teacher and the manner in which this process is carried out, depends on the teacher's Technological Pedagogical Content Knowledge (TPCK).The research was a multi-case study following a mixed-methods approach, where both qualitative and quantitative methods were used. The empirical study was conducted in two schools in Lesotho. In each school, fifteen learners volunteered participation. The investigation was done through classroom teaching by me as the researcher. The focus was on what challenges learners encountered and how they benefited from their 'spreadsheets algebra learning experience. Data were collected through classroom observations where field notes were recorded and an observation schedule was used by the researcher and the Assistant Observer respectively. A questionnaire was also administered to all learner participants after the whole teaching period. Six learners, representative of high, medium and low performances in class, were also interviewed with a goal of finding out their experiences. The Assistant Observer was also interviewed to reduce the bias that may result from to the researcher studying her own practiceThe study found that learners experiences with learning algebra through spreadsheets, comprised of both challenges and benefits. The challenges encountered by learners could be classified into those that were school-based and those that were instruction-based. The school-based challenges related to inadequate physical structures and lack of well-functioning equipment in the computer laboratories. Instruction-based challenges encountered by learners were both technical and personal. Technical challenges related to the physical manipulation of the artifact and the lack of understanding of concepts involved, where the spreadsheets meet the algebra. Personal challenges related to learners' attitude and behavior towards use of spreadsheets for algebra teaching and learning. While school authorities could address some of the challenges, it was found that both the teacher and learners could initiate strategies that could be used to overcome the instruction-based challenges. Teaching strategies such as 'technical-demo, 'explain-the-screen, 'discuss-the–screen, 'link-screen-board and 'spot-and-show (building on learners' responses), and the general organization of classroom environment were helpful in orchestrating algebra learning within the spreadsheets. It was also found that use of spreadsheets had both cognitive and affective values for the learners.Even though use of spreadsheets may benefit both teachers and learners in algebra teaching and learning, implementation of the practice would require critical considerations in terms of teacher preparation and infra-structural improvements in the schools.

[发布机构] Stellenbosch University