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 -LMS
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
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 in course
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 or the status of Complete or Incomplete to the question has the user completed the courseNumber 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 totalFirst 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 Completion Number of Modules
Number of Modules Required to be completed in a course for a userEnrollment Type
Unique ID for the type of EnrollmentEnrollment Date
Date user enrolled in courseEnrollment expected 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 - LMS
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.Course Completion Status
Displays the status of the user in regards to course completion. May return “In Progress” or “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 Grade
Grade displayed as percent or points on the individual activity in a courseActivity 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.Visible Activity
Displays “Yes” or “No” if the activity is visible to learnersActivities - number of
Total number of activities in course, determined by sum of unique Activities ID.Visits to Activity
Total number of visits by users to an activityTime Spent in Activity
Total time spent by users in an activityAverage Score in Activity
The average score of users on an activityFirst Access to Activity
Date of first time an activity was accessed by a userActivity Completion Category
Activity Completion Date
Date of activity completion if the activity has been completedActivity Completion Status
Displays the completion status of an activity, such as “Complete Pass,” “Complete Fail,” or “Incomplete”Percent Completed Activities
The percentage of completed activities in the courseActivities 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
Total number of users who have completed the activityActivity 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
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 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
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 most recent post in the discussion was created.Forum 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 learnersAssignments
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 achievable
Maximum grade achievable on the grade objectGrade Object Name
Friendly name (everyday name) of the grade itemGrade 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
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 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 - 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
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 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 course or of all users in a course, dependent upon the report.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
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 platformBrowsers 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.Days Since Last Submission
Show number of days since user submitted an activity (assignment, quiz, forum post, etc) in a course. Is determined by “Current Date - Date of Last submission”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 platformUser Profile Fields Category
User Profile Field Statuses Status
Displays the visibility of the user profile field, either “Visible” or “Not Visible”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 Created At
Timestamp for when the cohort was created.Cohorts Updated At
Timestamp for the most recent modification of the cohort.Cohort 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 - level of lms accessed
The level in the LMS the User has accessed. i.e. Course, Module, etc.Parameter
The Internal ID number that is assigned by the LMSVisits
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 users are most active in the course.Time of Day
Displays based on the filter setting. It may show 3 periods, 6 periods, or total time breakdown for the subsequent days of the week (hours) columns. In some reports, the Time of Day is already set, other reports may have a filter setting that can adjusted.Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday (Hours)
Time spent by User in specified time period of the day.Sunday Monday, Tuesday, Wednesday, Thursday, Friday, Saturday (Percent of total time)
Percent of total time spent by users on a specific day of the week compared to a full week.Progress
Progress of User on the LMS site in the course. Displays as a bar graph or a percentage of completion.Completed Activities
Total number of activities user has completed.Status - User
User’s status within the course. May display as either “Complete” or “Incomplete.”Time On Site - User
Total time User has spent on the LMS.Time on Courses - User
Total time User has spent in all courses.Time on Activities - User
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 - User
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. AssignedActions - Send Email
Click the mail icon to open a new email in your default email client and prefills the “to” email address with the user’s email address.Action - connect to LMS
Click the “View” link to access the connected LMSDate 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 Completed Learners
Total number of users with learner roles that have completed the course.Number 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 courseNumber of Visits to Course
Total number of visits by all users to a course.Percent 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.Number of Completions
Total number of Assignments that have been completed in a courseNumber of Submitted
Total number of Assignments that have been submitted in a courseNumber of Grades
Total number of Assignments that have been graded in a courseNumber of Enrolled Users
Total number of all users enrolled in course, regardless of role.Origin
The method the user used to access the content. i.e. “web”LMS Dashboards
Dashboard Time Spent (Total)
Total Time a user has spent on the LMS dashboardDashboard Visits (Total)
The number of clicks (mouse clicks) made by instructor in a specific courseFirst Access to Dashboard
Date of user’s first access to the LMS dashboardLast Access to Dashboard
Date of user’s most recent access to the LMS dashboardInstructor Dashboard Report/Item
The dashboard name and the particular item on this dashboard instructor has visitedEnrolled By
Name of person or role who enrolled user in courseInstructor related fields
Number of Instructor Posts in a Forum
The sum total of posts made by the instructor in a forum.Number of Active Learners in the Last 30 Days
Number of learners who have engaged with the LMS system in the last 30 daysNumber of Learner(s) with Completed Courses
The number of learners who have completed courses with the associated instructor (must be enabled in the LMS system)Average Grade for All Courses
The average grade for all learners in all courses associated with the instructorNumber of Users Accessed Course
Total number of users who have accessed the course, regardless of roleNumber of Users Who Never Accessed
Total number of users who have never accessed the course, regardless of roleNumber of Users Completed
Total number of users who have completed the courseNumber of Instructors
Total number of instructors assigned to a courseNumber of Incomplete Learners
Total number of enrolled learners that have not yet completed the courseNumber of Overdue Users
Total number of enrolled learners that are overdue for course completion.Number of Learners Who Entered The Course and Completed an Activity
Total number of learners who have accessed the course and completed at least 1 activityNumber of Learners Who Entered The Course and Not Completed an Activity
Total number of learners who have accessed the course but have not completed any activitiesCourse Progress related
Activity Views
Percent of Activities that have been viewed by the user as shown by a progress barPercent of Completed Modules
Percent of Modules that have been completed by the user as shown by a progress barAssignments Percent Completed
Percent of Assignments that have been completed by the user as shown by a progress barCourse (Feedback)
Displays feedback from the course by the userLast Downloaded from this Course
Displays the date the user last downloaded anything from the courseNumber 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
The complete and descriptive name of the course outcomeOutcome Short Name
The condensed version of the full name, often used for brevity in reports, dashboards, or other interfaces where space is limitedOutcome Description
Provides additional context or details about the outcome, including any specific skills, knowledge, or competencies that students should demonstrate. It elaborates on what the outcome entails and may include examples or criteria for achievement.Outcome Scale
This indicates how the outcome will be measured or assessed. It could be a qualitative scale (e.g., Excellent, Good, Fair, Poor) or a quantitative scale (e.g., Percentage, Letter Grade, Rubric Score).Outcome Average
This represents the average level of achievement for the outcome across all students in the course.Number of activities that will be Graded in a course
Total number of assignments, activities, etc that will be graded as part of the courseOutcome Number
The specific identifier or code assigned to each course outcome within an LMS or educational system.Component
The Open LMS Outcome Component for the courseMinimum Grade
Displays the minimum possible grade for the assignment or assessment.Maximum Grade
Displays the maximum possible grade for the assignment or assessment.Raw Grade
The raw score or grade achieved by the user on the assignment or assessment before any adjustments or calculations.Instance
This column may provide additional information about the instance or occurrence of the assignment or assessment within the course, such as a specific module or session.Attempts ID
A unique identifier for each attempt made by a user on an assignment or assessment.
Add Comment