Versions Compared

Key

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

...

Excerpt
nameQuiz Attempt Score

Score for the quiz attempt

Quiz

...

Excerpt
nameQuiz Attempts Points

TBD

Quiz Attempt Status

Excerpt
nameQuiz Attempt Status

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

...

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

...

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

Excerpt
nameAssignment Submissions Aggregated Last Assignment Submissions Grade Letter ID

TBD

...

Submission Feedback

Text feedback or comments on the assignment submission

Assignment Submission Feedback Date

Excerpt
nameAssignments

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

...

Assignment Submission Feedback Date

Date of when the submission feedback was created

Assignment Submission Score

Excerpt
nameLast Assignment Submission Score

Percentage grade Displays score of last assignment submitted in course

Assignments Submissions Category

...

the assignment, if graded

Assignment Submissions URL

Excerpt
nameAssignment Submission ID

Unique ID for the assignment submission record

...

Submissions URL

URL of the Assignment Submission

Last Assignment

Excerpt
nameLast Assignment Submission Date

Date of when the assignment Name of last Assignment activity that was submitted

...

Grade Category

Grade Object Max Grade achievable

Excerpt
nameAssignment Submission Feedback

Text feedback or comments on the assignment submission

...

Grade Object Max Grade - max achievable grade

Maximum grade achievable on the grade object

Grade Object Name

Excerpt
nameAssignment Submission Feedback Date

Date of when the submission feedback was created

...

Grade Object Name

Friendly name (everyday name) of the grade item

Grade Object Result ID

Excerpt
nameAssignment Submission Score

Displays score of the assignment, if graded

Assignment Submissions URL

Excerpt
nameAssignment Submissions URL

URL of the Assignment Submission

Last Assignment

Excerpt
nameLast Assignment

Name of last Assignment activity that was submitted

Grade Category

...

Grade 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

Grade Object Result Graded Date

Excerpt
nameGrade Object Max Grade

Maximum grade achievable on the grade object

...

Result Graded Date

Date of when the grade was entered

Grade Objects Results Grade Score

Excerpt
nameGrade Objects Results Grade Object Name

Friendly name (everyday name) of the grade item

...

Score

Number of points the learner achieved on the assignment

Grade Letter

TBD
Excerpt
nameGrade Object is External
Letter

Letter grade for an assignment or course

Grade Object Result

...

Status

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.

...

Status

Displays status of a grade object as either “Published” or “Unpublished”

Grade Object Type

Excerpt
nameGrade Object Result Grade Points

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

...

Type

Displays whether the grade line item is for an activity or a course

Grade Object Status

Excerpt
nameGrade Object Result Graded Date

Date of when the grade was entered

...

Status

Displays the status of a grade object as either “Active” or “Inactive”

User Tracking Total Category

User Tracking Total ID

Excerpt
nameGrade Objects Results Grade Score

Number of points the learner achieved on the assignment

...

User Tracking Total ID

A unique identifier for the record summarizing a single user’s action across the LMS. This is an IntelliBoard calculate field.

Total Visits

Excerpt
nameGrade Object Result Feedback

TBD

...

Total 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
nameGrade Letter

Letter grade for an assignment or course

...

Total 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.

Total Participations

Excerpt
nameGrade Object Result Status

Displays status of a grade object as either “Published” or “Unpublished”

...

Total Participations

The number of participations in a given activity within a course over time (as calculated by IntelliBoard), where "participations" are submissions by the student of content for feedback

IP Address

Excerpt
nameGrade Object Type

Displays whether the grade line item is for an activity or a course

...

IP Address

IP Address the user accessed the LMS from

First Access Date

Excerpt
nameGrade Object Status

Displays the status of a grade object as either “Active” or “Inactive”

User Tracking Total Category

...

First Access Date

Date of the user’s first access of the LMS

Last Access Date

Excerpt
nameUser Tracking Total ID

A unique identifier for the record summarizing a single user’s action across the LMS. This is an IntelliBoard calculate field.

...

Last Access Date

Date of the user’s most recent access of the LMS

Context Type

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.

...

Context Type

Displays if the user tracking point is from the site, a course, or a module.

Time Spent

Excerpt
nameTotal Time Spent

The cumulative amount Sum total of User’s time spent by the user viewing or interacting with a given activity within a course over time. This is an IntelliBoard calculated field.

...

in a course or of all users in a course, dependent upon the report.

User Last System Login

Excerpt
nameTotal Participations

The number of participations in a given activity within a course over time (as calculated by IntelliBoard), where "participations" are submission by the student of content for feedback

...

User Last System Login

Date of the most recent user login to the platform. Displays “0” if the user has not yet logged in.

User Tracking by Day Category

User Tracking By Day Visits

Excerpt
nameIP Address

IP Address the user accessed the LMS from

...

User Tracking By Day Visits

User visits per day

User Tracking by Day Time Spent

Excerpt
nameFirst Access Date

Date of the user’s first access of the LMS

...

User Tracking By Day Time Spent

Total time a user spent on the platform by day

User Tracking by Day Time Points

Excerpt
nameLast Access Date

Date of the user’s most recent access of the LMS

...

User Tracking by Day Time Points

Date which a user activity was logged in the LMS

User Tracking By Hour Category

User Tracking by Hour Visits

Excerpt
nameContext Type

Displays if the user tracking point is from the site, a course, or a module.

User Tracking By Hour Visits

Count of user visits by hour of the day

User Tracking By Hour Time Spent

Excerpt
nameUser Tracking By Hour Time Spent

Sum total of User’s time spent in a course or of all users in a course, dependent upon the report.

...

Time spent in the LMS by the user, broken down by hours. This in an IntelliBoard calculated field

User Tracking By Hour Time Points

Excerpt
nameUser Last System LoginTracking By Hour Time Points

Date of and hour for the most recent user login to the platform. Displays “0” if the user has not yet logged in.

User Tracking by Day Category

User Tracking By Day Visits

Excerpt
nameUser Tracking By Day Visits

User visits per day

User Tracking by Day Time Spent

Excerpt
nameUser Tracking By Day Time Spent

Total time a user spent on the platform by day

User Tracking by Day Time Points

Excerpt
nameUser Tracking by Day Time Points

Date which a user activity was logged in the LMS

User Tracking By Hour Category

User Tracking by Hour Visits

Excerpt
nameUser Tracking By Hour Visits

Count of user visits by hour of the day

User Tracking By Hour Time Spent

Excerpt
nameUser Tracking By Hour Time Spent

Time spent in the LMS by the user, broken down by hours. This in an IntelliBoard calculated field

User Tracking By Hour Time Points

Excerpt
nameUser Tracking By Hour Time Points

Date and hour for the most recent platform activity by the user. A user may have several of these per day if they access or record a participation in the LMS multiple times. (ie: 02.12.2023 12:30, 02.12.2023 13:12, 02.12.2023 15:26)

Roles Category

Role ID

Excerpt
nameRole ID

A unique identifier for a role which can be assigned to a user within a course or other context

Role

Excerpt
nameRole

The name of a role that can be assigned to a user within a course or other context

Role Alias

Excerpt
nameRole Alias

An alternative name for the role assigned to a user within a course or other context

Categories Category

Course Category ID

Excerpt
nameCourse Category ID

A unique identifier of a category unit used to group courses or subcategories

Course Category Name

Excerpt
nameCourse Category Name

Friendly name (everyday name) of a category unit used to group courses or subcategories

Course Category Path

Excerpt
nameCourse Category Path

The location of a category unit within a structure used to group courses or subcategories

Course Category Sort Order

Excerpt
nameCourse Category Sort Order

A parameter used to define how categories or organizational units will be sorted in a list

Course Category is Visible

Excerpt
nameCourse Category is Visible

Displays “Yes” or “No” if the category is visible in the platform.

Course Category Updated Date

Excerpt
nameCourse Category Updated Date

Date of the most recent modification in the platform

Course Category Code

Excerpt
nameCourse Category Code

Optional category id number. This is typically an external or SIS-linked id number.

Category Path

Excerpt
nameCategory Path

Hierarchical path of categories that has been set for courses in the LMS

Category

Category
Excerpt
name

platform activity by the user. A user may have several of these per day if they access or record a participation in the LMS multiple times. (ie: 02.12.2023 12:30, 02.12.2023 13:12, 02.12.2023 15:26)

Roles Category

Role ID

Excerpt
nameRole ID

A unique identifier for a role which can be assigned to a user within a course or other context

Role

Excerpt
nameRole

The name of a role that can be assigned to a user within a course or other context

Role Alias

Excerpt
nameRole Alias

An alternative name for the role assigned to a user within a course or other context

Categories Category

Course Category ID

Excerpt
nameCourse Category ID

A unique identifier of a category unit used to group courses or subcategories

Course Category Name

Excerpt
nameCourse Category Name

Friendly name (everyday name) of a category unit used to group courses or subcategories

...

Course Category

...

Path

Excerpt
nameTerm IDCourse Category Path

The unique identifier of a term or semester as defined in the connected platform

Term Name

Excerpt
nameTerm Name

The name of the term, a set period of time often used to organize courses, as defined on the connected platform

...

location of a category unit within a structure used to group courses or subcategories

Course Category Sort Order

Excerpt
nameTerm CodeCourse Category Sort Order

A unique, visible identifying code given to the term within the connected platform

...

parameter used to define how categories or organizational units will be sorted in a list

Course Category is Visible

Excerpt
nameTerm State Date

Date when the term begins, as defined in the connected platform

...

Course Category is Visible

Displays “Yes” or “No” if the category is visible in the platform.

Course Category Updated Date

Excerpt
nameTerm End Course Category Updated Date

Date of the end of the term, as defined most recent modification in the connected platform

...

Course Category Code

Excerpt
nameTerm Status

TBD

Browsers Category

Browser ID

Course Category Code

Optional category id number. This is typically an external or SIS-linked id number.

Category Path

Excerpt
nameBrowser ID

Unique ID for the browser used

...

Category Path

Hierarchical path of categories that has been set for courses in the LMS

Category

Excerpt
nameBrowser NameCategory

Friendly name (everyday name) for the browser used (ie: Firefox, Safari, or Chrome)

Operating Systems Category

...

of a category unit used to group courses or subcategories

Terms Category

Term ID

Excerpt
nameOperating System ID

Unique ID for the operating system

...

Term ID

The unique identifier of a term or semester as defined in the connected platform

Term Name

Excerpt
nameTerm Name

The name of the term, a set period of time often used to organize courses, as defined on the connected platform

Term Code

Excerpt
nameOperating System Name

Friendly name (everyday name) for the operating system (ie: Windows, ChromeOS, or MacOS)

Submissions Category

...

Term Code

A unique, visible identifying code given to the term within the connected platform

Term Start Date

Excerpt
nameAssignment Submission Status

Displays the status of the learner submission as “New,” “Draft,” “Submitted,” “Graded,” or “Reopened”

...

Term State Date

Date when the term begins, as defined in the connected platform

Term End Date

Excerpt
nameLast SubmissionTerm End Date

Date of last assignment submitted in course

...

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

Browsers Category

Browser ID

Excerpt
nameSubmitted At

Date the activity was submitted

...

Browser ID

Unique ID for the browser used

Browser Name

Excerpt
nameSubmission Type

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

LTI Tools

...

Browser Name

Friendly name (everyday name) for the browser used (ie: Firefox, Safari, or Chrome)

Operating Systems Category

Operating System ID

Excerpt
nameLTI Operating System ID

Unique ID for the LTI Tool

...

operating system

Operating System Name

Excerpt
nameLTI Operating System Name

Friendly name (everyday name) of the LTI tool

...

for the operating system (ie: Windows, ChromeOS, or MacOS)

Submissions Category

Assignment Submission Status

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”

...

Assignment Submission Status

Displays the status of the learner submission as “New,” “Draft,” “Submitted,” “Graded,” or “Reopened”

Last Submission

Excerpt
nameTime Created

Timestamp for when the LTI activity was created in the platform

Deprecated User Profile Field Categories

...

Last Submission

Date of last assignment submitted in course

Submitted At

Excerpt
nameUser Profile Field Categories ID

Unique ID for the user profile field category.

...

Submitted At

Date the activity was submitted

Submission Type

Excerpt
nameUser Profile Field Categories Name

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

Deprecated User Profile Fields

...

Submission Type

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

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

User Profile Field Data ID

Excerpt
nameUser Profile Field Data ID

Unique ID for the user profile field data record.

...

LTI 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

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.field, 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
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

...