{"id":"https://openalex.org/W3211756673","doi":"https://doi.org/10.1145/3488042.3489970","title":"Building a Better SQL Automarker for Database Courses","display_name":"Building a Better SQL Automarker for Database Courses","publication_year":2021,"publication_date":"2021-11-10","ids":{"openalex":"https://openalex.org/W3211756673","doi":"https://doi.org/10.1145/3488042.3489970","mag":"3211756673"},"language":"en","primary_location":{"id":"doi:10.1145/3488042.3489970","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3488042.3489970","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st Koli Calling International Conference on Computing Education Research","raw_type":"proceedings-article"},"type":"conference-paper","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/A5008107923","display_name":"Muyu Wang","orcid":"https://orcid.org/0009-0002-8009-3966"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Muyu Wang","raw_affiliation_strings":["University of Toronto Mississauga, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto Mississauga, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046399251","display_name":"Naaz Sibia","orcid":"https://orcid.org/0000-0001-7628-7077"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Naaz Sibia","raw_affiliation_strings":["University of Toronto Mississauga, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto Mississauga, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042306223","display_name":"Ilir Dema","orcid":null},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ilir Dema","raw_affiliation_strings":["University of Toronto Mississauga, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto Mississauga, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017029944","display_name":"Michael Liut","orcid":"https://orcid.org/0000-0003-2965-5302"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Michael Liut","raw_affiliation_strings":["University of Toronto Mississauga, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto Mississauga, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041109825","display_name":"Carlos An\u00edbal Su\u00e1rez","orcid":"https://orcid.org/0000-0002-6012-932X"},"institutions":[{"id":"https://openalex.org/I2135383","display_name":"Escuela Superior Politecnica del Litoral","ror":"https://ror.org/04qenc566","country_code":"EC","type":"education","lineage":["https://openalex.org/I2135383"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Carlos An\u00edbal Su\u00e1rez","raw_affiliation_strings":["Escuela Superior Polit\u00e9cnica del Litoral, Ecuador"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escuela Superior Polit\u00e9cnica del Litoral, Ecuador","institution_ids":["https://openalex.org/I2135383"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"3"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9908000230789185,"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.9908000230789185,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9710999727249146,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T14025","display_name":"Educational Technology and Assessment","score":0.9110999703407288,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/grading","display_name":"Grading (engineering)","score":0.7827004194259644},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7745974063873291},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.705612301826477},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49806952476501465},{"id":"https://openalex.org/keywords/teaching-assistant","display_name":"Teaching assistant","score":0.430703341960907},{"id":"https://openalex.org/keywords/institution","display_name":"Institution","score":0.41659754514694214},{"id":"https://openalex.org/keywords/work","display_name":"Work (physics)","score":0.4144592881202698},{"id":"https://openalex.org/keywords/mathematics-education","display_name":"Mathematics education","score":0.2835688292980194},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.13060486316680908},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.07919496297836304}],"concepts":[{"id":"https://openalex.org/C2777286243","wikidata":"https://www.wikidata.org/wiki/Q5591926","display_name":"Grading (engineering)","level":2,"score":0.7827004194259644},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7745974063873291},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.705612301826477},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49806952476501465},{"id":"https://openalex.org/C3019401138","wikidata":"https://www.wikidata.org/wiki/Q2070313","display_name":"Teaching assistant","level":2,"score":0.430703341960907},{"id":"https://openalex.org/C2780510313","wikidata":"https://www.wikidata.org/wiki/Q178706","display_name":"Institution","level":2,"score":0.41659754514694214},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.4144592881202698},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.2835688292980194},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.13060486316680908},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.07919496297836304},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C147176958","wikidata":"https://www.wikidata.org/wiki/Q77590","display_name":"Civil engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3488042.3489970","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3488042.3489970","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st Koli Calling International Conference on Computing Education Research","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.6399999856948853}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1646278814","https://openalex.org/W2011607672","https://openalex.org/W2085975912","https://openalex.org/W2111643688","https://openalex.org/W2546758670","https://openalex.org/W2974218799","https://openalex.org/W3116357669"],"related_works":["https://openalex.org/W2064165679","https://openalex.org/W1588461101","https://openalex.org/W2885058781","https://openalex.org/W3208525924","https://openalex.org/W1552490082","https://openalex.org/W2189583758","https://openalex.org/W3009904625","https://openalex.org/W1983121850","https://openalex.org/W3088126669","https://openalex.org/W4320802139"],"abstract_inverted_index":{"This":[0],"work":[1],"introduces":[2],"and":[3,29,35,50,74,89],"demonstrates":[4],"the":[5,21,26,32,42,48,70,104,117,122],"viability":[6],"of":[7,31,81,96,103],"a":[8,17,77,109],"novel":[9],"SQL":[10],"automarking":[11],"tool":[12,68],"(\u201cSQAM\u201d)":[13],"that:":[14],"(1)":[15],"provides":[16],"fair":[18],"grade":[19],"to":[20,37,44,64,94,125],"student,":[22],"one":[23],"which":[24],"matches":[25],"student\u2019s":[27],"effort":[28],"understanding":[30],"course":[33,107],"material,":[34],"(2)":[36],"provide":[38],"personalized":[39],"feedback,":[40],"allowing":[41],"student":[43],"remain":[45],"engaged":[46],"in":[47,58],"material":[49],"learn":[51],"from":[52],"their":[53],"mistakes":[54],"while":[55,115],"still":[56],"being":[57],"that":[59,66,76,95],"headspace.":[60],"Additionally,":[61],"we":[62,87],"strive":[63],"ensure":[65],"our":[67,91],"maintains":[69],"same":[71,105],"standards":[72],"(grade":[73],"feedback)":[75],"highly":[78],"qualified":[79],"member":[80],"teaching":[82,97,123],"staff":[83,124],"would":[84],"produce,":[85],"so":[86],"compare":[88],"contrast":[90],"automarker\u2019s":[92],"results":[93],"assistants":[98],"over":[99],"several":[100],"historic":[101],"offerings":[102],"database":[106],"at":[108],"large":[110],"research":[111],"intensive":[112],"public":[113],"institution,":[114],"reducing":[116],"grading":[118],"time,":[119],"thus":[120],"enabling":[121],"channel":[126],"more":[127],"time":[128],"into":[129],"instruction.":[130]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1}],"updated_date":"2026-07-15T18:14:33.161393","created_date":"2025-10-10T00:00:00"}