{"id":"https://openalex.org/W2249778925","doi":null,"title":"Learning Analytics with Excel Pivot Tables","display_name":"Learning Analytics with Excel Pivot Tables","publication_year":2012,"publication_date":"2012-01-01","ids":{"openalex":"https://openalex.org/W2249778925","mag":"2249778925"},"language":"en","primary_location":{"id":"pmh:oai:research.moodle.net:56","doi":null,"is_oa":false,"landing_page_url":"http://research.moodle.net/56/1/15%20-%20Dierenfeld%20-%20Learning%20Analytics%20with%20Excel%20Pivot%20Tables.pdf","pdf_url":"http://research.moodle.net/56/1/15%20-%20Dierenfeld%20-%20Learning%20Analytics%20with%20Excel%20Pivot%20Tables.pdf","source":{"id":"https://openalex.org/S4406922677","display_name":"Moodle Research","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference or Workshop Item"},"volume":null,"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/A5041320884","display_name":"Helena Dierenfeld","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Helena Dierenfeld","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5071069677","display_name":"Agathe Merceron","orcid":"https://orcid.org/0000-0003-1015-5359","observed_orcids":["https://orcid.org/0000-0003-1015-5359"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Agathe Merceron","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0003-1015-5359","affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.9547,"has_fulltext":false,"cited_by_count":26,"citation_normalized_percentile":{"value":0.7328153,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":98},"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.9990000128746033,"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.9990000128746033,"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/T14496","display_name":"Educational Technology and E-Learning","score":0.00039999998989515007,"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/T11891","display_name":"Big Data and Business Intelligence","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/learning-analytics","display_name":"learning analytics","score":0.9990000128746033},{"id":"https://openalex.org/keywords/moodle","display_name":"Moodle","score":0.8230000138282776},{"id":"https://openalex.org/keywords/usage-analytics","display_name":"usage analytics","score":0.7649999856948853},{"id":"https://openalex.org/keywords/course-design","display_name":"course design","score":0.5920000076293945},{"id":"https://openalex.org/keywords/non-technical-users","display_name":"non-technical users","score":0.6119999885559082}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7382655143737793},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6236443519592285},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5428812503814697},{"id":"https://openalex.org/C3019730874","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Microsoft excel","level":2,"score":0.5122029185295105},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.490386962890625},{"id":"https://openalex.org/C3018901056","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Ms excel","level":2,"score":0.4668933153152466},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3454463481903076},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.25704413652420044},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.23381981253623962},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:research.moodle.net:56","doi":null,"is_oa":false,"landing_page_url":"http://research.moodle.net/56/1/15%20-%20Dierenfeld%20-%20Learning%20Analytics%20with%20Excel%20Pivot%20Tables.pdf","pdf_url":"http://research.moodle.net/56/1/15%20-%20Dierenfeld%20-%20Learning%20Analytics%20with%20Excel%20Pivot%20Tables.pdf","source":{"id":"https://openalex.org/S4406922677","display_name":"Moodle Research","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference or Workshop Item"},{"id":"mag:2249778925","doi":null,"is_oa":false,"landing_page_url":"https://research.moodle.net/id/eprint/56","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality education","score":0.975600004196167,"id":"https://metadata.un.org/sdg/4"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1557144543","https://openalex.org/W1644511183","https://openalex.org/W2003805897","https://openalex.org/W2006444123","https://openalex.org/W2034334026","https://openalex.org/W2140190241","https://openalex.org/W2145283887","https://openalex.org/W2401600530","https://openalex.org/W2675793752"],"related_works":["https://openalex.org/W2789948175","https://openalex.org/W2394409080","https://openalex.org/W2181753132","https://openalex.org/W2768456881","https://openalex.org/W2752863933","https://openalex.org/W7136193311","https://openalex.org/W3014307082","https://openalex.org/W3102400874","https://openalex.org/W2810878372","https://openalex.org/W2902428278"],"abstract_inverted_index":{"Different":[0],"actors":[1],"like":[2],"teachers,":[3],"course":[4],"designers":[5],"and":[6,31,57],"content":[7],"providers":[8],"need":[9],"to":[10,48],"gain":[11,58],"more":[12],"information":[13],"about":[14],"the":[15,17,25],"way":[16],"resources":[18],"provided":[19],"with":[20,75],"Moodle":[21],"are":[22],"used":[23,47],"by":[24,73],"students":[26],"so":[27],"they":[28,69],"can":[29,45,70],"adjust":[30],"adapt":[32],"their":[33],"offer":[34],"better.":[35],"In":[36],"this":[37],"contribution":[38],"we":[39],"show":[40],"that":[41,68],"Excel":[42,64],"Pivot":[43,65],"Tables":[44,66],"be":[46,71],"conduct":[49],"a":[50],"flexible":[51],"analytical":[52],"processing":[53],"of":[54,63],"usage":[55],"data":[56],"valuable":[59],"information.":[60],"An":[61],"advantage":[62],"is":[67],"mastered":[72],"persons":[74],"good":[76],"IT-skills":[77],"but":[78],"not":[79],"necessarily":[80],"computer":[81],"scientists.":[82]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":2}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2016-06-24T00:00:00"}