The Course Enrollment Totals Report (aka CET Report) has almost all the data you would ever need regarding the learners in your university and their enrollments and completions. This is a powerful report with many ways to organize data.
NOTE: Keep in mind sometimes there may be issues with Excel trying to open very large reports. You may need to filter your data by date, course or groups to reduce it to a manageable size.
To access the Course Enrollment Totals Report go to Admin > Analytics > Training Reports > Course Enrollment Totals
Report Types: There are three types of reports you can run: Summary, Detail, and Logs. Use the Summary report type to get a summary of total enrollments, completions, and percentage complete numbers for each course. Use the Detail report type to get a detailed report of all individual user data for each course. Use the Logs report to see the enrollment/un-enrollments and completions of users in courses.
Report Criteria: There are two types of report criteria to select from: Enrollments and Completions.
Enrollments = All users enrolled but not completed course(s)
Completions = All users who have completed course(s)
Date Range: Select the date range for your report. Date Range is only supported with the Run Summary and Run Detail Report options, NOT Scheduled Report options. If you are setting up a Scheduled Report, skip the Date Range section and instead select the frequency of your report (e.g. daily, weekly, monthly, etc…) on the second screen that displays when you are saving your settings.
NOTE: The date range corresponds to the report criteria. If you are running for Enrollments, the date range is pulling the date enrolled in the course. If you are running for Completions, the date range is pulling the date the user completed the course.
User: Filter your report by selecting All Current Users if you want your report to display only the users that are currently in your university. Otherwise, select All Users (including removed) to display every user that has ever been enrolled in a course in your university. Choose Certain Groups if you want to run a report only for specific groups.
Categories: Filter your report by selecting a category of courses for this report. Use caution when choosing the Select All option, as this can be a very large report as it will be running a report for every learner who has enrolled and for every course in your university.
Choose Course: In addition to course categories, you can further filter your report to choose a specific course or all courses listed in the drop down.
Choose Schedule: This option displays only for courses that have associated schedules. You may choose to run a report for a specific schedule or all schedules associated with that course.
Show Students (Detail Report Only): This will include all users who have enrolled in a course, including users that are not in your university. This is helpful if you have shared courses in your university.
Report Columns (Detail Report Only): Use Select All to display all column data for display on this report. Otherwise, select Certain Report Columns to choose which columns you would like to display on this report.
Assessment Options (Detail Report Only): Use the Assessment check boxes to include assessment data in your reports. Use this option with caution as this data can result in very large files. You may reduce your file size by limiting the group of people or number of courses included.
Schedule or Run a Report
Determine if you need this report frequently (schedule) or on demand (run).
Schedule a Report
Whether you want to run a Summary or a Detailed Course Enrollment Totals report, you have an option to schedule those reports to run on a regular basis. For details, see Scheduling Recurring Reports.
Run Summary or Detail Report
If you need a detailed report immediately, the Run Detail Report button is available and will download the report immediately. You can select specific columns to display on your detailed Course Enrollment Totals reports. After you select the Certain Report Columns option all the columns available for your report display. You can select which columns are most beneficial for this report.
CAUTION: Detail reports may be quite large. Large file downloads can cause the BlueVolt system to run slower than optimal. Additionally, you may experience problems with timeouts. Some files may be so large that after it is downloaded, the report cannot open in Excel (due to limitations of Excel).
TIP: For large reports which may cause performance issues outlined above, try breaking up the report by running for smaller date ranges or groups of courses. You can use excel to merge the resulting reports.
Export to CSV
If you want to further manipulate your data and/or use additional formatting, or if your report is large and you are having problems opening it with Excel, you can download the report using one of three file types which can be selected from the drop-down menu next to the Run Summary Report button. Once you've downloaded the report, you can open the file, break it up to get in Excel, or drop into Excel and begin manipulating and formatting the data.
Please sign in to leave a comment.