The Community for Technology Leaders
RSS Icon
Issue No.06 - June (2009 vol.21)
pp: 854-866
Claus Pahl , Dublin City University, Dublin
Active learning and training is a particularly effective form of education. In various domains, skills are equally important to knowledge. We present an automated learning and skills training system for a database programming environment that promotes procedural knowledge acquisition and skills training. The system provides meaningful knowledge-level feedback such as correction of student solutions and personalized guidance through recommendations. Specifically, we address automated synchronous feedback and recommendations based on personalized performance assessment. At the core of the tutoring system is a pattern-based error classification and correction component that analyzes student input in order to provide immediate feedback and in order to diagnose student weaknesses and suggest further study material. A syntax-driven approach based on grammars and syntax trees provides the solution for a semantic analysis technique. Syntax tree abstractions and comparison techniques based on equivalence rules and pattern matching are specific approaches.
Artificial intelligence—applications and expert knowledge-intensive systems, data structures, education, programming languages, query languages.
Claus Pahl, "Interactive Correction and Recommendation for Computer Language Learning and Training", IEEE Transactions on Knowledge & Data Engineering, vol.21, no. 6, pp. 854-866, June 2009, doi:10.1109/TKDE.2008.144
[1] S. Abiteboul, R. Hull, and V. Vianu, Foundations of Databases. Addison-Wesley, 1994.
[2] A.V. Aho, M.S. Lam, R. Sethi, and J.D. Ullman, Compilers: Principles, Techniques, and Tools, second ed. Addison-Wesley, 2007.
[3] A.V. Aho, J.D. Ullman, and J.E. Hopcroft, Data Structures and Algorithms, series in Computer Science and Information Processing. Addison-Wesley, 1983.
[4] S. Bhagat, L. Bhagat, J. Kavalan, and M. Sasikumar. Acharya, “An Intelligent Tutoring Environment for Learning SQL,” Proc. Int'l Conf. Online Learning (Vidyakash), 2002.
[5] J. Beck, M. Stern, and E. Haugsjaa, “Applications of AI in Education,” ACM Crossroads, The Student J. ACM, vol. 3, no. 1, 1996.
[6] T. Boyle, Design for Multimedia Learning. Prentice Hall, 1997.
[7] S. Brass and C. Goldberg, “Semantic Errors in SQL Queries: A Complete List,” J. Systems and Software, vol. 79, pp. 630-644, 2006.
[8] P. Brusilovsky, “Adaptive Hypermedia: From Intelligent Tutoring Systems to Web-Based Education,” Proc. Fifth Int'l Conf. Intelligent Tutoring Systems (ITS '00), pp. 1-7, 2000.
[9] P. Brusilovsky, J. Knapp, and J. Gamper, “Supporting Teachers as Content Authors in Intelligent Educational Systems,” Int'l J. Knowledge and Learning, vol. 2, nos. 3/4, pp. 191-215, 2006.
[10] S. Chaudhuri, “An Overview of Query Optimization in Relational Systems,” Proc. 17th ACM Symp. Principles of Database Systems (PODS '98), pp. 34-43, 1998.
[11] C.-Y. Chou, T.-W. Chan, and C.-J. Lin, “Redefining the Learning Companion: The Past, Present, and Future of Educational Agents,” Computers & Education, vol. 40, no. 3, pp. 255-269, 2002.
[12] A. Collins, “Cognitive Apprenticeship and Instructional Technology,” Technical Report 6899, BBN Labs Inc., Cambridge, Mass., 1998.
[13] A. Collins, J.S. Brown, and A. Holum, “Cognitive Apprenticeship: Making Thinking Visible,” Am. Educator, Winter ed., 1991.
[14] P. De Bra, D. Smits, and N. Stash, “Creating and Delivering Adaptive Courses with AHA!,” Proc. First European Conf. Technology Enhanced Learning (EC-TEL '06), pp. 21-33, 2006.
[15] D. Heaney and C. Daly, “Mass Production of Individual Feedback,” Proc. Ninth Ann. ACM SIGCSE Int'l Conf. Innovation and Technology in Computer Science Education (ITiCSE '04), pp. 117-121, 2004.
[16] J. Herrington and R. Oliver, “An Instructional Design Framework for Authentic Learning Environments,” Educational Technology Research and Development, vol. 48, no. 3, pp. 23-48, 2000.
[17] C. Kenny, “Automated Tutoring for a Database Skills Training Environment,” MSc thesis, School of Computing, Dublin City Univ., 2006.
[18] C. Kenny and C. Pahl, “Automated Tutoring for a Database Skills Training Environment,” Proc. ACM SIGCSE '05, pp. 58-62, 2005.
[19] M. Mathews and A. Mitrovic, “Investigating the Effectiveness of Problem Templates on Learning in Intelligent Tutoring Systems,” Proc. 13th Int'l Conf. Artificial Intelligence in Education (AIED '07), pp. 611-613, 2007.
[20] E. Melis and C. Ullrich, “Local and Global Feedback,” Proc. 11th Int'l Conf. Artificial Intelligence in Education (AIED), 2003.
[21] A. Mitrovic, B. Martin, and P. Suraweera, “Intelligent Tutors for All: The Constraint-Based Approach,” IEEE Intelligent Systems, vol. 22, no. 4, pp. 38-45, July/Aug. 2007.
[22] T. Murray, “Authoring Intelligent Tutoring Systems: An Analysis of the State of the Art,” Int'l J. Artificial Intelligence in Education, vol. 10, pp. 98-129, 1999.
[23] S. Murray, J. Ryan, and C. Pahl, “A Tool-Mediated Cognitive Apprenticeship Approach for a Computer Engineering Course,” Proc. Third IEEE Int'l Conf. Advanced Learning Technologies (ICALT '03), pp. 2-6, 2003.
[24] C. Pahl, “Behaviour Analysis for Web-Mediated Active Learning,” Int'l J. Web-Based Learning and Teaching Technologies, vol. 1, no. 3, pp. 45-55, 2007.
[25] C. Pahl, R. Barrett, and C. Kenny, “Supporting Active Database Learning and Training through Interactive Multimedia,” Proc. Ninth Ann. Conf. Innovation and Technology in Computer Science Education (ITiCSE), 2004.
[26] R. Ramakrishnan and J. Gehrke, Database Management Systems. McGraw-Hill, 2003.
[27] A. Ravenscroft, K. Tait, and I. Hughes, “Beyond the Media: Knowledge Level Interaction and Guided Integration for CBL Systems,” Computers in Education, vol. 30, nos. 1/2, pp. 49-56, 1998.
[28] P. Reisner, “Human Factors Studies of Database Query Languages: A Survey and Assessment,” ACM Computing Surveys, vol. 13, pp.13-31, 1981.
[29] A. Rizzo, S. Bagnara, and M. Visciola, “Human Error Detection Processes,” Int'l J. Man-Machine Studies, vol. 27, pp. 555-570, 1987.
[30] S. Sadiq, M. Orlowska, W. Sadiq, and J. Lin, “SQLator—An Online SQL Learning Workbench,” Proc. Ninth Ann. ACM SIGCSE Int'l Conf. Innovation and Technology in Computer Science Education (ITiCSE '04), pp. 223-227, June 2004.
[31] Teaching and Learning Online, J. Stephenson, ed. Kogan Page, 2001.
[32] R.H. Stottler and M. Vinkavich, “Tactical Action Officer Intelligent Tutoring System (TAO ITS),” Proc. Interservice/Industry Training, Simulation and Education Conf. (I/ITSEC), 2000.
[33] K. Winnips, “Scaffolding-by-Design as a Model for Online Learner Support,” PhD dissertation, Faculty of Educational Science and Technology, Univ. of Twente, The Netherlands, 2001.
45 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool