Course Enrollment Totals Report
The Course Enrollment Totals Report has almost all the data you would ever need regarding the learners in your university and their enrollments and completions.
NOTE: Keep in mind that sometimes there can 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 (aka CET Report):
- Go to the Admin side of your university
- Select Reports > Course Enrollment Totals
Understanding your report options:
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/unenrollments and completions of users in courses.
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)
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.
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.
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.
In addition to course categories, you can further filter your report to choose a specific course or all courses listed in the drop down.
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
Scheduling 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. You will receive an email with a link to download your scheduled reports. Currently, there are four options for scheduled report frequency:
- Daily = previous day's data
- Weekly = previous 7 days' data (This option allows you to choose which day of the week to deliver the report. The day will be for 7 days preceding the delivery date.)
- Monthly = previous month's date
- Once = date range of your choice and will be delivered within an hour
NOTE: Scheduled Reports cannot be changed. If you decide to change the information contained in the report or the frequency it is run, you will need to create a new scheduled report and delete the old one.
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 displays. You can select which columns are most beneficial for this report. After you have figured out all your settings, ask yourself, "Will I need this report frequently?".
If the answer is:
- "Yes!" - Use the Scheduled Report button and select your frequency.
- "No!" - Use the Run Detail Now button.
- "Maybe!" - Select the Save Settings check box and Run Detail Now
Once you have named your saved report, you can run the detailed report. The report will display on your screen first. You can download the report, if needed, to Excel, PDF, or Word by clicking the Export icon.
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).
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.
NOTE: To locate reports you have scheduled or saved settings, go to: Reports > My Reports. There you can locate the report under the name you saved it as and choose to run it again as needed. You will also find a list of any scheduled reports under My Reports.