June 22, 2013
June 22, 2013
June 22, 2013
ASEE International Forum
21.12.1 - 21.12.9
An Interactive Courseware for Learning Data Warehousing on the WebData analytics is playing a significant role in today’s science and engineering education. Datawarehouses provide online analytical processing tools for the interactive analysis ofmultidimensional data of various granularities. The objective of this project is to develop a web-based interactive courseware to help students or beginning data warehouse designers worldwidein learning data warehousing. Contributors of this project include Computer Scienceinternational graduate students from India. The end user of the courseware can be anyone whohas access to internet.In this project we have developed a courseware to reinforce learning of the key concepts of thedata warehousing using a case study approach. The courseware now contains two working sub-systems: (1) data warehousing courseware; and (2) ETL (Extraction, Transformation, and Load)courseware. We have been using this courseware in a Data Warehousing and Data Mining courseat California State University in past two years. Students had very positive feedback on theirlearning experiences with the tool. We are now in the process of expanding to include one moresub-system, OLAP (On Line Analytical Processing) cube courseware.The main advantages of using this web-based interactive courseware to supplement classroominstructions or textbook are as follows: (a) The contents of the courseware can be updated by the instructor periodically to keep up with the rapid development of the field of data warehousing and data mining. (b) The incremental developing courseware provides an ideal platform for the instructor to share latest research development results with students so that we can make the technology transfer a little faster to our students. (c) This project provides a self-paced interactive learning tool not only to the students taking a course on data warehousing but also to any engineer in the world who have to build a data warehouse from scratch and needs to learn fundamental concepts quickly. From schema design to OLAP query execution, we explain concepts step by step and illustrate implementation techniques with examples from our case study. An end user can run various demo queries interactively as he/she is making progress in his/her own pace. (d) Our digital courseware offers a low cost alternative to traditional expensive textbooks. Students usually do not want to buy additional reference books due to the high costs.In this paper, we will introduce the design and implementation of our data warehousingcourseware. Of course, we will also share the lessons that we had learned from this project. Themethod used in this project can be generalized to other engineering fields which has globeeducational needs on self-paced learning tools.
Lu, M. (2013, June), An Interactive Courseware for Learning Data Warehousing on the Web Paper presented at 2013 ASEE International Forum, Atlanta, Georgia. https://peer.asee.org/17217
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2013 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015