Personalized Exploratorium for Database Courses

结构化查询语言(SQL)是使用最广泛的多用途数据库语言。广博的SQL知识和流利的SQL是掌握现代数据库技术的必备条件。这个项目正在开发一种创新的工具，允许信息科学的学生通过使用交互式自动评估的练习和示例来发展实用的SQL技能。PIS正在利用NSF支持的一个项目的结果，该项目通过探索交互式练习在数据库课程中的价值来使用交互式练习进行C语言编程。他们正在调整新西兰坎特伯雷大学安东尼娅·米特罗维奇博士开发的SQL练习自动评估(SQL-Tutor)现有技术，并开发基于脚本的补充评估技术。该项目为原始的SQL-Tutor技术提供了一套免费的交互式SQL示例，并通过个性化指导来增强它，众所周知，这可以提高学生的参与度和成功率。获得更好的参与度和成功率对于调整原始的SQL-Tutor技术以适应不同的目标受众至关重要，这些目标受众准备较少，参与互动练习的动机也较少。为了探索个性化练习、范例和个性化在数据库课程中的价值，匹兹堡大学还开展了几项形成性和终结性课堂研究。

Structured Query Language (SQL) is the most widely used multipurpose database language. Extensive knowledge and fluency in SQL is mandatory in mastering modern database technologies. This project is developing an innovative tool that allows Information Science students to develop practical SQL skills through the use of interactive automatically evaluated exercises and examples. The PIs are leveraging the results of an NSF-supported project that uses interactive exercises for C language programming by exploring the value of interactive exercises in the context of Database courses. They are adapting an existing technology for automatic evaluation of SQL exercises (SQL-Tutor) developed at the University of Canterbury, New Zealand by Dr. Antonija Mitrovic and developing a complementary script-based evaluation technology.This project is providing a complimentary set of interactive SQL examples for the original SQL-Tutor technology and enhancing it with personalized guidance that is known to increase student engagement and success rate. Achieving better engagement and success rate is essential to adapting the original SQL-Tutor technology to a different target audience that is less prepared and less motivated to work with interactive exercises. To explore the value of individualized exercises, examples, and personalization in the context of Database courses, the University of Pittsburgh also is running several formative and summative classroom studies.