...
| Table of Contents | ||
|---|---|---|
|
Users Category
User ID -LMS
| Excerpt | ||
|---|---|---|
| ||
The unique value automatically created for each user by the connected LMS system |
...
| Excerpt | ||
|---|---|---|
| ||
Timestamp for when the user account was created in the LMS |
Locale - Language
| Excerpt | ||
|---|---|---|
| ||
Language code (such as “EN”) for the user’s preferred language |
...
| Excerpt | ||
|---|---|---|
| ||
User state in the system, displays as either Active or Inactive |
Enrollment Category
Enrollment Role in course
| Excerpt | ||
|---|---|---|
| ||
User’s Role in course. (ie: Learner, Instructor, Designer, Observer) |
...
| Excerpt | ||
|---|---|---|
| ||
Course Grade displayed by points total |
Instructor Course Role
| Excerpt | ||
|---|---|---|
| ||
Instructor Course Role - TBD |
Learner Course Role
| Excerpt | ||
|---|---|---|
| ||
Learner Course Role - TBD |
Course Role Name
| Excerpt | ||
|---|---|---|
| ||
Course Role Name - TBD |
First Course Access
| Excerpt | ||
|---|---|---|
| ||
Date of user's first access to the course |
...
| Excerpt | ||
|---|---|---|
| ||
Total number of course modules or sections required to complete the course |
Enrollments
...
Completion Number of Modules
| Excerpt | ||
|---|---|---|
| ||
Number of Modules Required to be completed in a course for a user |
...
| Excerpt | ||
|---|---|---|
| ||
Unique ID for the type of Enrollment |
Enrollment
...
Date
| Excerpt | ||
|---|---|---|
| ||
Date for the expected start of the user’s enrollment in the courseuser enrolled in course |
Enrollment expected Start Date
| Excerpt | ||
|---|---|---|
| ||
Date for the expected start of the user’s enrollment in the course. The user is not expected to begin work in the course until this date. |
...
| Excerpt | ||
|---|---|---|
| ||
Course name as it appears in the LMS system. It is a clickable link to the course page in the LMS. You must be logged in the LMS to have access. |
Course ID - LMS
| Excerpt | ||
|---|---|---|
| ||
The unique value automatically created for each course by the connected LMS system |
...
| Excerpt | ||
|---|---|---|
| ||
Total number of courses user has completed. |
Course Completion Status
| Excerpt | ||
|---|---|---|
| ||
Displays the status of the user in regards to course completion. May return “In Progress” or “Completed” |
Activity Category
Activity ID
...
| Excerpt | ||
|---|---|---|
| ||
URL for the activity. This is an IntelliBoard calculated field. |
Activities Sort Order
| Excerpt | |
|---|---|
| Activities Sort Order | |
TBD |
Visible Activity
| Excerpt | ||
|---|---|---|
| ||
Displays “Yes” or “No” if the activity is visible to learners |
Activities - number of
| Excerpt | ||
|---|---|---|
| ||
Total number of activities in course, determined by sum of unique Activities ID. |
Activity Completion Category
...
Visits to Activity
| Excerpt | ||
|---|---|---|
| ||
Date of activity completion if the activity has been completed |
...
Total number of visits by users to an activity |
Time Spent in Activity
| Excerpt | ||
|---|---|---|
| ||
Total time spent by users in an activity |
Average Score in Activity
| Excerpt | ||
|---|---|---|
| ||
TBD |
...
The average score of users on an activity |
First Access to Activity
| Excerpt | ||
|---|---|---|
| ||
Date of first time an activity was accessed by a user |
Activity Completion
...
Category
Activity Completion
...
Date
| Excerpt | ||||
|---|---|---|---|---|
| Displays the completion status of an activity, such as
| |||
Date of activity completion if the activity has been completed |
Activity Completion Status
| Excerpt | ||
|---|---|---|
| ||
Displays the completion status of an activity, such as “Complete Pass,” “Complete Fail,” or “Incomplete” |
Course Module Activities Completions Status Name
| Excerpt | ||
|---|---|---|
| ||
TBD |
Percent Completed Activities
| Excerpt | ||
|---|---|---|
| ||
The percentage of completed points activities in the course |
Activity Types Category
...
Activities Completed Items
| Excerpt | ||
|---|---|---|
| ||
Unique value automatically created for each activity type by the connected LMS system |
Activity Type Name
| Excerpt | ||
|---|---|---|
| ||
Name of the activity, such as “Assignment” or “Quiz” |
Activity Type Alias
| Excerpt |
|---|
Friendly name (everyday name) for the activity type, such as “Assignment” or “Quiz” |
Quizzes Category
...
| |
Shows the total number of activities completed out of the total number of activities in a course. ie. 85 of 105 means the user has completed 85 activities out of the 105 activities that are in a course. |
Number of Users Who Completed Activity
| Excerpt | ||
|---|---|---|
| ||
Total number of users who have completed the activity |
Activity Types Category
Activity Type ID
| Excerpt | ||
|---|---|---|
| ||
Unique ID for the quizvalue automatically created for each activity type by the connected LMS system |
Activity Type Name
| Excerpt | ||
|---|---|---|
| ||
Name of the activity, such as “Assignment” or “Quiz” |
Activity Type Alias
| Excerpt |
|---|
Friendly name (everyday name) for the activity type, such as “Assignment” or “Quiz” |
Quizzes Category
Quiz ID
| Excerpt | ||
|---|---|---|
| ||
Unique ID for the quiz |
Quiz Name
| Excerpt | ||
|---|---|---|
| ||
Friendly name (everyday name) for the quiz |
...
| Excerpt | ||
|---|---|---|
| ||
Displays status of the quiz in a course as either “Active” or “Inactive” |
Quizzes - total number
| Excerpt | ||
|---|---|---|
| ||
Total number of quizzes in a course, determined by the sum of unique Quiz Activities IDs. |
...
| Excerpt | ||
|---|---|---|
| ||
Score for the quiz attempt |
Quiz
...
| Excerpt | ||
|---|---|---|
| ||
TBD |
Quiz Attempt Status
| Excerpt | ||
|---|---|---|
| ||
Status of the learner interaction with a quiz. Displays “Untaken,” “In Progress,” “Pending Review,” or “Complete.” |
...
| Excerpt | ||
|---|---|---|
| ||
TBD |
...
This column specifies the type or format of each quiz question, such as multiple-choice, true/false, short answer, essay, etc. |
Quiz Questions Types Type
| Excerpt | ||
|---|---|---|
| ||
TBD |
...
| Excerpt | ||
|---|---|---|
| ||
Displays “Yes” or “No” if the forum activity is a course announcement |
Forums - total number
| Excerpt | ||
|---|---|---|
| ||
Total number of forums in a course, determined by the sum of unique Forum Activities IDs. |
...
| Excerpt | ||
|---|---|---|
| ||
Date of when the most recent post in the discussion post/topic was created. |
Forum Posts Category
Forum Post ID
...
| Excerpt | ||
|---|---|---|
| ||
Displays “Yes” or “No” if the assignment is the visible to learners |
...
Assignments
| Excerpt | |||
|---|---|---|---|
| |||
TBD |
...
Total number of assignments in a course, determined by the sum of unique Assignment Activities IDs. |
Last Assignment Score
| Excerpt | ||
|---|---|---|
| ||
TBD |
Assignment Submissions Aggregated Last Assignment Submissions Grade Point
| Excerpt | ||
|---|---|---|
| ||
TBD |
Assignment Submissions Aggregated Last Assignment Submissions Grade Letter ID
| Excerpt | ||
|---|---|---|
| ||
TBD |
Assignments
| Excerpt | ||
|---|---|---|
| ||
Total number of assignments in a course, determined by the sum of unique Assignment Activities IDs. |
Last Assignment Score
| Excerpt | ||
|---|---|---|
| ||
| ||
Percentage grade of last assignment submitted in course |
...
| Excerpt | ||
|---|---|---|
| ||
Name of last Assignment activity that was submitted |
Grade Category
Grade Object Max Grade achievable
| Excerpt | ||
|---|---|---|
| ||
Maximum grade achievable on the grade object |
...
| Excerpt | ||
|---|---|---|
| ||
Friendly name (everyday name) of the grade item |
Grade Object is External
| Excerpt | ||
|---|---|---|
| ||
TBD |
Grade Object Result ID
| Excerpt | ||
|---|---|---|
| ||
A unique identifier assigned to a grade entry by the connected LMS. This is used to distinguish multiple grades entered into the system for the same cell in the gradebook. |
Grade Object Result Grade Points - graded
| Excerpt | ||
|---|---|---|
| ||
The raw number of points assigned by the grader to the submission |
...
| Excerpt | ||
|---|---|---|
| ||
Number of points the learner achieved on the assignment |
Grade Object Result Feedback
| Excerpt | ||
|---|---|---|
| ||
TBD |
Grade Letter
| Excerpt | ||
|---|---|---|
| ||
Letter grade for an assignment or course |
...
| Excerpt | ||
|---|---|---|
| ||
The number of times a user has viewed a given activity within a course over time. This is an IntelliBoard calculated field. |
Total Time Spent - per user
| Excerpt | ||
|---|---|---|
| ||
The cumulative amount of time spent by the user viewing or interacting with a given activity within a course over time. This is an IntelliBoard calculated field. |
...
| Excerpt | ||
|---|---|---|
| ||
The number of participations in a given activity within a course over time (as calculated by IntelliBoard), where "participations" are submission submissions by the student of content for feedback |
...
| Excerpt | ||
|---|---|---|
| ||
Date of the end of the term, as defined in the connected platform |
Term Status
| Excerpt | ||
|---|---|---|
| ||
TBD |
Browsers Category
Browser ID
...
| Excerpt | ||
|---|---|---|
| ||
The type of submission the activity is. Examples include: Online text entry, discussion topic, and online upload. |
LTI Tools
...
Days Since Last Submission
| Excerpt | ||
|---|---|---|
| ||
Unique ID for the LTI Tool |
LTI name
| Excerpt | ||
|---|---|---|
| ||
Friendly name (everyday name) of the LTI tool |
LTI Tool URL
| Excerpt | ||
|---|---|---|
| ||
URL of the LTI tool |
LTI Tool State
| Excerpt | ||
|---|---|---|
| ||
Status of the LTI tool, displays as either “Active” or “Inactive” |
Time Created
| Excerpt | ||
|---|---|---|
| ||
Timestamp for when the LTI activity was created in the platform |
Deprecated User Profile Field Categories
User Profile Field Categories ID
| Excerpt | ||
|---|---|---|
| ||
Unique ID for the user profile field category. |
User Profile Field Categories Name
| Excerpt | ||
|---|---|---|
| ||
Friendly name (everyday name) for the user profile field category |
Deprecated User Profile Fields
...
| |
Show number of days since user submitted an activity (assignment, quiz, forum post, etc) in a course. Decimals can be used to measure partial days, i.e. 2.5 days. Standard rounding rules are used. Is determined by “Current Date - Date of Last submission.” |
LTI Tools
LTI ID
| Excerpt | ||
|---|---|---|
| ||
Unique ID for the user profile field |
...
LTI Tool |
LTI name
| Excerpt | ||
|---|---|---|
| ||
Short name for the user profile field. This is typically the system name. |
...
| |
Friendly name (everyday name) of the LTI tool |
LTI Tool URL
| Excerpt | ||
|---|---|---|
| ||
Name of the user profile field. This is typically the friendly or display name. |
User Profile Fields Category
...
| |
URL of the LTI tool |
LTI Tool State
| Excerpt | ||
|---|---|---|
| ||
Displays the visibility of the user profile field, either “Visible” or “Not Visible” |
Deprecated User Profile Field Data Category
...
| ||
Status of the LTI tool, displays as either “Active” or “Inactive” |
Time Created
| Excerpt | ||||
|---|---|---|---|---|
| Unique ID for the user profile field data record.
| |||
Timestamp for when the LTI activity was created in the platform |
User Profile Fields Category
User Profile Field
...
Statuses Status
| Excerpt | ||||
|---|---|---|---|---|
| Contents
| |||
Displays the visibility of the user profile field, such as a department name, birth year, academic major, etc.either “Visible” or “Not Visible” |
User Profile Field Data Category
...
| Excerpt | ||
|---|---|---|
| ||
Status of the cohort, displays as “Active” or “Inactive” |
Cohorts Components
| Excerpt | ||
|---|---|---|
| ||
TBD |
Cohorts Created At
| Excerpt | ||
|---|---|---|
| ||
Timestamp for when the cohort was created. |
...
| Excerpt | ||
|---|---|---|
| ||
Timestamp for the most recent modification of the cohort. |
Cohort
...
| Excerpt | ||
|---|---|---|
| ||
TBD |
Cohort Statuses Status
| Excerpt | ||
|---|---|---|
| ||
Status of the cohort group, displays as either “Active” or “Inactive” |
...
IntelliBoard Lite/Legacy Data
Page - level of lms accessed
| Excerpt | ||
|---|---|---|
| ||
The level in the LMS the User has accessed. i.e. Course, Module, etc. |
...
| Excerpt | ||
|---|---|---|
| ||
The Internal ID number that is assigned by Totarathe LMS |
Visits
| Excerpt | ||
|---|---|---|
| ||
The number of visits to the course by the User |
...
| Excerpt | ||
|---|---|---|
| ||
Time spent by User in specified time period of the day.. |
Sunday Monday, Tuesday, Wednesday, Thursday, Friday, Saturday (Percent of total time)
| Excerpt | ||
|---|---|---|
| ||
Percent of total time spent by users on a specific day of the week compared to a full week. |
...
| Excerpt | ||
|---|---|---|
| ||
Progress of User on the LMS site in the course. Displays as a bar graph or a percentage of completion. |
Completed Activities
| Excerpt | ||
|---|---|---|
| ||
Total number of activities user has completed. |
Status - User
| Excerpt | ||
|---|---|---|
| ||
User’s status within the course. May display as either “Complete” or “Incomplete.” |
Time On Site - User
| Excerpt | ||
|---|---|---|
| ||
Total time User has spent on the LMS. |
Time on Courses - User
| Excerpt | ||
|---|---|---|
| ||
Total time User has spent in all courses. |
Time on Activities - User
| Excerpt | ||
|---|---|---|
| ||
Total time User has spent in all activities. |
...
| Excerpt | ||
|---|---|---|
| ||
The column stores data about whether the user's activity was deleted |
Modified - User
| Excerpt | ||
|---|---|---|
| ||
Date when User was modified in the LMS system |
...
| Excerpt | ||
|---|---|---|
| ||
Name of person or role who enrolled user in course |
Number of Courses in Category
| Excerpt | ||
|---|---|---|
| ||
The total number of courses within a category. |
Instructor related fields
...
| Excerpt | ||
|---|---|---|
| ||
Displays the date the user last downloaded anything from the course |
Number of Attempts
| Excerpt | ||
|---|---|---|
| ||
Total number of attempts users made in an activity, may be per user or for all users in a course dependent upon the report. |
Course Outcomes
Outcome Full Name
...