This class is for final year apprentices who will, as journey workers, soon be responsible for passing on their skills to new apprentices.  Developed by the Bureau of Apprenticeship Standards, this 8-hour course teaches soon-to-be journey workers how to serve as a mentor and job coach, how to provide hands-on skill training, how to give positive and effective performance feedback, and explores the characteristics of a positive and diverse work environment. Please note that this is a Blackboard online course. If you are not a current/former student of Blackhawk Technical College you will receive login credentials 3-5 days before class starts.

Develop your understanding of how Excel uses logic with functions like AND, OR, COUNTIF, IF, and Nested IF. Perform calculations with SUMIF, AVERAGEIF, OR COUNTIF when a specific condition is met. Use VLOOKUP and XLOOKUP to search for specific information in a table. Find out how to name cells and ranges, and then use them in formulas. Learn how to link cells within worksheets and workbooks, and how to create 3D formulas across worksheets and workbooks. Locate errors by utilizing Auditing to find precedents and dependents related to a function. Enable the Watch Window to view out of sight cells. Use Data Validation to limit the type of data that can be entered into a cell and to create a drop-down list.

Get creative with metal and make unique holiday decorations in this hands-on welding course! Participants will learn basic welding techniques while creating festive Christmas-themed projects, including holiday décor and ornaments. Explore cutting, shaping, joining, and finishing techniques as you transform metal into one-of-a-kind pieces to decorate your home or give as gifts. No previous welding experience is required. Safety instruction and hands-on guidance will be provided. Come ready to get creative and make something special for the holiday season!

Celebrate the season by creating a variety of festive baked treats perfect for sharing with family and friends. In this hands-on class, participants will learn baking techniques, decorating tips, and creative presentation ideas while preparing a selection of holiday cookies, breads, pastries, or other seasonal favorites. Designed for bakers of all skill levels, this course provides practical skills and recipes to help participants bring homemade holiday traditions to their own kitchens.