Transcript 01_CourseIntro - University of Central Florida

IMS 6217: Course Introduction
Course Introduction—Topics
• Course Topics
– Why these topics?
• Grading
• Project Teams
• Course Approach
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
1
IMS 6217: Course Introduction
Course Topics
• See Course Schedule from course link
– Relational table design (4 classes)
– SQL language review (1 class)
– Performance management (2 classes)
– Reporting (2 classes)
– Business Intelligence & Data Warehousing (2 classes)
– Allocating business logic (1 class)
– Distributed databases (1 class)
– DB and data management (1 class)
• What is the logic behind topic selection?
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
2
IMS 6217: Course Introduction
About You
• Four quotations from last year’s course evaluations:
– “Class was definitely dumbed down—too much on
elementary database design.”
– “Level was undergraduate level—did not master
anything.”
– “I am not at the same level as most students in this class
and often felt lost.”
– [Things I liked least] “The extent of the work because a
student without any background in databases will have
a difficult time grasping certain concepts and his/her
grades will suffer.”
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
3
IMS 6217: Course Introduction
About You (cont.)
• This course presents an interesting instructional
challenge for me
– Wide disparity in preparation for the course
– Wide disparity in experience
• Breadth
• Depth
• I have to craft a course that offers value to the whole
group
• There will clearly be tradeoffs
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
4
IMS 6217: Course Introduction
Grading, Project Teams, & Course Approach
• Most grades are group projects completed outside of
class
• Final project/exam is individual
• Groups will be important to your success
• You will need to be able to work virtually
• Course approach expects considerable independence
– My role is to guide and evaluate with some teaching (of
course)
– Similar to most work environments
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
5
IMS 6217: Course Introduction
Project Groups
• Group approach has several benefits
– Share the wealth by leveraging member expertise
– Brainstorming to figure things out
– Share the work load
– Very similar to real world work environments
• But…
– Logistics of distributed members needs investment to
overcome (but also mirror many work environments)
– Weak member can have adverse effect (duhhh)
• Project groups must be formed by next week’s class
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
6
IMS 6217: Course Introduction
Grading—Grade Weights
Activity
Course
Weight
DB Design Project
20%
Indexing Project
10%
Performance Tuning Project
10%
Report Project
20%
Business Intelligence/Data Warehouse Project
20%
Distributed Database Project
10%
Final Exam or Project
5%
Peer Evaluations
5%
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
7
IMS 6217: Course Introduction
Technologies
• We will use Microsoft SQL Server as a teaching vehicle
– Free to us
– Widely used
– Significant references available
• All students will need access to SQL Server 2005
Developers Edition (or Standard or Enterprise
Editions)
– SQL Server 2008 is not acceptable
• Become proficient at moving databases and database
objects among team members
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
8
IMS 6217: Course Introduction
Textbooks
• No assigned textbook in this course
• See Software and Textbook link in the syllabus for
reference recommendations
Dr. Lawrence West, MIS Dept., University of Central Florida
[email protected]
9