Abstract
This chapter addresses the differential effects on learning outcomes of two instructional strategies in an introductory course on solving database query problems using a relational database. In both strategies a problem-solving method was explicitly presented to grade 10 high school students. One strategy involved a top-down approach in solving the problems, while in the other strategy problems were approached in a bottom-up fashion. Although the top-down approach is considered to be superior in solving problems in general, it is hypothesized that for novices this is only the case if they possess relatively much relevant knowledge and skills. For querying a relational database logical reasoning, knowledge of set theory and the ability to identify relevance and sufficiency of data are supposed to be important. It is hypothesized that for high-ability students (with respect to the knowledge and skills mentioned) the top-down approach will be superior to the bottom-up approach, but for low-ability students the bottom-up approach will yield better results. For low-ability students the data supports the hypothesis; for high-ability students however, presenting different problem-solving strategies did not result in significant differences in learning outcomes. After discussing these results, plans for further research will be presented.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Anderson, J.R., and Jeffries, R.: Novice LISP errors: Undetected losses of information from working memory. Human-Computer Interaction. 1, 107–131 (1985)
Bradley, C.A.: The relationship between students’ information-processing styles and logo programming. Journal of Educational Computing Research. 1, 427–433 (1985)
Brooks, R.: Towards a theory of the cognitive processes in computer programming. International Journal of Man-Machine Studies. 9, 737–751 (1977)
Chi, M.T.H., Feltovich, P.J., and Glaser, R.: Categorization and representation of physics problems by experts and novices. Cognitive Science. 5, 121–152 (1981)
Dahl, O.J., Dijkstra, E.W., and Hoare, C.A.R.: Structured Programming. London: Academic Press 1972
De Corte, E., and Verschaffel, L.: Journal of Structural Learning. 9, 161–174 (1986)
De Jong, T. and Ferguson-Hessler, M.G.M.: Cognitive structures of good and poor novice problem solvers in physics. Journal of Educational Psychology. 78, 279–288 (1986)
Doyle, W.: Academic Work. Review of Educational Research. 53, 159–199 (1983)
Elshout, J.J.: Problem-solving and education. In: Learning and instruction. (E. De Corte, H. Lodewijks, R. Parmentier and P. Span, eds.). pp. 259–273. Oxford: Pergamon Books/Leuven: University Press 1987
Finnie, G.R.: Is top-down natural?: Some experimental results from non-procedural languages. International Journal of Man-Machine Studies. 25, 469–478 (1986)
Glaser, R.: Learning theory and theories of knowledge. In: Learning and Instruction. (E. De Corte, H. Lodewijks, R. Parmentier and P. Span, eds.). pp. 397–414. Oxford: Pergamon Books/Leuven: University Press 1987
Jeffries, R., Turner, A.A., Poison, P.G., and Atwood, M.E.: The processes involved in designing software. In: Cognitive skills and their acquisition. (J.R. Anderson, ed.). pp. 255–284. Hillsdale, NJ: Lawrence Erlbaum 1981
Larkin, J.H., McDermott, J., Simon, D.P., and Simon, H.A.: Models of competence in solving physics problems. Cognitive Science. 4, 317–345 (1980)
Linn, M.C., and Dalbey, J.: Cognitive consequences of programming instruction: Instruction, access, and ability. Educational Psychologist. 20, 191–206 (1985)
Littlefield, J., Declos, V.R., Lever, S., Clayton, K.N., Bransford, J.D., and Franks, J.J.: Learning logo: Method of teaching, transfer of general skills, and attitudes toward school and computers. In: Teaching and learning computer programming: Multiple research perspectives. (R.E. Mayer, ed.). pp. 111–135. Hillsdale, NJ: Lawrence Erlbautn 1988
McKeithen, K.B., Reitman, J.S., Rueter, H.H., and Hirtle, S.C.: Knowledge organization and skill differences in computer programmers. Cognitive Psychology. 13, 307–325 (1981)
Pea, R.D., and Kurland, D.M.: On the cognitive effects of learning computer programming: A critical look. New Ideas in Psychology. 2, 137–168 (1984)
Perkins, D.N., and Martin, F.: Fragile knowledge and neglected strategies in novice programmers. In: Empirical studies of programmers. (E. Soloway and S. Iyengar, eds.). pp. 213–229. Norwood, NJ: Ablex 1986
Perkins, D.N., and Salomon, Ci.: Are cognitive skills context-bound? Educational Researcher. 18, 16–25 (1989)
Reitsma, E.H.: Grenzen en beperkingen van SQL. Informatie. 27, 198–201 (1985)
Remmen, F.: Hoe vriendelijk zijn vraagtalen in het gebruik? htfonnatie. 27, 666–673 (1985)
Sweller, J.: Cognitive load during problem solving: Effects on learning. Cognitive Science. 12, 257–285 (1988)
Tromp, Th.J.M.: The acquisition of expertise in computer programming. Dissertation. Amsterdam: University of Amsterdam 1989
Van Merrienboer, J.J.G., and Krammer, H.P.M.: Instructional strategies and tactics for the design of introductory computer programming courses in high school. Instructional Science. 16, 251–285 (1987)
Van Merrienboer, JJ.G., and Paas, F.: Automation and schema acquisition in learning elementary computer programming: Implications for the design of practice. Computers in Human Behavior. 6, 3, 273–289 (1990)
Veenman, M.V.J. and Elshout, J.J.: De meerwaarde van een goede probleemaanpak. Tijdschrift voor Onderwijsresearch. 15, 337–346 (1990)
White, C.S.: The impact of structured activities with a computer-based file-management program on selected information-processing skills. Dissertation. Bloomington, IN: Indiana University 1985
White, C.S.: Developing information-processing skills through structured activities with a computerized file-management program. Journal of Educational Computing Research. 3, 355–375 (1987)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1992 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
van Dijk, E.M.A.G. (1992). Instructional strategies for teaching database query languages. In: Dijkstra, S., Krammer, H.P.M., van Merriënboer, J.J.G. (eds) Instructional Models in Computer-Based Learning Environments. NATO ASI Series, vol 104. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-02840-7_17
Download citation
DOI: https://doi.org/10.1007/978-3-662-02840-7_17
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-08148-4
Online ISBN: 978-3-662-02840-7
eBook Packages: Springer Book Archive