This is the first course in a sequence that develops foundational skills in the use of Microsoft Office Excel features to efficiently and effectively produce business spreadsheets. Students will apply Microsoft Excel skills to solve practical problems in a project-based format. Activities will work on creating a spreadsheet, incorporate appropriate formulas and functions to report accurate data, and chart results. Recommended computer foundations: Windows competency, including solid file management skills; basic math fundamentals. This course will use Microsoft Office 2019 or Office 365.
Students will learn to use MS Excel. Credit B activities will include using advanced features of formulas, object linking and embedding, multiple worksheets, 3-D references, macro basics and database basics. COREQUISITE: 10103151 MS Excel A.
In Human Resource Management, the learner applies the skills and tools necessary to effectively value and apply employees' abilities and needs to organization goals. Each learner will demonstrate the application of the supervisor's role in contemporary human resources management, impacts of EEOC, writing job descriptions, recruitment, selection, conducting job interviews, orientation, developing policies and procedures, training, performance management, employee counseling and development, and effective use of compensation and benefit strategies. It is recommended that the learner have experience using a PC/MAC, using the MS Windows operating systems and software suite, browsing Web pages, downloading files, using e-mail, and exchanging files prior to enrolling in this course.
In keeping in line with electronic recordkeeping, human resources and payroll have followed suit. Tracking employee information and payroll transactions is handled efficiently and securely using human resources information systems and payroll software. The learner will come to understand how this type of software works. Payroll calculation will be highly emphasized taking into account all the federal and state laws and filing requirements.
Compensation encompasses the remuneration issues of employment. It will cover all aspects of wage and salary administration including job design, job analysis, pay range development, salary surveys, bonus programs, state and federal compensation law and performance management in regards to pay practices. PREREQUISITE: 10116100 Human Resource Management.
Getting the right employees in the right job is really an art. Learn the methods of recruitment used to attract employees to your organization. Once recruitment takes place, then selection of the most suitable candidate for an opening takes place. This process is highly governed by state and federal law which must be learned and used as the basis for lawful selection of employees. PREREQUISITE: 10116100 Human Resource Management.
The course provides students with both the common and complex issues related to human behavior in the workplace as it relates to employee relations, state and federal mandates and laws. In-depth examination of relationships among workers, management, laws and government are the major focus of this course. PREREQUISITE: 10116100 Human Resource Management.
The onboarding and training course prepares participants to be able to orient, train and take new hires through the onboarding process so they have the greatest opportunity to be successful, productive employees in the workplace. Key topics are: training and development, delivery techniques, assessing employee strengths, and methods to determine where employees may focus talent improvement processes. Course will also explore the value of engaging in company culture including techniques for success within that culture. PREREQUISITE: 10116100 Human Resource Management.
With the ever changing health care laws, this benefits course will address the evolution of benefit offerings in health insurance as well as the other benefit areas. Taking the total reward approach, other topics to be covered include dental insurance, disability insurance, paid time off, government mandated benefits and optional work arrangements. PREREQUISITE: 10116100 Human Resource Management.
This course examines customer service as it relates to organizational quality. It addresses service models for internal and external customers, systems and strategies applied to customer service, and tools and techniques for gathering customer feedback and handling complaints.
In Conflict Resolution and Confrontation Skills the learner applies the skills and tools necessary to deal with conflict and confrontation in the workplace. The learner will identify the major causes of conflict, develop a working plan of action to confront difficult situations, and establish guidelines for gaining resolution to difficult situations. The learner will build greater personal skill and confidence in their ability to deal with conflict in their personal and professional life.
This course integrates algebraic concepts, proportions, percents, simple interest, compound interest, annuities, and basic statistics with business/consumer scenarios. It also applies math concepts to the purchasing/buying and selling processes. Emphasis is placed on the use of complex formulas for sinking funds and for present/future value and payments in both the accumulation and distribution phases of an annuity as well as to the development of formulas for business scenarios such as finding effective interest rates and finding the proceeds of a third-party discount.
Total: 27 Credits
Choose a campus to view contact information, or for general assistance, please contact us.