This workbook investigates the time utilization and success rate of training classes.
To calculate the time utilization of the training classes, the report divides the total number of students confirmed in the class by the maximum number of students allowed to enroll in the class.
To calculate the success rate of the training class the report divides the total number of successful students by the total number of students confirmed in the class.
This workbook includes the following worksheets:
By Sponsoring Organization
By Sponsor Organization and Year
By Training Course
By Training Course and Year
By Training Center
By Training Center and Year
By Training Category
By Training Category and Year
By Competence
By Competence and Year
The workbook uses the following calculations:
Success Rate
Success rate is calculated as a number of successful training hours delivered to external students divided by the total number of training hours delivered to external students, where:
The number of successful training hours per class is the number of successful external students enrolled, multiplied by the class duration.
The total number of training hours delivered to external students for a class is the total number of external students enrolled in the class, multiplied by the class duration in days.
Successful Hours
This calculation is based on the number of Training Hours multiplied by the number of successful students.
Utilization
This calculation is based on the Training Hours Delivered divided by the Training Hours Offered.
Hours Delivered
This calculation is based on the number of training hours required by the class multiplied by the number of enrolled students.
Hours Offered
This calculation is based on the number of training hours required by the class multiplied by the maximum number of attendees.
These worksheets use classes to calculate success. For a class to be included it must:
Have an end date prior to the present date.
Have a status of Normal or Closed, if the class is scheduled.
Not be Cancelled.
The hours of a class are calculated using a predefined Oracle FastFormula. Depending on how you record the duration of classes, you may need to customize this formula. See Setting Up and Customizing Training Hours
In addition to displaying information you have set up in OLM and HRMS, the Training Success workbook calculates the following:
Hours Offered
The total number of training hours for all relevant classes multiplied by the number of places available in all relevant classes.
Hours Delivered
The total number of training hours of all the relevant classes multiplied by the number of places filled by students in these classes.
Hours Received
The total number of training hours employees have attended for all relevant training classes.
Successful Hours
If a student is recorded as successfully having attended the class, then the employee's hours for this class are recorded as successful hours.
In the workbook, the successful hours are the total number of successful hours for all relevant classes.
Utilization %
The total hours delivered as a percentage of the hours offered. For example, if 5 hours were delivered, and 10 hours were offered, then the utilization percentage would be 50%.
Success Rate %
Successful hours delivered as a percentage of the total hours delivered. For example, if 10 hours were delivered, and 8 hours were successful, the success rate would be 80%.
This worksheet enables you to investigate the training success rate of training classes for different sponsoring organizations.
What is the training utilization rate by sponsoring organization for a year?
What is the training success rate by sponsoring organization for a year?
This worksheet has no parameters.
This worksheet enables you to investigate the training success rate of training classes for a sponsoring organization for each year.
What is the training utilization rate for a sponsoring organization by year?
What is the training success rate by sponsoring organization by year?
This worksheet has no parameters.
This worksheet enables you to investigate the success rate of different training courses. You can investigate courses by year and sponsoring organization.
What is the training utilization rate by training course for a year?
What is the training success rate by training course for a year?
This worksheet has no parameters.
This worksheet enables you to investigate the success rate of courses each year. You can investigate courses by business group and course.
What is the training utilization rate for a training course by year?
What is the training success rate for a training course by year?
This worksheet has no parameters.
This worksheet enables you to investigate the training success rate of different training centers, by business group and year.
What is the training utilization rate by training center for a class year?
What is the training success rate by training center for a class year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the training success rate of a training center over a number of years. You can analyze success by business group and training center.
What is the training utilization rate for a training center by training year
What is the training success rate for a training center by training year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the training success rate of classes by training category. You can investigate different training categories for a business group and year.
What is the training utilization rate by training category for a training year?
What is the training success rate by training category for a training year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the training success rate of a training class in different years. You can analyze training success for a business group and training category.
What is the training utilization rate for a training category by year?
What is the training success rate for a training category by year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the success rate of a training course by competencies. You can investigate competencies for a sponsoring organization and year.
What is the training utilization rate by training competency for a class year?
What is the training success rate by training competency for a class year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the training success rate of training activities for a competence over a number of years. You can investigate a competence for each sponsoring organization.
What is the training utilization rate for a training competence by class year?
What is the training success rate for a training competence by class year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center