{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,8]],"date-time":"2025-12-08T15:56:15Z","timestamp":1765209375644,"version":"3.46.0"},"publisher-location":"New York, NY, USA","reference-count":38,"publisher":"ACM","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2025,6,13]]},"DOI":"10.1145\/3724363.3729022","type":"proceedings-article","created":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T08:57:23Z","timestamp":1750150643000},"page":"465-471","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":1,"title":["A Generative AI Tool to Foster and Assess Authentic Learning: A Case Study in Teaching SQL"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0003-9128-1097","authenticated-orcid":false,"given":"Raja","family":"Sooriamurthi","sequence":"first","affiliation":[{"name":"Carnegie Mellon University, Pittsburgh, PA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-7322-3710","authenticated-orcid":false,"given":"Xiaoying","family":"Tu","sequence":"additional","affiliation":[{"name":"Carnegie Mellon University, Pittsburgh, PA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-3860-1736","authenticated-orcid":false,"given":"Allison E. Connell","family":"Pensky","sequence":"additional","affiliation":[{"name":"Carnegie Mellon University, Pittsburgh, PA, USA"}]}],"member":"320","published-online":{"date-parts":[[2025,6,17]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/3649217.3653594"},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/3649217.3653543"},{"key":"e_1_3_2_1_3_1","volume-title":"The 2 sigma problem: The search for methods of group instruction as effective as one-to-one tutoring. Educational researcher, 13(6):4--16","author":"Bloom Benjamin S","year":"1984","unstructured":"Benjamin S Bloom. The 2 sigma problem: The search for methods of group instruction as effective as one-to-one tutoring. Educational researcher, 13(6):4--16, 1984."},{"key":"e_1_3_2_1_4_1","volume-title":"How to assess authentic learning","author":"Burke Kay","year":"2009","unstructured":"Kay Burke. How to assess authentic learning. Corwin Press, 2009."},{"key":"e_1_3_2_1_5_1","first-page":"403","volume-title":"Proceedings of the 19th Workshop on Innovative Use of NLP for Building Educational Applications (BEA","author":"Carpenter Dan","year":"2024","unstructured":"Dan Carpenter, Wookhee Min, Seung Lee, Gamze Ozogul, Xiaoying Zheng, and James Lester. Assessing student explanations with large language models using fine-tuning and few-shot learning. In Ekaterina Kochmar, Marie Bexte, Jill Burstein, Andrea Horbach, Ronja Laarmann-Quante, Ana\u00efs Tack, Victoria Yaneva, and Zheng Yuan, editors, Proceedings of the 19th Workshop on Innovative Use of NLP for Building Educational Applications (BEA 2024), pages 403--413, Mexico City, Mexico, June 2024. Association for Computational Linguistics."},{"key":"e_1_3_2_1_6_1","volume-title":"November","author":"Chiang Cheng-Han","year":"2024","unstructured":"Cheng-Han Chiang, Wei-Chih Chen, Chun-Yi Kuan, Chienchou Yang, and Hung-yi Lee. Large language model as an assignment evaluator: Insights, feedback, and challenges in a 1000 student course, November 2024."},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/3649217.3653574"},{"key":"e_1_3_2_1_8_1","volume-title":"Matthew Flatt, and Shriram Krishnamurthi. How to Design Programs","author":"Felleisen Matthias","year":"2018","unstructured":"Matthias Felleisen, Robert Bruce Findler, Matthew Flatt, and Shriram Krishnamurthi. How to Design Programs. MIT Press, 2nd edition edition, 2018.","edition":"2"},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.5220\/0011084400003182"},{"key":"e_1_3_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/3649217.3653570"},{"key":"e_1_3_2_1_11_1","volume-title":"Design Patterns: Elements of Reusable Object-Oriented Software","author":"Gamma Erich","year":"1994","unstructured":"Erich Gamma, Richard Helm, Ralph Johnson, and John Vlissides. Design Patterns: Elements of Reusable Object-Oriented Software. Addison-Wesley, 1994."},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/3626253.3635607"},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.3390\/app11125467"},{"key":"e_1_3_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/3649217.3653624"},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.30935\/cedtech\/13036"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4614-3185-5_32"},{"key":"e_1_3_2_1_17_1","unstructured":"Simon Holywell. Sql style guide https:\/\/www.sqlstyle.guide."},{"key":"e_1_3_2_1_18_1","first-page":"5","article-title":"The impact of large language models on programming education and student learning outcomes","volume":"14","author":"Jo\u0161t Gregor","year":"2024","unstructured":"Gregor Jo\u0161t, Viktor Taneski, and Sa\u0161o Karakati\u0107. The impact of large language models on programming education and student learning outcomes. Applied Sciences (Switzerland), 14, 5 2024.","journal-title":"Applied Sciences (Switzerland)"},{"key":"e_1_3_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.lindif.2023.102274"},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/3649217.3653612"},{"key":"e_1_3_2_1_21_1","volume-title":"Artificial intelligence in intelligent tutoring systems toward sustainable education: a systematic review, 12","author":"Lin Chien Chang","year":"2023","unstructured":"Chien Chang Lin, Anna Y.Q. Huang, and Owen H.T. Lu. Artificial intelligence in intelligent tutoring systems toward sustainable education: a systematic review, 12 2023."},{"key":"e_1_3_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/3626252.3630789"},{"key":"e_1_3_2_1_23_1","first-page":"750","volume-title":"SIGCSE 2024 - Proceedings of the 55th ACM Technical Symposium on Computer Science Education","volume":"1","author":"Liu Rongxin","year":"2024","unstructured":"Rongxin Liu, Carter Zenke, Charlie Liu, Andrew Holmes, Patrick Thornton, and David J. Malan. Teaching cs50 with ai: Leveraging generative artificial intelligence in computer science education. In SIGCSE 2024 - Proceedings of the 55th ACM Technical Symposium on Computer Science Education, volume 1, pages 750--756. Association for Computing Machinery, Inc, 3 2024."},{"key":"e_1_3_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/3649217.3653554"},{"volume-title":"Introducing llama 3.1: Our most capable models to date, https:\/\/ai.meta.com\/blog\/meta-llama-3--1, 7","year":"2024","key":"e_1_3_2_1_25_1","unstructured":"Meta. Introducing llama 3.1: Our most capable models to date, https:\/\/ai.meta.com\/blog\/meta-llama-3--1, 7 2024."},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1109\/TE.2024.3467912"},{"key":"e_1_3_2_1_27_1","first-page":"958","volume-title":"Proceedings of the 55th ACM Technical Symposium on Computer Science Education V. 1, SIGCSE 2024","author":"Nguyen Ha","year":"2024","unstructured":"Ha Nguyen and Vicki Allan. Using gpt-4 to provide tiered, formative code feedback. In Proceedings of the 55th ACM Technical Symposium on Computer Science Education V. 1, SIGCSE 2024, page 958--964, New York, NY, USA, 2024. Association for Computing Machinery."},{"key":"e_1_3_2_1_28_1","volume-title":"Chatgpt: Optimizing language models for dialogue, https:\/\/chatgpt.r4wand.eu.org","author":"AI.","year":"2022","unstructured":"OpenAI. Chatgpt: Optimizing language models for dialogue, https:\/\/chatgpt.r4wand.eu.org, 2022."},{"key":"e_1_3_2_1_29_1","volume-title":"Hello gpt-4o, https:\/\/openai.com\/index\/hello-gpt-4o","author":"AI.","year":"2024","unstructured":"OpenAI. Hello gpt-4o, https:\/\/openai.com\/index\/hello-gpt-4o, 2024."},{"key":"e_1_3_2_1_30_1","first-page":"1","volume-title":"Proceedings of the 31st International Conference on Computers in Education","author":"Pankiewicz Maciej","year":"2023","unstructured":"Maciej Pankiewicz and R. Baker. Large language models (gpt) for automating feedback on programming assignments. In Ju-Ling SHIH, Akihiro KASHIHARA, Weiqin CHEN, and Hiroaki OGATA, editors, Proceedings of the 31st International Conference on Computers in Education, pages 1--12. Asia-Pacific Society for Computers in Education, 2023."},{"key":"e_1_3_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/3689535.3689554"},{"key":"e_1_3_2_1_32_1","first-page":"421","volume-title":"Studies in Health Technology and Informatics","author":"Saplacan Diana","year":"2018","unstructured":"Diana Saplacan, Jo Herstad, and Zada Pajalic. Feedback from digital systems used in higher education: An inquiry into triggered emotions two universal design oriented solutions for a better user experience. In Studies in Health Technology and Informatics, volume 256, pages 421--430. IOS Press, 2018."},{"key":"e_1_3_2_1_33_1","volume-title":"Proceedings of the 32nd European Conference on Information Systems (ECIS)","author":"Sengewald Julian","year":"2024","unstructured":"Julian Sengewald, Mathis Wilz, and Richard Lackes. AI-Assisted Learning Feedback: Should Gen-AI Feedback Be Restricted to Improve Learning Success? A Pilot Study in a SQL Lecture. In Proceedings of the 32nd European Conference on Information Systems (ECIS), 2024."},{"key":"e_1_3_2_1_34_1","volume-title":"Teaching SQL query formulation: A three-step heuristics based approach","author":"Sooriamurthi Raja","year":"2024","unstructured":"Raja Sooriamurthi and Xiaoying Tu. Teaching SQL query formulation: A three-step heuristics based approach. 2024."},{"key":"e_1_3_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/InCIT60207.2023.10412991"},{"key":"e_1_3_2_1_36_1","volume-title":"Proceedings of the 40th International Conference on Information Systems (ICIS)","author":"Winkler Rainer","year":"2019","unstructured":"Rainer Winkler and Julian Roos. Bringing ai into the classroom: Designing smart personal assistants as learning tutors. In Proceedings of the 40th International Conference on Information Systems (ICIS), 2019."},{"key":"e_1_3_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/3626253.3635408"},{"key":"e_1_3_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1002\/rev3.3433"}],"event":{"name":"ITiCSE 2025: Innovation and Technology in Computer Science Education","sponsor":["SIGCSE ACM Special Interest Group on Computer Science Education"],"location":"Nijmegen Netherlands","acronym":"ITiCSE 2025"},"container-title":["Proceedings of the 30th ACM Conference on Innovation and Technology in Computer Science Education V. 1"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3724363.3729022","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,12,8]],"date-time":"2025-12-08T15:21:30Z","timestamp":1765207290000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3724363.3729022"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,6,13]]},"references-count":38,"alternative-id":["10.1145\/3724363.3729022","10.1145\/3724363"],"URL":"https:\/\/doi.org\/10.1145\/3724363.3729022","relation":{},"subject":[],"published":{"date-parts":[[2025,6,13]]},"assertion":[{"value":"2025-06-17","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}