Summary
This guide explains how to access, create, and customize the Passed Courses Report, including template configuration, generation options, and practical use cases for tracking course completion rates and learner success.
Introduction
The Passed Courses Report shows all courses that selected users passed during a selected date range. This includes certificate information and scores achieved on certification quizzes, giving you a complete picture of course completion success. Whether you need to track training completion rates, identify learners who have successfully finished required courses, or analyze quiz performance, this report delivers the data you need. 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 Passed 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 Passed 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 Passed courses.
When you select Passed 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 Passed Courses 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.
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.
Certificate: Unique certificate number issued upon course completion.
Score: Score achieved on the certification quiz.
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 Passed Courses Report
Navigate to Reports > Report Generation.
Locate your newly created Passed 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 the 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
Track completion rates: Generate a report for a specific group and date range to see which learners have successfully passed their assigned courses. Use this to measure training effectiveness and completion rates.
Monitor quiz performance: Review the Score column to identify learners who passed with high scores versus those who barely passed. This helps identify learners who may need additional support or refresher training.
Conclusion
You have successfully learned how to generate and customize the Passed Courses Report. This report provides valuable insights into course completion success by tracking which courses learners have passed, along with certificate numbers and quiz scores. By creating custom templates with the fields that matter most, you can efficiently monitor training completion rates and maintain compliance records.