CONTINUING EDUCATION

Read more

In this course, learners build on intermediate Microsoft Access skills. They investigate complex reports, switchboards, macros, mail merge and data normalization. Upon successful completion of the course, learners will be able to apply advanced concepts to useful database design and to skillfully analyze database content and design using a variety of database tools.

 

Instructor Arlene Roche
Tuesdays, 5/11/21 & 5/18/21
4:00 pm - 8:00 pm
Room 267 - iMET Center

Hide

Read more

In this course, learners build on basic Microsoft Access database skills. They examine data validation, database relationships, and the design and purpose of more complex queries and forms. Learners practice using calculations in tables, queries, and forms. Upon completion of this course, learners will be able to build a report using conditional formatting, build a navigation form to help users find their way around a database, and present data using basic macros to automate common tasks.

 

Instructor Arlene Roche
Tuesdays, 4/27/21 & 5/4/21
4:00 pm - 8:00 pm
Room 261 - iMET Center

Hide

Read more

Learners in this course will assess their own communication skills and hone their abilities to express themselves effectively and respectfully.

 

Instructor will contact you with Zoom meeting information.

 

Instructor Liz Oplatka
Wednesday, 4/21/21
6:00 pm - 10:00 pm
Zoom Only

Hide

Read more

Learners in this course will assess their own communication skills and hone their abilities to express themselves effectively and respectfully.

 

Instructor will contact you with Zoom meeting information.

 

Instructor Liz Oplatka
Wednesday, 5/5/21
8:00 am - 12:00 pm
Zoom Only

Hide

Read more

In this course, learners explore basic features of Microsoft Excel. They examine spreadsheet terminology and editing. Learners explore Excel formatting functions and the features to create simple charts. Learners practice using spreadsheet printing options, page setup options, and a variety of shortcut techniques. Upon completion of the course, learners will be able to create, edit, and navigate a basic spreadsheet and create simple charts associated with a spreadsheet.

 

Instructor Arlene Roche
Thursdays, 5/6/21 & 5/13/21
4:00 pm - 8:00 pm
Room A216 - Kenosha Campus

Hide

Read more

In this course, learners build on basic Microsoft Excel skills. They examine advanced text formatting options. Learners investigate order of operations, differentiate between absolute and relative references, and practice using formulas and functions to perform calculations. Learners explore basic Excel functions (logical, date and time, statistical) used to analyze and manipulate data. Upon completion of the course, learners will be able to perform a variety of intermediate level spreadsheet functions to format, manipulate, and analyze data.

 

Instructor Arlene Roche
Wednesdays, 4/28/21 & 5/5/21
8:00 am - 12:00 pm
Room 110 - Burlington Campus

Hide

Read more

In this course, learners build on intermediate level Microsoft Excel skills. They explore the purpose and function of three-dimensional (3D) and external references. Learners apply sorting, filtering, grouping, and subtotaling features to spreadsheet data and its validation. They examine more advanced logical functions used to test for the presence of and various combinations of data (if, and, or). Learners consider special formatting features that enhance tables and charts. Upon completion of the course, learners will be able to analyze, manipulate, organize, and visualize data.

 

Instructor Arlene Roche
Wednesdays, 5/12/21 & 5/19/21
8:00 am - 12:00 pm
Room 110 - Burlington Campus

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to investigate the process of finding specific values within a data set. They examine Excel's lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE) and practice applying them to specific scenarios. The simplicity and flexibility of Excel's XLOOKUP function is presented. Upon completion of the course, learners will be able to use reference functions to search for specific information in a data set and use it to retrieve, combine, and categorize data.

 

Instructor Arlene Roche
Wednesday, 6/2/21
10:30 am - 12:30 pm
Room 110 - Burlington Campus

Hide

Read more

In this course, learners use advanced Microsoft Excel skills to analyze complex data. They examine how to build PivotTables that summarize large data sets and how to apply conditional formatting and filtering to the PivotTables they create. Learners investigate how to create a visual representation (PivotChart) of a PivotTable , and they explore the relationship between them. Upon completion of the course, learners will be able to summarize, visualize, and analyze complex data and present it in an effective and efficient, interactive visual format to meet the needs of business planners.

 

Instructor Arlene Roche
Wednesday, 6/2/21
8:00 am - 10:00 am
Room 110 - Burlington Campus
 

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to automate a task or set of tasks. Using Visual Basic for Applications (VBA) available in Excel, learners develop custom actions designed to streamline data and spreadsheet-related tasks. They practice planning, recording, editing, running, debugging, and saving a macro of their creation. Upon completion of the course, learners will be able to design, create, edit, and save custom actions that enhance the efficiency of spreadsheet tasks.

 

Instructor Arlene Roche
Wednesday, 6/9/21
8:00 am - 12:00 pm
Room 110 - Burlington Campus

Hide

Read more

This four hour workshop trains participants in the use of the Dremel 3D printers, Epilog Laser Engraver and Roland GX24 Vinyl Cutter. This workshop meets the Lab requirements for you to operate the equipment when using the Lab. There is some informational background given on Fab Lab, but the focus is training. Limit 10 Participants, four Participant Minimum.

 

Pandemic Requirements
You are required to wear a mask while on any Gateway Campus. Gateway also requires you to social distance whenever possible. There will be hand sanitizer, and visual aids for Social Distancing available.

 

Wednesday, March 5, 2021
5:30 PM - 9:30 PM
S.C. Johnson iMET Center
2320 Renaissance Blvd
Room 117

 

*Veterans & Gateway Students/Alumni, Contact the Fab Lab 262-564-2677 for a discount code before registering for this workshop!

Hide

Read more

In this course, learners investigate the function and components of Microsoft Windows-based personal computers. They differentiate hardware and software and identify common hardware parts and devices. Learners navigate within the Microsoft Windows environment. They perform common file and folder management tasks using File Explorer. Learners explore connectivity between personal computers and the Internet, analyze the function of a web browser, and compose a professional email message using current email applications. Upon completion of the course, learners will be able to use Microsoft Windows to perform everyday tasks, communicate with others, and maximize efficiency in the workplace.

 

Instructor Arlene Roche
Tuesdays, 5/4/21 & 5/11/21
8:00 am - 12:00 pm
Room A216 - Kenosha Campus

Hide

Read more

This 12-week course is designed to introduce participants to the essentials of Lean Operations. Lean training is one of the most valuable skills in business today. Businesses of all types are utilizing lean principles as the primary continuous improvement methodology. Lean changes businesses through techniques that create proven results that translate directly to the bottom-line. Blending on-line instruction with online modules, and a work project with 3 hours of individual coaching.

 

Instructor Rick Lofy
623-812E-1WDB
Mondays, 5/3/21 - 8/2/21
8:00 am - 10:00 am

Hide

Read more

This 12-week course is designed to certify participants with Lean Six Sigma Green Belt credentials. Lean Six Sigma is the standard for world-class quality based on continuous improvement through identifying and eliminating waste. Blending on-line instruction with online modules and a work project with 6 hours of individual coaching. The first half of this course (623-497) is comprised of Lean enterprise and Six Sigma organizational structure, and the elements of define and measure in the DMAIC process. The second half of the course (623-428) will cover the Analyze, Improve, and Control elements of the DMAIC Process with report outs of individual workplace improvement projects.

 

Corequisite: You must be registered in both the Part A (623-497) and Part B (623-498) courses to participate.

 

Instructor Rick Lofy
623-497E-1WDB
Mondays, 5/3/21 - 8/2/21
12:00 PM - 2:00 PM

Hide

Read more

This 12-week course is designed to certify participants with Lean Six Sigma Green Belt credentials. Lean Six Sigma is the standard for world-class quality based on continuous improvement through identifying and eliminating waste. Blending on-line instruction with online modules and a work project with 6 hours of individual coaching. The first half of this course (623-497) is comprised of Lean enterprise and Six Sigma organizational structure, and the elements of define and measure in the DMAIC process. The second half of the course (623-428) will cover the Analyze, Improve, and Control elements of the DMAIC Process with report outs of individual workplace improvement projects.

 

Corequisite: You must be registered in both the Part A (623-497) and Part B (623-498) courses to participate.

 

Instructor Rick Lofy
623-498E-1WDB
Mondays, 5/3/21 - 8/2/21
2:00 pm - 4:00 pm

Hide