Child pages
  • 6 - Characterize use by course and department

Sakai Usage Data Work Group: Sample Site Usage Report

 

This sample report for the course site MEDCHEM 532 011 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. It is presented in this format to be a readable example; however, the required format would be more like a spreadsheet in which each row represents a unique site, and columns are the variables listed here and the current values for each site.

 

Definitions:

 

  • Views are the number of times this content has been viewed. This is generally a higher value than visits. For example, “Students in this class viewed resources 100 times over the last week”.

 

  • Visits are the number of sessions that included views of this content. For example, “Students logged in to the site 25 times last week.”

 

  • Variables are the views, 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.

 

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 Site Report – MED CHEM 532 001

 

Variable

Value

Source

Site ID

1119893021099-20471608

ctools_user.sakai_site

Site Title

MEDCHEM 532 001

ctools_user.sakai_site

Site Type

Course

ctools_user.sakai_site

Provider IDs

2005,2,A,MEDCHEM,532,001

ctools_user.sakai_site

Site Status

Published

ctools_user.sakai_site

Related Course/s

MedChem 532 001

ctools_user.sakai_site

Related Department/s

Medical School

no source as of Sakai 2.0

# of Users

21

ctools_user.sakai_site_user

Created On

2005-06-27

ctools_user.sakai_site

Site Size

250 MB

AFS (institutional file storage)

# of Total Views

70

List of total views by visitor, time

Event Logs (NetTracker Directory Summary, filtered by Site ID)

# of Total Visits

48

List of total views by visitor, time

Event Logs (NetTracker Directory Summary, filtered by Site ID)

# of Schedule Items

30

List of items with creator, type, start date, end date, title, attachments

ctools_user.calendar_event (XML)

# of Schedule Views

50

List of views by visitor, time

Event Logs (NetTracker Directory Summary, filtered by Site ID)

# of Announcement Items

3

List of items with creator, date, subject, attachments

ctools_user.announcement_message (XML)

# of Announcement Views

70

List of views by visitor, time

Event Logs (NetTracker Directory Summary, filtered by Site ID)

# of Announcements Emailed

2

List of items with creator, date, subject, attachments

Add notification.low, notification.high events

# of Announcements Public

1

List of items with creator, date, subject, attachments

ctools_user.announcement_message (XML)

# of Resource Items

45

List of items with creator, date, type, title, path

ctools_user.content_resource (XML)

# of Resource Views

70

List of views by visitor, time

Event Logs (NetTracker Directory Summary, filtered by Site ID)

# of Resources Emailed

5

List of items with creator, date, type, title, path

Add notification.low, notification.high events

# of Resources Public

2

List of items with creator, date, type, title

ctools_user.content_resource (XML)

# of Discussion Categories

2

List of items with creator, date, title

ctools_user.discussion_channel (XML)

# of Discussion Topics

12

List of items with creator, date, category, title

ctools_user.discussion_message (XML)

# of Discussion Contributors

21

List of visitors with dates, categories, titles, total word count

ctools_user.discussion_message (XML)

# of Discussion Replies

63

List of items with creator, date, category, title, reply-to message title

ctools_user.discussion_message (XML)

# of Dropbox Items

42

List of items with creator, date, title, type

ctools_user.content_collection (XML)

# of Chat Rooms

1

List of items with date created, creator, title

ctools_user.chat_message

# of Chat Messages

33

List of items with date created, time created, creator

ctools_user.chat_message

# of Chat Contributors

10

List of visitors by items created

ctools_user.chat_message

# of Chat Views

90

List of views by visitor, time

Event Logs (NetTracker Directory Summary, filtered by Site ID)

# of Email Archive Messages

2

List of items with date created, time created, creator, title

ctools_user.mailarchive_message

# of Email Contributors

2

List of visitors by items created

ctools_user.mailarchive_message

# of Assignments

2

List of items with date created, creator, title, grade type, start date, close date, due date

ctools_user.assignment_assignment (XML)

# of Assignment Submissions

41

List of items with date submitted, creator, submission-to, title, type, if-returned

ctools_user.assignment_submission (XML)

# of Help Views

3

List of views by visitor, time, page viewed

Web server access logs?

# of Web Content Items

2

List of items with creator, date, title, URL

Web server access logs?

# of News Items

1

List of items with creator, date, title, URL

Web server access logs?

# of Site Info Views

5

List of views by visitor, time, page viewed

Event Logs (NetTracker Directory Summary, filtered by Site ID)