CONTINUING EDUCATION

Digital Art Workshop with 4H Group

This Workshop is an Introduction to Art in the Fab Lab. Please bring an image, drawing or photograph to work with. We will be using software and the different equipment in the Fab Lab to make art. Please bring your own flash drive.

4th Grade and Up
Thursday, 11/7/19 5:00 pm - 6:30 pm
S.C. Johnson iMET Center
2320 Renaissance Blvd
Room 117

Digital Art Workshop with Bridgehomeschool Group

This Workshop is focused on laser and vinyl. We will have heat press vinyl available, but bring your own T shirt. Feel free to bring an image, drawing or photograph to work with. Please bring your own flash drive.

4th Grade and Up
Wednesday 11/13/19 1:00 pm - 3:00 pm
S.C. Johnson iMET Center
2320 Renaissance Blvd
Room 117

In the Look-up fucntions course, students will learn the use of the following functions:

• V-look up and H-look up fucntions
• Match and Index functions

Upon completion of this 2-hour course, students will be able to look-up and retrieve pieces of data from a dataset, combine data from 2 or more tables and classify/categorize data all through the use of look-up functions.

Instructor Arlene Roche
Wednesday, 11/20/19
12:30 pm - 2:30 pm
Room S239 - Elkhorn Campus

In the Pivot Table course, students will learn the following:

• creating and modifying PivotTables
• creating and modifying PivotCharts
• filtering data using timelines and slicers

Upon completion of this 2-hour course, student will be more efficient in analyzing and organizing data through PivotTables and PivotCharts.

Instructor Arlene Roche
Wednesday, 11/13/19
12:30 pm - 2:30 pm
Room S239 - Elkhorn Campus

In the MS Excel Macros course, students will learn the following:

• recording and saving macros for a variety of simple tasks
• performing basic edits of a macro
• debuging simple macro errors
• adding simple form controls to help run macros

Upon completion of this 4-hour course, students will better understand the purpose and function of macros. In addition, students will have a simple understanding of how macros are designed through coding.

Instructor Arlene Roche
Wednesday - 12:30 pm - 4:30 pm
Room S239 - Elkhorn Campus

In the MS Excel Macros course, students will learn the following:

• recording and saving macros for a variety of simple tasks
• performing basic edits of a macro
• debugging simple macro errors
• adding simple form controls to help run macros

Upon completion of this 4-hour course, students will better understand the purpose and function of macros. In addition, students will have a simple understanding of how macros are designed through coding.

Instructor Arlene Roche
Thursday - 8:00 am - 12:00 pm
Room 227 - iMET Center

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. You must be registered in both the Part A (623-497) and Part B (623-498) courses to participate.

Instructor Rick Lofy
623-497E-2W7A
Fridays, 12:00 pm - 4:00 pm

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. You must be registered in both the Part A (623-497) and Part B (623-498) courses to participate.

Instructor Rick Lofy
623-498E-2W7A
Fridays, 12:00 pm - 4:00 pm

This 12-week course is designed to take certified Green Belts to the Black Belt level. Participants will apply powerful problem solving tools and basic statistical techniques necessary for the Black Belt to lead strategic implementation of lean six sigma practices in the organization, as well as train and mentor black belts and green belts. This course blends on-line instruction with online modules and a work project with 6 hours of individual coaching.

Instructor Rick Lofy
623-817E-2W7A
Fridays, 10:00 am - Noon

In the Excel 1 course, students will learn the following:

• basic spreadsheet terminology and editing
• basic functions such as Sum, Average, Min, Max and Count
• basic spreadsheet formatting, such as changing font, alignment, number and cell styles
• basic charting tools
• basic page setup & printing options

This course is designed for an individual with some basic and general computer skills. Throughout the course, students will learn to be more efficient and use a variety of short-cuts.
Upon completion of this 8-hour course, students will be more efficient in creating, editing and navigating a basic spreadsheet as well as performing simple calculations.

Instructor Arlene Roche
Wednesdays - 11/13/19 & 11/20/19
8:00 am - 12:00 pm
Room S239 - Elkhorn Campus

In the Excel 1 course, students will learn the following:

• basic spreadsheet terminology and editing
• basic functions such as Sum, Average, Min, Max and Count
• basic spreadsheet formatting, such as changing font, alignment, number and cell styles
• basic charting tools
• basic page setup & printing options

This course is designed for an individual with some basic and general computer skills. Throughout the course, students will learn to be more efficient and use a variety of short-cuts.
Upon completion of this 8-hour course, students will be more efficient in creating, editing and navigating a basic spreadsheet as well as performing simple calculations.

Instructor Arlene Roche
Thursdays - 11/14/19 & 11/21/19
8:00 am - 12:00 pm
Room TBD - iMET Center

In the Excel 2 course, students will learn the following:

• functions to format text including Abs, Substitute, Upper, Lower, Trim, Concat, etc...
• calculations using absolute references and order of operation
• basic logical functions such as If, Sumif, Countif, etc…
• creation and purpose of named ranges
• basic statistical and date/time functions such as Small, Large, Rank, Now, Today, Days, etc…

Throughout the course, students will learn to be more efficient and use a variety of short-cuts.
Upon completion of this 8-hour course, students will be able to perform a variety of spreadsheet functions to be more efficient in formatting and analyzing data.

Instructor Arlene Roche
Wednesdays - 12/4/19 & 12/11/19
8:00 am - 12:00 pm
Room S239 - Elkhorn Campus

In the Excel 2 course, students will learn the following:

• functions to format text including Abs, Substitute, Upper, Lower, Trim, Concat, etc...
• calculations using absolute references and order of operation
• basic logical functions such as If, Sumif, Countif, etc…
• creation and purpose of named ranges
• basic statistical and date/time functions such as Small, Large, Rank, Now, Today, Days, etc…

Throughout the course, students will learn to be more efficient and use a variety of short-cuts.
Upon completion of this 8-hour course, students will be able to perform a variety of spreadsheet functions to be more efficient in formatting and analyzing data.

Instructor Arlene Roche
Thursdays - 12/5/19 & 12/12/19
8:00 am - 12:00 pm
Room TBD - iMET Center

In the PowerPoint Intermediate course, students will learn the following:

• insertion and format of a variety of objects, such as audio, video, SmartArt, hyperlinks, etc…
• slide organization with sections
• more advanced slideshow settings
• the customization of templates and master slides
• more advanced saving and printing options
• insertion and linking of MS Word outlines & tables
• linking MS Excel spreadsheets to a slide
• adding action buttons to the slideshow

This course is designed for an individual with some basic knowledge of using MS Power Point.
Upon completion of this 8-hour course, students will be more efficient in creating, editing and using professional looking presentations.

Instructor Arlene Roche
Wednesdays, 12:30 pm - 4:30 pm
Room 227 - iMET Center

In the Word Advanced course, students will learn the following:

• recording & running simple macros
• creating & using forms & controls
• using & saving templates

Upon completion of this 8-hour course, students will have learned some advanced concepts to help design profession-looking documents as well as be efficient users of MS Word.

Instructor Arlene Roche
Wednesdays - 8:00 am - 12:00 pm
Room 227 - iMET Center