{"id":"https://openalex.org/W4400267666","doi":"https://doi.org/10.1145/3649217.3653579","title":"Enhancing Feedback Generation for Autograded SQL Statements to Improve Student Learning","display_name":"Enhancing Feedback Generation for Autograded SQL Statements to Improve Student Learning","publication_year":2024,"publication_date":"2024-07-03","ids":{"openalex":"https://openalex.org/W4400267666","doi":"https://doi.org/10.1145/3649217.3653579"},"language":"en","primary_location":{"id":"doi:10.1145/3649217.3653579","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649217.3653579","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3649217.3653579?download=true","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3649217.3653579?download=true","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5082591165","display_name":"Carsten Kleiner","orcid":"https://orcid.org/0000-0001-9497-0312"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Carsten Kleiner","raw_affiliation_strings":["Faculty IV - Department of Computer Science, University of Applied Science and Arts, Hannover, Germany"],"affiliations":[{"raw_affiliation_string":"Faculty IV - Department of Computer Science, University of Applied Science and Arts, Hannover, Germany","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074463410","display_name":"Felix Heine","orcid":"https://orcid.org/0000-0001-7290-6037"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Felix Heine","raw_affiliation_strings":["Faculty IV - Department of Computer Science, University of Applied Sciences and Arts, Hannover, Germany"],"affiliations":[{"raw_affiliation_string":"Faculty IV - Department of Computer Science, University of Applied Sciences and Arts, Hannover, Germany","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5082591165"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.8013,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.86956481,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"248","last_page":"254"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9958000183105469,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9958000183105469,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9927999973297119,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11283","display_name":"Experimental Learning in Engineering","score":0.9696999788284302,"subfield":{"id":"https://openalex.org/subfields/2214","display_name":"Media Technology"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7515861988067627},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5953422784805298},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.27881065011024475}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7515861988067627},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5953422784805298},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.27881065011024475}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3649217.3653579","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649217.3653579","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3649217.3653579?download=true","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"},{"id":"pmh:oai:serwiss.opus4:3230","is_oa":true,"landing_page_url":"https://nbn-resolving.org/urn:nbn:de:bsz:960-opus4-32303","pdf_url":"https://serwiss.bib.hs-hannover.de/files/3230/kleiner_heine2024-autograded_sql.pdf","source":{"id":"https://openalex.org/S4306400852","display_name":"SerWisS (University of Applied Sciences and Arts Hannover)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I140025399","host_organization_name":"Hochschule Hannover","host_organization_lineage":["https://openalex.org/I140025399"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:conferenceObject"},{"id":"doi:10.25968/opus-3230","is_oa":true,"landing_page_url":"https://doi.org/10.25968/opus-3230","pdf_url":null,"source":{"id":"https://openalex.org/S7407052879","display_name":"Bibliotheksservice-Zentrum Baden-Wuerttemberg (BSZ)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.1145/3649217.3653579","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649217.3653579","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3649217.3653579?download=true","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Quality Education","score":0.5699999928474426,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4400267666.pdf"},"referenced_works_count":18,"referenced_works":["https://openalex.org/W2020126579","https://openalex.org/W2028537988","https://openalex.org/W2050781086","https://openalex.org/W2112867685","https://openalex.org/W2133743537","https://openalex.org/W2216374816","https://openalex.org/W2286501037","https://openalex.org/W2534674944","https://openalex.org/W2783082347","https://openalex.org/W2809284492","https://openalex.org/W3003642164","https://openalex.org/W3007946258","https://openalex.org/W3041823931","https://openalex.org/W3116357669","https://openalex.org/W4200122970","https://openalex.org/W4220675766","https://openalex.org/W4283691621","https://openalex.org/W4302474908"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052","https://openalex.org/W2382290278","https://openalex.org/W4395014643"],"abstract_inverted_index":{"Several":[0],"tools":[1,19,40],"to":[2,35,82,92,118,165],"support":[3],"autograding":[4],"of":[5,17,122,150,169,191,193,197],"student":[6,198,203],"provided":[7],"SQL":[8,61],"statements":[9],"have":[10],"already":[11],"been":[12],"introduced.":[13],"The":[14],"full":[15],"potential":[16],"such":[18],"can":[20,130],"only":[21],"be":[22,132],"leveraged,":[23],"if":[24],"they":[25],"extend":[26],"beyond":[27],"grading":[28],"efficiency":[29],"by":[30,44,205],"also":[31,131,173],"providing":[32],"tutoring":[33],"capabilities":[34],"the":[36,65,84,88,96,100,105,120,126,148,151,157,167,170,179,207],"students.":[37],"With":[38],"that,":[39],"become":[41],"really":[42],"useful":[43],"offering":[45],"self-paced":[46],"and":[47],"individually":[48],"timed":[49],"learning":[50,199],"experiences.":[51],"In":[52,116],"this":[53,128],"paper":[54],"we":[55,159],"present":[56,160],"an":[57,60],"extension":[58],"for":[59,68,125,135],"autograder":[62],"which":[63],"improves":[64],"hints":[66,123,163],"generated":[67,124,164,209],"students":[69],"in":[70,181],"cases":[71],"where":[72],"their":[73],"solution":[74,86,90,111],"is":[75,81],"not":[76],"entirely":[77],"correct.":[78],"Our":[79],"approach":[80],"compare":[83],"student's":[85,106],"with":[87,108,154,178],"model":[89,110],"structurally":[91],"identify":[93],"differences":[94],"between":[95],"syntax":[97],"trees":[98],"describing":[99],"statements.":[101],"This":[102],"complements":[103],"comparing":[104],"query":[107,114],"a":[109],"based":[112],"on":[113,176],"results.":[115],"addition":[117],"improving":[119],"quality":[121],"students,":[127],"concept":[129,158],"used":[133],"easily":[134],"data":[136,141],"manipulation":[137],"language":[138,143],"(DML)":[139],"or":[140],"definition":[142],"(DDL)":[144],"statements,":[145],"thus":[146],"extending":[147],"applicability":[149],"autograder.":[152],"Along":[153],"details":[155],"about":[156],"some":[161],"example":[162],"illustrate":[166],"usefulness":[168],"approach.":[171],"We":[172],"report":[174],"anecdotally":[175],"experiences":[177],"system":[180],"two":[182],"different":[183,189],"level":[184],"database":[185],"courses.":[186],"Results":[187],"from":[188],"instances":[190],"one":[192],"them":[194],"show":[195],"improvements":[196],"as":[200,202],"well":[201],"involvement":[204],"using":[206],"newly":[208],"hints.":[210]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4}],"updated_date":"2026-03-13T16:22:10.518609","created_date":"2025-10-10T00:00:00"}