Designing SpreadsheetBased Tasks for Purposeful Algebra
 Janet Ainley,
 Liz Bills,
 Kirsty Wilson
 … show all 3 hide
Rent the article at a discount
Rent now* Final gross prices may vary according to local VAT.
Get AccessAbstract
We describe the design of a sequence of spreadsheetbased pedagogic tasks for the introduction of algebra in the early years of secondary schooling within the Purposeful Algebraic Activity project. This design combines two relatively novel features to bring a different perspective to research in the use of spreadsheets for the learning and teaching of algebra: the tasks which are purposeful for pupils and contain opportunities to appreciate the utility of algebraic ideas, and careful matching of the affordances of the spreadsheet to the algebraic ideas which are being introduced. Examples from two tasks are used to illustrate the design process. We then present data from a teaching programme using these tasks to highlight connections between aspects of the task design and the construction of meanings for variable.
 Ainley, J. Constructing purposeful mathematical activity in primary classrooms. In: Tikly, C., Wolf, A. eds. (2000) The Maths We Need Now. Bedford Way Papers, London
 Ainley, J. and Pratt, D. (2002). Purpose and utility in pedagogic task design. In A. Cockburn and E. Nardi (Eds), Proceedings of the 26th Annual Conference of the International Group for the Psychology of Mathematics Education, Vol. 2 (pp. 17–24). UK.
 Ainley, J., Pratt, D. and Hansen, A. (forthcoming). Connecting engagement and focus in pedagogic task design. British Educational Research Journal
 Ainley, J., Wilson, K. and Bills, L. (2003). Generalising the context and generalising the calculation. In N.A. Pateman, B.J. Dougherty and J. Zilliox (Eds), Proceedings of the 27th Annual Conference of the International Group for the Psychology of Mathematics Education, Vol. 2 (pp. 9–16). Honolulu.
 Ainley, J., Bills, L. and Wilson, K. (2005). Purposeful task design and the emergence of transparency. Proceedings of the 29th Annual Conference of the International Group for the Psychology of Mathematics Education.
 Brousseau, G. In: Balacheff, N., Cooper, M., Sutherland, R., Warfield, V. eds. (1997) Theory of Didactical Situations. Kluwer Academic Publishers, Dordrecht
 Carraher, D., Schliemann, A. and Brinzuela, B. (2001). Can young students operate on unknowns? In M. van den HeuvelPanhuizen (Ed.), Proceedings of the 25th Annual Conference of the International Group for the Psychology of Mathematics Education, Vol. 1 (pp. 130–140). Netherlands.
 Cooper, C., Dunne, M. (2000) Assessing Children’s Mathematical Knowledge. Open University Press, Buckingham
 Dettori, G., Garuti, R., Lemut, E. From arithmetic to algebraic thinking by using a spreadsheet. In: Sutherland, R., Rojano, T., Bell, A., Lins, R. eds. (2001) Perspectives on School Algebra. Kluwer, Dordrecht
 Filloy, E., Rojano, T. (1989) Solving equations: The transition from arithmetic to algebra. For the Learning of Mathematics 9: pp. 1925
 Harel, G. (1998) Two dual assertions: The first on learning and the second on teaching (or vice versa). American Mathematical Monthly 105: pp. 497507
 Herscovics, N., Linchevski, L. (1994) A cognitive gap between arithmetic and algebra. Educational Studies in Mathematics 27: pp. 5978 CrossRef
 Kieran, C. The changing face of school algebra. In: Alsina, C., Alvares, J.M., Hodgson, B., Laborde, C., A., Pérez eds. (1996) Proceedings of the Eighth International Congress on Mathematics Education: Selected Lectures. S.A.E.M., Seville, pp. 271290
 Nunes, T., Schliemann, A.D., Carraher, D.W. (1993) Street Mathematics and School Mathematics. Cambridge University Press, Cambridge
 Radford, L. (2000) Signs and meanings in students’ emergent algebraic thinking: A semiotic analysis. Educational Studies in Mathematics 42: pp. 237268 CrossRef
 Radford, L. (2002) The seen, the spoken and the written. A semiotic approach to the problem of objectification of mathematical knowledge. For the Learning of Mathematics 22: pp. 1423
 Radford, L. (2003) Gestures, speech and the sprouting of signs: A semioticcultural approach to students’ types of generalization. Mathematical Thinking and Learning 5: pp. 3770 CrossRef
 Radford, L., Bardini, C. and Sabena, C. (2005). Perceptual semiosis and the microgenesis of algebraic generalizations. Proceedings of the 4th congress of the European society for Research in Mathematics Education. Barcelona, Spain.
 Schliemann, A. (1995). Some concerns about bringing everyday mathematics to mathematics education. In L. Meira and D. Carraher (Eds), Proceedings of the 19th Annual Conference of the International Group for the Psychology of Mathematics Education, Vol. 1 (pp. 45–60). Brazil.
 Stacey, K. and MacGregor, M. (1997). Multiple referents and the shifting meanings of unknowns in students’ use of algebra. In E. Pehkonen (Ed.), Proceedings of the 21st Annual Conference of the International Group for the Psychology of Mathematics Education, Vol. 4 (pp. 190–197). Finland.
 Sutherland, R. (1991) Some unanswered research questions on the teaching and learning of algebra. For the Learning of Mathematics 11: pp. 4046
 Sutherland, R. (1993). Project AnA–the gap between arithmetic and algebra (R000232132). Final report to ESRC. Institute of Education, University of London.
 Sutherland, R., Rojano, T. (1993) A spreadsheet approach to solving algebra problems. Journal of Mathematical Behaviour 12: pp. 353383
 Tabach, M. and Friedlander, A. (2004). Levels of student responses in a spreadsheetbased environment. In M. Johnsen Høines and A.B. Fuglestad (Eds), Proceedings of the Twenty Eighth Annual Conference of the International Group for the Psychology of Mathematics Education, Vol. 2 (pp. 423–430). Bergen University College.
 Ursini, S. and Trigueros, M. (2001). A model for the uses of variable in elementary algebra. In M. van den HeuvelPanhuizen (Ed.), Proceedings of the 25th Annual Conference of the International Group for the Psychology of Mathematics Education, Vol. 4 (pp. 335–342). Netherlands.
 Wilson, K., Ainley, J. and Bills, L. (2004). Spreadsheet generalising and paper and pencil generalising. In M. Johnsen Høines and A. B. Fuglestad (Eds), Proceedings of the 28th Annual Conference of the International Group for the Psychology of Mathematics Education, Vol. 4 (pp. 441–448). Norway.
 Title
 Designing SpreadsheetBased Tasks for Purposeful Algebra
 Journal

International Journal of Computers for Mathematical Learning
Volume 10, Issue 3 , pp 191215
 Cover Date
 20051201
 DOI
 10.1007/s1075800584209
 Print ISSN
 13823892
 Online ISSN
 15731766
 Publisher
 Kluwer Academic Publishers
 Additional Links
 Topics
 Keywords

 algebra
 spreadsheets
 task design
 variable
 Authors

 Janet Ainley ^{(1)}
 Liz Bills ^{(2)}
 Kirsty Wilson ^{(1)}
 Author Affiliations

 1. Institute of Education, University of Warwick, Coventry, CV4 7AL, UK
 2. School of Education and Lifelong Learning, University of East Anglia, Norwich, UK