Skip to main content
SpringerLink
Log in

Data Warehouse Technology for E-Learning

  • Chapter
Methods and Supporting Technologies for Data Analysis

Part of the book series: Studies in Computational Intelligence ((SCI,volume 225))

Abstract

E-Learning platforms are gaining popularity and relevance among organizations such as global enterprises, open and distance universities and research institutes. But regrettably these platforms present yet unsolved problems. One of these is that instructors cannot guarantee the success of the learning process because they lack tools with which monitor, assess and measure the performance of students in their virtual courses. Therefore, it is necessary to develop specific tools that help professors to do their work suitably. In this chapter, we show that data warehouse and OLAP technologies are the most suitable ones to build this software application. Likewise we explain the steps for its implementation from its conception up to the user interface development. Lastly, we summarize our experience in the design and implementation of MATEP,Monitoring and Analysis Tool for E-learning Platforms, which is a tool built in the University of Cantabria.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Álvarez, E., Zorrilla, M.E.: Orientaciones en el diseño y evaluación de un curso virtual parala enseñanza de aplicaciones informáticas. IEEE-RITA 3(2), 1–10 (2008)

    Google Scholar 

  2. Avouris, N., Komis, V., Fiotakis, G., Margaritis, M., Voyiatzaki, G.: Logging of fingertip actions is not enough for analysis of learning activities. In: Proccedings of Workshop Usage Analysis in learning systems (AIED 2005), Amsterdam (2005)

    Google Scholar 

  3. Blackboard, http://www.blackboard.com

  4. Claroline, http://www.claroline.net/

  5. Cooley, R., Mobasher, B., Srivastava, J.: Data Preparation for Mining World Wide Web Browsing Patterns. Journal of Knowledge and Information Systems 1(1) (1999)

    Google Scholar 

  6. GISMO (2007), http://gismo.sourceforge.net/

  7. Han, J.: Data mining: Concepts and Techniques. Morgan Kaufmann, San Francisco (2006)

    Google Scholar 

  8. Harinath, S., Quinn, S.: Professional SQL Server Analysis Services 2005 with MDX. Wiley Publishing Inc., Chichester (2006)

    Google Scholar 

  9. Hernández Orallo, J., Ramírez Quintana, M.J., Ferri Ramírez, C.: Introducción a la minería de datos. Pearson Prentice Hall, London (2004)

    Google Scholar 

  10. Hu, X., Cercone, N.: A data warehouse/online analytic processing framework for web usage mining and business intelligence reporting. International Journal of Intelligent Systems 19(7), 585–606 (2004)

    Article  Google Scholar 

  11. Inmon, W.H.: Building the Data Warehouse. Willey & Son, Chichester (2002)

    Google Scholar 

  12. Jacobson, R.: Microsoft SQL Server 2000 Analysis Services step by step. OLAP Train. Microsoft Press (2000)

    Google Scholar 

  13. Kimball, R., et al.: The Data Warehouse Lifecycle Toolkit: Tools and Techniques for Designing, Developing, and Deploying Data Warehouses. John Wiley & Sons, Chichester (1998)

    Google Scholar 

  14. Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit. John Wiley & Sons, Chichester (2002)

    Google Scholar 

  15. Kimball, R., Ross, M.: The data warehouse toolkit: the complete guide to dimensional modelling. John Wiley & Sons, Chichester (2002)

    Google Scholar 

  16. Luotonen, A.: The common log file format (1995), http://www.w3.org/pub/WWW/

  17. Martín Fraile, L.: Monitoring and analysis tool for e-Learning platforms. Final Degree Project directed by Zorrilla Pantaleón, M. University of Cantabria (2007)

    Google Scholar 

  18. Mazza, R., Dimitrova, V.: CourseVis: A graphical student monitoring tool for supporting instructors in web-based distance courses. International Journal of Human-Computer Studies 65(2), 125–139 (2007)

    Article  Google Scholar 

  19. Merceron, A., Yacef, K.: Tada-ed for educational data mining. Interactive Multimedia Electronic Journal of Computer-Enhanced Learning 7(1), 267–287 (2005)

    Google Scholar 

  20. Moodle, http://moodle.org/

  21. Mostow, J., Beck, J., Cen, H., Cuneo, A., Gouvea, E., Heiner, C.: An Educational Data Mining Tool to Browse Tutor-Student Interactions: Time Will Tell! In: Proc. of Workshop on educational data mining, pp. 15–22 (2005)

    Google Scholar 

  22. Mundy, J., Thorthwaite, W., Kimball, R.: The Microsoft Data Warehouse Toolkit: with SQL Server 2005 and the Microsoft Business Intelligence Toolset. Wiley Publishing Inc., Chichester (2006)

    Google Scholar 

  23. Pabarskaite, Z., Raudys, A.: A process of knowledge discovery from web log data: systematization and critical review. Journal Intelligent Information Systems 28, 79–114 (2007)

    Article  Google Scholar 

  24. Pentaho, http://www.pentaho.com/

  25. Romero, C., Ventura, S.: Data mining in E-Learning. Advances in Management Information, vol. 4. WIT Press (2006)

    Google Scholar 

  26. Spofford, G., et al.: MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase. Wiley Publishing, Chichester (2006)

    Google Scholar 

  27. Srivastava, J., Cooley, R., Deshpande, M., Tan, P.: Web usage mining: discovery and applications of usage patterns from Web data. SIGKDD Explor. 1(2), 12–23 (2000)

    Article  Google Scholar 

  28. Tan, P., Steinbach, M., Kumar, V.: Introduction to data mining. Pearson Prentice Hall, London (2006)

    Google Scholar 

  29. Tang, C., McCalla, G.: Smart recommendation for an evolving e-learning system. International Journal on E-Learning 4(1), 105–129 (2005)

    Google Scholar 

  30. Thomsen, E.: OLAP Solutions: Building Multidimensional Information Systems, 2nd edn. John Wiley & Sons, Chichester (2002)

    Google Scholar 

  31. Witten, I., Frank, E.: Data mining. Practical machine learning tools and techniques. Morgan Kaufmann, San Francisco (2005)

    MATH  Google Scholar 

  32. Zaïane, O., Xin, M., Han, J.: Discovering Web Access Patterns and Trends by Applying OLAP and Data Mining Technology on Web Logs. In: Proc. Advances in Digital Libraries, Santa Barbara (1998)

    Google Scholar 

  33. Zaïane, O.: Web Usage Mining for a Better Web-Based Learning Environment. In: Proc. of Conference on Advantage Technology for Education, Alberta, Canada (2001)

    Google Scholar 

  34. Zaïane, O.: Building a Recommender Agent for e-Learning Systems. In: Proceedings of the International Conference on Computers in Education (ICCE) (2000)

    Google Scholar 

  35. Zorrilla, M.E., Menasalvas, E., Marín, D., Mora, E., Segovia, J.: Web usage mining project for improving web-based learning sites. In: Moreno Díaz, R., Pichler, F., Quesada Arencibia, A. (eds.) EUROCAST 2005. LNCS, vol. 3643, pp. 205–210. Springer, Heidelberg (2005)

    Chapter  Google Scholar 

  36. Zorrilla, M., Millán, S., Menasalvas, E.: Data webhouse to support web intelligence in e-learning environments. In: Proc. of the IEEE International Conference on Granular Computing, Beijing, China (2005)

    Google Scholar 

  37. Zorrilla, M.E., Marín, D., Álvarez, E.: Towards virtual course evaluation using Web Intelligence. In: Moreno Díaz, R., Pichler, F., Quesada Arencibia, A. (eds.) EUROCAST 2007. LNCS, vol. 4739, pp. 392–399. Springer, Heidelberg (2007)

    Chapter  Google Scholar 

  38. Zorrilla, M.E., Álvarez, E.: MATEP: Monitoring and Analysis Tool for e-Learning Platforms. In: Proc. of the 8th IEEE International Conference on Advanced Learning Technologies, Santander, Spain, July, pp. 611–613 (2008)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Mathematics, Statistics and Computation, University of Cantabria., Avenida de los Castros s/n, 39005, Santander, Spain

    Marta E. Zorrilla

Authors
  1. Marta E. Zorrilla
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institute of Computer Science, Technical University of Lodz , Wolczanska 215, 90-924, Lodz, Poland

    Danuta Zakrzewska  & Liliana Byczkowska-Lipinska  & 

  2. Facultad de Informatica, Universidad Politecnica de Madrid , Campus de Montegancedo s/n, 28660, Boadilla del Monte Madrid, Spain

    Ernestina Menasalvas

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Zorrilla, M.E. (2009). Data Warehouse Technology for E-Learning. In: Zakrzewska, D., Menasalvas, E., Byczkowska-Lipinska, L. (eds) Methods and Supporting Technologies for Data Analysis. Studies in Computational Intelligence, vol 225. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-02196-1_1

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-02196-1_1

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-02195-4

  • Online ISBN: 978-3-642-02196-1

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation