{"id":"https://openalex.org/W4390606890","doi":"https://doi.org/10.1109/fie58773.2023.10343207","title":"Uncovering Patterns of SQL Errors in Student Assignments: A Comparative Analysis of Different Assignment Types","display_name":"Uncovering Patterns of SQL Errors in Student Assignments: A Comparative Analysis of Different Assignment Types","publication_year":2023,"publication_date":"2023-10-18","ids":{"openalex":"https://openalex.org/W4390606890","doi":"https://doi.org/10.1109/fie58773.2023.10343207"},"language":"en","primary_location":{"id":"doi:10.1109/fie58773.2023.10343207","is_oa":false,"landing_page_url":"https://doi.org/10.1109/fie58773.2023.10343207","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE Frontiers in Education Conference (FIE)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5022587958","display_name":"Sophia Yang","orcid":"https://orcid.org/0000-0003-1274-4851"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sophia Yang","raw_affiliation_strings":["University of Illinois Urbana-Champaign,Department of Computer Science","Department of Computer Science, University of Illinois Urbana-Champaign"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign,Department of Computer Science","institution_ids":["https://openalex.org/I157725225"]},{"raw_affiliation_string":"Department of Computer Science, University of Illinois Urbana-Champaign","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037065721","display_name":"Z. Li","orcid":"https://orcid.org/0009-0007-1239-2493"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zepei Li","raw_affiliation_strings":["University of Illinois Urbana-Champaign,Department of Computer Science","Department of Computer Science, University of Illinois Urbana-Champaign"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign,Department of Computer Science","institution_ids":["https://openalex.org/I157725225"]},{"raw_affiliation_string":"Department of Computer Science, University of Illinois Urbana-Champaign","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038676484","display_name":"Geoffrey Herman","orcid":"https://orcid.org/0000-0002-9501-2295"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Geoffrey L. Herman","raw_affiliation_strings":["University of Illinois Urbana-Champaign,Department of Computer Science","Department of Computer Science, University of Illinois Urbana-Champaign"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign,Department of Computer Science","institution_ids":["https://openalex.org/I157725225"]},{"raw_affiliation_string":"Department of Computer Science, University of Illinois Urbana-Champaign","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011238152","display_name":"Kathryn Cunningham","orcid":"https://orcid.org/0000-0002-9702-2796"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kathryn Cunningham","raw_affiliation_strings":["University of Illinois Urbana-Champaign,Department of Computer Science","Department of Computer Science, University of Illinois Urbana-Champaign"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign,Department of Computer Science","institution_ids":["https://openalex.org/I157725225"]},{"raw_affiliation_string":"Department of Computer Science, University of Illinois Urbana-Champaign","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5014235464","display_name":"Abdussalam Alawini","orcid":"https://orcid.org/0000-0003-1106-7190"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Abdussalam Alawini","raw_affiliation_strings":["University of Illinois Urbana-Champaign,Department of Computer Science","Department of Computer Science, University of Illinois Urbana-Champaign"],"affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign,Department of Computer Science","institution_ids":["https://openalex.org/I157725225"]},{"raw_affiliation_string":"Department of Computer Science, University of Illinois Urbana-Champaign","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5022587958"],"corresponding_institution_ids":["https://openalex.org/I157725225"],"apc_list":null,"apc_paid":null,"fwci":1.3847,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.86938067,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"01","last_page":"09"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9929999709129333,"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"}},"topics":[{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9929999709129333,"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/T10533","display_name":"Teaching and Learning Programming","score":0.9901999831199646,"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9628000259399414,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/coursework","display_name":"Coursework","score":0.855227530002594},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8432816863059998},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.7836616039276123},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7642955780029297},{"id":"https://openalex.org/keywords/syntax-error","display_name":"Syntax error","score":0.5354692339897156},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5248413681983948},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.42817455530166626},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3074488043785095},{"id":"https://openalex.org/keywords/abstract-syntax","display_name":"Abstract syntax","score":0.25911813974380493},{"id":"https://openalex.org/keywords/mathematics-education","display_name":"Mathematics education","score":0.25909286737442017},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.08436015248298645}],"concepts":[{"id":"https://openalex.org/C2781110425","wikidata":"https://www.wikidata.org/wiki/Q2074695","display_name":"Coursework","level":2,"score":0.855227530002594},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8432816863059998},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.7836616039276123},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7642955780029297},{"id":"https://openalex.org/C11742125","wikidata":"https://www.wikidata.org/wiki/Q1195374","display_name":"Syntax error","level":4,"score":0.5354692339897156},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5248413681983948},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.42817455530166626},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3074488043785095},{"id":"https://openalex.org/C114408938","wikidata":"https://www.wikidata.org/wiki/Q333373","display_name":"Abstract syntax","level":3,"score":0.25911813974380493},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.25909286737442017},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.08436015248298645}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/fie58773.2023.10343207","is_oa":false,"landing_page_url":"https://doi.org/10.1109/fie58773.2023.10343207","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE Frontiers in Education Conference (FIE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.6000000238418579}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":32,"referenced_works":["https://openalex.org/W43076228","https://openalex.org/W1995969371","https://openalex.org/W2024092127","https://openalex.org/W2071100465","https://openalex.org/W2089624191","https://openalex.org/W2095026299","https://openalex.org/W2098307754","https://openalex.org/W2120913149","https://openalex.org/W2130719656","https://openalex.org/W2132032354","https://openalex.org/W2286501037","https://openalex.org/W2292552191","https://openalex.org/W2338073987","https://openalex.org/W2347061999","https://openalex.org/W2473995384","https://openalex.org/W2745060418","https://openalex.org/W2766624855","https://openalex.org/W2788882425","https://openalex.org/W2885090162","https://openalex.org/W2916040897","https://openalex.org/W2998738573","https://openalex.org/W3009770877","https://openalex.org/W3033482208","https://openalex.org/W3172255581","https://openalex.org/W3193751197","https://openalex.org/W4247069824","https://openalex.org/W4252681483","https://openalex.org/W4281764247","https://openalex.org/W4381660888","https://openalex.org/W6601764871","https://openalex.org/W6680101216","https://openalex.org/W6696745995"],"related_works":["https://openalex.org/W1530314747","https://openalex.org/W2005927140","https://openalex.org/W1638016577","https://openalex.org/W3210858091","https://openalex.org/W4296517586","https://openalex.org/W1592149428","https://openalex.org/W650213220","https://openalex.org/W4313167435","https://openalex.org/W2613250302","https://openalex.org/W1980548249"],"abstract_inverted_index":{"Structured":[0],"Query":[1],"Language":[2],"(SQL)":[3],"is":[4],"an":[5,56,65],"essential":[6],"skill":[7],"to":[8,63,83,96],"acquire":[9],"for":[10,71,128,152,163],"those":[11],"who":[12],"interact":[13],"with":[14,205],"databases,":[15],"such":[16],"as":[17,135,137,170],"researchers,":[18],"developers,":[19],"and":[20,88,100,122,125,149,185,207,228],"people":[21],"involved":[22],"in":[23,62,104],"businesses.":[24],"However,":[25],"the":[26,40,91,105,110,118,138,157,160,189],"challenges":[27],"that":[28,44,58,175],"these":[29,131],"users":[30],"face":[31],"while":[32],"learning":[33],"SQL":[34,81,169,220],"requires":[35],"further":[36],"research.":[37],"In":[38,74],"particular,":[39],"types":[41,50,134,162],"of":[42,68,90,112,120,130,168,188],"errors":[43,196],"students":[45,102,177],"encounter":[46],"on":[47,201,218],"various":[48],"assignment":[49,132,161,190,209],"or":[51],"under":[52],"exam":[53,202],"conditions":[54],"are":[55,60],"area":[57],"we":[59,77],"interested":[61],"determine":[64],"optimal":[66],"arrangement":[67],"coursework":[69,154],"materials":[70],"improved":[72],"learning.":[73],"this":[75],"paper,":[76],"analyze":[78],"156,513":[79],"student":[80],"submissions":[82,127],"homework":[84,206],"assignments,":[85,87],"collaborative":[86,208],"exams":[89],"Database":[92],"Systems":[93],"course":[94],"available":[95],"730":[97],"upper-level":[98],"undergraduate":[99],"graduate":[101],"offered":[103],"Fall":[106],"2022":[107],"semester":[108],"at":[109,117],"University":[111],"Illinois":[113],"Urbana-Champaign.":[114],"We":[115,144,173,211],"look":[116],"ratio":[119],"syntax":[121,141,181,195,224,229],"semantic":[123,199],"errors,":[124],"correct":[126],"each":[129],"problem":[133],"well":[136],"most":[139,178],"frequent":[140],"error":[142,182],"codes.":[143],"visualize":[145],"our":[146],"data":[147],"findings":[148],"draw":[150],"recommendations":[151],"future":[153],"arrangements":[155],"from":[156],"comparisons":[158],"between":[159],"a":[164,171,215],"more":[165,194],"effective":[166],"acquisition":[167],"skill.":[172],"found":[174],"although":[176],"commonly":[179],"encountered":[180],"codes":[183],"1064":[184],"1054":[186],"regardless":[187],"type,":[191],"they":[192],"made":[193],"(and":[197],"fewer":[198],"errors)":[200],"problems":[203],"compared":[204],"problems.":[210],"recommend":[212],"instructors":[213],"place":[214],"higher":[216],"emphasis":[217],"non-timed":[219],"programming":[221],"problems,":[222],"targeted":[223],"drills":[225],"during":[226,231],"instruction,":[227],"support":[230],"exams.":[232]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}