Excerpt Macros for defining data within IntelliBoard. Updating information here will update it throughout all support documents that use the excerpt macro.
The unique value automatically created for each user by the connected LMS system |
Friendly name for the user in the platform, typically the login name for the user and created by the organization |
User’s first and last name |
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. |
The organization associated with the user in the LMS |
Timestamp for when the user account was created in the LMS |
Language code (such as “EN”) for the user’s preferred language |
Home country code of the user, such as AU or US |
An arbitrary ID code number, perhaps from the institution |
Timestamp for the first time the user logged in to the platform. Displays 0 if the user has not yet logged in. |
Timestamp for the most recent user login to the platform. Displays 0 if the user has not yet logged in. |
Count of user logins to the platform. This is an IntelliBoard calculated field. |
Link to the User’s LMS profile page. You must log in to the LMS to have access. |
User’s First Name |
User’s Last Name |
User state in the system, displays as either Active or Inactive |
User’s Role in course. (ie: Learner, Instructor, Designer, Observer) |
Unique ID for the user enrollment |
Timestamp for the last activity of the learner in the enrolled course |
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. |
Date of when learner satisfies all requirements to complete the course |
Returns yes or no or the status of Complete or Incomplete to the question has the user completed the course |
Count of complete activities for the learner’s enrollment. This is an IntelliBoard calculated field. |
Total number of activities the learner must complete to satisfy enrollment requirements |
Course Grade displayed as a percentage out of 100 |
Course Grade displayed by points total |
Date of user's first access to the course |
Date of user’s last access to the course |
Course Grade displayed by letter grade |
Total number of course modules or sections required to complete the course |
Number of Modules Required to be completed in a course for a user |
Unique ID for the type of Enrollment |
Date user enrolled in course |
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. |
Date for most recent modification to a user’s enrollment |
Date for the expected completion date of an enrollment, if entered. If no completion date is set, “Never” will be displayed. |
Total amount of time spent by user in the course on the LMS |
How the user enrolled in a course, such as “manual,” “cohort,” or via a 3rd party registration system such as IntelliCart |
Displays the status of a learner’s enrollment: Active, Inactive, Deleted, or Completed |
Displays “yes” or “no” if an enrollment in a course has satisfied requirements for completion |
The number of days since user last accessed the course |
Date the user last accessed the course |
User’s current grade in the course, number out of 100. |
The total number of enrollments in the course, determined by the sum of unique User ID enrolled in the 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. |
The unique value automatically created for each course by the connected LMS system |
The unique value automatically created for each course by the connected SIS data. |
Course format such as weeks, topics, social, sites, etc. |
The Organization associated with the course in the connected platform |
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. |
User-defined code for the course, typically the SIS ID |
Date for when the course was created in the LMS |
Date for the scheduled start of the course |
Date for the scheduled end of the course |
Displays “Yes” or “No” if the course is visible to students |
URL to the course in the LMS. This is an IntelliBoard generated field. |
Instructor(s) for course |
Email contact for the course Instructor(s) |
Average grade of all learners in the course |
Displays whether the course is visible in the LMS as “Active” or “Inactive” |
Total number of users in the course |
Average amount of time spent per user in course |
Average number of times users participated in the course |
The average grade of students in the class, determined by taking the average of all current grades in the course |
Total number of active courses user is enrolled. |
Total number of courses user has completed. |
Displays the status of the user in regards to course completion. May return “In Progress” or “Completed” |
The unique value automatically created for each activity by the connected LMS system |
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. |
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. |
Grade displayed as percent or points on the individual activity in a course |
If the activity is an assignment, displays type of submission such as “comment” or “file” |
Date of when the activity record was created |
Shows due date for activity if the activity is a quiz or assignment |
Date for the expected activity completion date |
Unique ID for the course module which contains the activity |
URL for the activity. This is an IntelliBoard calculated field. |
Displays “Yes” or “No” if the activity is visible to learners |
Total number of activities in course, determined by sum of unique Activities ID. |
Total number of visits by users to an activity |
Total time spent by users in an activity |
The average score of users on an activity |
Date of first time an activity was accessed by a user |
Date of activity completion if the activity has been completed |
Displays the completion status of an activity, such as “Complete Pass,” “Complete Fail,” or “Incomplete” |
The percentage of completed activities in the course |
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. |
Total number of users who have completed the activity |
Unique value automatically created for each activity type by the connected LMS system |
Name of the activity, such as “Assignment” or “Quiz” |
Friendly name (everyday name) for the activity type, such as “Assignment” or “Quiz” |
Unique ID for the quiz |
Friendly name (everyday name) for the quiz |
Date for when the quiz becomes available in the course |
Date for when the quiz will become unavailable. Includes “grace period” time. |
Date for when the quiz will become unavailable. Does not include the “grace period.” |
Date for when the quiz was created |
Displays status of the quiz in a course as either “Active” or “Inactive” |
Total number of quizzes in a course, determined by the sum of unique Quiz Activities IDs. |
Unique ID for the quiz completion attempt |
Number of the quiz attempt (ie: a learner’s 2nd attempt) |
Timestamp for when the quiz attempt was started |
Timestamp for when the quiz attempt was completed |
Score for the quiz attempt |
Status of the learner interaction with a quiz. Displays “Untaken,” “In Progress,” “Pending Review,” or “Complete.” |
Unique ID for the quiz question |
Name of the quiz question |
Text of the question |
Total number of points the learner can achieve with a correct answer |
This column specifies the type or format of each quiz question, such as multiple-choice, true/false, short answer, essay, etc. |
TBD |
Unique ID for the forum activity |
Name of the forum activity |
Date of when the forum activity was created |
Displays “Yes” or “No” if the forum activity is a course announcement |
Total number of forums in a course, determined by the sum of unique Forum Activities IDs. |
Unique ID for the forum discussion |
Name of the forum discussion/topic |
Date of when the most recent post in the discussion was created. |
Unique ID for the forum post as given by the LMS |
Content of the discussion post |
Number of replies the post received. This is an IntelliBoard calculated field. |
Date of when the forum/discussion post was created |
Date of when the post/discussion was modified |
Displays if the forum/discussion post is “Active,” “Inactive,” or “Deleted” |
Unique ID for the page |
Friendly name (everyday name) of the page |
Date of when the page was created |
Displays “Yes” or “No” if the course page is visible to students |
Total number of pages in a course, determined by the sum of unique Page Activities IDs. |
The type of submission accepted by the assignment (ie: file, URL, plain text) |
ID of the course module the assignment is contained within |
Name of the assignment |
Date of when the assignment becomes available in the course |
Date of when the assignment will no longer be available in the course |
Date of assignment’s due date |
Date of when the assignment was created |
Displays “Yes” or “No” if the assignment is the visible to learners |
Total number of assignments in a course, determined by the sum of unique Assignment Activities IDs. |
Percentage grade of last assignment submitted in course |
Unique ID for the assignment submission record |
Date of when the assignment was submitted |
Text feedback or comments on the assignment submission |
Date of when the submission feedback was created |
Displays score of the assignment, if graded |
URL of the Assignment Submission |
Name of last Assignment activity that was submitted |
Maximum grade achievable on the grade object |
Friendly name (everyday name) of the grade item |
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. |
The raw number of points assigned by the grader to the submission |
Date of when the grade was entered |
Number of points the learner achieved on the assignment |
Letter grade for an assignment or course |
Displays status of a grade object as either “Published” or “Unpublished” |
Displays whether the grade line item is for an activity or a course |
Displays the status of a grade object as either “Active” or “Inactive” |
A unique identifier for the record summarizing a single user’s action across the LMS. This is an IntelliBoard calculate field. |
The number of times a user has viewed a given activity within a course over time. This is an IntelliBoard calculated field. |
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. |
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 the user accessed the LMS from |
Date of the user’s first access of the LMS |
Date of the user’s most recent access of the LMS |
Displays if the user tracking point is from the site, a course, or a module. |
Sum total of User’s time spent in a course or of all users in a course, dependent upon the report. |
Date of the most recent user login to the platform. Displays “0” if the user has not yet logged in. |
User visits per day |
Total time a user spent on the platform by day |
Date which a user activity was logged in the LMS |
Count of user visits by hour of the day |
Time spent in the LMS by the user, broken down by hours. This in an IntelliBoard calculated field |
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) |
A unique identifier for a role which can be assigned to a user within a course or other context |
The name of a role that can be assigned to a user within a course or other context |
An alternative name for the role assigned to a user within a course or other context |
A unique identifier of a category unit used to group courses or subcategories |
Friendly name (everyday name) of a category unit used to group courses or subcategories |
The location of a category unit within a structure used to group courses or subcategories |
A parameter used to define how categories or organizational units will be sorted in a list |
Displays “Yes” or “No” if the category is visible in the platform. |
Date of the most recent modification in the platform |
Optional category id number. This is typically an external or SIS-linked id number. |
Hierarchical path of categories that has been set for courses in the LMS |
Friendly name (everyday name) of a category unit used to group courses or subcategories |
The unique identifier of a term or semester as defined in the connected platform |
The name of the term, a set period of time often used to organize courses, as defined on the connected platform |
A unique, visible identifying code given to the term within the connected platform |
Date when the term begins, as defined in the connected platform |
Date of the end of the term, as defined in the connected platform |
Unique ID for the browser used |
Friendly name (everyday name) for the browser used (ie: Firefox, Safari, or Chrome) |
Unique ID for the operating system |
Friendly name (everyday name) for the operating system (ie: Windows, ChromeOS, or MacOS) |
Displays the status of the learner submission as “New,” “Draft,” “Submitted,” “Graded,” or “Reopened” |
Date of last assignment submitted in course |
Date the activity was submitted |
The type of submission the activity is. Examples include: Online text entry, discussion topic, and online upload. |
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.” |
Unique ID for the LTI Tool |
Friendly name (everyday name) of the LTI tool |
URL of the LTI tool |
Status of the LTI tool, displays as either “Active” or “Inactive” |
Timestamp for when the LTI activity was created in the platform |
Displays the visibility of the user profile field, either “Visible” or “Not Visible” |
Format of the user profile field. Typically displays the name of the platform the profile field was created in. |
Unique ID of the cohort |
Friendly name (everyday name) for the cohort |
User-generated ID for the cohort. Typically matched with external systems such as an SIS. |
Status of the cohort, displays as “Active” or “Inactive” |
Timestamp for when the cohort was created. |
Timestamp for the most recent modification of the cohort. |
Status of the cohort group, displays as either “Active” or “Inactive” |
The total number of users enrolled in a section regardless of a role |
The level in the LMS the User has accessed. i.e. Course, Module, etc. |
The Internal ID number that is assigned by the LMS |
The number of visits to the course by the User |
Primary language of the User |
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. |
Displays the day of the week users are most active in the course. |
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. |
Time spent by User in specified time period of the day. |
Percent of total time spent by users on a specific day of the week compared to a full week. |
Progress of User on the LMS site in the course. Displays as a bar graph or a percentage of completion. |
Total number of activities user has completed. |
User’s status within the course. May display as either “Complete” or “Incomplete.” |
Total time User has spent on the LMS. |
Total time User has spent in all courses. |
Total time User has spent in all activities. |
User’s primary phone number |
Secondary phone number if available. |
Institution of User |
Department of User |
User’s street address |
User’s city/town of residence. |
User’s country of residence. |
Type of Degree User is pursuing. ie. PhD, Associate, Bachelor, High School, etc |
User’s self identified ethnic group if available |
User’s student status, Full Time or Part Time, if available |
User’s self identified gender, if available |
User’s assigned group |
Time stamp of the most recent log in to the LMS |
Time stamp of the most recent log out of the LMS |
Displays the percentage a User has used particular browsers. i.e. Firefox, Chrome, Safari, Edge, etc. |
Displays the percentage a User has used particular operating systems. i.e. Windows 10, Mac OS X, Linus, etc |
Displays the percentage a User has used particular devices. i.e. iPhone, iPad, Android, etc |
Total number of courses User is enrolled |
The authentication method by which the user was added to the LMS system |
The column stores data about whether the user's data was confirmed |
The column stores data about whether the user's activity was suspended |
The column stores data about whether the user's activity was deleted |
Date when User was modified in the LMS system |
The last time the user logged in using previously saved data. User is still logged on. |
Average of grades in all enrolled courses. |
Learner's current grade in course |
Displays if the user’s role has been changed, either yes or no. |
Displays the name of person who changed the user’s role, if it has been changed. |
Displays the previous role held by the user, if the role has been changed. |
Action taken in the role change. i.e. Assigned |
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. |
Click the “View” link to access the connected LMS |
Date the role change occurred. |
Shortened name for limited space needs |
Date an assignment, activity, or quiz was graded. |
Name of person who graded the assignment, activity, or quiz |
The total number of forums within a course. |
Total number of visits to forum(s) within a course |
Total amount of time users have spent on forums within a course |
Total number of posts within a course’s forum(s) |
Total number of discussions within a course’s forum(s) |
Total time user spent on a specific activity. |
A hyperlink to details of the activity and BBB attendance |
Total number of users with learner roles that have completed the course. |
Total number of users with learner roles that are enrolled in a course. |
Total number of Learner Events in a course |
Total number of visits by all users to a course. |
The percent of activities in a course that have been completed |
The average number of forum posts per day by learners in a course |
The average number of overall course visits per day by learners in a course |
Total number of workshops in a course |
Total number of any new activities added to a course after the course’s initial creation date. |
Total number of Assignments that have been completed in a course |
Total number of Assignments that have been submitted in a course |
Total number of Assignments that have been graded in a course |
Total number of all users enrolled in course, regardless of role. |
The method the user used to access the content. i.e. “web” |
Total Time a user has spent on the LMS dashboard |
The number of clicks (mouse clicks) made by instructor in a specific course |
Date of user’s first access to the LMS dashboard |
Date of user’s most recent access to the LMS dashboard |
The dashboard name and the particular item on this dashboard instructor has visited |
Name of person or role who enrolled user in course |
The total number of courses within a category. |
The sum total of posts made by the instructor in a forum. |
Number of learners who have engaged with the LMS system in the last 30 days |
The number of learners who have completed courses with the associated instructor (must be enabled in the LMS system) |
The average grade for all learners in all courses associated with the instructor |
Total number of users who have accessed the course, regardless of role |
Total number of users who have never accessed the course, regardless of role |
Total number of users who have completed the course |
Total number of instructors assigned to a course |
Total number of enrolled learners that have not yet completed the course |
Total number of enrolled learners that are overdue for course completion. |
Total number of learners who have accessed the course and completed at least 1 activity |
Total number of learners who have accessed the course but have not completed any activities |
Percent of Activities that have been viewed by the user as shown by a progress bar |
Percent of Modules that have been completed by the user as shown by a progress bar |
Percent of Assignments that have been completed by the user as shown by a progress bar |
Displays feedback from the course by the user |
Displays the date the user last downloaded anything from the course |
Total number of attempts users made in an activity, may be per user or for all users in a course dependent upon the report. |
The complete and descriptive name of the course outcome |
The condensed version of the full name, often used for brevity in reports, dashboards, or other interfaces where space is limited |
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. |
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). |
This represents the average level of achievement for the outcome across all students in the course. |
Total number of assignments, activities, etc that will be graded as part of the course |
The specific identifier or code assigned to each course outcome within an LMS or educational system. |
The Open LMS Outcome Component for the course |
Displays the minimum possible grade for the assignment or assessment. |
Displays the maximum possible grade for the assignment or assessment. |
The raw score or grade achieved by the user on the assignment or assessment before any adjustments or calculations. |
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. |
Amount paid by user for enrollment |
Type of currency used to pay for enrollment |
Total number of courses that were enrolled in using a specific enrollment method |
Total number of enrollments using a specific enrollment method |