Summary
This guide explains how to access, create, and customize the Activity by Courses Report, including template configuration, generation options, and practical use cases for tracking course activity across in progress, viewed, and passed states within a selected date range.
Introduction
The Activity by Courses Report shows all courses that were in progress, viewed, or passed within a selected date range for selected groups. Whether you need to monitor overall course engagement, track which learners are actively working on content, or identify completed courses, this report delivers a complete picture of course activity. For a complete overview of the Reports section, refer to Reports: An Overview of the Reports Section in LMS.
Steps to Follow
How to Create a Custom Activity by Courses Report Template
The Report Generation tab contains predefined templates that come with your KnowledgeCity LMS, along with any custom templates you have previously created. If the default Activity by Courses template meets your needs, you can run it directly. To create a new custom template with specific fields and settings, follow the steps below.
Navigate to Reports > New Report Template.
From the Report type dropdown, select Activity by courses.
When you select Activity by Courses as the report type, the system automatically populates default fields, along with default template name, language, description, and title style, all of which you can customize to suit your needs.
Configure your template:
Field | Description |
|---|---|
Template name | Specify a unique name (e.g., "Q1 Activity Report by Department") |
Template language | Select the preferred language for report output |
Description | Provide a brief description (up to 500 characters) to clarify the report's purpose |
Title style | Format the report title using bold, italic, underline, font size, alignment, and title text and background color options |
Include portal logo | Toggle to add your portal logo to the report output |
Default Fields in This Report
Group: The user group(s) the user belongs to.
User Name: The user's unique login identifier.
Date of Birth: The user's birth date.
Last Login Time: Timestamp of the user's most recent login.
License Status: Current status of the user's license (activated, assigned, expired).
Course ID: Unique identifier for the course in the LMS.
Course Name: Official name of the course.
Begin: Date when the user started the course.
Begin time: Time when the user began the course session.
Watched: Date when the user fully viewed all course content.
Watched time: Time when the user completed viewing all course content.
Passed: Date when the user successfully passed the course.
Passed time: Time when the user met the criteria to pass.
Course status: Current status: Not Started, In Progress, Viewed, or Passed.
Score: Score achieved on the certification quiz.
Certificate: Unique certificate number issued upon course completion.
You can modify these defaults or add additional fields to tailor the report to your requirements. For detailed descriptions of all available fields, refer to Report Fields: A Complete Reference Guide for All Reports.
Customize columns using the rows adjustment section:
Click Add column to include additional fields.
Drag and drop columns to reorder if required.
Click the Edit button on any column to format, style, or add conditional rules.
Click the Delete button to remove columns.
For detailed instructions on managing columns, refer to Report Templates: How to Manage Columns with Rows Adjustment and Formatting.
Click Save template.
How to Generate the Activity by Courses Report
Navigate to Reports > Report Generation.
Locate your newly created Activity by Courses report template.
Click Run report.
The Run report button opens a configuration window where you can set the following parameters before generating the report:
Option | Description |
|---|---|
Group | Select which user group to include or All groups |
Time Zone | Choose the time zone for date calculations |
Date start / Date end | Set the reporting period for course activity |
Include Passed courses | Toggle to include courses that users have already passed |
Include archived courses | Toggle to include courses no longer active |
Click Create and proceed to the Reports tab, locate your report on the top of the list and click the Download button to export.
Example Use Cases
Monitor overall course engagement: Generate a report for a specific group and date range to see which courses are in progress, viewed, or passed. Use this to get a complete picture of learner activity across all statuses.
Track completion trends: Filter by passed status to identify which courses have the highest completion rates and which learners are successfully finishing their training.
Conclusion
You have successfully learned how to generate and customize the Activity by Courses Report. This report provides a complete view of course activity by tracking courses that are in progress, viewed, or passed within a selected date range. By creating custom templates with the fields that matter most, you can efficiently monitor learner engagement and identify both active and inactive learners.