Student provenance data mining using an innovative tool: SOLAP

1
Student provenance data mining using an
innovative tool SOLAP

• Richard MasséLuc SimonJacques Turcotte
• CIRPA
• october 2004, Montréal, Qc

2
Plan

• Background
• Action plan
• strategic issues
• technologic issues
• Implementation

3
Background

• Stakeholders
• Bureau dinformation et de promotion
• Faculty officers (schools, departments,
  programs)
• Bureau du registraire
• Bureau de planification et détudes
  institutionnelles

4
(No Transcript)
5
Background

• Available datasets
• Université Laval
• CRÉPUQ

6
Available datasets - UL

7
Available datasets - CRÉPUQ

8
Available datasets - CRÉPUQ

9
Background

• Much information is already available, reliable,
  detailed, historic, etc
• Unfortunately, it seems that this information is
  underused in the planning of student recruitment
  activities
• CHALLENGE Develop the means to allow the proper
  information to be readily accessible to
  stakeholders, in a timely manner

10
Action plan strategic issues

• Solution 1 BPEI or an external consultant is
  mandated to realize student provenance analyses,
  periodically or ad hoc, and present the results
  to stakeholders
• Solution 2 Develop a more userfriendly tool
  that could be used by stakeholders themselves to
  conduct analyses tailored to their needs in a
  timely fashion

11
Action plan technologic issues

• userfriendliness
• user interface
• thin client (Java enabled web browser)
• value added
• geographic dimension
• graphic presentation
• originality/ novel approach
• Spatial OnLine Analytical Processing
• Jointly developed by KHEOPS Technologies and
  Centre de recherche en géomatique de lUniversité
  Laval

12
SOLAP
Software for exploiting databases containing a
spatial dimension offering multiple information
scales, many analysis themes, different
timescales and graphical presentation modes
maps, tables and statistical charts. Yvan
Bédard, CRG director
13
Implementation

• Centre de recherche en géomatique (CRG)
• Bureau de planification et détudes
  institutionnelles (BPEI)
• Bureau du registraire
• CRÉPUQ
• Bureau dinformation et de promotion (BIP)

14
Implementation

• Université Laval Cube
• New registrations since 1993
• All undergraduate programs
• Every faculty and departments
• Comprehensive list of institutions of
  provenance, by country, by province, by region

15
User interface
Standard menus
16
User interface
Mapping tools
17
User interface
SOLAP tools
18
User interface
Display of dimensions
19
User interface
Analysis axes
20
User interface
Display zone
21
Menus

• Using menu Fichier the user can
• open a cube (Ouvrir un cube). When a cube is
  already opened, opening a new cube automatically
  closes all windows and displays related to the
  previous cube
• quit the application (Quitter).

22
Mapping tools
Display selection
Previous zoom

• Measure
• Distance
• Périmeter and area

Selection report
Move Center
Identification
Hyperlinks
Zoom out
Annuler la sélection
Zoom in
Hide tags
Print map

• Selection
• By point
• By rectangle
• By circle
• By polygon

Full view
Display tags
Query
Email map
Reset to original view
23
SOLAP tools

• Display a diagram
• Histogram
• Bar chart
• Pie chart
• Area chart
• Line chart
• Scatter chart

Execute
No Drill
Drill sideways
Display a map
Drill up
Display a table
Drill down
24
Available dimensions
Dimensions hierarchy
Dimension area
25
Available dimensions
Dimensions hierarchy
Dimension area
26
Available dimensions
Dimensions hierarchy
Dimension area
27
Available dimensions
Dimensions hierarchy
Dimension area
28
Examples

• Table of the number of undergrad students newly
  registered in the faculté des sciences et du
  génie, over the last 4 years
• Idem, by sex
• Map presenting the provenance of students newly
  registered in the MD program, in 2002

29
Example 1
30
Example 2
31
Example 3
32
Example 3
33
Summary

• We now have 10 years of undergrad registration
  data integrated in the SOLAP system
• Data from CREPUQ will also be available soon
• The system is now ready for field tests on
  campus
• Feedback from users will lead to adjustments to
  the interface
• BIP will monitor this projects success
• user satisfaction
• registration increases !!

34
Ackowledgements
Centre de recherche en géomatique (CRG) Yvan
Bédard Martin Nadeau Bureau du
registraire Louis-René Rheault CRÉPUQ Guy
Girard Yvon Bousquet Bureau dinformation et de
promotion (BIP) Johanne Morneau
Marie-Josée Proulx Sonia Rivest
35
Question period