skip to main content
research-article

Learning SQL Programming with Interactive Tools: From Integration to Personalization

Published: 01 January 2010 Publication History

Abstract

Rich, interactive eLearning tools receive a lot of attention nowadays from both practitioners and researchers. However, broader dissemination of these tools is hindered by the technical difficulties of their integration into existing platforms. This article explores the technical and conceptual problems of using several interactive educational tools in the context of a single course. It presents an integrated Exploratorium for database courses, an experimental platform, which provides personalized access to several types of interactive learning activities. Several classroom studies of the Exploratorium have demonstrated its value in both the integration of several tools and the provision of personalized access.

References

[1]
Berge, Z. L. 2002. Active, interactive, and reflective eLearning. Q. Rev. Dist. Educ. 3, 2, 181--190.
[2]
Brusilovsky, P. 2004. KnowledgeTree: A distributed architecture for adaptive e-learning. In Proceedings of the 13th International World Wide Web Conference (WWW’04). 104--113.
[3]
Brusilovsky, P. and Eklund, J. 1998. A study of user-model based link annotation in educational hypermedia. J. Univ. Comput. Sci. 4, 4, 429--448.
[4]
Brusilovsky, P., Mitrovic, A., Sosnovsky, S., Mathews, M., Yudelson, M., Lee, D., Zadorozhny, V. 2009. Database exploratorium: A semantically integrated adaptive educational system. In Proceedings of the Ubiquitous User Modeling Workshop at the 17th International Conference on User Modeling, Adaptation, and Personalization (UMAP’09).
[5]
Brusilovsky, P. and Pesin, L. 1998. Adaptive navigation support in educational hypermedia: An evaluation of the ISIS-Tutor. J. Comput. Inform. Techn. 6, 1, 27--38.
[6]
Brusilovsky, P. and Peylo, C. 2003. Adaptive and intelligent Web-based educational systems. Int. J. AI Educ. 13, 2-4, 159--172.
[7]
Brusilovsky, P. and Sosnovsky, S. 2005. Engaging students to work with self-assessment questions: A study of two approaches. In Proceedings of the 10th Annual Conference on Innovation and Technology in Computer Science Education (ITiCSE’05). 251--255.
[8]
Brusilovsky, P., Sosnovsky, S., and Yudelson, M. 2009b. Addictive links: The motivational value of adaptive link annotation, New Rev. Hypermedia Multimedia 15, 1, 97--118.
[9]
Brusilovsky, P., Yudelson, M., and Sosnovsky, S. 2004. An adaptive e-learning service for accessing Interactive examples. In Proceedings of the World Conference on E-Learning (E-Learn’04). 2556--2561.
[10]
Conlan, O. and Wade, V. P. 2004. Evaluation of APeLS: An adaptive eLearning service based on multi-model, metadata-driven approach. In Proceedings of the 3rd International Conference on Adaptive Hypermedia and Adaptive Web-Based Systems (AH’04). 291--295.
[11]
Dagger, D., Conlan, O., and Wade, V. P. 2003. An architecture for candidacy in adaptive eLearning systems to facilitate the reuse of learning resources. In Proceedings of the World Conference on E-Learning (E-Learn’03). 49--56.
[12]
Davidovic, A., Warren, J., and Trichina, E. 2003. Learning benefits of structural example-based adaptive tutoring systems. IEEE Trans. Educ. 46, 2, 241--251.
[13]
Dieberger, A., Dourish, P., Höök, K., Resnick, P., and Wexelblat, A. 2000. Social navigation: Techniques for building more usable systems. Interactions 7, 6, 36--45.
[14]
Douce, C., Livingstone, D., and Orwell, J. 2005. Automatic test-based assessment of programming: A review. ACM J. Educ. Res. Comput. 5, 3, Article 4.
[15]
Guimaraes, M. 2006. The Kennesaw Database Courseware (KDC): Strong points, weak points, and experience using it in a classroom environment. J. Comput. Sci. Coll. 21, 3, 91--96.
[16]
Hauk, S. and Segalla, A. 2005. Student perceptions of the Web-based homework program WeBWorK in moderate enrollment college algebra classes. J. Comput. Math. Sci. Teach. 24, 3, 229--253.
[17]
Higgins, C., Gray, G., Symeonidis, P., and Tsintsifas, A. 2005. Automated assessment and experiences of teaching programming. ACM J. Educ. Res. Comput. 5, 3, Article 5.
[18]
Joy, M., Griffiths, N., and Boyatt, R. 2005. The BOSS online submission and assessment system. ACM J. Educ. Res. Comput. 5, 3, Article 2.
[19]
Kenny, C. and Pahl, C. 2005. Automated tutoring for a database skills training environments. In Proceedings of the 36th SIGCSE Technical Symposium on Computer Science Education (SIGCSE’05). 58--62.
[20]
Masthoff, J. 2002. Design and evaluation of a navigation agent with a mixed locus of control. In Proceedings of the 6th International Conference on Intelligent Tutoring Systems (ITS’02). 982--991.
[21]
Mitrovic, A. 2003. An intelligent SQL tutor on the Web. Int. J. AI Educ. 13, 2-4, 173--197.
[22]
Nuzzo-Jones, G., Walonoski, J., Heffernan, N., and Livak, T. 2005. The eXtensible tutor architecture: A new foundation for ITS. In Proceedings of the Workshop on Adaptive Systems for Web-based Education at 12th International Conference on Artificial Intelligence in Education (AIED’05). 1--7.
[23]
Pahl, C., Barrett, R., and Kenny, C. 2004. Supporting active database learning and training through interactive multimedia. In Proceedings of the 9th Annual SIGCSE Conference on Innovation and Technology in Computer Science Education (ITiCSE’04). 27--31.
[24]
Reeves, T. C. 1999. A research agenda for interactive learning in the new millennium. In Proceedings of the 11th World Conference on Educational Multimedia, Hypermedia and Telecommunications (EMHT’99). 15--20.
[25]
Rey-López, M., Brusilovsky, P., Meccawy, M., Díaz-Redondo, R. P., Fernández-Vilas, A., and Ashman, H. 2008. Resolving the problem of intelligent learning content in learning management systems. IJEL 7, 3, 363--381.
[26]
Sosnovsky, S., Brusilovsky, P., Lee, D. H., Zadorozhny, V., and Zhou, X. 2008. Reassessing the value of adaptive navigation support in e-learning. In Proceedings of the 5th International Conference on Adaptive Hypermedia and Adaptive Web-Based Systems (AH’08). 193--203.
[27]
Specht, M. 1998. Empirical evaluation of adaptive annotation in hypermedia. In Proceedings of the 10th World Conference on Educational Multimedia and Hypermedia and World Conference on Educational Telecommunications (EDMEDIA/EDTELECOM’98). 1327--1332.
[28]
Trella, M., Carmona, C., and Conejo, R. 2005. MEDEA: An open service-based learning platform for developing intelligent educational systems for the Web. In Proceedings of the Workshop on Adaptive Systems for Web-based Education at 12th International Conference on Artificial Intelligence in Education (AIED’05). 27--34.
[29]
Weber, G. and Brusilovsky, P. 2001. ELM-ART: An adaptive versatile system for Web-based instruction. Int. J. AI Educ. 12, 4, 351--384.
[30]
Yudelson, M., Brusilovsky, P., and Zadorozhny, V. 2007. A user modeling server for contemporary adaptive hypermedia: An evaluation of push approach to evidence propagation. In Proceedings of the 11th International Conference on User Modeling (UM’07). 27--36.

Cited By

View all
  • (2025)Relational Database Courses with CodeRunner in Moodle: Extending SQL Programming Assignments to Client-Server Database EnginesProceedings of the 56th ACM Technical Symposium on Computer Science Education V. 110.1145/3641554.3701830(1239-1245)Online publication date: 12-Feb-2025
  • (2024)Intelligent Technologies for Personalized Practice SystemsInformation and Technology in Education and Learning10.12937/itel.4.1.Inv.p0014:1(Inv-p001-Inv-p001)Online publication date: 2024
  • (2024)Enhancing Feedback Generation for Autograded SQL Statements to Improve Student LearningProceedings of the 2024 on Innovation and Technology in Computer Science Education V. 110.1145/3649217.3653579(248-254)Online publication date: 3-Jul-2024
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Transactions on Computing Education
ACM Transactions on Computing Education  Volume 9, Issue 4
January 2010
79 pages
EISSN:1946-6226
DOI:10.1145/1656255
Issue’s Table of Contents
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 January 2010
Accepted: 01 September 2009
Revised: 01 August 2009
Received: 01 January 2009
Published in TOCE Volume 9, Issue 4

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. Adaptive educational system
  2. SQL
  3. adaptive hypermedia
  4. integrated learning environment

Qualifiers

  • Research-article
  • Research
  • Refereed

Funding Sources

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)33
  • Downloads (Last 6 weeks)2
Reflects downloads up to 18 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2025)Relational Database Courses with CodeRunner in Moodle: Extending SQL Programming Assignments to Client-Server Database EnginesProceedings of the 56th ACM Technical Symposium on Computer Science Education V. 110.1145/3641554.3701830(1239-1245)Online publication date: 12-Feb-2025
  • (2024)Intelligent Technologies for Personalized Practice SystemsInformation and Technology in Education and Learning10.12937/itel.4.1.Inv.p0014:1(Inv-p001-Inv-p001)Online publication date: 2024
  • (2024)Enhancing Feedback Generation for Autograded SQL Statements to Improve Student LearningProceedings of the 2024 on Innovation and Technology in Computer Science Education V. 110.1145/3649217.3653579(248-254)Online publication date: 3-Jul-2024
  • (2024)SQL Puzzles: Evaluating Micro Parsons Problems With Different Feedbacks as Practice for NovicesProceedings of the 2024 CHI Conference on Human Factors in Computing Systems10.1145/3613904.3641910(1-15)Online publication date: 11-May-2024
  • (2023)Framework for SQL Error Message Design: A Data-Driven ApproachACM Transactions on Software Engineering and Methodology10.1145/360718033:1(1-50)Online publication date: 23-Nov-2023
  • (2023)What Affects the Success of Programmers in Query Validation Process? An Eye Tracking StudyHuman Interface and the Management of Information10.1007/978-3-031-35129-7_38(522-532)Online publication date: 23-Jul-2023
  • (2022)Exploring Behavioral Patterns for Data-Driven Modeling of Learners' Individual DifferencesFrontiers in Artificial Intelligence10.3389/frai.2022.8073205Online publication date: 15-Feb-2022
  • (2022)A Study of Worked Examples for SQL ProgrammingProceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 110.1145/3502718.3524813(82-88)Online publication date: 7-Jul-2022
  • (2022)Advances in database systems education: Methods, tools, curricula, and way forwardEducation and Information Technologies10.1007/s10639-022-11293-028:3(2681-2725)Online publication date: 31-Aug-2022
  • (2021)Stepwise Help and Scaffolding for Java Code Tracing Problems With an Interactive Trace TableProceedings of the 21st Koli Calling International Conference on Computing Education Research10.1145/3488042.3490508(1-10)Online publication date: 17-Nov-2021
  • Show More Cited By

View Options

Login options

Full Access

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media