{"id":"https://openalex.org/W4366964219","doi":"https://doi.org/10.5220/0011848200003470","title":"Learning Analytics Solution for Monitoring and Analyzing the Students\u2019 Behavior in SQL Lab Work","display_name":"Learning Analytics Solution for Monitoring and Analyzing the Students\u2019 Behavior in SQL Lab Work","publication_year":2023,"publication_date":"2023-01-01","ids":{"openalex":"https://openalex.org/W4366964219","doi":"https://doi.org/10.5220/0011848200003470"},"language":"en","primary_location":{"id":"doi:10.5220/0011848200003470","is_oa":true,"landing_page_url":"http://dx.doi.org/10.5220/0011848200003470","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Conference on Computer Supported Education","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://dx.doi.org/10.5220/0011848200003470","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5051649554","display_name":"Abdelkader Ouared","orcid":"https://orcid.org/0000-0003-4257-0522"},"institutions":[{"id":"https://openalex.org/I149768937","display_name":"University of Namur","ror":"https://ror.org/03d1maw17","country_code":"BE","type":"education","lineage":["https://openalex.org/I149768937"]}],"countries":["BE"],"is_corresponding":true,"raw_author_name":"Abdelkader Ouared","raw_affiliation_strings":["Faculty of Computer Science / NaDI, University of Namur, Rue Grandgagnage, Namur 5000, Belgium, --- Select a Country ---"],"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science / NaDI, University of Namur, Rue Grandgagnage, Namur 5000, Belgium, --- Select a Country ---","institution_ids":["https://openalex.org/I149768937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103239660","display_name":"Moussa Amrani","orcid":"https://orcid.org/0000-0002-6987-1037"},"institutions":[{"id":"https://openalex.org/I149768937","display_name":"University of Namur","ror":"https://ror.org/03d1maw17","country_code":"BE","type":"education","lineage":["https://openalex.org/I149768937"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Moussa Amrani","raw_affiliation_strings":["Faculty of Computer Science / NaDI, University of Namur, Rue Grandgagnage, Namur 5000, Belgium, --- Select a Country ---"],"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science / NaDI, University of Namur, Rue Grandgagnage, Namur 5000, Belgium, --- Select a Country ---","institution_ids":["https://openalex.org/I149768937"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011513275","display_name":"Pierre\u2010Yves Schobbens","orcid":"https://orcid.org/0000-0001-8677-4485"},"institutions":[{"id":"https://openalex.org/I149768937","display_name":"University of Namur","ror":"https://ror.org/03d1maw17","country_code":"BE","type":"education","lineage":["https://openalex.org/I149768937"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Pierre-Yves Schobbens","raw_affiliation_strings":["Faculty of Computer Science / NaDI, University of Namur, Rue Grandgagnage, Namur 5000, Belgium, --- Select a Country ---"],"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science / NaDI, University of Namur, Rue Grandgagnage, Namur 5000, Belgium, --- Select a Country ---","institution_ids":["https://openalex.org/I149768937"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5051649554"],"corresponding_institution_ids":["https://openalex.org/I149768937"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.03617596,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"184","last_page":"195"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.8999999761581421,"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.8999999761581421,"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/T11283","display_name":"Experimental Learning in Engineering","score":0.8592000007629395,"subfield":{"id":"https://openalex.org/subfields/2214","display_name":"Media Technology"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T14470","display_name":"Advanced Data Processing Techniques","score":0.7534000277519226,"subfield":{"id":"https://openalex.org/subfields/2207","display_name":"Control and Systems Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"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.7583109140396118},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.7160974144935608},{"id":"https://openalex.org/keywords/work","display_name":"Work (physics)","score":0.624043881893158},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6167178750038147},{"id":"https://openalex.org/keywords/learning-analytics","display_name":"Learning analytics","score":0.5439481735229492},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4615177810192108},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.29032376408576965},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.11370015144348145}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7583109140396118},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.7160974144935608},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.624043881893158},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6167178750038147},{"id":"https://openalex.org/C2777648619","wikidata":"https://www.wikidata.org/wiki/Q2845208","display_name":"Learning analytics","level":2,"score":0.5439481735229492},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4615177810192108},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.29032376408576965},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.11370015144348145},{"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":"doi:10.5220/0011848200003470","is_oa":true,"landing_page_url":"http://dx.doi.org/10.5220/0011848200003470","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Conference on Computer Supported Education","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.unamur.be:openaire/26bd111a-befa-4f7a-abba-54a428b8bc5b","is_oa":true,"landing_page_url":"https://researchportal.unamur.be/en/publications/26bd111a-befa-4f7a-abba-54a428b8bc5b","pdf_url":null,"source":{"id":"https://openalex.org/S4406922457","display_name":"Repository of the University of Namur","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Ouared, A, Amrani, M & Schobbens, P Y 2023, Learning Analytics Solution for Monitoring and Analyzing the Students\u2019 Behavior in SQL Lab Work. in J Jovanovic, I-A Chounta, J Uhomoibhi & B McLaren (eds), Proceedings of the 15th International Conference on Computer Supported Education - Volume 2, CSEDU 2023. International Conference on Computer Supported Education, CSEDU - Proceedings, vol. 2, Science and Technology Publications, Lda, pp. 184-195, 15th International Conference on Computer Supported Education, CSEDU 2023, Prague, Czech Republic, 21/04/23. https://doi.org/10.5220/0011848200003470","raw_type":"contributionToPeriodical"},{"id":"pmh:oai:pure.unamur.be:openaire_cris_publications/26bd111a-befa-4f7a-abba-54a428b8bc5b","is_oa":true,"landing_page_url":"https://www.scopus.com/pages/publications/85160859359","pdf_url":null,"source":{"id":"https://openalex.org/S4406922457","display_name":"Repository of the University of Namur","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Ouared, A, Amrani, M & Schobbens, P Y 2023, Learning Analytics Solution for Monitoring and Analyzing the Students\u2019 Behavior in SQL Lab Work. in J Jovanovic, I-A Chounta, J Uhomoibhi & B McLaren (eds), Proceedings of the 15th International Conference on Computer Supported Education - Volume 2, CSEDU 2023. International Conference on Computer Supported Education, CSEDU - Proceedings, vol. 2, Science and Technology Publications, Lda, pp. 184-195, 15th International Conference on Computer Supported Education, CSEDU 2023, Prague, Czech Republic, 21/04/23. https://doi.org/10.5220/0011848200003470","raw_type":"contributionToPeriodical"}],"best_oa_location":{"id":"doi:10.5220/0011848200003470","is_oa":true,"landing_page_url":"http://dx.doi.org/10.5220/0011848200003470","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Conference on Computer Supported Education","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W1987827786","https://openalex.org/W2799586942","https://openalex.org/W2504091800","https://openalex.org/W2331775400","https://openalex.org/W2768832457","https://openalex.org/W2816728186","https://openalex.org/W2804624249","https://openalex.org/W605203981","https://openalex.org/W2560130217","https://openalex.org/W2911048623"],"abstract_inverted_index":{"Computer-assisted":[0],"learning":[1,33,54,69,90,99,145,152],"is":[2,23,84,128,183],"widely":[3],"discussed":[4],"in":[5,18,70,147,173],"the":[6,10,37,60,67,89,106,136,159,165,170,178],"literature":[7],"to":[8,27,36,49,56,102,130,157,176],"aid":[9],"comprehension":[11],"of":[12,110],"SQL":[13,71,111,121,174],"queries":[14],"(Structured":[15],"Query":[16],"Language)":[17],"higher":[19,38],"education.":[20],"However,":[21],"it":[22],"difficult":[24],"for":[25,51,81,155],"educators/instructors":[26],"track,":[28],"monitor":[29,57],"and":[30,41,58,108,112,134,150,161,168],"analyze":[31,59],"students\u2019":[32,166],"situation":[34],"due":[35],"education":[39],"massification,":[40],"institutions":[42],"with":[43],"large":[44],"classes.":[45],"Consequently,":[46],"we":[47,96],"need":[48],"provide":[50],"educators":[52,156],"a":[53,75,85,141],"dashboard":[55,154],"digital":[61],"traces":[62],"issued":[63,115],"from":[64,116],"students":[65,104,118,171],"during":[66,119,143],"practice":[68,144],"course.":[72],"We":[73],"propose":[74,97],"system":[76],"called":[77],"LSQL":[78],"(Learning":[79],"Analytics":[80],"SQL)":[82],"that":[83,163],"solution":[86],"based":[87],"on":[88],"analytics\u2019":[91],"methodology.":[92],"To":[93],"this":[94],"end,":[95],"(i)":[98],"environment":[100],"dedicated":[101],"help":[103],"understand":[105],"syntax":[107],"logic":[109],"getting":[113],"data":[114],"these":[117],"online":[120],"lab":[122],"work,":[123],"(ii)":[124],"trace":[125],"model":[126],"which":[127],"designed":[129],"more":[131],"effectively":[132],"represent":[133,164],"capture":[135],"complex":[137],"interactions/actions":[138],"carried":[139],"by":[140],"student":[142],"activities":[146],"virtual/remote":[148],"laboratories,":[149],"(iii)":[151],"analytics":[153],"visualize":[158],"statistics":[160],"metrics":[162],"behavior,":[167],"control":[169],"progress":[172],"skills":[175],"enhance":[177],"teaching":[179],"activities.":[180],"Tool":[181],"support":[182],"fully":[184],"available.":[185]},"counts_by_year":[],"updated_date":"2025-12-23T23:11:35.936235","created_date":"2025-10-10T00:00:00"}