{"id":"https://openalex.org/W2050428880","doi":null,"title":"Online assessment of SQL query formulation skills","display_name":"Online assessment of SQL query formulation skills","alternate_titles":[],"publication_year":2003,"publication_date":"2003-01-01","ids":{"openalex":"https://openalex.org/W2050428880","mag":"2050428880"},"language":"en","primary_location":{"id":"mag:2050428880","doi":null,"is_oa":false,"landing_page_url":"http://crpit.com/confpapers/CRPITV20Prior.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306417782","display_name":"Australasian Computing Education Conference","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Australasian Computing Education Conference","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2050428880"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":[],"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/A5082791746","display_name":"Julia Coleman Prior","orcid":"https://orcid.org/0000-0002-7182-0984","observed_orcids":["https://orcid.org/0000-0002-7182-0984"]},"institutions":[{"id":"https://openalex.org/I114017466","display_name":"University of Technology Sydney","ror":"https://ror.org/03f0f6041","country_code":"AU","type":"education","lineage":["https://openalex.org/I114017466"]}],"countries":["AU"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Julia Prior","raw_affiliation_strings":["Department of Software Engineering, Faculty of Information Technology, University of Technology, Sydney, Sydney, Australia#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Software Engineering, Faculty of Information Technology, University of Technology, Sydney, Sydney, Australia#TAB#","institution_ids":["https://openalex.org/I114017466"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5082791746"],"corresponding_institution_ids":["https://openalex.org/I114017466"],"apc_list":null,"apc_paid":null,"fwci":1.1713,"has_fulltext":false,"cited_by_count":57,"citation_normalized_percentile":{"value":0.76500639,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"247","last_page":"256"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9682999849319458,"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/T10533","display_name":"Teaching and Learning Programming","score":0.9682999849319458,"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/T14025","display_name":"Educational Technology and Assessment","score":0.011300000362098217,"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"}},{"id":"https://openalex.org/T11299","display_name":"Problem and Project Based Learning","score":0.002099999925121665,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/online-assessment","display_name":"online assessment","score":0.9589999914169312},{"id":"https://openalex.org/keywords/assessment-task-design","display_name":"assessment task design","score":0.6420000195503235},{"id":"https://openalex.org/keywords/deep-learning","display_name":"deep learning","score":0.9449999928474426},{"id":"https://openalex.org/keywords/software-engineering-education","display_name":"software engineering education","score":0.6299999952316284},{"id":"https://openalex.org/keywords/database-programming","display_name":"database programming","score":0.3140000104904175}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8308287858963013},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6911870241165161},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.6819831132888794},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.49455854296684265},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.49186253547668457},{"id":"https://openalex.org/C2777855551","wikidata":"https://www.wikidata.org/wiki/Q12310021","display_name":"Subject (documents)","level":2,"score":0.4127640724182129},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4012482762336731},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.36427587270736694},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.26539939641952515},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.22941920161247253},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.21194249391555786},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.11605274677276611},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.10357698798179626},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09084442257881165},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0714057981967926},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"mag:2050428880","doi":null,"is_oa":false,"landing_page_url":"http://crpit.com/confpapers/CRPITV20Prior.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306417782","display_name":"Australasian Computing Education Conference","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Australasian Computing Education Conference","raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.10.4202","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.10.4202","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://crpit.com/confpapers/CRPITV20Prior.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.866.5842","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.866.5842","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://opus.lib.uts.edu.au/bitstream/10453/1792/3/2003001930.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.975600004196167,"display_name":"Quality education","id":"https://metadata.un.org/sdg/4"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W30690199","https://openalex.org/W1508984685","https://openalex.org/W1964560776","https://openalex.org/W2058655740","https://openalex.org/W2058925366","https://openalex.org/W2071100465","https://openalex.org/W2086642376","https://openalex.org/W2125350446","https://openalex.org/W2135982540","https://openalex.org/W2806639017"],"related_works":["https://openalex.org/W2084734886","https://openalex.org/W1606424393","https://openalex.org/W6964977191","https://openalex.org/W2020126579","https://openalex.org/W1608013224","https://openalex.org/W7095314968","https://openalex.org/W2809284492","https://openalex.org/W3134953192"],"abstract_inverted_index":{"Being":[0],"able":[1],"to":[2,47,57,112],"formulate":[3],"useful":[4],"SQL":[5,36],"queries":[6],"is":[7,19,40,103,120,130,141],"a":[8,20,41,91,94,114,131],"fundamental":[9],"skill":[10,18],"required":[11],"by":[12],"many":[13],"software":[14],"development":[15],"professionals.":[16],"Masteringthis":[17],"difficultprocess,":[21],"requiringconsiderable":[22],"practice":[23],"and":[24,52,77,101,110],"effort":[25],"on":[26,97],"the":[27,30,58,122,133],"part":[28],"of":[29,35,70,82,148],"student.":[31],"In":[32],"addition,":[33],"assessment":[34],"query":[37],"formulation":[38],"skills":[39],"process":[42],"that":[43,86,105,136],"does":[44],"not":[45],"appear":[46],"have":[48],"been":[49],"thoroughly":[50],"researched,":[51],"numerous":[53],"problems":[54,74],"are":[55,88,107,127],"inherent":[56],"approaches":[59],"commonly":[60],"taken":[61],"in":[62,90],"universitiesto":[63],"do":[64],"this":[65,146],"assessment.":[66,83,149],"Thispaper":[67],"examines":[68],"two":[69],"these":[71],"approaches,":[72],"identifies":[73],"with":[75],"them,":[76],"then":[78],"proposes":[79],"another":[80],"method":[81],"The":[84,117],"way":[85],"students":[87],"assessed":[89],"subject":[92],"has":[93],"significant":[95],"impact":[96],"their":[98],"learning":[99],"approach,":[100],"it":[102,126],"crucial":[104],"assessmenttasks":[106],"carefully":[108],"designed":[109],"implemented":[111],"inculcate":[113],"deep":[115],"learningexperience.":[116],"online":[118],"assessmentmethodproposed":[119],"described,evaluated,and":[121],"challengesand":[123],"benefitsof":[124],"using":[125],"discussed.":[128],"This":[129],"work-in-progressand":[132],"conclusion":[134],"states":[135],"further":[137],"validationis":[138],"needed,and":[139],"there":[140],"opportunity":[142],"for":[143],"additionalresearchand":[144],"developmentin":[145],"particulararea":[147]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2050428880","counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":8},{"year":2017,"cited_by_count":8},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
