Exploring the Use of Sub-Goals to Train Students to Solve Novel Problems in a SQL Context
Issues in Information Systems · 2021
Within this study, we address the question of how the use of sub-goals within a technical advanced database course promotes students' abilities to address novel problems that rely on their technical skills.We report on a learning module developed with this in mind.The module requires students to apply known skills, such as CAST and CROSS JOIN functions and SQL variable declarations as well as newly presented content regarding SQL Server's geography-related functions and data types, toward solving a novel problem.The assignment first introduced students to ways of using knowledge of SQL to address three specified sub-goals within a geography-related database problem.After practicing the steps required to address these sub-goals, students were then asked to complete a new geography-related database problem that did not closely match the content or context of the practice example.