{"id":"https://openalex.org/W4412731815","doi":"https://doi.org/10.1145/3735091.3737573","title":"Train Hard, Score High: The Impact of Practice Tests on SQL Learning","display_name":"Train Hard, Score High: The Impact of Practice Tests on SQL Learning","publication_year":2025,"publication_date":"2025-06-22","ids":{"openalex":"https://openalex.org/W4412731815","doi":"https://doi.org/10.1145/3735091.3737573"},"language":"en","primary_location":{"id":"doi:10.1145/3735091.3737573","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3735091.3737573","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3735091.3737573","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th International Workshop on Data Systems Education: Bridging Education Practice with Education Research","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3735091.3737573","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5085145885","display_name":"Andrzej W\u00f3jtowicz","orcid":"https://orcid.org/0000-0003-1385-6572"},"institutions":[{"id":"https://openalex.org/I59411706","display_name":"Adam Mickiewicz University in Pozna\u0144","ror":"https://ror.org/04g6bbq64","country_code":"PL","type":"education","lineage":["https://openalex.org/I59411706"]}],"countries":["PL"],"is_corresponding":true,"raw_author_name":"Andrzej Wojtowicz","raw_affiliation_strings":["Adam Mickiewicz University, Poznan, Poland"],"affiliations":[{"raw_affiliation_string":"Adam Mickiewicz University, Poznan, Poland","institution_ids":["https://openalex.org/I59411706"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085938352","display_name":"Anna Stachowiak","orcid":"https://orcid.org/0000-0001-6988-5407"},"institutions":[{"id":"https://openalex.org/I59411706","display_name":"Adam Mickiewicz University in Pozna\u0144","ror":"https://ror.org/04g6bbq64","country_code":"PL","type":"education","lineage":["https://openalex.org/I59411706"]}],"countries":["PL"],"is_corresponding":false,"raw_author_name":"Anna Stachowiak","raw_affiliation_strings":["Adam Mickiewicz University, Poznan, Poland"],"affiliations":[{"raw_affiliation_string":"Adam Mickiewicz University, Poznan, Poland","institution_ids":["https://openalex.org/I59411706"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5119105826","display_name":"Emilia Pankowska","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Emilia Pankowska","raw_affiliation_strings":["Independent Researcher, Poznan, Poland"],"affiliations":[{"raw_affiliation_string":"Independent Researcher, Poznan, Poland","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5085145885"],"corresponding_institution_ids":["https://openalex.org/I59411706"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.10152657,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"35","last_page":"40"},"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.9955000281333923,"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.9955000281333923,"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/T10028","display_name":"Topic Modeling","score":0.991100013256073,"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/T12072","display_name":"Machine Learning and Algorithms","score":0.9696000218391418,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7382506132125854},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.616905152797699},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3960827887058258},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.37481844425201416},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.27392858266830444}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7382506132125854},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.616905152797699},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3960827887058258},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.37481844425201416},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.27392858266830444}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3735091.3737573","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3735091.3737573","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3735091.3737573","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th International Workshop on Data Systems Education: Bridging Education Practice with Education Research","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3735091.3737573","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3735091.3737573","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3735091.3737573","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th International Workshop on Data Systems Education: Bridging Education Practice with Education Research","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.5,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4412731815.pdf","grobid_xml":"https://content.openalex.org/works/W4412731815.grobid-xml"},"referenced_works_count":25,"referenced_works":["https://openalex.org/W140928998","https://openalex.org/W2047116498","https://openalex.org/W2133705455","https://openalex.org/W2161621074","https://openalex.org/W2163569782","https://openalex.org/W2221289407","https://openalex.org/W2293412016","https://openalex.org/W2473995384","https://openalex.org/W2885090162","https://openalex.org/W2936355586","https://openalex.org/W3006713862","https://openalex.org/W3007946258","https://openalex.org/W3009770877","https://openalex.org/W3193751197","https://openalex.org/W4207080468","https://openalex.org/W4252692452","https://openalex.org/W4255130368","https://openalex.org/W4282024298","https://openalex.org/W4323037334","https://openalex.org/W4382652696","https://openalex.org/W4392861661","https://openalex.org/W4392865259","https://openalex.org/W4396833300","https://openalex.org/W4400267666","https://openalex.org/W4407681660"],"related_works":["https://openalex.org/W2961085424","https://openalex.org/W4306674287","https://openalex.org/W4387369504","https://openalex.org/W4394896187","https://openalex.org/W3170094116","https://openalex.org/W4386462264","https://openalex.org/W3107602296","https://openalex.org/W4364306694","https://openalex.org/W4312192474","https://openalex.org/W4283697347"],"abstract_inverted_index":{"Practice":[0],"testing":[1],"is":[2,20,41],"a":[3,108],"well-established":[4],"method":[5,49],"for":[6],"enhancing":[7],"learning":[8,83],"and":[9,32,61,68,99,117],"long-term":[10],"knowledge":[11],"retention,":[12],"particularly":[13],"in":[14,50,125],"fields":[15],"requiring":[16],"problem-solving":[17],"skills.However,":[18],"there":[19],"still":[21],"not":[22],"enough":[23],"attention":[24],"given":[25],"to":[26,43,57],"the":[27,33,45,63,73],"automation":[28],"of":[29,35,47,75],"that":[30],"process":[31],"specifics":[34],"SQL":[36,82],"query-writing":[37],"skills.Moreover,":[38],"further":[39],"research":[40],"needed":[42],"clarify":[44],"effectiveness":[46],"this":[48],"database":[51],"education,":[52],"how":[53],"committed":[54],"students":[55,122],"are":[56],"taking":[58],"practice":[59,78,97,114,126],"tests,":[60],"whether":[62],"effects":[64],"differ":[65],"between":[66,112],"advanced":[67],"struggling":[69],"students.This":[70],"study":[71],"examines":[72],"influence":[74],"ungraded":[76],"(formative)":[77],"tests":[79,98,127],"on":[80,102],"students'":[81,94],"outcomes":[84],"using":[85],"CodeRunner/Jobe":[86],"autograder":[87],"system.We":[88],"conducted":[89],"an":[90],"observational":[91],"study,":[92],"analyzing":[93],"engagement":[95,116],"with":[96,121],"subsequent":[100],"performance":[101],"graded":[103,118],"(summative)":[104],"assessments.The":[105],"results":[106],"demonstrate":[107],"positive":[109],"causal":[110],"effect":[111],"low-high":[113],"test":[115,119],"scores,":[120],"actively":[123],"participating":[124],"achieving":[128],"significantly":[129],"higher":[130],"grades.":[131]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}