Overview

The Learner Transcript is one of the most popular reports used in Adobe Captivate Prime. The report enables one to get nearly every possible detail in a single report in CSV format.

Apart from being a report that users can fetch to track and analyze learning behaviors, the report can also be viewed as the format in which Prime can be set up to export data about learning behaviors to external applications/systems.

A typical enterprise scenario is to take a periodic export of learner transcript for Prime, analyze it to extract learners completing an important learning program, and placing an order for a gift voucher to recognize and reward timely completions.

Another use case is to add the learning behavior data to an enterprise data warehouse, where one may want to combine learning data with other enterprise data to analyze correlations between learning behavior and other process data.

In the rest of the document, we briefly describe how one can fetch the Learner Transcript from Prime; and then proceed to providing the details on how each row and column of the report needs to be interpreted.

This information may be useful for any developer who intends to integrate Prime with other systems by way of processing the exported learner transcript data.

Fetch Learner Transcript from the User Interface

From the Profile Settings, a learner can download his/her transcript. For more information,  see Download Learner Transcript.

Administrators can generate Learner Transcripts for the whole organization, a specific set of users or a specific set of learning objects, or a specific set of users and learning objects. They can also get all learning records for a time interval duration and indicate if module level information is required (by default, module level information is omitted). For more details, see Download Learner Transcripts.

Administrators can also set up the system to email the Learner Transcript periodically.

Notă:

The Learner Transcript generated via the UI will be an Excel file, which also contains the “Skill Transcript”. In this document, we will refer to what is generated in the CSV format, a report containing learning activities pertaining to enrollment, starting, progress or completion of a learning object.

Export Learner Transcript

When the Learner Transcript has to be consumed by an external system, Prime provides a feature called Export Data, where Learner Transcript is one of the types of data that can be exported. As explained in the Preamble, this is required for integration of Prime with an external system that needs to process learning behavior data or for populating an enterprise data warehouse with learning behavior data.

For details of how the connectors that supporting Export of Learner Transcript, see the Export Data section in the FTP, Box and PowerBI Connectors.

The purpose served by these connectors is to export data to a downstream application periodically (once in N days). So, these connectors export only the incremental learning behavior data in every run. Note that these connectors don’t allow for fetching records pertaining to specific subset of users or learning objects – it is always data about all users and all learning objects in that account.

In the case of PowerBI, the customer should provide a workspace where Prime can keep exporting this data incrementally into a dynamically created dataset. This connector merely exports data, and the customers must build their own reports/dashboards based on this dataset as need be.

The next section provides the details on how a downstream system should interpret the records in the learner transcript.

Interpret the Learner Transcript

Each row in a Learner Transcript can be thought of as some learning behavior that was captured in Prime in a specific time period. Typically, the connectors export “incremental data” and so the rows represent learning activities that happened between the last run of the connector and the current run.

Of course, the connectors also allow you to fetch the learner transcript on demand, and in this case the user can specify a start date and the end date is assumed to be now. Usually one would do this once initially and then set up the connector for exporting the incremental learner transcript at a specific time of day, once in N days (the default value of N, being 1).

Let us now define what is meant by Incremental Learner Transcript

In the learner transcript, every row represents a specific activity involving a specific learner and a specific learning object. We are primarily interested in what state a learner is with respect to the learning object – Enrolled, Started, In Progress, and Completed. Therefore, the learner transcript captures four corresponding dates as well.

Now there are three types of learning objects, where Prime tracks learner progress; and the exported data contains progress information at the module level, which is the most granular unit of content that a learner can experience in Prime.

  • Course – a composition of one or more modules
  • Learning Program – a composition of one or more courses
  • Certification – a composition of one or more courses.

Every row in the Learner Transcript could be pertaining to a specific user’s engagement with a Module, Course, Learning Program or Certification. When a user is enrolled to a Learning Program, the transcript will indicate that the user is e

The columns of the Learner Transcript provide various pieces of information pertaining to each learning activity, and the following table describes the semantics of each column.

Column Name

Type of value

Description

Name

Never empty

Name of the learner

email

Never empty

Email address of the learner

Learning plan Name

Can be empty

Name of the learning plan (if any), the user was enrolled into for this learning activity.

LP/Certification/Course

Never empty

Name of the learning pogram, Certification or Course

Type

Certification | Learning Program| Course

The type of the learning object, the user was enrolled into. Note that

Course

Can be empty

Name of course. When it is empty, the row represents either a Certification or Learning Program. When it is

Instance 

Can be empty

Name of the instance of the LO user is enrolled into. When empty the instance for this has to be "inferred" from parent wherever applicable

Selection Criteria

Never empty

Basis of enrollment (how this learner got enrolled to this LO)

Module

Can be empty

Name of module. When empty this row represents either a course, learning program or certification

Enrollment Date

Can be empty

Date of enrollment. Will be empty if row is representing a module of a course

Started Date

Can be empty

Date on which learner started this. Empty implies the learner has not yet started this

Completion Date

Can be empty

Date on which learner completed this. Empty implies the learner has not yet completed this

Deadline

Can be empty

Date by which learner is expected to complete this. Empty implies that there is no deadline for this

Status

Not Started | In Progress | Completed

Status of learner with respect to this module, course, LP or certification

Progress %

Percentage

Indicates the extent to which learner has completed this

Grade

Pass | Fail | Empty

Indicates success of learner. 'Pass', if user has met success criteria for this, 'Fail' otherwise.

Quiz Score

X/Y, where X and Y are numeric

X is the score obtained by learner and Y is maximum score possible. Can be empty

userState

Active | Inactive

Lifecycle state of user in the account.

profile

Never Empty

Name of the profile with which user is associated

Manager Email

Can be empty

Email of the manager of the learner

Manager Name

Can be empty

Name of the learner's manager

Attempts

Can be empty

The total number of attempts by learner so far, for this module

Best score

X/Y, where X and Y are numeric

X is the best score obtained by learner across multiple attempts, and Y is maximum score possible. Can be empty

Groupable Active Field

 

For each groupable Active Field in account, there will be a column, where the column name is that of Active Field and the value will be the specific value the learner has for that field.

Notă:

  • Sometimes administrators may mark completion for a Learning Object manually (especially for Class Room courses) much after the class. In such a scenario, if Export Data is set up to export LT daily, the actual date of completion may have passed already and so the export will never get such completion records that were marked as completed much after the class happened. When this is detected, consider exporting the transcript from a given start date till date (on demand) in the UI; and then take it to the downstream application for “late processing”. While doing  this, you may have to ignore records that have already been processed.
  • Multiple Attempts for a module depends on whether that is enabled for that LO. When enabled, what you now see in a CSV row related to a module is one attempt. Not all attempts in a day may be reported and so you may see the total number of attempts see increment by more than one. Also an attempt may not necessarily improve a score, and at any given point you will only the best score.