WebCT Vista PowerLinks Reporting Interfaces - PowerPoint PPT Presentation

1 / 29
About This Presentation
Title:

WebCT Vista PowerLinks Reporting Interfaces

Description:

Relevant information can be spread out among many, many tables ... The result is a set of 'safe' database views containing the most relevant data all in one place ... – PowerPoint PPT presentation

Number of Views:70
Avg rating:3.0/5.0
Slides: 30
Provided by: eduga
Category:

less

Transcript and Presenter's Notes

Title: WebCT Vista PowerLinks Reporting Interfaces


1
WebCT VistaPowerLinks Reporting Interfaces
  • John Hallett
  • Senior Product Manager
  • WebCT, Inc.
  • John.Hallett_at_WebCT.com

2
Overview
  • WebCT contains vast amounts of data
  • Prior to WebCT Vista, this data was stored in a
    distributed, flat file database
  • This made correlation and detailed data analysis
    almost impossible

3
Overview
  • WebCT Vista introduced an SQL database server
  • With that, detailed analysis became possible, but
    there was still a problem

4
Overview
  • The Vista data schema is not exactly intuitive
  • The DB is designed for functionality and
    performance, not for data extraction
  • Relevant information can be spread out among
    many, many tables
  • And the table schema can change from version to
    version

5
Overview
  • The Vista Reporting Interfaces solve these
    problems by abstracting away from direct DB
    access
  • The result is a set of safe database views
    containing the most relevant data all in one place

6
Why is this important?
7
Why is this important?
8
Why is this important?
9
Why is this important?
10
Why is this important?
11
Why is this important?
12
Why is this important?
13
Why is this important?
14
Details
  • The Vista Reporting Interfaces provide seven
    tables
  • 5 are live views, 2 are extracts

15
Details
  • RPT_PERSON
  • Contains information on users
  • IDs (Login, person, and IMS)
  • Name (First, last, prefix, suffix)
  • Active/Inactive flag

16
Details
  • RPT_LEARNING_CONTEXT
  • Contains information on LCs (E.g. Course)
  • IDs (LC, Parent and IMS)
  • Name, type, of childern
  • Start/end dates, last archived date, templates
  • of members, path

17
Details
  • RPT_LEARNING_CONTEXT_SIZE
  • Adds up data size in a given LC
  • ID
  • Size of templates
  • Size of non-template files

18
Details
  • RPT_MEMBER
  • Contains information on memberships
    (enrollments)
  • Three columns Person, LC, Role

19
Details
  • RPT_TEMPLATE
  • Contains information on template contents
  • ID
  • Counts of all major Learning Objects in use
    (quiz, questions, assignments, discussions, etc)

20
Details
  • RPT_TRACKING
  • All tracked events
  • User, LC, event type, time, dwell time, target
    name
  • This can be a very large table
  • Unlike the tracking tool itself, tracked events
    are not filtered by role (so it is possible to
    see designer actions)

21
Details
  • RPT_GRADEBOOK
  • All grades, every student, every course
  • Calculated columns are presented as a formula

22
Details
  • RPT_TEMPLATE and RPT_LEARNING_CONTEXT_SIZE are
    extracts, and must be scheduled via the UI

23
Details
24
It all comes together
25
It all comes together
Vista Enrollment by Department
26
It all comes together
Vista Tool Usage by Department
27
It all comes together
Average Final Grade vs Vista Sessions
28
Questions?
29
Thank you
  • For more info, please contact me
  • John Hallett
  • Senior Product Manager
  • WebCT, Inc
  • John.Hallett_at_WebCT.com
Write a Comment
User Comments (0)
About PowerShow.com