The impact of sequencing and prior knowledge on learning mathematics through spreadsheet applications

Abstract

According to cognitive load theory, instruction needs to be designed in a manner that facilitates the acquisition of knowledge in long-term memory while reducing unnecessary demands on working memory. When technology is used to deliver instruction, the sequence in which students learn to use the technology and learn the relevant subject matter may have cognitive load implications, and should interact with their prior knowledge levels. An experiment, using spreadsheets to assist student learning of mathematics, indicated that for students with little knowledge of spreadsheets, sequential instruction on spreadsheets followed by mathematics instruction was superior to a concurrent presentation. The reverse was found for students with more knowledge of spreadsheets. These results are explained in terms of cognitive load theory.