Home Campus Directory | A-Z Index

Computer Topics

Introduction to Word (CSE 5315)
12 hours - 1.2 CEU's
Course fee: $120.00 (includes materials)
What you type in a document is just the beginning. Words alone don't always get your message across. Learn how to use Microsoft Word to create a variety of professional-looking documents using features such as themes, styles, SmartArt, and more.

Intermediate Word (CSE 5118A)
12 hours - 1.2 CEU's
Course fee: $120.00 (includes materials)
For those with basic knowledge of Microsoft Word 2007/2010, you'll discover how to use document themes, find and replace text, use Format Painter, apply WordArt, and create charts. You'll also learn how to use organizational and structural features within Word, how to add custom headers and footers, and how to manipulate page setup and page layout functions to customize the look of your documents.

Introduction to Excel (CSE 5317)
12 hours - 1.2 CEU's
Course fee: $120.00 (includes materials)
Working on a computer loaded with the latest Excel software, you will create spreadsheets, input data, perform mathematical calculations, develop worksheets, edit cells, and use formulas, functions, Wizards, and much more.

Intermediate Excel (CMPBD 5080)
12 hours - 1.2 CEU's
Course Fee: $120.00 (includes materials)
This course focuses on useful formula design for data processing and modeling, using Excel's built-in range features like Data Validation, useful worksheet functions like VLookup, and applying Excel's built-in data processing tools and worksheet functions to analyze and clean text files and worksheet tables. You will learn how to develop analysis and data processing problems on the worksheet, then how to determine the proper Excel tools to create a unique solution.

Introduction to Access (CSE 5316)
12 hours - 1.2 CEU's
Course fee: $120.00 (includes materials)
This class will show you how to build a database from scratch, including how to plan and set up tables and fields, create and use forms to enhance data integrity, design and run meaningful queries, and create useful and attractive reports.

Intermediate Access (CSE 6489)
12 hours - 1.2 CEU's
Course Fee: $120.00 (includes materials)
Learn how to design a query, use queries to display related information from two or more tables, and construct selection criteria to extract specific records from tables using queries. You will also learn how to create and utilize pivot tables and charts based on query information.

Introduction to PowerPoint (CSE 5332)
6 hours - 0.6 CEU's
Course fee: $60.00 (includes materials)
PowerPoint 2007 is the presentation graphics software in the Microsoft 2007 Office Suite. With PowerPoint, you can use it's easy-to-use predefined layouts, themes, or templates to create dynamic and professional presentations. Learn how to prepare, present, and distribute your multimedia presentation.

Intermediate PowerPoint (CSE 5129)
6 hours - 0.6 CEU's
Course Fee: $60.00 (includes materials)
Introduces users to more advanced PowerPoint tasks, such as creating hyperlinks to other slides, presentations files, and Web sites; inserting action buttons, clipart, images and charts into presentations; aminating text and graphic objects; and adding slide transitions.

Microsoft Project 2010 (CSE 6579)
16 hours - 1.6 CEU's
Course Fee: $650.00
Microsoft Project Overview - Companies large and small require project plans developed in Microsoft Project to track the status of their projects. Learn the proper methods for using Microsoft Project 2010. You will learn the #1 and #2 mistakes even seasoned users make. Explore how to build project plans properly for effective project management. Understand the "Nine Steps to Effective Project Plans" and the "Seven Cardinal Rules of Microsoft Project."



Social Networking

Basic Networking Workshop

What is Facebook? What is Twitter? What is social networking and marketing? By understanding these social networking website you leverage your business and reach new people, increase business, and promote new products. In this course we will go over the fundamentals of Facebook and Twitter. Students will gain a greater understanding of these tools; their effectiveness as well as limitations. We will also discuss some fun web tools that will make your on-line presence even stronger.

Hands-on Networking Workshop

Building upon a basic framework or understanding of Facebook and Twitter, this class will afford students the opportunity to have hands-on work in Facebook and Twitter. It is recommended that you already have a Facebook and/or Twitter account. If you do not, you will have the opportunity to sign up and get going on these popular social networking sites. For the latter option you will need web access to your e-mail.

 


Leadership Training

Responding to Organizational Change (MGMT 5136)
An interactive workshop for supervisors and managers focusing on an awareness of individual strengths, their impact on a positive approach to work and life, and the challenge of achieving organizational goals in a changing environment.

Team Building (MGMT 5139)
Complete and analyze a personal conflict style profile. Describe the various types of conflict that can show up in a team building strategies for managing conflict in a team setting, identify practices for minimizing conflict and discuss the group development process of your team work.

Promoting a Positive Work Climate (LA 5106)
Participants will discuss traditional and current management strategies. Discussion will include various methods for managing a diverse workforce such as diversity and pluralism. Participants will learn motivational theories for assessing the current climate within an organization and strategies for creating a motivational climate. Delegation and negotiation techniques will be applied to work situations.

Diversity: A Competitive Advantage (LA 5108)
The goal of this course is to increase participants' awareness, knowledge and skills in order to work more effectively in a multicultural organization. At the conclusion of the session, participants will be able to: Define Diversity, explain how diversity relates to EEO and Affirmative Action, analyze census 2000 information with regards business trends and managerial impact, analyze a business study dealing with diversity issues and describe the skills required to manage diversity.

Effective Business Presentations
This program is designed to meet the needs of professionals who are routinely faced with the responsibility of developing and delivering oral presentations in small group meetings or in formal public speaking situations

Supervisor/Manager and the Law
Learn about Federal Equal Employment Opportunity (EEO) laws ; Increase your awareness about harassment and sexual harassment; Familiarize yourself with the American Disabilities Act; Relate the Family and Medical Leave Act to your work environment; Synthesize the Age Discrimination in Employment Act into your company policies.

Improving Operations and Processes (MDEV 6012O 20 hour course)
This course provides participants with an overview of the concepts, tools and techniques essential to improving both operational and resources management. The program focuses on process understanding and optimization. The emphasis of this program is to improve individual and organization effectiveness by providing a basic understanding of costs and budgets, improving cycle time and reducing waste. this highly interactive workshop features case studies, a variety of planning exercises and other activities designed with an active learning focus.

Building your Team (MDEV 6010B - 16 hour course)
This course is designed to continue building on basic competencies that today's supervisors need in leading employees by focusing on building your team: interviewing, selecting and lacing employees, creating a climate for teamwork, cooperation and involvement; building high-performance work teams and resolving interpersonal conflicts.

Finance and Accounting for Nonfinancial (MDEV 6021O - 20 hour course)
This program has been designed as an overview of financial management tolls and skills. The overriding objective is to present a number of "nuts and bolts" financial concepts in order to provide useable information including basic accounting principles, budgeting and fundamental financial analysis tools.

Project Management Fundamentals (MDEV 6049O - 16 hour course)
When Projects are well managed, they are completed on time and under budget recognized by all team members as a positive experience and completed effectively and efficiently. These factors are critical to success in today's competitive environment. This intensive, interactive program will provide participants with tools and knowledge. This highly interactive workshop features case studies a variety of planning exercises and other activities designed with an action learning focus.

 


Lean Manufacturing

LE101 Principles of Lean Manufacturing (8 hours)
Principles of Lean Manufacturing with live Simulation is the first step to learning the principles of lean manufacturing. No previous experience is required. The course is a mix of classroom and live simulation. Participants begin by manufacturing simulated circuit boards in a traditional manufacturing setting. The results of the first simulation round will provide the setting for continuous improvement, applying lean manufacturing principles in subsequent rounds of the simulation.

Each lesson is designed to eliminate waste in the manufacturing process.
Participants will understand the 8 wastes in manufacturing. A mixture of lecture and hands-on simulations teach lessons in:

  • Standardized work
  • Workplace organization
  • Visual Controls
  • Set-up reduction
  • Batch size reduction
  • Point of use storage
  • Quality at the source
  • Workforce practices
  • Pull Systems

LE 202 Value-Stream Mapping

Whether you have made the decision to adopt lean manufacturing or are still not sure of its strategic fit, value stream mapping is the place to start! Defining value versus non-value and mapping the activity within your organization is the most critical step towards becoming lean. Manufacturers learn to see the organization as a value stream by creating current and future-state maps of the organization that are the basis for all lean implementations and define the work that lies ahead.

Set-Up Reduction

Setup or changeover is the preparation of a production line or piece of equipment for a different process or product. Setups often take hours, even days to complete (all of which is 100% non-value added time). Based on the Single Minute Exchange of Dies philosophy, documented by Shigeo Shingo in The SMED System, this implementation involves an analysis of an actual changeover process and set-up reduction in a team environment. Typical results range from 50-75% reduction in set-up time after the first iteration, providing additional capacity and driving up productivity.

LE 203 The 6S System Workplace Organization and Standardization
This workshop offers you an opportunity to experience first hand how the 6S System reduces waste in the mounting plate assembly area of a simulated production facility. Participants learn the concepts of the 6S System and then apply them to transform a cluttered, disorganization production area in a clean, organized and orderly workplace.

LE 111 Lean Office
Learn how to make your company’s office operate more efficiently by attending a workshop featuring a live simulation. The concept of lean manufacturing is now being applied to other areas than just the shop floor.

 


OSHA Course for General Industry

This course is designed to provide a basic understanding of safety issues for those newly appointed to responsibility in occupational safety and health or those looking for an update with the latest from OSHA.

Attendees will receive a certificate and wallet card issued by OSHA that verifies successful completion of the course. Participants will also receive the OSHA Voluntary Compliance Outreach Program manual.

 


Practical Spanish for the Workplace

This workshop is for individuals who work with Spanish speaking employees in the workplace and are seeking basic conversational Spanish skills for use in their day-to-day communications. The course will also be adjusted according to the profession and needs of class participants. It is expected that participants will have no Spanish training or limited Spanish education that has been forgotten.

 


Safety - Hazardous Waste Operations and Emergency Response (HAZWOPER)

This program provides an overview of the rules of HAZWOPER and how it relates to manufacturing facilities. This interactive workshop starts by addressing the issues of "Who is covered by OSHA's HAZWOPER Standard?" and "How do we comply with HAZWOPER training requirements?" Standard interpretations will be discussed and then specific incident awareness and response to chemical spills will be addressed.

PROGRAM THEMES

  • 29 CFR 1910.120 Requirements (OSHA, EPA, DEP)
  • Standard Interpretations from OSHA
  • Incident Preparation including spill kits, MSDS review, and chemical identification
  • Incident & Emergency Response

 


U.S. Dept. of Energy Best Practices Training

Do you want to learn how to manage your motors and optimize your pumping system? Or do you need to calculate the energy cost of compressed air in your facility? Would you like to find ways to save energy in your data center?

PennTAP and Penn State Continuing Education are partnering to provide U.S. Department of Energy BestPractices Training. To meet the diverse needs to U.S. industry, BestPractices provides a number of resources for corporate executives, plant managers, technical staff, and the general public. We invite you to join the many U.S. companies that are saving energy and money and improving productivity right now.

Detailed information about the topics listed above can be found at www1.eere.energy.gov/industry/bestpractices

 


DMAIC Black Belt Training

Candidates will train one week a month for 3 months in the DMAIC methodology. They will learn to apply tools like Voice of Customer, FMEA, Hypothesis Testing, Regression, Design of Experiments, Response Surface Methodology, Stakeholder Analysis, and Change Management to their projects.

Dates: To Be Announced
Times: 8:00 a.m. - 5:00 p.m.
Fee: $6500 (instruction, materials, breakfast, and lunch included)
Location: To Be Determined

 


Warehousing In Today's Business Environment

A joint program of Penn State Hazleton and Schuylkill Campuses

A focused, three-day course that can help you improve your warehouse and distribution process. Managing and working successfully in the current warehousing environment is critical to your business. This course will explore key business and operational concerns, such as logistics, materials management, inspection of incoming equipment, the use of powered industrial trucks and warehouse design and layout concerns. It will also include an introduction to warehouse business principles and law, and offer specific insights and techniques for warehousing success.

Who should attend: This program can benefit anyone interested in understanding the fundamentals of warehouse operation. This includes front line employees, new managers, supervisors, team leaders, and employees involved in the planning and daily operations of a warehouse or those seeking work in this area.

You can learn:

  • how warehousing for supply chain management impacts business profitability
  • how to manage critical warehousing functions and activities
  • how to handle key management and operational issues in warehousing

Dates: To Be Determined
Times: 8:30 a.m. - 4:00 p.m.
Fee: $725.00
Location: At Penn State Hazleton and video conferenced to PSU Schuylkill Campus

 

For more information contact:
Debra Conway, Associate Director of Continuing Education
Penn State Hazleton
570-450-3136
dxk40@psu.edu