Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt
nameCompleted Courses

Total number of courses user has completed.

Course Completion Status

Excerpt
nameCourse Completion Status

Displays the status of the user in regards to course completion. May return “In Progress” or “Completed”

Activity Category

Activity ID

...

Excerpt
nameActivities - total number

Total number of activities in course, determined by sum of unique Activities ID.

Activity Completion Category

...

Visits to Activity

Excerpt
nameVisits to Activity Completion Date

Date of activity completion if the activity has been completed

...

Total number of visits by users to an activity

Time Spent in Activity

Excerpt
nameTime Spent in Activity Completion Status

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
namePercent Completed ActivitiesAverage Score in Activity

The percentage of completed activities in the course

...

average score of users on an activity

First Access to Activity

Excerpt
nameActivities Completed Items

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

...

First Access to Activiy

Date of first time an activity was accessed by a user

Activity Completion Category

Activity Completion Date

Excerpt
nameActivity Type ID

Unique value automatically created for each activity type by the connected LMS system

...

Completion Date

Date of activity completion if the activity has been completed

Activity Completion Status

Name of the
Excerpt
nameActivity Type Name
Completion Status

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
nameQuiz ID

Unique ID for the quiz

...

Percent Completed Activities

The percentage of completed activities in the course

Activities Completed Items

Excerpt
nameQuiz Name

Friendly name (everyday name) for the quiz

Quiz Start Date

Excerpt
nameQuiz Start Date

Date for when the quiz becomes available in the course

Quiz End Date

Excerpt
nameQuiz End Date

Date for when the quiz will become unavailable. Includes “grace period” time.

Quiz Due Date

Excerpt
nameQuiz Due Date

Date for when the quiz will become unavailable. Does not include the “grace period.”

Quiz Creation Date

Excerpt
nameQuiz Creation Date

Date for when the quiz was created

Quiz Status

Excerpt
nameQuiz Status

Displays status of the quiz in a course as either “Active” or “Inactive”

Quizzes - total number

Excerpt
nameQuizzes

Total number of quizzes in a course, determined by the sum of unique Quiz Activities IDs.

Quiz Attempts Category

...

Activities Completed Items

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
nameNumber of Users Who Completed Activity

Total number of users who have completed the activity

Activity Types Category

Activity Type ID

Excerpt
nameActivity Type ID

Unique value automatically created for each activity type by the connected LMS system

Activity Type Name

Excerpt
nameActivity Type Name

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
nameQuiz Attempt ID

Unique ID for the quiz completion attempt

Quiz

...

Name

Excerpt
nameQuiz Attempt

Number of the quiz attempt (ie: a learner’s 2nd attempt)

...

Name

Friendly name (everyday name) for the quiz

Quiz Start Date

Excerpt
nameQuiz Attempt Start TimeDate

Timestamp Date for when the quiz attempt was startedbecomes available in the course

Quiz

...

End Date

Timestamp
Excerpt
nameQuiz Attempt Finish Time
End Date

Date for when the quiz attempt was completed

...

will become unavailable. Includes “grace period” time.

Quiz Due Date

Excerpt
nameQuiz Attempt ScoreDue Date

Score Date for when the quiz attemptwill become unavailable. Does not include the “grace period.”

Quiz

...

Creation Date

TBD
Excerpt
nameQuiz Attempts Points
Creation Date

Date for when the quiz was created

Quiz

...

Status

Excerpt
nameQuiz Attempt Status

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
nameQuizzes

Total number of quizzes in a course, determined by the sum of unique Quiz Activities IDs.

Quiz Attempts Category

Quiz Attempt ID

Excerpt
nameQuiz Question Attempt ID

Unique ID for the quiz questioncompletion attempt

Quiz

...

Attempt

Excerpt
nameQuiz Question NameAttempt

Name Number of the quiz questionattempt (ie: a learner’s 2nd attempt)

Quiz

...

Attempt Start Time

Excerpt
nameQuiz Question Text

Text of the question

...

Attempt Start Time

Timestamp for when the quiz attempt was started

Quiz Attempt Finish Time

Excerpt
nameQuiz Question Max Points

Total number of points the learner can achieve with a correct answer

...

Attempt Finish Time

Timestamp for when the quiz attempt was completed

Quiz Attempt Score

Excerpt
nameQuiz Question Types Name

TBD

...

Attempt Score

Score for the quiz attempt

Quiz Attempt Status

TBD
Excerpt
nameQuiz Questions Types Type
Attempt Status

Status of the learner interaction with a quiz. Displays “Untaken,” “In Progress,” “Pending Review,” or “Complete.”

Quiz Questions

...

Category

Quiz Question

...

ID

Excerpt
nameQuiz Question

...

ID

Unique ID for the quiz question

Quiz Question

...

Name

Excerpt
nameQuiz Question

...

Name

Name of the quiz question

Quiz Question

...

Forums Category

...

Text

Excerpt
nameQuiz Question Text

Text of the question

Quiz Question Max Points

Excerpt
nameForum ID

Unique ID for the forum activity

...

Quiz Question Max Points

Total number of points the learner can achieve with a correct answer

Quiz Question Types Name

Excerpt
nameForum Quiz Question Types Name

Name of the forum activity

Forum Creation Date

Forum
Excerpt
name

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
nameQuiz Questions Types Type

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
nameForum ID

Unique ID for the forum activity

Forum Name

Excerpt
nameForum Name

Name of the forum activity

Forum Creation Date

Excerpt
nameForum Creation Date

Date of when the forum activity was created

...

Excerpt
nameForum is an Announcement

Displays “Yes” or “No” if the forum activity is a course announcement

Forums - total number

Excerpt
nameForums - total number

Total number of forums in a course, determined by the sum of unique Forum Activities IDs.

...

Excerpt
nameForum Discussion Last Post Date

Date of when the discussion post/topic most recent post in the discussion was created.

Forum Posts Category

Forum Post ID

...

Excerpt
nameVisible Assignment

Displays “Yes” or “No” if the assignment is the visible to learners

...

Assignments

Excerpt
nameAssignmentsAssignment Submissions Aggregated Last Assignment Submissions Submitted At

TBD

...

Total number of assignments in a course, determined by the sum of unique Assignment Activities IDs.

Last Assignment Score

Excerpt
nameAssignment Submissions Aggregated Last Assignment Submissions Grade Score

TBD

...

Percentage grade of last assignment submitted in course

Assignments Submissions Category

Assignment Submission ID

Excerpt
nameAssignment Submissions Aggregated Last Assignment Submissions Grade Point

TBD

Assignment Submissions Aggregated Last Assignment Submissions Grade Letter ID

Excerpt
nameAssignment Submissions Aggregated Last Assignment Submissions Grade Letter ID

TBD

Assignments

Excerpt
nameAssignments

Total number of assignments in a course, determined by the sum of unique Assignment Activities IDs.

Last Assignment Score

Excerpt
nameLast Assignment Score

Percentage grade of last assignment submitted in course

Assignments Submissions Category

...

Submission ID

Unique ID for the assignment submission record

Assignment Submission Date

Excerpt
nameAssignment Submission Date

Date of when the assignment was submitted

Assignment Submission Feedback

Unique ID for
Excerpt
nameAssignment Submission ID
Feedback

Text feedback or comments on the assignment submission record

Assignment Submission Feedback Date

Excerpt
nameAssignment Submission Feedback Date

Date of when the assignment submission feedback was submittedcreated

Assignment Submission

...

Excerpt
nameAssignment Submission Feedback

Text feedback or comments on the assignment submission

Assignment Submission Feedback Date

Excerpt
nameAssignment Submission Feedback Date

Date of when the submission feedback was created

Assignment Submission ScoreScore

Excerpt
nameAssignment Submission Score

Displays score of the assignment, if graded

...

Excerpt
nameLast Assignment

Name of last Assignment activity that was submitted

Grade Category

Grade Object Max Grade achievable

Excerpt
nameGrade Object Max Grade - max achievable grade

Maximum grade achievable on the grade object

...

Excerpt
nameGrade Object Name

Friendly name (everyday name) of the grade item

Grade Object is External

Excerpt
nameGrade Object is External

TBD

Grade Object Result ID

Excerpt
nameGrade Object Result ID

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
nameGrade Object Result Grade Points - graded

The raw number of points assigned by the grader to the submission

...

Excerpt
nameGrade Objects Results Grade Score

Number of points the learner achieved on the assignment

Grade

...

Excerpt
nameGrade Object Result Feedback

TBD

Grade Letter

Excerpt
nameGrade Letter

Letter grade for an assignment or course

...

Excerpt
nameTotal Visits

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
nameTotal Time Spent - per user

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
nameTotal Participations

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
nameTerm End Date

Date of the end of the term, as defined in the connected platform

Term Status

Excerpt
nameTerm Status

TBD

Browsers Browsers Category

Browser ID

Excerpt
nameBrowser ID

Unique ID for the browser used

...

Excerpt
nameSubmission Type

The type of submission the activity is. Examples include: Online text entry, discussion topic, and online upload.

LTI Tools

...

Days Since Last Submission

Excerpt
nameLTI ID

Unique ID for the LTI Tool

LTI name

Excerpt
nameLTI Name

Friendly name (everyday name) of the LTI tool

LTI Tool URL

Excerpt
nameLTI Tool URL

URL of the LTI tool

LTI Tool State

Excerpt
nameLTI Tool State

Status of the LTI tool, displays as either “Active” or “Inactive”

Time Created

Excerpt
nameTime Created

Timestamp for when the LTI activity was created in the platform

Deprecated User Profile Field Categories

User Profile Field Categories ID

Excerpt
nameUser Profile Field Categories ID

Unique ID for the user profile field category.

User Profile Field Categories Name

Excerpt
nameUser Profile Field Categories Name

Friendly name (everyday name) for the user profile field category

Deprecated User Profile Fields

...

Days Since Last Submission

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
nameUser Profile Fields LTI ID

Unique ID for the user profile field

...

LTI Tool

LTI name

Excerpt
nameUser Profile Fields Shortname

Short name for the user profile field. This is typically the system name.

...

LTI Name

Friendly name (everyday name) of the LTI tool

LTI Tool URL

Excerpt
nameUser Profile Fields Name

Name of the user profile field. This is typically the friendly or display name.

User Profile Fields Category

...

LTI Tool URL

URL of the LTI tool

LTI Tool State

Excerpt
nameUser Profile Field Statuses Status

Displays the visibility of the user profile field, either “Visible” or “Not Visible”

Deprecated User Profile Field Data Category

...

LTI Tool State

Status of the LTI tool, displays as either “Active” or “Inactive”

Time Created

Unique ID for the user profile field data record.
Excerpt
nameUser Profile Field Data ID
Time Created

Timestamp for when the LTI activity was created in the platform

User Profile Fields Category

User Profile Field

...

Statuses Status

Contents
Excerpt
nameUser Profile Field Data
Statuses Status

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
nameCohorts Status

Status of the cohort, displays as “Active” or “Inactive”

Cohorts Components

Excerpt
nameCohorts Components

TBD

Cohorts Created At

Excerpt
nameCohorts Created At

Timestamp for when the cohort was created.

...

Excerpt
nameCohorts Update At

Timestamp for the most recent modification of the cohort.

Cohort

...

Excerpt
nameCohort Members Added At

TBD

Cohort Statuses Status

Excerpt
nameCohort Statuses Status

Status of the cohort group, displays as either “Active” or “Inactive”

...

IntelliBoard Lite/Legacy Data

Page - level of lms accessed

Excerpt
namePage - level of lms accessed

The level in the LMS the User has accessed. i.e. Course, Module, etc.

...

Excerpt
nameParameter

The Internal ID number that is assigned by Totarathe LMS

Visits

Excerpt
nameVisits

The number of visits to the course by the User

...

Excerpt
nameSunday, Monday, Tuesday, etc (hours)

Time spent by User in specified time period of the day..

Sunday Monday, Tuesday, Wednesday, Thursday, Friday, Saturday (Percent of total time)

Excerpt
nameSunday, Monday, Tuesday, etc.. Percent of Total

Percent of total time spent by users on a specific day of the week compared to a full week.

...

Excerpt
nameProgress

Progress of User on the LMS site in the course. Displays as a bar graph or a percentage of completion.

Completed Activities

Excerpt
nameCompleted Activities

Total number of activities user has completed.

Status - User

Excerpt
nameStatus - User

User’s status within the course. May display as either “Complete” or “Incomplete.”

Time On Site - User

Excerpt
nameTime on Site - User

Total time User has spent on the LMS.

Time on Courses - User

Excerpt
nameTime Total time on all Courses - User

Total time User has spent in all courses.

Time on Activities - User

Excerpt
nameTime on Activities - User

Total time User has spent in all activities.

...

Excerpt
nameDeleted

The column stores data about whether the user's activity was deleted

Modified - User

Excerpt
nameModified - User

Date when User was modified in the LMS system

...

Excerpt
nameenrolled by

Name of person or role who enrolled user in course

Number of Courses in Category

Excerpt
nameNumber of course in category

The total number of courses within a category.

Instructor related fields

...

Excerpt
nameLast Downloaded from this Course

Displays the date the user last downloaded anything from the course

Number of Attempts

Excerpt
nameNumber of Attempts

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

...