Excerpt Macros for defining data within IntelliBoard. Updating information here will update it throughout all support documents that use the excerpt macro.
Users Category
User ID
The unique value automatically created for each user by the connected LMS systemUsername
Friendly name for the user in the platform, typically the login name for the user and created by the organizationFull Name
User’s first and last nameEmail Address
User’s Primary Email Address as entered in the LMS. In IntelliBoard Pro, it displays as a clickable mailto link that automatically opens a new email in your default email client and prefills the “to” email address.User Organization
The organization associated with the user in the LMSUser Creation Date
Timestamp for when the user account was created in the LMSLocale
Language code (such as “EN”) for the user’s preferred languageCountry Code
Home country code of the user, such as AU or USUser SIS ID
An arbitrary ID code number, perhaps from the institutionFirst System Login
Timestamp for the first time the user logged in to the platform. Displays 0 if the user has not yet logged in.Last System Login
Timestamp for the most recent user login to the platform. Displays 0 if the user has not yet logged in.Number of System logins
Count of user logins to the platform. This is an IntelliBoard calculated field.URL to User Profile
Link to the User’s LMS profile page. You must log in to the LMS to have access.First Name
User’s First NameLast Name
User’s Last NameUser Status
User state in the system, displays as either Active or InactiveEnrollment Category
Enrollment Role
User’s Role in course. (ie: Learner, Instructor, Designer, Observer)Enrollment ID
Unique ID for the user enrollmentLast Activity Date
Timestamp for the last activity of the learner in the enrolled courseLast Participation
Timestamp for the leaner’s last participation in the enrolled course. Note: an instructor may return a last participation if they have interacted in course forums.Course Completion Date
Date of when learner satisfies all requirements to complete the courseCourse Completion Met
Returns yes or no if the enrollment is completeNumber of Completed Activities
Count of complete activities for the learner’s enrollment. This is an IntelliBoard calculated field.Number of Activities
Total number of activities the learner must complete to satisfy enrollment requirementsCourse Grade (Percent)
Course Grade displayed as a percentage out of 100Course Grade (Points)
Course Grade displayed by points totalInstructor Course Role
Instructor Course Role - TBDLearner Course Role
Learner Course Role - TBDCourse Role Name
Course Role Name - TBDFirst Course Access
Date of user's first access to the courseLast Course Access
Date of user’s last access to the courseCourse Grade Letter
Course Grade displayed by letter gradeNumber of Modules/Course Sections required to complete the course
Total number of course modules or sections required to complete the courseEnrollments Need Complete Modules
Number of Modules Required to be completed in a course for a userEnrollment Type
Unique ID for the type of EnrollmentEnrollment Start Date
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.Enrollment Updated Date
Date for most recent modification to a user’s enrollmentEnrollment End Date
Date for the expected completion date of an enrollment, if entered. If no completion date is set, “Never” will be displayed.Course Total Time Spent
Total amount of time spent by user in the course on the LMSEnrollment Type Name
How the user enrolled in a course, such as “manual,” “cohort,” or via a 3rd party registration system such as IntelliCartEnrollment Status
Displays the status of a learner’s enrollment: Active, Inactive, Deleted, or CompletedEnrollment Status Complete
Displays “yes” or “no” if an enrollment in a course has satisfied requirements for completionDays Since Enrollment Last Course Access
The number of days since user last accessed the courseEnrollment Last Access
Date the user last accessed the courseEnrollment Course Grade Score
User’s current grade in the course, number out of 100.Total Enrollments
The total number of enrollments in the course, determined by the sum of unique User ID enrolled in the course.Courses Category
Course
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
The unique value automatically created for each course by the connected LMS systemCourse SIS ID
The unique value automatically created for each course by the connected SIS data.Course Format
Course format such as weeks, topics, social, sites, etc.Course Organization
The Organization associated with the course in the connected platformCourse Name
Friendly name (or everyday name) for the course. This is not attached to the URL for the course in the LMS. It is useful when downloading a report as .csv or .xlsx file.Course Code
User-defined code for the course, typically the SIS IDCourse Creation Date
Date for when the course was created in the LMSCourse Start Date
Date for the scheduled start of the courseCourse End Date
Date for the scheduled end of the courseVisible Course
Displays “Yes” or “No” if the course is visible to studentsCourse URL
URL to the course in the LMS. This is an IntelliBoard generated field.Instructor(s)
Instructor(s) for courseInstructor Email(s)
Email contact for the course Instructor(s)Course Average Grade
Average grade of all learners in the courseCourse Status
Displays whether the course is visible in the LMS as “Active” or “Inactive”User(s) in Course
Total number of users in the courseAverage Time Spent
Average amount of time spent per user in courseAverage Participation
Average number of times users participated in the courseAverage Course Grade
The average grade of students in the class, determined by taking the average of all current grades in the courseActive Courses
Total number of active courses user is enrolled.Completed Courses
Total number of courses user has completed.Activity Category
Activity ID
The unique value automatically created for each activity by the connected LMS systemActivity
The name of the activity as populated in the LMS. It is a clickable link to the activity page in the LMS. You must be logged in the LMS to have access.Activity Name
The name of the activity as populated in the LMS. This is not attached to the URL for the activity in the LMS. It is useful when downloading a report as .csv or .xlsx file.Activity Submission Type
If the activity is an assignment, displays type of submission such as “comment” or “file”Activity Creation Date
Date of when the activity record was createdActivity Due Date
Shows due date for activity if the activity is a quiz or assignmentActivity Expected Completion Date
Date for the expected activity completion dateActivity Object ID
Unique ID for the course module which contains the activityActivities URL
URL for the activity. This is an IntelliBoard calculated field.Activities Sort Order
TBDVisible Activity
Displays “Yes” or “No” if the activity is visible to learnersActivities
Total number of activities in course, determined by sum of unique Activities ID.Activity Completion Category
Activity Completion Date
Date of activity completion if the activity has been completedActivity Completion URL
TBDActivity Completion ID
TBDActivity Completion Status
Displays the completion status of an activity, such as “Complete Pass,” “Complete Fail,” or “Incomplete”Course Module Activities Completions Status Name
TBDPercent Completed Activities
The percentage of completed points in the courseActivity Types Category
Activity Type ID
Unique value automatically created for each activity type by the connected LMS systemActivity Type Name
Name of the activity, such as “Assignment” or “Quiz”Activity Type Alias
Friendly name (everyday name) for the activity type, such as “Assignment” or “Quiz”Quizzes Category
Quiz ID
Unique ID for the quizQuiz Name
Friendly name (everyday name) for the quizQuiz Start Date
Date for when the quiz becomes available in the courseQuiz End Date
Date for when the quiz will become unavailable. Includes “grace period” time.Quiz Due Date
Date for when the quiz will become unavailable. Does not include the “grace period.”Quiz Creation Date
Date for when the quiz was createdQuiz Status
Displays status of the quiz in a course as either “Active” or “Inactive”Quizzes
Total number of quizzes in a course, determined by the sum of unique Quiz Activities IDs.Quiz Attempts Category
Quiz Attempt ID
Unique ID for the quiz completion attemptQuiz Attempt
Number of the quiz attempt (ie: a learner’s 2nd attempt)Quiz Attempt Start Time
Timestamp for when the quiz attempt was startedQuiz Attempt Finish Time
Timestamp for when the quiz attempt was completedQuiz Attempt Score
Score for the quiz attemptQuiz Attempts Points
TBDQuiz Attempt Status
Status of the learner interaction with a quiz. Displays “Untaken,” “In Progress,” “Pending Review,” or “Complete.”Quiz Questions Category
Quiz Question ID
Unique ID for the quiz questionQuiz Question Name
Name of the quiz questionQuiz Question Text
Text of the questionQuiz Question Max Points
Total number of points the learner can achieve with a correct answerQuiz Question Types Name
TBDQuiz Questions Types Type
TBDQuiz 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
Unique ID for the forum activityForum Name
Name of the forum activityForum Creation Date
Date of when the forum activity was createdForum is an Announcement
Displays “Yes” or “No” if the forum activity is a course announcementForums
Total number of forums in a course, determined by the sum of unique Forum Activities IDs.Forum Discussion Category
Forum Discussion ID
Unique ID for the forum discussionForum Discussion Name
Name of the forum discussion/topicForum Discussion Last Post Date
Date of when the discussion post/topic was createdForum Posts Category
Forum Post ID
Unique ID for the forum post as given by the LMSForum Post Text
Content of the discussion postForum Post Number of Replies
Number of replies the post received. This is an IntelliBoard calculated field.Forum Post Creation Date
Date of when the forum/discussion post was createdForum Post Updated Date
Date of when the post/discussion was modifiedForum Post Status
Displays if the forum/discussion post is “Active,” “Inactive,” or “Deleted”Pages Category
Page ID
Unique ID for the pagePage Name
Friendly name (everyday name) of the pagePage Creation Date
Date of when the page was createdPage Status
Displays “Yes” or “No” if the course page is visible to studentsPages
Total number of pages in a course, determined by the sum of unique Page Activities IDs.Assignment Category
Assignment Submission Type
The type of submission accepted by the assignment (ie: file, URL, plain text)Assignment ID
ID of the course module the assignment is contained withinAssignment Name
Name of the assignmentAssignment Start Date
Date of when the assignment becomes available in the courseAssignment End Date
Date of when the assignment will no longer be available in the courseAssignment Due Date
Date of assignment’s due dateAssignment Creation Date
Date of when the assignment was createdVisible Assignment
Displays “Yes” or “No” if the assignment is the visible to learnersAssignment Submissions Aggregated Last Assignment Submissions Submitted At
TBDAssignment Submissions Aggregated Last Assignment Submissions Grade Score
TBDAssignment Submissions Aggregated Last Assignment Submissions Grade Point
TBDAssignment Submissions Aggregated Last Assignment Submissions Grade Letter ID
TBDAssignments
Total number of assignments in a course, determined by the sum of unique Assignment Activities IDs.Last Assignment Score
Percentage grade of last assignment submitted in courseAssignments Submissions Category
Assignment Submission ID
Unique ID for the assignment submission recordAssignment Submission Date
Date of when the assignment was submittedAssignment Submission Feedback
Text feedback or comments on the assignment submissionAssignment Submission Feedback Date
Date of when the submission feedback was createdAssignment Submission Score
Displays score of the assignment, if gradedAssignment Submissions URL
URL of the Assignment SubmissionLast Assignment
Name of last Assignment activity that was submittedGrade Category
Grade Object Max Grade
Maximum grade achievable on the grade objectGrade Object Name
Friendly name (everyday name) of the grade itemGrade Object is External
TBDGrade 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
The raw number of points assigned by the grader to the submissionGrade Object Result Graded Date
Date of when the grade was enteredGrade Objects Results Grade Score
Number of points the learner achieved on the assignmentGrade Object Result Feedback
TBDGrade Letter
Letter grade for an assignment or courseGrade Object Result Status
Displays status of a grade object as either “Published” or “Unpublished”Grade Object Type
Displays whether the grade line item is for an activity or a courseGrade Object Status
Displays the status of a grade object as either “Active” or “Inactive”User Tracking Total Category
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
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
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
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 feedbackIP Address
IP Address the user accessed the LMS fromFirst Access Date
Date of the user’s first access of the LMSLast Access Date
Date of the user’s most recent access of the LMSContext Type
Displays if the user tracking point is from the site, a course, or a module.Time Spent
Sum total of User’s time spent in a courseUser 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
User visits per dayUser Tracking by Day Time Spent
Total time a user spent on the platform by dayUser Tracking by Day Time Points
Date which a user activity was logged in the LMSUser Tracking By Hour Category
User Tracking by Hour Visits
Count of user visits by hour of the dayUser Tracking By Hour Time Spent
Time spent in the LMS by the user, broken down by hours. This in an IntelliBoard calculated fieldUser 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
A unique identifier for a role which can be assigned to a user within a course or other contextRole
The name of a role that can be assigned to a user within a course or other contextRole Alias
An alternative name for the role assigned to a user within a course or other contextCategories Category
Course Category ID
A unique identifier of a category unit used to group courses or subcategoriesCourse Category Name
Friendly name (everyday name) of a category unit used to group courses or subcategoriesCourse Category Path
The location of a category unit within a structure used to group courses or subcategoriesCourse Category Sort Order
A parameter used to define how categories or organizational units will be sorted in a listCourse Category is Visible
Displays “Yes” or “No” if the category is visible in the platform.Course Category Updated Date
Date of the most recent modification in the platformCourse Category Code
Optional category id number. This is typically an external or SIS-linked id number.Category Path
Hierarchical path of categories that has been set for courses in the LMSCategory
Friendly name (everyday name) of a category unit used to group courses or subcategoriesTerms Category
Term ID
The unique identifier of a term or semester as defined in the connected platformTerm Name
The name of the term, a set period of time often used to organize courses, as defined on the connected platformTerm Code
A unique, visible identifying code given to the term within the connected platformTerm Start Date
Date when the term begins, as defined in the connected platformTerm End Date
Date of the end of the term, as defined in the connected platformTerm Status
TBDBrowsers Category
Browser ID
Unique ID for the browser usedBrowser Name
Friendly name (everyday name) for the browser used (ie: Firefox, Safari, or Chrome)Operating Systems Category
Operating System ID
Unique ID for the operating systemOperating System Name
Friendly name (everyday name) for the operating system (ie: Windows, ChromeOS, or MacOS)Submissions Category
Assignment Submission Status
Displays the status of the learner submission as “New,” “Draft,” “Submitted,” “Graded,” or “Reopened”Last Submission
Date of last assignment submitted in courseSubmitted At
Date the activity was submittedSubmission Type
The type of submission the activity is. Examples include: Online text entry, discussion topic, and online upload.LTI Tools
LTI ID
Unique ID for the LTI ToolLTI name
Friendly name (everyday name) of the LTI toolLTI Tool URL
URL of the LTI toolLTI Tool State
Status of the LTI tool, displays as either “Active” or “Inactive”Time Created
Timestamp for when the LTI activity was created in the platformDeprecated User Profile Field Categories
User Profile Field Categories ID
Unique ID for the user profile field category.User Profile Field Categories Name
Friendly name (everyday name) for the user profile field categoryDeprecated User Profile Fields
User Profile Fields ID
Unique ID for the user profile fieldUser Profile Fields Shortname
Short name for the user profile field. This is typically the system name.User Profile Fields Name
Name of the user profile field. This is typically the friendly or display name.User Profile Fields Category
User 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
Unique ID for the user profile field data record.User Profile Field Data
Contents of the user profile field, such as a department name, birth year, academic major, etc.User Profile Field Data Category
User Profile Field Data Format
Format of the user profile field. Typically displays the name of the platform the profile field was created in.Cohort Category
Cohorts ID
Unique ID of the cohortCohorts Name
Friendly name (everyday name) for the cohortCohorts ID Number
User-generated ID for the cohort. Typically matched with external systems such as an SIS.Cohorts Status
Status of the cohort, displays as “Active” or “Inactive”Cohorts Components
TBDCohorts Created At
Timestamp for when the cohort was created.Cohorts Updated At
Timestamp for the most recent modification of the cohort.Cohort Members Added At
TBDCohort Statuses Status
Status of the cohort group, displays as either “Active” or “Inactive”Course Sections
Course Section Start Date
Course Section End Date
Course Section ID
Course Section Name
Course Section Update Date
Course Section Total Users
The total number of users enrolled in a section regardless of a roleCourse Section Description
Course Section Course Listed Course ID
IntelliBoard Lite/Legacy Data
Page
The level in the LMS the User has accessed. i.e. Course, Module, etc.Parameter
The Internal ID number that is assigned by TotaraVisits
The number of visits to the course by the UserUser Language
Primary language of the UserCourse Template
The template organizational unit serves as a grouping container in the LMS for organizing similar or related courses. For example, you can group all History 101 classes in one place if you offer multiple sections or group all History classes in one place. It helps make enrolling, creating, and managing courses easier over time.Most Active Day
Displays the day of the week the specific User is most active in the course.Time of Day
Displays based on the filter setting above. Shows 3 periods, 6 periods, or total time breakdown for the subsequent days of the week (hours) columns.Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday (Hours)
Time spent by User in specified time period of the day.Progress
Progress of User on the LMS site in the course. Displays as a bar graph.Completed Activities
Total number of activities user has completed.Status
User’s status within the course. May display as either “Complete” or “Incomplete.”Time On Site
Total time User has spent on the LMS.Time on Courses
Total time User has spent in all courses.Time on Activities
Total time User has spent in all activities.Telephone
User’s primary phone numberPhone 2
Secondary phone number if available.Institution
Institution of UserDepartment
Department of UserAddress
User’s street addressCity/Town
User’s city/town of residence.Country
User’s country of residence.Degree
Type of Degree User is pursuing. ie. PhD, Associate, Bachelor, High School, etcEthnic Group
User’s self identified ethnic group if availableFull Time/Part Time
User’s student status, Full Time or Part Time, if availableGender
User’s self identified gender, if availableGroup
User’s assigned groupLog In Time
Time stamp of the most recent log in to the LMSLog Out Time
Time stamp of the most recent log out of the LMSBrowser Use Percentage
Displays the percentage a User has used particular browsers. i.e. Firefox, Chrome, Safari, Edge, etc.Operating System Percentage
Displays the percentage a User has used particular operating systems. i.e. Windows 10, Mac OS X, Linus, etcDevice Use Percentage
Displays the percentage a User has used particular devices. i.e. iPhone, iPad, Android, etcNumber of Courses
Total number of courses User is enrolledAuthentication Method
The authentication method by which the user was added to the LMS systemConfirmed
The column stores data about whether the user's data was confirmedSuspended
The column stores data about whether the user's activity was suspendedDeleted
The column stores data about whether the user's activity was deletedModified
Date when User was modified in the LMS systemCurrent Login
The last time the user logged in using previously saved data. User is still logged on.Grade
Average of grades in all enrolled courses.Score
Learner's current grade in courseRole Changed
Displays if the user’s role has been changed, either yes or no.Role Changed By
Displays the name of person who changed the user’s role, if it has been changed.Role Changed From
Displays the previous role held by the user, if the role has been changed.Action
Action taken in the role change. i.e. AssignedDate Role Was Changed
Date the role change occurred.Short Name
Shortened name for limited space needsDate Graded
Date an assignment, activity, or quiz was graded.Graded By
Name of person who graded the assignment, activity, or quizForum Total
The total number of forums within a course.Forum Visits
Total number of visits to forum(s) within a courseForum Time Spent
Total amount of time users have spent on forums within a courseForum Posts
Total number of posts within a course’s forum(s)Forum Discussions
Total number of discussions within a course’s forum(s)Time Spent on Activity
Total time user spent on a specific activity.Details
A hyperlink to details of the activity and BBB attendanceNumber of Learners Enrolled
Total number of users with learner roles that are enrolled in a course.Number of Learner Events
Total number of Learner Events in a coursePercent of Activities Completed by Learners
The percent of activities in a course that have been completedAverage Learner Forum Post by Day
The average number of forum posts per day by learners in a courseAverage Learner Course Visits by Day
The average number of overall course visits per day by learners in a courseNumber of Workshops
Total number of workshops in a courseNumber of New Activities Added After Course Creation Date
Total number of any new activities added to a course after the course’s initial creation date.
Add Comment