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 system
Username
Friendly name for the user in the platform, typically the login name for the user and created by the organization
Full Name
User’s first and last name
Email 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 LMS
User Creation Date
Timestamp for when the user account was created in the LMS
Locale
Language code (such as “EN”) for the user’s preferred language
Country Code
Home country code of the user, such as AU or US
User SIS ID
An arbitrary ID code number, perhaps from the institution
First 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 Name
Last Name
User’s Last Name
User Status
User state in the system, displays as either Active or Inactive
Enrollment Category
Enrollment Role
User’s Role in course. (ie: Learner, Instructor, Designer, Observer)
Enrollment ID
Unique ID for the user enrollment
Last Activity Date
Timestamp for the last activity of the learner in the enrolled course
Last 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 course
Course Completion Met
Returns yes or no or the status of Complete or Incomplete to the question has the user completed the course
Number 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 requirements
Course Grade (Percent)
Course Grade displayed as a percentage out of 100
Course Grade (Points)
Course Grade displayed by points total
Instructor Course Role
Instructor Course Role - TBD
Learner Course Role
Learner Course Role - TBD
Course Role Name
Course Role Name - TBD
First Course Access
Date of user's first access to the course
Last Course Access
Date of user’s last access to the course
Course Grade Letter
Course Grade displayed by letter grade
Number of Modules/Course Sections required to complete the course
Total number of course modules or sections required to complete the course
Enrollments Need Complete Modules
Number of Modules Required to be completed in a course for a user
Enrollment Type
Unique ID for the type of Enrollment
Enrollment 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 enrollment
Enrollment 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 LMS
Enrollment Type Name
How the user enrolled in a course, such as “manual,” “cohort,” or via a 3rd party registration system such as IntelliCart
Enrollment Status
Displays the status of a learner’s enrollment: Active, Inactive, Deleted, or Completed
Enrollment Status Complete
Displays “yes” or “no” if an enrollment in a course has satisfied requirements for completion
Days Since Enrollment Last Course Access
The number of days since user last accessed the course
Enrollment Last Access
Date the user last accessed the course
Enrollment 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 system
Course SIS ID
The unique value automatically created for each course by the connected SIS data.
Course format such as weeks, topics, social, sites, etc.
Course Organization
The Organization associated with the course in the connected platform
Course 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 ID
Course Creation Date
Date for when the course was created in the LMS
Course Start Date
Date for the scheduled start of the course
Course End Date
Date for the scheduled end of the course
Visible Course
Displays “Yes” or “No” if the course is visible to students
Course URL
URL to the course in the LMS. This is an IntelliBoard generated field.
Instructor(s)
Instructor(s) for course
Instructor Email(s)
Email contact for the course Instructor(s)
Course Average Grade
Average grade of all learners in the course
Course Status
Displays whether the course is visible in the LMS as “Active” or “Inactive”
User(s) in Course
Total number of users in the course
Average Time Spent
Average amount of time spent per user in course
Average Participation
Average number of times users participated in the course
Average Course Grade
The average grade of students in the class, determined by taking the average of all current grades in the course
Active 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 system
Activity
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 course
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 created
Activity Due Date
Shows due date for activity if the activity is a quiz or assignment
Activity Expected Completion Date
Date for the expected activity completion date
Activity Object ID
Unique ID for the course module which contains the activity
Activities URL
URL for the activity. This is an IntelliBoard calculated field.
Activities Sort Order
TBD
Visible Activity
Displays “Yes” or “No” if the activity is visible to learners
Activities
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 completed
Activity Completion URL
TBD
Activity Completion ID
TBD
Activity Completion Status
Displays the completion status of an activity, such as “Complete Pass,” “Complete Fail,” or “Incomplete”
Course Module Activities Completions Status Name
TBD
Percent Completed Activities
The percentage of completed points in the course
Activity Types Category
Activity Type ID
Unique value automatically created for each activity type by the connected LMS system
Activity 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 quiz
Quiz Name
Friendly name (everyday name) for the quiz
Quiz Start Date
Date for when the quiz becomes available in the course
Quiz 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 created
Quiz 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 attempt
Quiz Attempt
Number of the quiz attempt (ie: a learner’s 2nd attempt)
Quiz Attempt Start Time
Timestamp for when the quiz attempt was started
Quiz Attempt Finish Time
Timestamp for when the quiz attempt was completed
Quiz Attempt Score
Score for the quiz attempt
Quiz Attempts Points
TBD
Quiz 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 question
Quiz Question Name
Name of the quiz question
Quiz Question Text
Text of the question
Quiz Question Max Points
Total number of points the learner can achieve with a correct answer
Quiz Question Types Name
TBD
Quiz Questions Types Type
TBD
Quiz Questions Answers Category
Quiz Question Answer ID
Quiz Question Answer Given by User
Quiz Question Score
Quiz Question Answers Points
Quiz Question Answers Original Question ID
Forums Category
Forum ID
Unique ID for the forum activity
Forum Name
Name of the forum activity
Forum Creation Date
Date of when the forum activity was created
Forum is an Announcement
Displays “Yes” or “No” if the forum activity is a course announcement
Forums
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 discussion
Forum Discussion Name
Name of the forum discussion/topic
Forum Discussion Last Post Date
Date of when the discussion post/topic was created
Forum Posts Category
Forum Post ID
Unique ID for the forum post as given by the LMS
Forum Post Text
Content of the discussion post
Forum 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 created
Forum Post Updated Date
Date of when the post/discussion was modified
Forum Post Status
Displays if the forum/discussion post is “Active,” “Inactive,” or “Deleted”
Pages Category
Page ID
Unique ID for the page
Page Name
Friendly name (everyday name) of the page
Page Creation Date
Date of when the page was created
Page Status
Displays “Yes” or “No” if the course page is visible to students
Pages
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 within
Assignment Name
Name of the assignment
Assignment Start Date
Date of when the assignment becomes available in the course
Assignment End Date
Date of when the assignment will no longer be available in the course
Assignment Due Date
Date of assignment’s due date
Assignment Creation Date
Date of when the assignment was created
Visible Assignment
Displays “Yes” or “No” if the assignment is the visible to learners
Assignment Submissions Aggregated Last Assignment Submissions Submitted At
TBD
Assignment Submissions Aggregated Last Assignment Submissions Grade Score
TBD
Assignment Submissions Aggregated Last Assignment Submissions Grade Point
TBD
Assignment Submissions Aggregated Last Assignment Submissions Grade Letter ID
TBD
Assignments
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 course
Assignments Submissions Category
Assignment Submission ID
Unique ID for the assignment submission record
Assignment Submission Date
Date of when the assignment was submitted
Assignment Submission Feedback
Text feedback or comments on the assignment submission
Assignment Submission Feedback Date
Date of when the submission feedback was created
Assignment Submission Score
Displays score of the assignment, if graded
Assignment Submissions URL
URL of the Assignment Submission
Last Assignment
Name of last Assignment activity that was submitted
Grade Category
Grade Object Max Grade
Maximum grade achievable on the grade object
Grade Object Name
Friendly name (everyday name) of the grade item
Grade Object is External
TBD
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
The raw number of points assigned by the grader to the submission
Grade Object Result Graded Date
Date of when the grade was entered
Grade Objects Results Grade Score
Number of points the learner achieved on the assignment
Grade Object Result Feedback
TBD
Grade Letter
Letter grade for an assignment or course
Grade 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 course
Grade 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 feedback
IP Address
IP Address the user accessed the LMS from
First Access Date
Date of the user’s first access of the LMS
Last Access Date
Date of the user’s most recent access of the LMS
Context 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 day
User Tracking by Day Time Spent
Total time a user spent on the platform by day
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
Count of user visits by hour of the day
User 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
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 context
Role
The name of a role that can be assigned to a user within a course or other context
Role Alias
An alternative name for the role assigned to a user within a course or other context
Categories Category
Course Category ID
A unique identifier of a category unit used to group courses or subcategories
Course Category Name
Friendly name (everyday name) of a category unit used to group courses or subcategories
Course Category Path
The location of a category unit within a structure used to group courses or subcategories
Course Category Sort Order
A parameter used to define how categories or organizational units will be sorted in a list
Course 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 platform
Course 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 LMS
Category
Friendly name (everyday name) of a category unit used to group courses or subcategories
Terms Category
Term ID
The unique identifier of a term or semester as defined in the connected platform
Term Name
The name of the term, a set period of time often used to organize courses, as defined on the connected platform
Term Code
A unique, visible identifying code given to the term within the connected platform
Term Start Date
Date when the term begins, as defined in the connected platform
Term End Date
Date of the end of the term, as defined in the connected platform
Term Status
TBD
Browsers Category
Browser ID
Unique ID for the browser used
Browser 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 system
Operating 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 course
Submitted At
Date the activity was submitted
Submission Type
The type of submission the activity is. Examples include: Online text entry, discussion topic, and online upload.
LTI ID
Unique ID for the LTI Tool
LTI name
Friendly name (everyday name) of the LTI tool
URL of the LTI tool
Status of the LTI tool, displays as either “Active” or “Inactive”
Time Created
Timestamp for when the LTI activity was created in the platform
Deprecated 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 category
Deprecated User Profile Fields
User Profile Fields ID
Unique ID for the user profile field
User 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
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 cohort
Cohorts Name
Friendly name (everyday name) for the cohort
Cohorts 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
TBD
Cohorts 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
TBD
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 role
Course 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 Totara
Visits
The number of visits to the course by the User
User Language
Primary language of the User
Course 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.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.
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 number
Phone 2
Secondary phone number if available.
Institution
Institution of User
Department
Department of User
Address
User’s street address
City/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, etc
Ethnic Group
User’s self identified ethnic group if available
Full Time/Part Time
User’s student status, Full Time or Part Time, if available
Gender
User’s self identified gender, if available
Group
User’s assigned group
Log In Time
Time stamp of the most recent log in to the LMS
Log Out Time
Time stamp of the most recent log out of the LMS
Browser 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, etc
Device Use Percentage
Displays the percentage a User has used particular devices. i.e. iPhone, iPad, Android, etc
Number of Courses
Total number of courses User is enrolled
Authentication Method
The authentication method by which the user was added to the LMS system
Confirmed
The column stores data about whether the user's data was confirmed
Suspended
The column stores data about whether the user's activity was suspended
Deleted
The column stores data about whether the user's activity was deleted
Modified
Date when User was modified in the LMS system
Current 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 course
Role 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. Assigned
Actions - 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 LMS
Date Role Was Changed
Date the role change occurred.
Short Name
Shortened name for limited space needs
Date Graded
Date an assignment, activity, or quiz was graded.
Graded By
Name of person who graded the assignment, activity, or quiz
Forum Total
The total number of forums within a course.
Forum Visits
Total number of visits to forum(s) within a course
Forum Time Spent
Total amount of time users have spent on forums within a course
Forum 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 attendance
Number 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 course
Number 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 completed
Average Learner Forum Post by Day
The average number of forum posts per day by learners in a course
Average Learner Course Visits by Day
The average number of overall course visits per day by learners in a course
Number of Workshops
Total number of workshops in a course
Number 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 course
Number of Submitted
Total number of Assignments that have been submitted in a course
Number of Grades
Total number of Assignments that have been graded in a course
Number 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 dashboard
Dashboard Visits (Total)
The number of clicks (mouse clicks) made by instructor in a specific course
First Access to Dashboard
Date of user’s first access to the LMS dashboard
Last Access to Dashboard
Date of user’s most recent access to the LMS dashboard
Instructor Dashboard Report/Item
The dashboard name and the particular item on this dashboard instructor has visited
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 days
Number 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 instructor
Number of Users Accessed Course
Total number of users who have accessed the course, regardless of role
Number of Users Who Never Accessed
Total number of users who have never accessed the course, regardless of role
Number of Users Completed
Total number of users who have completed the course
Number of Instructors
Total number of instructors assigned to a course
Number of Incomplete Learners
Total number of enrolled learners that have not yet completed the course
Number 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 activity
Number 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 activities
Activity Views
Percent of Activities that have been viewed by the user as shown by a progress bar
Percent of Completed Modules
Percent of Modules that have been completed by the user as shown by a progress bar
Assignments Percent Completed
Percent of Assignments that have been completed by the user as shown by a progress bar
Course (Feedback)
Displays feedback from the course by the user
Last Downloaded from this Course
Displays the date the user last downloaded anything from the course
Course Outcomes
Outcome Full Name
The complete and descriptive name of the course outcome
Outcome Short Name
The condensed version of the full name, often used for brevity in reports, dashboards, or other interfaces where space is limited
Outcome 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 courseThe specific identifier or code assigned to each course outcome within an LMS or educational system.
Component
The Open LMS Outcome Component for the course
0 Comments