Page tree
Skip to end of metadata
Go to start of metadata

The Program Progress Data Source is a curated selection of LMS data that enables you to create Reports on the progress of learners in courses. Relevant items in this Data Source include the Program Progress, Status, Date Completed, and User and Organization information of learners in courses.

The Program Progress Data Source is located in the Public folder in the Zoola™ Repository. To locate the Data Source in either the Repository or the Data Chooser (when selecting a Data Source to create an Ad Hoc View), navigate to Public > Totara > Data Sources.

This Data Source contains LMS data organized to report on the progress information of learners in your courses. “Progress” information consists of fields and measures that track the progress of a learner's path to completing a course, including numerical representations of completion progress, course status, completion dates, and course, organization, and user information. Using fields and measures from the three sets included in this Data Source, you can easily build out Reports and Views to track learner progress of course completion.

The links along the right-hand side of this article will open the Learners Program Progress Detailed Table View. If you are logged in to Zoola™, this view will open in the Ad Hoc Editor. The left-hand View panel will display the contents of the Program Progress Data Source, organized into sets of items (as both fields and measures).

All included sets are comprised of selections from the tables listed in the Totara table, located at the end of the right-hand column.

Specifically, the Program Progress Data Source is comprised of the following sets:

  • Course: Items (fields and measures) in the Courses set provide naming and categorization data for your LMS courses.

  • User: Items in the User set provide user identification information, such as user ID's, names, locations, and other LMS profile-related data.

  • Program: Items in the Programs set provide program status and progress data, as well as completion dates.




 

Related Ad Hoc Views 

The following links will directly open the Ad Hoc Views in Zoola™: 
  

 

 

Included LMS Tables

The following links will directly open visual representations of included tables in the Lambda Totara schema documentation. The Program Progress Data Source is comprised of elements from each of these tables. 

 

Totara

mdl_course

mdl_course_categories

mdl_prog

mdl_user

mdl_pos

mdl_pos_assignment

mdl_org

mdl_course_completions

mdl_prog_completion

course_status_names (Derived Table)

position_type (Derived Table)

program_course (Derived Table)

program_progress (Derived Table)

program_status_names (Derived Table)

  • No labels