This course covers basic skills including basic parts of an Excel window, formatting, alignment, indenting, merging cells; creating a simple spreadsheet with formulas, functions, format painter, absolute reference, freezing columns and rows, split windows, copy & paste, paste special, using multiple windows of the same file, printing options, creating charts and graphs, non-adjacent cells, and mail merges.

Excel Level 1 is a great introductory class for those who are starting their Excel journey or would like to know more. Participants should already know how to find a file given a path, have basic math skills, know how to use a mouse and keyboard. Objectives in Level 1 are formatting, inputting data, creating formulas and functions, format painter, absolute reference, viewing and printing options, comments/notes, creating a template and how to use an Excel database to create a mail merge using Word.

Learn basic programming, maintenance and trouble-shooting PLC based industrial controls using PLC trainers with Allen Bradley/ Rockwell Automation Control-Logix hardware and Allen Bradley/Rockwell Automation RSLogix 5000 and RSLinx software. This will allow you to benefit from vendor training on specific equipment. The central processing unit is an L36 ERM. The basic operating principles of all PLCs, their inputs and outputs (discrete and analog), programming, maintenance, and networking will be covered. Hands on approach to Factory Talk View is also included.

Ken Walsh

Ken Walsh started his career as an Electrical Engineer developing automated sawmill equipment. Ken worked for Rockwell Automation for Nearly 20 years as a field support engineer.

• Experience in Automation Systems, software, System Design, Pneumatics, Electric Motor Drives, Panel Design, logic controllers, HMI project management, startup, troubleshooting and repair with disciplines applied across a multitude of industries.
• Broad knowledge of general automation, networks, motion control, drive systems and process control that spans across multiple control vendors.
• Experience with networks and communications includes: Controlnet, Devicenet, Ethernet, Modbus.

This course covers naming a range, specialprinting titles of rows & columns, paste between work-sheets, pasting values and links, viewing and workingwith multiple work-sheets, 3D formulas,  protecting a workbook \ worksheet, & cells, checking for duplicates, Excel as a database, autofilters, slicers,and creating a graph with two axis.

Excel Level 2 is a continuation of Level 1, participants should have those skills before taking Excel Level 2. Course objectives are how to work with multiple files and worksheets, naming a range and benefits, sorting and filtering data using Excel as a database, tables and their benefits, data validation, sub-totals, Pivot Tables, conditional formatting, graphs with two axis and sparklines.

Arkansas State University Newport’s Controls Tech Apprenticeship prepares apprentices for high-demand careers in advanced manufacturing and industrial automation, with a focus on electrical systems, programmable logic controllers (PLCs), robotics, and process control technologies.

Program Highlights:

This industry-driven apprenticeship combines classroom instruction with hands-on training to develop skilled Controls Technicians who are ready to support, maintain, and troubleshoot complex manufacturing systems.

Apprentices who successfully complete the program are prepared to work in automated environments across industries such as food processing, steel production, advanced manufacturing, and logistics.

Start Dates:

⮚ August 18

⮚ October 15

⮚ January 20

⮚ March 16

Enroll for the full apprenticeship program or select specific classes that fit your needs.

Training Overview by Year:

Year 1 

⮚ Industrial Electricity 1

⮚ Industrial Motor Control 1

⮚ Industrial Electricity 2

⮚ Programmable Logic Controls 1 (PLC 1)

⮚ Industrial Process Control

Year 2 

⮚ Industrial Motor Control 2

⮚ Programmable Logic Controls 2 (PLC 2)

⮚ Industrial Robotics

⮚ Temperature Process Controls

⮚ Introduction to Network

Year 3 

⮚ Level and Flow Process Control

⮚ Computer-Aided Drafting (CAD)

⮚ Programmable Logic Controls 3 (PLC 3)

Customizable and Flexible Schedules available. Pick and choose courses based on your needs.

To Register or for any Questions

Email - workforce@asun.edu or call (870) 680-8717.

Arkansas State University Newport’s Industrial Maintenance Apprenticeship prepares apprentices for high-demand careers in maintaining, troubleshooting, and repairing the mechanical, electrical, and fluid power systems used in today’s industrial and manufacturing facilities.

Program Highlights:

This industry-aligned apprenticeship combines classroom instruction with hands-on lab experience to train Industrial Maintenance Technicians who are equipped to ensure the safety, efficiency, and reliability of production equipment and systems.

Apprentices who successfully complete the program are prepared to work in a variety of sectors, including food processing, steel production, advanced manufacturing, and logistics.

Start Dates:

⮚ August 18

⮚ October 15

⮚ January 20

⮚ March 16

Enroll for the full apprenticeship program or select specific classes that fit your needs.

Training Overview by Year:

Year 1 

⮚ Mathematical Applications

⮚ Mechanical Drives

⮚ Industrial Fluid Power 1

⮚ Industrial Electricity 1

⮚ Trade Skills

Year 2

⮚ Workplace Essentials

⮚ Programmable Logic Controls 1 (PLC 1)

⮚ Programmable Logic Controls 2  (PLC 2)

⮚ Industrial Motor Controls 1

⮚ Industrial Fluid Power 2

⮚ Industrial Electricity 2

Customizable and Flexible Schedules available. Pick and choose courses based on your needs.

Learning Format: Courses are delivered in a hybrid format with scheduled start dates throughout the year, combining in-person instruction and hands-on training to meet the needs of today’s industrial workforce.

To Register or for any Questions

Email workforce@asun.edu or call (870) 680-8717

Students will learn Allen Bradley VFD Powerflex HMI, including lockout procedures for safety. This class includes the following units of instruction; introduction to various types of AC motors, AC motor basics of voltage, speed, power factor, torque, and motor starting methods, VFD Basics, VFD Working Principle and Operation, VFD Control, VFD Installation (hard wiring VFD-cable termination), VFD Start-up, Soft Starter working principle, Drive software start, and Troubleshooting VFD Drives.Also includes introduction to Allen-Bradley PanelView Plus operator interface configuration and complementary ControlLogix programming, using FTView, Studio5000 and RSLinx. Variable frequency drive basics taught are the same for all VFDs regardless of brand. Includes the Laboratory Manual, Final Exam, and Certificate of Completion.

About the Instructor

Ken Walsh started his career as an Electrical Engineer developing automated sawmill equipment. He worked for Rockwell Automation for just under 20 years as a field support engineer where he saw applications everywhere imaginable. Ken is also a proud Vietnam era veteran.

Build the Leadership Skills Needed to Lead Teams and Drive Success

Arkansas State University Newport’s Supervisor Apprenticeship is a 35-week, 140-hour program is designed for aspiring or new supervisors seeking foundational leadership and workplace management skills.

With 50% online and 50% in-person delivery, it offers flexibility while maintaining hands-on learning and engagement.

Tuition: $700 (2 payments available)

Total Hours: 140 (70 online / 70 in person)

In person hours are every Tuesday from 5pm to 8pm

Course Modules Include:

✔ Microsoft Applications (24 hrs) Gain proficiency in Excel, Word, PowerPoint, Outlook, and Teams to improve daily productivity and team collaboration.

✔ Leadership Development I (12 hrs) Learn the foundational practices for effective leadership, responsibility, vision-setting, and empathic communication.

✔ Transitioning to Supervisor (12 hrs) Explore the essential mindset, skills, and responsibilities of becoming a confident and capable supervisor.

✔ Leadership Development II (7 hrs) Deepen leadership impact by building trust, setting strategic goals, and mentoring others to reach their potential.

✔ Time Management (7 hrs) Master planning, prioritization, and productivity strategies to maximize your time and energy.

✔ HR Essentials for Supervisors (12 hrs) Understand the core HR principles related to hiring, performance management, employee engagement, and workplace safety.

✔ Communication (12 hrs) Enhance your ability to exchange information clearly, professionally, and persuasively across your organization.

✔ Business Budgeting (24 hrs) Build your financial literacy, budgeting skills, and data-driven decision-making abilities.

✔ OSHA 10-Hour General Industry Certification (10 hrs) Learn the fundamentals of workplace safety and hazard prevention.

Designed For: New or prospective supervisors in any industry who want a well-rounded, practical leadership foundation.

To Register or to Learn More:

Email workforce@asun.edu or call (870) 680-8717

This course provides advanced tools for solving real-world problems in Microsoft Excel 2019: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.

Excel Level 3 is a continuation of Level 2, participants should have those skills before taking Excel Level 3. Course objectives are If Statements, Lookup Functions, Date and Text Functions, What-If Analysis, Exporting, Importing using Power Pivot, Simple Macros and Form Tools.