{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T04:21:55Z","timestamp":1750220515645,"version":"3.41.0"},"publisher-location":"New York, NY, USA","reference-count":23,"publisher":"ACM","license":[{"start":{"date-parts":[[2021,11,18]],"date-time":"2021-11-18T00:00:00Z","timestamp":1637193600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2021,11,18]]},"DOI":"10.1145\/3488042.3489961","type":"proceedings-article","created":{"date-parts":[[2021,11,10]],"date-time":"2021-11-10T23:28:49Z","timestamp":1636586929000},"page":"1-3","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["Exploring the Prevalence of SQL Misconceptions: a Study Design"],"prefix":"10.1145","author":[{"given":"Daphne","family":"Miedema","sequence":"first","affiliation":[{"name":"AIDE Lab, Eindhoven University of Technology, Netherlands"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Efthimia","family":"Aivaloglou","sequence":"additional","affiliation":[{"name":"Leiden Institute of Advanced Computer Science, Leiden University, Netherlands and Open Universiteit, Netherlands"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"George","family":"Fletcher","sequence":"additional","affiliation":[{"name":"AIDE Lab, Eindhoven University of Technology, Netherlands"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2021,11,18]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/2839509.2844640"},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"crossref","unstructured":"Alireza Ahadi Julia Prior Vahid Behbood and Raymond Lister. 2016. Students semantic mistakes in writing seven different types of SQL queries. In ITiCSE. 272\u2013277.  Alireza Ahadi Julia Prior Vahid Behbood and Raymond Lister. 2016. Students semantic mistakes in writing seven different types of SQL queries. In ITiCSE. 272\u2013277.","DOI":"10.1145\/2899415.2899464"},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2005.06.028"},{"key":"e_1_3_2_1_4_1","doi-asserted-by":"crossref","unstructured":"Anthony Kleerekoper and Andrew Schofield. 2018. SQL tester: An online SQL assessment tool and its impact. In ITiCSE. 87\u201392.  Anthony Kleerekoper and Andrew Schofield. 2018. SQL tester: An online SQL assessment tool and its impact. In ITiCSE. 87\u201392.","DOI":"10.1145\/3197091.3197124"},{"key":"e_1_3_2_1_5_1","volume-title":"How Well Do Multiple Choice Tests Evaluate Student Understanding in Computer Programming Classes?Journal of Information Systems Education 14, 4","author":"Kuechler William","year":"2003","unstructured":"William Kuechler and Mark Simkin . 2003. How Well Do Multiple Choice Tests Evaluate Student Understanding in Computer Programming Classes?Journal of Information Systems Education 14, 4 ( 2003 ), 389. William Kuechler and Mark Simkin. 2003. How Well Do Multiple Choice Tests Evaluate Student Understanding in Computer Programming Classes?Journal of Information Systems Education 14, 4 (2003), 389."},{"key":"e_1_3_2_1_6_1","first-page":"99","article-title":"Guessing, partial knowledge, and misconceptions in multiple-choice tests","volume":"14","author":"Ngee\u00a0Kiong Lau Paul","year":"2011","unstructured":"Paul Ngee\u00a0Kiong Lau , Sie\u00a0Hoe Lau , Kian\u00a0Sam Hong , and Hasbee Usop . 2011 . Guessing, partial knowledge, and misconceptions in multiple-choice tests . Educational Technology and Society 14 , 4 (2011), 99 \u2013 110 . Paul Ngee\u00a0Kiong Lau, Sie\u00a0Hoe Lau, Kian\u00a0Sam Hong, and Hasbee Usop. 2011. Guessing, partial knowledge, and misconceptions in multiple-choice tests. Educational Technology and Society 14, 4 (2011), 99\u2013110.","journal-title":"Educational Technology and Society"},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1080\/08993408.2011.554722"},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"crossref","unstructured":"Daphne Miedema Efthimia Aivaloglou and George Fletcher. 2021. Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study. In ICER.  Daphne Miedema Efthimia Aivaloglou and George Fletcher. 2021. Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study. In ICER.","DOI":"10.1145\/3446871.3469759"},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"crossref","unstructured":"Andrew Migler and Alex Dekhtyar. 2020. Mapping the SQL learning process in introductory database courses. In SIGCSE. 619\u2013625.  Andrew Migler and Alex Dekhtyar. 2020. Mapping the SQL learning process in introductory database courses. In SIGCSE. 619\u2013625.","DOI":"10.1145\/3328778.3366869"},{"key":"e_1_3_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10639-017-9673-3"},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"crossref","unstructured":"Seth Poulsen Liia Butler Abdussalam Alawini and Geoffrey\u00a0L. Herman. 2020. Insights from Student Solutions to SQL Homework Problems. In ITiCSE. 404\u2013410.  Seth Poulsen Liia Butler Abdussalam Alawini and Geoffrey\u00a0L. Herman. 2020. Insights from Student Solutions to SQL Homework Problems. In ITiCSE. 404\u2013410.","DOI":"10.1145\/3341525.3387391"},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1977.231131"},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"crossref","unstructured":"Alaaeddin Swidan Felienne Hermans and Marileen Smit. 2018. Programming misconceptions for school students. In ICER. 151\u2013159.  Alaaeddin Swidan Felienne Hermans and Marileen Smit. 2018. Programming misconceptions for school students. In ICER. 151\u2013159.","DOI":"10.1145\/3230977.3230995"},{"key":"e_1_3_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/3287324.3287359"},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/3398377"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/3231712"},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1080\/00219266.1989.9655083"},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1007\/BF02356835"},{"key":"e_1_3_2_1_19_1","first-page":"190","article-title":"The Development of Three Tier Multiple Choice Test to Explore Junior High School Students \u2019 Scientific Literacy Misconceptions","volume":"8","author":"Wahidah Nurul","year":"2019","unstructured":"Nurul Wahidah and Sigit Saptono . 2019 . The Development of Three Tier Multiple Choice Test to Explore Junior High School Students \u2019 Scientific Literacy Misconceptions . Journal of Innovative Science Education 8 , 2 (2019), 190 \u2013 198 . Nurul Wahidah and Sigit Saptono. 2019. The Development of Three Tier Multiple Choice Test to Explore Junior High School Students \u2019 Scientific Literacy Misconceptions. Journal of Innovative Science Education 8, 2 (2019), 190\u2013198.","journal-title":"Journal of Innovative Science Education"},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"crossref","unstructured":"Renske Weeda Cruz Izu Maria Kallia and Erik Barendsen. 2020. Towards an Assessment Rubric for EiPE Tasks in Secondary Education: Identifying Quality Indicators and Descriptors. In Koli Calling (Koli Finland). Article 30 10\u00a0pages.  Renske Weeda Cruz Izu Maria Kallia and Erik Barendsen. 2020. Towards an Assessment Rubric for EiPE Tasks in Secondary Education: Identifying Quality Indicators and Descriptors. In Koli Calling (Koli Finland). Article 30 10\u00a0pages.","DOI":"10.1145\/3428029.3428031"},{"key":"e_1_3_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/319628.319656"},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1109\/FIE.2017.8190459"},{"key":"e_1_3_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10639-018-9824-1"}],"event":{"name":"Koli Calling '21: 21st Koli Calling International Conference on Computing Education Research","acronym":"Koli Calling '21","location":"Joensuu Finland"},"container-title":["Proceedings of the 21st Koli Calling International Conference on Computing Education Research"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3488042.3489961","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3488042.3489961","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T21:24:32Z","timestamp":1750195472000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3488042.3489961"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021,11,18]]},"references-count":23,"alternative-id":["10.1145\/3488042.3489961","10.1145\/3488042"],"URL":"https:\/\/doi.org\/10.1145\/3488042.3489961","relation":{},"subject":[],"published":{"date-parts":[[2021,11,18]]},"assertion":[{"value":"2021-11-18","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}