...
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 | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
Displays the completion status of an activity, such as “Complete Pass,” “Complete Fail,” or “Incomplete” |
...
Total time spent by users in an activity |
Average Score in Activity
Excerpt | ||
---|---|---|
| ||
The percentage of completed activities in the course |
...
average score of users on an activity |
First Access to Activity
Excerpt | ||
---|---|---|
| ||
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. |
Activity Types Category
...
| |
Date of first time an activity was accessed by a user |
Activity Completion Category
Activity Completion Date
Excerpt | ||
---|---|---|
| ||
Unique value automatically created for each activity type by the connected LMS system |
...
| |
Date of activity completion if the activity has been completed |
Activity Completion Status
Excerpt | ||||
---|---|---|---|---|
| Name of the
| |||
Displays the completion status of an 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
“Complete Pass,” “Complete Fail,” or “Incomplete” |
Percent Completed Activities
Excerpt | ||
---|---|---|
| ||
Unique ID for the quiz |
...
| |
The percentage of completed activities in the course |
Activities Completed Items
Excerpt | ||
---|---|---|
| ||
Friendly name (everyday name) for the quiz |
Quiz Start Date
Excerpt | ||
---|---|---|
| ||
Date for when the quiz becomes available in the course |
Quiz End Date
Excerpt | ||
---|---|---|
| ||
Date for when the quiz will become unavailable. Includes “grace period” time. |
Quiz Due Date
Excerpt | ||
---|---|---|
| ||
Date for when the quiz will become unavailable. Does not include the “grace period.” |
Quiz Creation Date
Excerpt | ||
---|---|---|
| ||
Date for when the quiz was created |
Quiz Status
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. |
Quiz Attempts 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 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
Quiz ID
Excerpt | ||
---|---|---|
| ||
Unique ID for the quiz completion attempt |
Quiz
...
Name
Excerpt | ||
---|---|---|
| ||
Number of the quiz attempt (ie: a learner’s 2nd attempt) |
...
| |
Friendly name (everyday name) for the quiz |
Quiz Start Date
Excerpt | ||
---|---|---|
| ||
Timestamp Date for when the quiz attempt was startedbecomes available in the course |
Quiz
...
End Date
Excerpt | ||||
---|---|---|---|---|
| Timestamp
| |||
Date for when the quiz attempt was completed |
...
will become unavailable. Includes “grace period” time. |
Quiz Due Date
Excerpt | ||
---|---|---|
| ||
Score Date for when the quiz attemptwill become unavailable. Does not include the “grace period.” |
Quiz
...
Creation Date
Excerpt | ||||
---|---|---|---|---|
| TBD
| |||
Date for when the quiz was created |
Quiz
...
Status
Excerpt | ||
---|---|---|
| ||
Status Displays status of the learner interaction with a quiz. Displays “Untaken,” “In Progress,” “Pending Review,” or “Complete.” |
Quiz Questions Category
...
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. |
Quiz Attempts Category
Quiz Attempt ID
Excerpt | ||
---|---|---|
| ||
Unique ID for the quiz questioncompletion attempt |
Quiz
...
Attempt
Excerpt | ||
---|---|---|
| ||
Name Number of the quiz questionattempt (ie: a learner’s 2nd attempt) |
Quiz
...
Attempt Start Time
Excerpt | ||
---|---|---|
| ||
Text of the question |
...
| |
Timestamp for when the quiz attempt was started |
Quiz Attempt Finish Time
Excerpt | ||
---|---|---|
| ||
Total number of points the learner can achieve with a correct answer |
...
| |
Timestamp for when the quiz attempt was completed |
Quiz Attempt Score
Excerpt | ||
---|---|---|
| ||
TBD |
...
| |
Score for the quiz attempt |
Quiz Attempt Status
Excerpt | ||||
---|---|---|---|---|
| TBD
| |||
Status of the learner interaction with a quiz. Displays “Untaken,” “In Progress,” “Pending Review,” or “Complete.” |
Quiz Questions
...
Category
Quiz Question
...
ID
Excerpt | ||
---|---|---|
|
...
| |
Unique ID for the quiz question |
Quiz Question
...
Name
Excerpt | ||
---|---|---|
|
...
| |
Name of the quiz question |
Quiz Question
...
Forums Category
...
Text
Excerpt | ||
---|---|---|
| ||
Text of the question |
Quiz Question Max Points
Excerpt | ||
---|---|---|
| ||
Unique ID for the forum activity |
...
| |
Total number of points the learner can achieve with a correct answer |
Quiz Question Types Name
Excerpt | ||
---|---|---|
| ||
Name of the forum activity |
Forum Creation Date
Excerpt | |
---|---|
name | ForumThis 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 |
Quiz Questions Answers Category
Quiz Question Answer ID
Quiz Question Answer Given by User
Quiz Question Score
Quiz Question Answers Points
Quiz Question Answers Original Question ID
Forums Category
Forum ID
Excerpt | ||
---|---|---|
| ||
Unique ID for the forum activity |
Forum Name
Excerpt | ||
---|---|---|
| ||
Name of the forum activity |
Forum Creation Date
Excerpt | ||
---|---|---|
| ||
Date of when the forum activity was created |
...
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 discussion post/topic most recent post in the discussion 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 |
...
Percentage grade of last assignment submitted in course |
Assignments Submissions Category
Assignment Submission ID
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 |
Assignments Submissions Category
...
| |
Unique ID for the assignment submission record |
Assignment Submission Date
Excerpt | ||
---|---|---|
| ||
Date of when the assignment was submitted |
Assignment Submission Feedback
Excerpt | ||||
---|---|---|---|---|
| Unique ID for
| |||
Text feedback or comments on the assignment submission record |
Assignment Submission Feedback Date
Excerpt | ||
---|---|---|
| ||
Date of when the assignment submission feedback was submittedcreated |
Assignment Submission
...
Excerpt | ||
---|---|---|
| ||
Text feedback or comments on the assignment submission |
Assignment Submission Feedback Date
Excerpt | ||
---|---|---|
| ||
Date of when the submission feedback was created |
Assignment Submission ScoreScore
Excerpt | ||
---|---|---|
| ||
Displays score of the assignment, if graded |
...
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
...
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 Browsers Category
Browser ID
Excerpt | ||
---|---|---|
| ||
Unique ID for the browser used |
...
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
...