Daniela Resende Silva1 E-mail: daniela@dc.ufscar.br Marina Teresa Pires Vieira E-mail: marina@dc.ufscar.br
Department of Computer Sciences UFSCar - Federal University of São Carlos Rod. Washington Luís, Km 235 Caixa Postal 676 13565-905 / São Carlos – SP – Brazil Phone/Fax:(55 16) 260-8232 Abstract
This paper discusses the use of Data Warehouse and Data Mining resources to aid in the assessment of distance learning of students enrolled in distance courses. Information considered relevant for the assessment of distance learning is presented, as is the modeling of a data warehouse to store this information and the MultiStar environment, which allows for knowledge discovery to be performed in the data warehouse. The work proposed herein presents an approach that differs from the existing ones for the ongoing assessment of distance learning using some of the aspects relating to those utilized in the above cited studies. Section 2 provides a set of information to guide the implementation of ongoing assessment of learning in distance learning environments, while Section 3 briefly discusses the modeling of a data warehouse based on the set of information proposed. Section 4 presents the implementation of this data warehouse using the MultiStar environment, and finally, Section 5 lists our conclusions to this paper.
1. Introduction
A variety of applications have benefited from the use of Data Warehousing technology [1, 2, 3] to support management analyses, which can be obtained through the use of Data Mining [4]. The joint use of Data Warehousing and Data Mining techniques is a trend in KDD – Knowledge Discovery in Data Warehousing applications (referred to herein as KDW – Knowledge Discovery in Data Warehouse), since the data in a warehouse are better prepared for data mining. This paper discusses how the data warehouse and data mining resources can be used for the
References: [1] W.H. Inmon, Building the Data Warehouse, John Wiley & Sons, 2nd edition, 1996 [2] R. Kimball, The Data Warehouse Toolkit – Practical Techniques for Building Dimensional Data Warehouses, John Wiley Professio, 1996 [3] R. Kimball, L. Reeves, M. Ross and W. Thornthwaite, The Data Warehouse Lifecycle Toolkit, Willey Computer Publishings, 1998 [4] J. Han and M. Kamber, Data mining – Concepts and Techniques, 1 st edition, New York: Morgan Kaufmann, 2000 [5] K. Nurmela, E. Lehtinen, T. Palonen, Evaluating CSCL Log Files by Social Network Analysis, In: 44 Computer Support for Collaborative Learning, Stanford, USA, 1999. Proceedings. p. 434-441 [6] M. Rahkila and M. Karjalainen, Evaluation of Learning in Computer Based Education Using Log Systems. In: ASEE/IEEE Frontiers in Education Conference, 29., San Juan, Puerto Rico, 1999, Procedings. p. 16-21 [7] S.L. Tanimoto, Towards an Ontology for Alternative Assessment in Education. Metting of IEEE Learning Technology Standards Committee, Pittsburgh, USA, 1998 [8] J. Pei, J. Han, B. Mortazavi-Asl and H. Zhu, Mining Access Patterns Efficiently from Web Logs, In: PacificAsia Conference on Knowledge Discovery and Data Mining, Kyoto, Japan, 2000, Proceedings. p. 396-407 [9] O.R. Zaiane, M. Xin and J. Han, Discovering Web Access Patterns and Trends by Applying OLAP and Data Mining Technology on Web Logs, In: Advances in Digital Libraries Conference, Santa Barbara, USA, 1998, Proceedings. p. 19-29 [11] B. Mortazavi-Asl, Discovering and Mining User Web-Page Traversal Patterns, MPhil. Dissertation, Simon Fraser University, 1999, p. 93 [12] D.R. Silva and M.T.P. Vieira, An Ongoing Assessment Model in Distance Learning, In: Proceedings of Internet and Multimedia Systems and Applications, Honolulu, USA, 2001 [13] C. Vrasidas and M.S. McIsaac, Factors Influencing Interaction in an Online Course; The American Journal of Distance Education, v. 13, n. 3, 1999. [14] D.R. Silva, A Tool for Knowledge Discovery using Data Warehousing and its Application on the Ongoing Assessment of Distance Learning. MPhil. Dissertation, Departament of Computer Science, UFSCar, São Carlos, Brazil, 2002, 108p. (In portuguese) [15] R. Agrawal, T. Imielinski and A. Swami, Mining Associations between Sets of Items in Massive Databases. In: ACM SIGMOD International Conference on the Management of Data. New York, USA, 1993. Proceedings. NY: ACM Press, 1993, p. 207--216. [16] J.R. Quinlan, Induction of Decision Trees. Machine Learning, 1:81-106, 1986 [17] P. Cheeseman and J. Stutz, Bayesian Classification (AutoClass): Theory and Results, In: Advances in Knowledge Discovery in Databases, 1995. 10., Proceedings. AAAI Press, p. 61-83, 1995 45