Transcript ppt

Experiences in Teaching Data
Warehouse Systems within the
Computer Science and Software
Engineering Curriculum
Ivan Luković,
University of Novi Sad,
Faculty of Technical Sciences
&
University of Montenegro,
Faculty of Science, Podgorica
9th Workshop JCSE
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
Agenda
•
•
•
•
Scope and Prerequisites
Goals and Plan
Results
Experiences
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
2 / 24
Scope and Prerequisites
• Faculty of Technical Sciences
– Department of Computing and Control
– Curriculum
• Computing and Control
• Module: Computer Science and Informatics
• accredited bologna program, type: 4 + 1
– Course
• Data Warehouse Systems (DW Systems, for short)
• I semester of Master Curriculum (actually, IX semester)
• 3+2, 5 ECTS
– elective course
– the first performance: 2008/2009
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
3 / 24
Scope and Prerequisites
• Curriculum
– general background (fundamentals)
• mathematics, physics, electrical engineering, electronics,
theory of systems, automation and control systems
• "strong", and "classical" approach
• a wide room reserved for such courses
– constant organizational intention and "pressure" to extend it
– Computer Science and SE fundamentals
• computer architecture, operating systems, computer
networks,
• algorithms, programming techniques and paradigms,
databases, computer graphics,
• software engineering, information systems, etc.
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
4 / 24
Scope and Prerequisites
• Curriculum
– closely related courses
• Software Modeling
– VI semester, mandatory
• Software Design
– VII semester, mandatory
• Databases
– VII semester, mandatory
• Information Systems
– VIII semester, elective
• Data Mining
– IX semester, elective
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
5 / 24
Scope and Prerequisites
• Implementation aspects
– lack of real knowledge / awareness about
•
•
•
•
•
•
•
organization system theory
management of organization systems
ERP, CRM, HR, financial management, etc.
project management
business process modeling and WfMS
quality assurance in organization systems
performance measurement and analysis of organization
processes
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
6 / 24
Scope and Prerequisites
• Implementation aspects
– prior students' experiences
• approximately a half of students are already employed or
contracted for a job
• most of them believe that they "perfectly know" in advance
– what knowledge they will need in software industry
– what are the real circumstances in software industry
– what will be the real circumstances in the future
• most of them believe that
– they are very good in database design, but
– information system design is an easy and intuitive job
• they are usually strong and confident in their belief, but
– the reality is much different from their belief, and
– some of them are not so strong in proper completing their
duties
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
7 / 24
Agenda
•
•
•
•
Scope and Prerequisites
Goals and Plan
Results
Experiences
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
8 / 24
Goals and Plan
• Data Warehouse Systems
– Goals
• recognize wide variety of DW topics, and their usage
domains
• recognize organizational, engineering (particularly SE), and
technology issues in developing a DW system
• practice how to successfully specify and build a DW system
in a given application domain
• become able for further self learning
• become able for team working
– Methods
• ex-cathedra, but motivating the students for a discussion
• group exercises
• practices trough a project in a selected application domain
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
9 / 24
Goals and Plan
• Data Warehouse Systems
– Topics
•
•
•
•
•
•
•
Fundamentals of DW, classifications and terminology
Planning, requirements and development of DW systems
Types and structures of database schemas for DW systems
Data management and ETL process in DW systems
Data aggregation in DW systems
Physical data organization in DW systems
Fundamentals of Business Intelligence, Data Mining and OnLine Analytical Processing (OLAP)
• OLAP functions and queries over a DW
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
10 / 24
Goals and Plan
• Data Warehouse Systems
– Score system
Ex1
Ex2
Proj1
Test1
Atnd.

Fin.Ex.

Max.
10
10
30
15
5
70
30
100
Adv.
Min.
6
6
15
8
5
40
15
55
Points
Grade
55 – 64
6
65 – 74
7
75 – 84
8
85 – 94
9
95 – 100
10
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
11 / 24
Goals and Plan
• Data Warehouse Systems
– Score system
• Min. 30 points required from in-term requirements
• Min. 55 points required to pass the whole exam
• Final Exam, as any other requirement, is not mandatory
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
12 / 24
Agenda
•
•
•
•
Scope and Prerequisites
Goals and Plan
Results
Experiences
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
13 / 24
Results
• Obtained from one year course performance
• No. of students: 54
– No. of students that are selected Data Mining course
at the same time: 24
• Attendance and initial requirements
Lesson attendance (average)
83.18%
Excercise attendance (average)
96.38%
Total attendance (average)
89.78%
Students with attendance  80% (47 / 54)
87.04%
Students with  30 pts from in-term reqirements
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
100.00%
14 / 24
Results
• Performance
Avg. No. of pts from in-term excercises
46.37 / 50
92.74%
Avg. No. of pts from test (theoretical knwldg.)
9.15 / 15
61.00%
Avg. No. of pts from final exam ("theoretical")
19.56 / 30
65.20%
No. of students passed till today
45 / 54
83.33%
No. of students passed without final exam
12 / 45
26.67%
76.09
76.09%
8.22
82.20%
Average No. of points
Average final grade
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
15 / 24
Results
• Performance
– "extremes" (10, 9) vs. (6, 7) are significant
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
16 / 24
Agenda
•
•
•
•
Scope and Prerequisites
Goals and Plan
Results
Experiences
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
17 / 24
Experiences
• General
– there are always well-motivated students
• ready to learn something new and useful
• ready to communicate well
• ready to complete all the tasks in time
– sometimes, a lack of discipline
• a culture of proper exercise attendance is present, but
• problems with lessons attendance
– lesson attendance of 83.18% gives a false picture
– in some cases, it is just fighting for points and nothing more
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
18 / 24
Experiences
• Students' comments
– positive
• everything is ok, nice to learn something new, etc.
– in our circumstances, if something is performed in a proper
way, it is not commented at all, because it is ok!
• a very good experience with a student spending before a
couple of months in Wien, Austria
– working on SAP system, in a large-scale company
– with excellent performance in her studies
– with perfect perceiving of motivation factors for DW
• a remarkable experience with self-motivated students
– with excellent or very good performance in their studies
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
19 / 24
Experiences
• Students' comments
– negative
• We don't need such kind of knowledge in practice!
• Why do you force us to learn something that we really don't
need in practice?
• The DW knowledge is applicable only in large-scale projects,
and even we don't have such projects in Serbia!
• May be, DW projects will be present in Serbia in a far future!
• We need a practice, why do you force us to learn theory
about DW?
• Everything can be learned easily trough projects only! Why
theory?
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
20 / 24
Experiences
• Students' comments
– Unfortunately, very false pictures are perceived
• DW systems are not necessarily large-scale
– there is a plenty of "small" problems that may be resolved by
means of DW approach
• every day emerging opportunities for DW projects in Serbia
and the region, and even more in EU
– new software companies come with primary business interests
in DW systems
• a balance between theory and practice is a must in CS and
SE
– software and system development is not an easy job;
– requires a theoretical knowledge and the abstraction principle
• if you think that you don't need some knowledge, it doesn't
mean that you really don't need it
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
21 / 24
Experiences
• Some issues
– problems with perceiving a real importance of the
topics and problems discussed throughout the course
in an industry practice
• there is a noticeable difference between students having and
not having and industry experience
– it seems that students mostly recognize as the
important only the knowledge necessary for their first
working years
• they primarily think how to target their first jobs
• they sometimes do not perceive that they must survive and
be competitive on market for 40 years, not only for the first 5
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
22 / 24
Experiences
• Some issues
– a whole picture about the DW knowledge is
"assembled" at the end of the course, or even latter
• a significant raising of students' motivation at the very end of
the course
– a problem of having false pictures may be seen as a
consequence of
• constrained life experience combined with bad economical
situation for many years
• a lack of culture that "naturally" imposes respecting the
organizational rules
• weak recognition of the importance of knowledge about
system organization and management in the course of
engineering
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
23 / 24
Experiences
• What we may / should do locally?
– better profile CS and SE curriculum
• with a special care to the selection and design of
fundamental courses
• more oriented towards body of knowledge in CS and SE
• more flexible and multidisciplinary oriented
– create better opportunities for exchanging students
between different institutions
• give them a chance to exchange experiences, attend other
universities and meet early highly developed economies
– early motivate students to better
• develop their capabilities for abstraction and adoption of
common theoretical principles
• differentiate between more and less important things
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.
24 / 24
Experiences in Teaching Data
Warehouse Systems within the
Computer Science and Software
Engineering Curriculum
Ivan Luković,
University of Novi Sad,
Faculty of Technical Sciences
&
University of Montenegro,
Faculty of Science, Podgorica
9th Workshop JCSE
JCSE W-2009 / Ivan Luković
Neum, 30. 8 – 6. 9. 2009.