{"id":"https://openalex.org/W7220803465","doi":null,"title":"Echelon; meaningful feature extraction and clustering on SQL queries","display_name":"Echelon; meaningful feature extraction and clustering on SQL queries","publication_year":2022,"publication_date":"2022-07-22","ids":{"openalex":"https://openalex.org/W7220803465"},"language":"en","primary_location":{"id":"pmh:oai:www.ideals.illinois.edu:2142/116293","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/116293","pdf_url":"https://www.ideals.illinois.edu/items/125418/bitstreams/411693/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"volume":null,"type":"dissertation","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://www.ideals.illinois.edu/items/125418/bitstreams/411693/data.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5157791210","display_name":"Matthew Charles Weston","orcid":null,"observed_orcids":[]},"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":"Weston, Matthew Charles","raw_affiliation_strings":["Computer Science in the Graduate College of the University of Illinois Urbana-Champaign , 2022 Urbana , Illinois"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science in the Graduate College of the University of Illinois Urbana-Champaign , 2022 Urbana , Illinois","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5157791210"],"corresponding_institution_ids":["https://openalex.org/I157725225"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.5814999938011169,"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.5814999938011169,"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.3878999948501587,"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/T10260","display_name":"Software Engineering Research","score":0.013299999758601189,"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/sql-queries","display_name":"SQL queries","score":0.5879999995231628},{"id":"https://openalex.org/keywords/student-code-analysis","display_name":"student code analysis","score":0.7599999904632568},{"id":"https://openalex.org/keywords/automated-grading","display_name":"automated grading","score":0.6690000295639038},{"id":"https://openalex.org/keywords/feature-extraction","display_name":"feature extraction","score":0.5879999995231628},{"id":"https://openalex.org/keywords/clustering","display_name":"clustering","score":0.6949999928474426},{"id":"https://openalex.org/keywords/database-systems-education","display_name":"database systems education","score":0.8069999814033508},{"id":"https://openalex.org/keywords/computer-science-education","display_name":"computer science education","score":0.7360000014305115},{"id":"https://openalex.org/keywords/interactive-dashboard","display_name":"interactive dashboard","score":0.6320000290870667},{"id":"https://openalex.org/keywords/assessment-of-student-learning","display_name":"assessment of student learning","score":0.31200000643730164}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7502999901771545},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.6323999762535095},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.48489999771118164},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.45750001072883606},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.43529999256134033},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.42640000581741333},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.3531999886035919},{"id":"https://openalex.org/C195807954","wikidata":"https://www.wikidata.org/wiki/Q1662562","display_name":"Information extraction","level":2,"score":0.3529999852180481},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33149999380111694},{"id":"https://openalex.org/C52622490","wikidata":"https://www.wikidata.org/wiki/Q1026626","display_name":"Feature extraction","level":2,"score":0.29109999537467957},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.28040000796318054},{"id":"https://openalex.org/C17212007","wikidata":"https://www.wikidata.org/wiki/Q5511111","display_name":"Fuzzy clustering","level":3,"score":0.27889999747276306},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.2678999900817871},{"id":"https://openalex.org/C153180895","wikidata":"https://www.wikidata.org/wiki/Q7148389","display_name":"Pattern recognition (psychology)","level":2,"score":0.26750001311302185}],"mesh":[],"locations_count":1,"locations":[{"id":"pmh:oai:www.ideals.illinois.edu:2142/116293","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/116293","pdf_url":"https://www.ideals.illinois.edu/items/125418/bitstreams/411693/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"}],"best_oa_location":{"id":"pmh:oai:www.ideals.illinois.edu:2142/116293","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/116293","pdf_url":"https://www.ideals.illinois.edu/items/125418/bitstreams/411693/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality education","score":0.9235000014305115}],"study_designs":[],"awards":[{"id":"https://openalex.org/G7066688587","display_name":"Foundational Research and Data-driven Tool Development to Enhance Learning of Database Programming","funder_award_id":"2021499","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7220803465.pdf","grobid_xml":"https://content.openalex.org/works/W7220803465.grobid-xml"},"referenced_works_count":9,"referenced_works":["https://openalex.org/W1964523235","https://openalex.org/W1981759353","https://openalex.org/W2037085022","https://openalex.org/W2216374816","https://openalex.org/W2286501037","https://openalex.org/W2751448157","https://openalex.org/W2980741705","https://openalex.org/W3030163527","https://openalex.org/W4236151674"],"related_works":["https://openalex.org/W7042838691","https://openalex.org/W7113636890","https://openalex.org/W2999699333","https://openalex.org/W1546412598","https://openalex.org/W4297745865","https://openalex.org/W3020406534","https://openalex.org/W7133208575","https://openalex.org/W2282411808","https://openalex.org/W2801426799","https://openalex.org/W4200122970"],"abstract_inverted_index":{"A":[0],"core":[1],"part":[2],"of":[3,16,74,106,122,132,202],"Computer":[4,140],"Science":[5,141],"education,":[6],"and":[7,22,89,118,157,169],"Database":[8],"Systems":[9],"education":[10],"in":[11,66,115,191],"particular,":[12],"is":[13,130],"the":[14,44,53,59,165,188],"use":[15,56,121],"machine":[17],"problems":[18],"to":[19,27,57,69,83,96,125,160,174,182,194],"both":[20],"develop":[21,126],"assess":[23],"students'":[24,75,116,154,192],"abilities.In":[25],"order":[26],"conserve":[28],"resources,":[29],"these":[30,47,93,123,172],"assignments":[31,60],"are":[32],"often":[33],"automatically":[34],"graded":[35],"via":[36],"auto-grading":[37],"systems":[38,48],"that":[39,41,112,129,149,163,178],"verify":[40],"they":[42],"produce":[43],"correct":[45],"outputs.Unfortunately,":[46],"lack":[49],"essential":[50],"insights":[51],"into":[52],"approaches":[54,167,193],"students":[55],"solve":[58],"being":[61],"graded,":[62],"allowing":[63],"subtle":[64],"flaws":[65],"student":[67],"intuition":[68],"go":[70],"unseen.Furthermore,":[71],"manual":[72],"analysis":[73,201],"code":[76],"submissions":[77],"at":[78],"scale":[79],"ranges":[80],"from":[81,153],"costly":[82],"impossible,":[84],"depending":[85],"on":[86,204],"course":[87],"size":[88],"assignment":[90],"frequency,":[91],"making":[92],"drawbacks":[94],"difficult":[95],"avoid.In":[97],"this":[98],"thesis":[99],"paper,":[100],"we":[101],"rigorously":[102],"define":[103],"a":[104,110,127,135,195,199],"series":[105],"metrics":[107,124],"for":[108,139],"evaluating":[109],"system":[111,128],"captures":[113],"nuances":[114],"approach,":[117],"then":[119,170],"make":[120],"capable":[131],"serving":[133],"as":[134],"significant":[136,152],"force":[137],"multiplier":[138],"faculty.This":[142],"system,":[143],"Echelon,":[144],"functions":[145],"by":[146],"extracting":[147],"features":[148],"instructors":[150],"deem":[151],"SQL":[155],"queries":[156],"using":[158],"them":[159],"generate":[161],"clusters":[162,173],"capture":[164],"key":[166],"taken,":[168],"projecting":[171],"an":[175],"interactive":[176],"dashboard":[177],"can":[179],"be":[180],"used":[181],"help":[183],"teaching":[184],"staff":[185],"quickly":[186],"identify":[187],"major":[189],"trends":[190],"problem.We":[196],"conclude":[197],"with":[198],"full":[200],"Echelon":[203],"real":[205],"data.":[206]},"counts_by_year":[],"updated_date":"2026-11-08T12:12:28.789561","created_date":"2026-10-07T00:00:00"}