Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Process in which a Compliance report (Excel Spreadsheet) is retrieved from the UTLearn Training Standard Reports system. Performed bi-monthly.
Table of Contents |
---|
Summary: Admin locates 4 Core Compliance Courses, runs progress summary for each course, consolidates data into one spreadsheet, and sends reports by email to Training Manager and Senior Data Analyst
Navigating to Reports on UTLearn
- Visit UTLearn LMS.
- On the homepage, hover over "Reports" - click "Standard Reports" in the drop-down.
In the new Reports screen, click "Training."
Near the bottom right of the screen (scroll-down) look for and click on "Training Progress Summary Pie Chart."
Entering Search Criteria
In the new screen, you are now prompted to enter several Criteria for the course you are looking for. First step is to enter the Date Criteria.
Info title Best Practice Select (left as-is) + From: (blank) + To: (Today's Date)
In "User Criteria," select "Legacy Division" and use the "Search" icon to open a new window. Find the Custodial Services Legacy Division with Search.
- Click the "Add" icon in the "Search Results." Click "Done." This will close the window and populate User Criteria.
- In "Advanced Criteria," go over the following sections to ensure accurate data is retrieved:
- Training Title - Search for CW 101, CW 121, CW 123, and CW 170 (Report is generated for EACH)
- Transcript Status - Tick the box
- Equivalent Training - Tick the box
- ILT Training - Must have radio button selected for "Events and Sessions."
Training Title must be searched. Use the "Search" tool to find the compliance course of your choice by entering the course number as a keyword search.
- Click "Add" icon from the Search Results. The window will close and the course title will populate in the "Training Title" field.
- Click "Search."
Exporting the Reports
- Scroll to the area under the pie chart "Export to Excel."
- Repeat search for all other core compliance reports
- Combine data from reports - be sure to leave out pie charts.
Send email to current Training Manager and Senior Data Analyst with attached spreadsheet of combined data.
Sample of completed merge (FY 2016-17)
Excel col 9 name Training_Progress_Summary_Pie_Chart_4_Core_170615.xls sheet Sample Compliance Report (Merged) row 16-22
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Page Properties | ||
---|---|---|
| ||
|
Info | ||
---|---|---|
| ||
The training tab in the Reports screen has a ton of useful reports that might help when locating specific and detailed transcript information. Explore these when you are requested to look for specific training that is tracked on UTLearn. |
Info | ||
---|---|---|
| ||
UTLearn times out if you are inactive for more than a few minutes. Simply refresh the page or visit another section of the site, then return to your original mission! |
Info | ||
---|---|---|
| ||
Custodial Services Department ID #: 4500007. Enter this number in the ID field to quickly find Facilities Services Custodial Services. Failure to identify the correct department will result in bad data. That is a mega no-no. |
Info | ||
---|---|---|
| ||
Keyword Searches: CW 101 - Introduction To The Compliance & Ethics Program. CW 121 - Sexual Misconduct Prevention. CW 123 - Equal Employment Opportunity (EEO). CW 170 - Information Security Awareness |
Info | ||
---|---|---|
| ||
Combining data from all four core reports helps the Data Analyst who will in the next step add crafts, date of hire, and job title. This information is turned into a data visualization that will assist trainers in compliance training set-up. |