An Intelligent SQL Tutor on the Web

The paper presents SQLT-Web, a Web-enabled intelligent tutoring system for the SQL database language. SQLT-Web is a Web-enabled version of an earlier, standalone ITS. In this paper we describe how the components of the standalone system were reused to develop the Web-enabled system. The system observes students' actions and adapts to their knowledge and learning abilities. We describe the system's architecture in comparison to the architectures of other existing Web-enabled tutors. All tutoring functions are performed on the server side, and we explain how SQLT-Web deals with multiple students. The system has been open to outside users since March 2000. SQLT-Web has been evaluated in the context of genuine teaching activities. We present the results of three evaluation studies with the University of Canterbury students taking database courses, which show that SQLT-Web is an effective system. The students have found the system a valuable asset to their learning.

[1]  湯浅 太一,et al.  Common Lisp(パネル討論会) , 1986 .

[2]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[3]  Charles L. Forgy,et al.  Rete: a fast algorithm for the many pattern/many object pattern match problem , 1991 .

[4]  Ramez Elmasri,et al.  Fundamentals of Database Systems, 2nd Edition , 1994 .

[5]  Stellan Ohlsson,et al.  Constraint-Based Student Modeling , 1994 .

[6]  Bert Bredeweg,et al.  Student Modelling: The Key to Individualized Knowledge-Based Instruction , 2010, NATO ASI Series.

[7]  John C. Mallery.  A common LISP hypermedia server , 1994, WWW Spring 1994.

[8]  Stellan Ohlsson,et al.  Learning from Performance Errors. , 1996 .

[9]  Peter Brusilovsky,et al.  ELM-ART: An Intelligent Tutoring System on World Wide Web , 1996, Intelligent Tutoring Systems.

[10]  Daniel D. Suthers,et al.  An Architecture for Intelligent Collaborative Educational Systems. , 1997 .

[11]  Riichiro Mizoguchi,et al.  Artificial Intelligence in Education: Knowledge and Media in Learning Systems , 1997 .

[12]  Jim Kurose,et al.  Intelligence on the Web , 1997 .

[13]  Antonija Mitrovic,et al.  Experiences in Implementing Constraint-Based Modeling in SQL-Tutor , 1998, Intelligent Tutoring Systems.

[14]  Antonija Mitrovic,et al.  A Knowledge-Based Teaching System for SQL , 1998 .

[15]  Antonija Mitrovic,et al.  Learning SQL with a computerized tutor , 1998, SIGCSE '98.

[16]  Mark K. Singley,et al.  Deploying Intelligent Tutors on the Web: An Architecture and an Example , 1999 .

[17]  Antonija Mitrovic,et al.  Evaluation of a Constraint-Based Tutor for a Database Language , 1999 .

[18]  Peter Brusilovsky,et al.  Adaptive and Intelligent Technologies for Web-based Eduction , 1999, Künstliche Intell..

[19]  W. Lewis Johnson,et al.  Pedagogical agents on the Web , 1999, AGENTS '99.

[20]  Usha Mehta,et al.  On the World Wide Web , 2000 .

[21]  Emilia Pecheanu,et al.  A Hybrid Aproach to Dynamic Course Generation on the WWW , 2000 .

[22]  kulvwrskk3h\orr±±7reldvv7khohqq±±&odxvv5roolqjhuu+,et al.  A web-based intelligent educational system for PROLOG , 2000 .

[23]  Antonija Mitrovic,et al.  Evaluating an Animated Pedagogical Agent , 2000, Intelligent Tutoring Systems.

[24]  Antonija Mitrovic,et al.  Using a Probabilistic Student Model to Control Problem Difficulty , 2000, Intelligent Tutoring Systems.

[25]  Volker Sorge,et al.  Adaptive Course Generation and Presentation , 2000 .

[26]  Trude Heift,et al.  Theoretical and Practical Considerations for Web-Based Intelligent Language Tutoring Systems , 2000, Intelligent Tutoring Systems.

[27]  Antonija Mitrovic,et al.  Evaluating the effectiveness of feedback in SQL-Tutor , 2000, Proceedings International Workshop on Advanced Learning Technologies. IWALT 2000. Advanced Learning Technology: Design and Development Issues.

[28]  Peter Brusilovsky,et al.  ELM-ART: An Adaptive Versatile System for Web-based Instruction , 2001 .

[29]  Antonija Mitrovic.  Investigating Students' Self-Assessment Skills , 2001, User Modeling.

[30]  Antonija Mitrovic,et al.  Optimising ITS Behaviour with Bayesian Networks and Decision Theory , 2001 .

[31]  Antonija Mitrovic,et al.  NORMIT: a Web-enabled tutor for database normalization , 2002, International Conference on Computers in Education, 2002. Proceedings..

[32]  Antonija Mitrovic,et al.  KERMIT: A Constraint-Based Tutor for Database Modeling , 2002, Intelligent Tutoring Systems.

[33]  Antonija Mitrovic,et al.  A Comparative Analysis of Cognitive Tutoring and Constraint-Based Modeling , 2003, User Modeling.

[34]  Antonija Mitrovic,et al.  Using Evaluation to Shape ITS Design: Results and Experiences with SQL-Tutor , 2002, User Modeling and User-Adapted Interaction.