TEACHING DATABASE ANALYSIS AND DESIGN IN A WEB-BASED CONSTRUCTIVIST LEARNING ENVIRONMENT

Thomas M. Connolly, Carolyn E. Begg

2006

Abstract

The study of database systems is typically core in undergraduate and postgraduate courses related to computer science and information systems. However, there are parts of this curriculum that learners find difficult, in particular, the abstract and complex domain of database analysis and design, an area that is critical to the development of modern information systems. This paper reflects on these difficulties and describes an approach for teaching database analysis and design online motivated by principles found in the constructivist epistemology, which helps to overcome these difficulties and provides the learner with the knowledge and higher-order skills necessary to understand and perform database analysis and design effectively as a professional practitioner. The paper presents some preliminary results of this work and reflects on the findings.

References

  1. Armarego, J. (2002). Advanced Software Design: A Case in Problem-Based Learning. In Proceedings of the 15th Conference on Software Engineering Education and Training (pp. 44-54). 25-27 February 2002, Covington, Kentucky, USA.
  2. Ben-Ari, M. (2001). Constructivism in Computer Science Education, Journal of Computers in Mathematics and Science Teaching, 20(1), 45-73.
  3. Brown, J.S., Collins, A., & Duguid, P. (1989). Situated cognition and the culture of learning, Educational Researcher, 18(1), 32-42.
  4. Bubenko, J. (1995). Challenges in Requirements Engineering. Keynote address. In Second IEEE International Symposium on Requirements Engineering. York, England.
  5. Budgen, D. (1995). Is teaching software design a 'wicked' problem too? In Proceedings of the 8th SEI Conference on Software Engineering Education (pp. 239-254). New Orleans (La).
  6. Collins, A., Brown, J.S., & Newman, S.E. (1989). Cognitive Apprenticeship: Teaching the Craft of reading, writing, and mathematics. In L. Resnick (Ed.). Knowing, Learning, and Instruction: Essays in Honor of Robert Glaser. Hillsdale, NJ: Lawrence Erlbaum.
  7. Connolly, T.M. & Begg, C.E. (2006). A ConstructivistBased Approach to Teaching Database Analysis and Design, Journal of Information Systems Education (accepted for publication).
  8. Connolly, T.M. & Stansfield, M.H. (2006). From eLearning to Games-based eLearning: Using Interactive Technologies in Teaching Information Systems, International Journal of Information Technology Management (submitted).
  9. Connolly, T.M., MacArthur, E., Stansfield, M.H., & McLellan, E. (2006). A Quasi-Experimental Study of Three Online Learning Courses in Computing, Journal of Computers and Education (in print).
  10. Connolly, T.M., Stansfield, M.H, & McLellan, E. (2005). An Online Games-Based Collaborative Learning Environment to Teach Database Analysis and Design, In Proceedings of 4th IASTED International Conference on Web-Based Education. Grindelwald, Switzerland, February 2005.
  11. DeGrace, P. & Hulet Stahl, L. (1998). Wicked Problems, Righteous Solutions: A Catalog of Modern Engineering Paradigms, Prentice Hall.
  12. Forman, E. & McPhail, J. (1993). Vygotskian perspectives on children's collaborative problem-solving activities, In E.A. Forman, N. Minick, and C. Addison Stone (Eds.). Contexts for learning. Sociocultural dynamics in children's development. Oxford University Press.
  13. Gance, S. (2002). Are constructivism and computer-based learning environments incompatible?, Journal of the Association for History and Computing, V(1).
  14. Gruba, P. & Søndergaard, H. (2001). A constructivist approach to communication skills instruction in computer science, Computer Science Education, 11(3), 203-219.
  15. Hadjerrouit, S. (1999). A Constructivist Approach to Object-Oriented Design and Programming. In Proceedings of 4th Annual SIGCSE/SIGCUE Conference on Innovation and Technology in Computer Science Education (ITiCSE'99), 171-174.
  16. Koehler, M.J. & Mishra, P. (2005). Teachers Learning Technology by Design, Journal of Computing in Teacher Education, 21(3), Spring 2005.
  17. Mohtashami, M. & Scher, J.M. (2000). Application of Bloom's Cognitive Domain Taxonomy to Database Design. In Proceedings of ISECON (Information Systems Educators Conference) 2000. Philadelphia.
  18. Papert, S. (1980). Mindstorms: children, computers and powerful ideas, Basic Books.
  19. Pullen, M. (2001). The Network Workbench and Constructivism: Learning Protocols by Programming, Computer Science Education, 11(3), 189-202.
  20. Schön, D.A. (1983). The Reflective Practitioner: How Professionals Think in Action. Basic Books: New York.
  21. Taxén, G. (2003). Teaching Computer Graphics Constructively. In Proceedings of International Conference on Computer Graphics and Interactive Techniques (pp. 1-4). San Diego, California.
  22. Wilson, B. (1996). Constructivist learning environments: Case studies in instructional design. Educational Technology Publications: New Jersey.
Download


Paper Citation


in Harvard Style

M. Connolly T. and E. Begg C. (2006). TEACHING DATABASE ANALYSIS AND DESIGN IN A WEB-BASED CONSTRUCTIVIST LEARNING ENVIRONMENT . In Proceedings of WEBIST 2006 - Second International Conference on Web Information Systems and Technologies - Volume 2: WEBIST, ISBN 978-972-8865-47-4, pages 164-171. DOI: 10.5220/0001240301640171


in Bibtex Style

@conference{webist06,
author={Thomas M. Connolly and Carolyn E. Begg},
title={TEACHING DATABASE ANALYSIS AND DESIGN IN A WEB-BASED CONSTRUCTIVIST LEARNING ENVIRONMENT},
booktitle={Proceedings of WEBIST 2006 - Second International Conference on Web Information Systems and Technologies - Volume 2: WEBIST,},
year={2006},
pages={164-171},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001240301640171},
isbn={978-972-8865-47-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of WEBIST 2006 - Second International Conference on Web Information Systems and Technologies - Volume 2: WEBIST,
TI - TEACHING DATABASE ANALYSIS AND DESIGN IN A WEB-BASED CONSTRUCTIVIST LEARNING ENVIRONMENT
SN - 978-972-8865-47-4
AU - M. Connolly T.
AU - E. Begg C.
PY - 2006
SP - 164
EP - 171
DO - 10.5220/0001240301640171