Classroom Exercise

1
Classroom Exercise

• Student Registration, Attendance, Performance
  Data Mart BITS Model

2
Requirements

• Analyze student registration
• Analyze student attendance
• Relate attendance to performance
• Analyze facility utilization

3
Scenario

• Many Disciplines
• Many Departments
• First degree Higher degree
• Multiple campuses
• 4000 on campus students (Pilani)
• 350 courses offered each semester
• Each student doing 6 courses/sem
• 40 lectures per course
• 5 years data

4
Analysis Requirements

• Top/Bottom 5 electives
• Correlation between attendance and performance
• Variation in MGPA in courses
• Variation in CGPA of students discipline
  wise/campus wise
• Average CGPA/MGPA over the last few semesters at
  different campuse
• Attendance/performance in CDCs of first second
  disciplines
• Attendance in forenoon/afternoon sessions
• Attendance for UG/PG students
• Most popular discipline as choice for dual at
  different campuses
• Performance of dualites vs. single degree
  students

5
Student Registration Event

• Grain of the FT would be one row for each
  registered course by student semester
• Semester is the lowest level available for the
  registration events
• Semester dimension should conform to the calendar
  date dimension
• Student dimension should have demographic data
  on campus information like part-time, full-time,
  involvement in athletics, major, UG/PG,