View in EDS

A Problem‐to‐Code Teaching Framework for Technology‐Enhanced Database Programming in Engineering Education: A Mixed‐Methods Study.

Saved in:
Bibliographic Details
Title: A Problem‐to‐Code Teaching Framework for Technology‐Enhanced Database Programming in Engineering Education: A Mixed‐Methods Study.
Authors: Chen, Hung‐Yi1 (AUTHOR), Liu, Ying‐Chieh2 (AUTHOR) allanliu@ncut.edu.tw, Chiu, Tiffany3 (AUTHOR)
Source: Computer Applications in Engineering Education. Mar2026, Vol. 34 Issue 2, p1-19. 19p.
Subjects: Database design, Engineering education, Mixed methods research, Self-efficacy, Computer assisted instruction, Academic support programs
Abstract: In engineering education contexts, students in database programming courses within the College of Informatics and Engineering often encounter challenges when transforming problem statements into executable code in technology‐enhanced programming environments, which often diminishes their self‐efficacy. To address this issue, this study introduces the Problem‐to‐Code Teaching Framework (PCTF), an instructional model that integrates the Function/Pattern‐Oriented Teaching Method with supporting scaffolding activities. The PCTF was implemented in an 18‐week PL/SQL course with 45 undergraduates at a university of science and technology in Taiwan, conducted in a technology‐enhanced environment using Oracle 19c databases and SQL IDE tools. Using a convergent mixed‐methods design, programming self‐efficacy was measured at three time points and analyzed with linear mixed‐effects regression, while 16 semi‐structured interviews captured students' perceptions of conceptual, procedural, and feedback scaffolds. Results indicated a steady increase in programming self‐efficacy across the semester, with the compensatory effect among students starting at lower levels. Deep learning approaches showed a strong, positive association, whereas the surface approach was not reliably associated. Qualitative findings indicated that multilayered scaffolds were perceived as supporting confidence and persistence by clarifying problem abstraction and solution modeling, structuring the problem‐to‐code conversion process, and providing timely feedback. Overall, the PCTF represents a context‐bounded yet structurally transferable, technology‐enhanced instructional framework that bridges problem analysis and code implementation, contributing to technology‐integrated data‐centric engineering programming education. [ABSTRACT FROM AUTHOR]
Copyright of Computer Applications in Engineering Education is the property of Wiley-Blackwell and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Database: Engineering Source
Description
Abstract:In engineering education contexts, students in database programming courses within the College of Informatics and Engineering often encounter challenges when transforming problem statements into executable code in technology‐enhanced programming environments, which often diminishes their self‐efficacy. To address this issue, this study introduces the Problem‐to‐Code Teaching Framework (PCTF), an instructional model that integrates the Function/Pattern‐Oriented Teaching Method with supporting scaffolding activities. The PCTF was implemented in an 18‐week PL/SQL course with 45 undergraduates at a university of science and technology in Taiwan, conducted in a technology‐enhanced environment using Oracle 19c databases and SQL IDE tools. Using a convergent mixed‐methods design, programming self‐efficacy was measured at three time points and analyzed with linear mixed‐effects regression, while 16 semi‐structured interviews captured students' perceptions of conceptual, procedural, and feedback scaffolds. Results indicated a steady increase in programming self‐efficacy across the semester, with the compensatory effect among students starting at lower levels. Deep learning approaches showed a strong, positive association, whereas the surface approach was not reliably associated. Qualitative findings indicated that multilayered scaffolds were perceived as supporting confidence and persistence by clarifying problem abstraction and solution modeling, structuring the problem‐to‐code conversion process, and providing timely feedback. Overall, the PCTF represents a context‐bounded yet structurally transferable, technology‐enhanced instructional framework that bridges problem analysis and code implementation, contributing to technology‐integrated data‐centric engineering programming education. [ABSTRACT FROM AUTHOR]
ISSN:10613773
DOI:10.1002/cae.70163