Learning Analytics with Excel Pivot Tables

Learning Analytics with Excel Pivot Tables

• 1.
  Learning Analytics withExcel Pivot Tables Helena Dierenfeld Agathe Merceron Beuth Hochschule für Technik {hdierenfeld,merceron}@beuth-hochschule.de 18 September 2012
• 2.
  Outline  Motivation  LAMA–Learning, Analytics, Mining and Adaption  Pivot Tables  Conclusion and Future Work 2 Helena Dierenfeld
• 3.
  Motivation – LAMA – Pivot Tables – Conclusion Motivation  LMS will become more and more indispensable  It is important for teachers to be aware of how students learn  Learning analytics is a key factor for improving teaching and learning  LMS store user interaction data that can be analyzed 3 Helena Dierenfeld
• 4.
  Motivation – LAMA – Pivot Tables – Conclusion Why is this useful – an example Number of accesses to non compulsory quizzes in a course with over 50 students 4 Helena Dierenfeld
• 5.
  Motivation – LAMA – Pivot Tables – Conclusion Project Goal The goal of our project is to develop a tool to analyze usage data of learning management systems in depth for different education providers:  Own data model  Structuring usage data for analysis  Data anonymization  Intuitive GUI 5 Helena Dierenfeld
• 6.
  Motivation – LAMA – Pivot Tables – Conclusion Adaptation to the User  GUI with three different levels:  Quick overview • Specific charts  Personalized overview • Pivot Tables  For professionals • More statistics, data mining… 6 Helena Dierenfeld
• 7.
  Motivation LAMA – LAMA – Pivot Tables – Conclusion LAMA - Learning, Analytics, Mining and Adaption  View of all courses of a teacher after log in through moodle  Selecting the Courses to analyse  Chose which analysis type you want  Download it by clicking the submit button 7 Helena Dierenfeld
• 8.
  Motivation – LAMA – Pivot Tables – Conclusion What is a Pivot Table  A Pivot Table is a highly flexible contingency table  It offers the possibility to look at one sector at a time from a large dataset  For Excel the following formats are needed:  Headlines in the first row  No empty rows or columns are allowed  Empty fields are possible 8 Helena Dierenfeld
• 9.
  Motivation – LAMA – Pivot Tables – Conclusion Working with a Template 9 Helena Dierenfeld
• 10.
  Motivation – LAMA – Pivot Tables – Conclusion Conclusion and Future Work  Data model  First version of LAMA-Tool with Pivot Tables  Pivot Table template  Moodle Connection  Integration the GUI for a quick overview  Tests with the users  Research in data mining area 10 Helena Dierenfeld
• 11.
  Thank you Questions? 11 Helena Dierenfeld