Sakai Usage Data Work Group: Sample Installation Report

 

This sample report for the Sakai installation called "CTools" at University of Michigan combines usage data from different sources into one report. This type of report would meet the data needs of many identified stakeholders, including support staff, instructors, managers, and researchers.  This report sums objects and would be run periodically as values would change daily.
 

Definitions:

 

  • Variables are the objects or attributes we want to measure.

 

  • Values are the quantitative measurement. This typeface indicates that we want to “drill down” into that value to look at the specific views, objects, or attributes that are included.

 

  • Active Project sites, Grad Tools sites, and users are those who have logins within the last month. Active Course sites are those for the current academic term.

 

  • The Source column lists one of several data sources that currently store usage data as of Sakai 2.0.
     
    • The Sakai database. This typeface refers to the table in the Sakai database that stores the data.
       
    • Event logs. Text files parsed by day that list code-specified events and associated users, sites, and times. These are generated from a database query and imported into third-party log analysis software (in the UM case, that’s NetTracker).
       
    • Web server access logs. Standard access logs specified and produced by the web server software (in the University of Michigan environment, that’s Apache).

 

Sample Installation Report – CTools as of February 27, 2006

 

Variable

Value

Source

Total Course Sites

10, 245

ctools_user.sakai_site

Total Project Sites

6,269

ctools_user.sakai_site

Total Grad Tools Sites

1,040

ctools_user.sakai_site

Active Course Sites

2,583

ctools_user.sakai_realm

Active Project Sites

3,500

?

Active Grad Tools Sites

400

?

Total Unique Visitors Winter 2006

42,076

event Logs

Total Unique Students (ever)

57,628

ctools_user.sakai_realm_rl_gr

Total Unique Instructors (ever)

6,283

ctools_user.sakai_realm_rl_gr

Total Unique Affiliates (ever)

826

ctools_user.sakai_realm_rl_gr

Total Unique Members (ever)

27,014

ctools_user.sakai_realm_rl_gr

Total Unique Observers (ever)

11,373

ctools_user.sakai_realm_rl_gr

Total Unique Organizers (ever)

4,163

ctools_user.sakai_realm_rl_gr

Total Public Sites

10,931

ctools_user.sakai_site

Total Joinable Sites

2,562

ctools_user.sakai_site

Total Unpublished Sites

2,167

ctools_user.sakai_site

Total Published Sites

15,478

ctools_user.sakai_site

10 Most Visited Sites

 

Event logs

Top 10 Most Active Users

 

Event logs