CONTINUING EDUCATION

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

• V-look up and H-look up functions
• 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
Thursday -10:30 am - 12:30 pm
Room 227 - iMET Center

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
Thursday - 8:00 am - 10:00 am
Room 227 - iMET Center

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

In the PC Basics course, students will learn the following:

• identify, define and use common computer hardware devices (i.e. keyboard, mouse, Flash drive, etc..)
• navigate in Microsoft Windows and manage applications windows
• manage folders and files in File Explorer
• save and share files in numerous types and locations
• compose a professional email message

Upon completion of this 8-hour course, students will have learned some very basic and useful concepts to better understanding how computers operate. Students will be more efficient in navigation and organization of files, folders and applications. In addition, students will be able to better communicate via email in a professional manner.

Instructor Arlene Roche
Wednesdays - 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-427) 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.

Section Number: 623-498E-1W7A

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.

Section Number: 623-817E-1W7A

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

Access Advanced – In the Access Advanced course, students will learn the following:

• design and purpose of more complex reports
• outlines and calculations on reports
• design and purpose of switchboards
• macro recording of simple tasks
• mail merging options
• data normalization

Upon completion of this 8-hour course, students will have learned some advanced concepts to help design useful databases in MS Access as well as better analyze data through a variety of database tools.

Instructor Arlene Roche
Thursdays - 10/17/19 1:00 pm - 5:00 pm
10/24/19 12:30 pm - 4:30 pm
Room 227 - iMET Center

In the Access Beginning course, students will learn the following:

• basic database management terminology and editing
• basic data entry rules
• design and creation of tables, including data entry of fields & records
• basic sorts, filters and calculations on data
• design and purpose of simple queries, forms, and reports

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 efficient in creating, navigating and editing a simple database.

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

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

• data validation and restriction on fields and records
• database relationships including joining tables & queries
• design and purpose of subdatasheets
• object dependencies and object navigation tools
• design and purpose of more complex queries
• design and purpose of more complex forms
• calculations in many objects including tables, queries and forms

Upon completion of this 8-hour course, students will be more efficient in analyzing data and restricting data as well as better understand relationships among database objects.

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

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

• purpose and functionality of 3D and external references
• grouping and subtotals
• sorting and applying filters on data
• data validation and restriction
• some logical functions such as AND, OR, nested IF functions and more
• special formatting such as table styles and sparklines
• paste special options

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 better navigate and create relationships in larger and multiple worksheets. In addition, students will be able to better analyze and organize large amounts of data as well as be able to set data entry restrictions.

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

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 - 9/5/19 12:00 pm - 4:00 pm & 9/12/19 8:00 am - 12:00 pm
Room 227 - 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
Thursdays - 8:00 am - 12:00 pm
Room 227 - iMET Center