How does ELC get requested iTunes U activity logs?


Requesting Activity Reports

When a request comes in for log information, the following information must be collected.  Also let the instructor know that this process can take several days.

  • Date range during which the instructor wants to see shell activity.
  • What shell the logs are needed for.
    • If its a course shell you'll need the course number and semester.
    • If its a department shell, you'll need the name of the shell.

This information should be recorded in the ticket and then it will be escalated to OLE.  When OLE has created the reports they will email them back as an Excel spreadsheet with the ticket as a reply.  This raw data can be released to the instructor, however it will not make a lot of sense without some processing.


Processing Activity Reports

Creating a processed report is easiest using a pivot table in MS Excel. The PC version is a bit more user friendly than the Mac version, however either will work.

1.  Open the Excel document from OLE and go to the Insert tab and select Pivot Table.

    Screen shot of inserting the pivot table.

2.  When you add a Pivot Table, it will open on a new sheet (tab) in the spreadsheet.  Make sure that you re-name the sheet something like BBA123-Chart to differentiate from the raw data sheet.  (I often also rename the raw data sheet something like BBA123-RAW)

Sample of chart naming conventions

3.  Make sure that all data is selected and click the OK button. Build the table as follows: Column Labels=ACTION, Row Labels=PATH, and Values=Sum of COUNT (Sum will be added by default when you drag COUNT into the Values box)

Screen shot of pivot table set up

4.  Select the entire Pivot Table and go to the Home tab.  Then add in gridlines by selecting the All Borders option from the Borders drop box.       

How to add gridlines     
How to add banded rows or columns


Replying to the Requester

When replying to the requester I attach the Excel spreadsheet, with my changes saved in it, to the ticket and include a message similar to the following.

Attached you will find the requested activity report.  I left the raw data sheets in the Excel workbook, so you'll see 2 sheets for each class one called BBAxxx-RAW and one called BBAxxx-Chart.  The one labeled -Chart is the processed data that will make more sense as it has been summarized.

You will see that each column is labeled with an 'Action', below is a key to what those 'Actions' mean.

  • Browse = page view
  • Download Preview = track viewed on iTunes U only, not downloaded
  • Download Track = single track downloaded
  • Download Tracks = All tracks are downloaded using the
  • Get Tracks button
  • Edit Files = files changed by admin
  • Edit Page = page changed by admin
  • Subscription =  new subscription created
  • Subscription Enclosure = existing subscription checks for and downloads new tracks
  • Subscription Feed = existing subscription is checking for new tracks, there were none to download
  • Upload = files uploaded by admin

Total downloads = Subscription enclosure + Download Track + Download Tracks

Let me know if you have any questions.

Last updated: Mar 15, 2010