Westerntc.edu  >  Business and Industry  >  Customized Training  >  Information Technology/Computer Skills

Information Technology/Computer Skills

From Microsoft Suite to Cisco to wireless networks, Western can give you the tools and skills you need to manage today's complex technology needs.

Intro to Network Security Fundamentals

Provides an understanding of information security management and technical components of security. The material covers the history and terminology of security and an overview of how to manage an information security program. Topics include legal and ethical issues, risk management, security design (logical and physical) and maintenance. Case studies and hands-on scenarios provide students with opportunities to create solutions to security issues.
Details

Introduction to SQL- Structured Query Language

Structured Query Language (SQL) is a standard computer language for accessing and manipulating database systems. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. In this seminar you will learn database fundamentals like; relational database architecture, database design techniques, and simple and complex query skills. If you are an analyst, developer, designer, administrator, or manager new to the SQL programming language, this session will help you understand SQL functions. Additional topics include: join techniques, database objects and constraints, and how to write useful SELECT, INSERT, UPDATE and DELETE statements.
Details

Microsoft Access - Database Design

Careful thought and planning will save you wasted time having to redesign your Access database. Learn design techniques to create effective databases.
Details

Microsoft Access - Forms

Create forms to make data entry easier for your users and reduce data entry errors. Experience with tables required.
Details

Microsoft Access - Queries

Learn to set up and run various queries including: select queries, parameter queries, action queries and crosstab queries. Create custom queries using criteria, get sums, totals and averages from your database. Experience with tables required.
Details

Microsoft Access - Reports

Unleash the power of Access by creating attractive and easy to design reports. The report wizard will amaze you! Experience with tables required.
Details

Microsoft Access - Tables

Learn to create tables, define primary keys, add fields, choose data types, set field properties, add and edit table data, sort and filter records.
Details

Microsoft Excel™

This seminar is designed for those with a basic knowledge of Excel™ but who want to expand their skills to work faster and more efficiently. This seminar is entirely hands-on so each participant will learn tips and shortcuts to immediately use in the workplace. Topics to be covered include formulas, how to work with workbooks, and how to create a variety of charts. Please bring a flash drive to save your work.

In creating the workbook for this seminar, students will learn how to enter formulas, calculate an average, find the highest and lowest numbers in a range, change column widths and row heights. Students will also learn how to select a range and use the AutoSum button to sum numbers in a column or row. Using the fill handle, they will discover how to copy a cell to adjacent cells. Students will learn how to spellcheck a worksheet, print a worksheet, print a section of a worksheet, and display and print the formulas version of the worksheet using the Fit to option. They will then learn how to use the Chart Wizard to add a 3-D clustered column chart to the worksheet. After completing the worksheet, they will learn how to save the workbook on a flash drive, and how to print the worksheet and chart. Finally, they will learn how to use the Excel Help system to answer questions.

objectives

In this seminar, students will learn how to:

About the Instructor:

Peggy Langreck has been with Western Technical College for over 20 years. She works full-time as the development manager in the Foundation Office as well as teaching credit and non-credit Excel classes for Western. Peggy uses Excel every day and sees it as an essential tool to her professional and personal life.


Details

Microsoft Excel™ Worksheets & Formulas

As you continue to work with Excel, you may find your worksheets growing in size and complexity. In this seminar, participants will learn to work with multiple-sheet workbooks, set up a workbook witht a master sheet and detail sheets. Also create formulas using the IF function and consolidate data from several worksheets to a single worksheet using 3-D formulas. Please bring a project saved on a key drive to work with during this hands-on seminar. This seminar will be taught using Excel version 2003.
Details

Microsoft Office 2007 Update

The new Microsoft Office 2007 interface is designed to increase efficiency and make it easier for users to find perviously buried and unused features. This seminar will provide a detailed overview of the new interface as well as clarify some areas of challenge. Come learn tips and tricks for using the ribbon and the new file formats to increase your efficiency and collaboration.
Details

Microsoft PowerPoint&trade

Even the best audio/visual tool is only as good as the user's skill. In this hands-on workshop, learn basic skills needed for developing professional presentations using Power Point. Learn tasks to create, enhance and print presentation slides; use the outline pane; and edit and proof text. In addition, learn how to use graphic impages and table, format text. Finally, participants will learn how to add interest and creativity to an existing presentation through use of clip art, sound, and moviesand timing a presentation to run automatically. Students are encouraged to bring a disk or CD with a project from their workplace to use as their work sample.
Details

Microsoft Project- Filtering, Sorting Manipulating, Importing and Exporting

Microsoft Project is a powerful project management program used for planning, scheduling, cost analysis and tracking projects. This hands-on workshop focuses on using MS Project to define, plan, schedule and manage projects, as well as combine concurrent projects and share resource pools. This series of seminars will take you from the basics of creating a project through the full potential of the software and developing Gantt and PERT charts and preparing a variety of reports. Participants must take session one and two to take session three and four. Take all four sessions for $350.00 ****Additional costs for textbooks will be required for each session.
Details

Microsoft Project- Setting up Resources and Costs

Microsoft Project is a powerful project management program used for planning, scheduling, cost analysis and tracking projects. This hands-on workshop focuses on using MS Project to define, plan, schedule and manage projects, as well as combine concurrent projects and share resource pools. This series of seminars will take you from the basics of creating a project through the full potential of the software and developing Gantt and PERT charts and preparing a variety of reports. Participants must take session one and two to take session three and four. Take all four sessions for $350.00 ****Additional costs for textbooks will be required for each session.
Details

Microsoft Project- Setting up Timelines and Tasks

Microsoft Project is a powerful project management program used for planning, scheduling, cost analysis and tracking projects. This hands-on workshop focuses on using MS Project to define, plan, schedule and manage projects, as well as combine concurrent projects and share resource pools. This series of seminars will take you from the basics of creating a project through the full potential of the software and developing Gantt and PERT charts and preparing a variety of reports. Participants must take session one and two to take session three and four. Take all four sessions for $350.00 ****Additional costs for textbooks will be required for each session.
Details

Microsoft Project- Tracking and Evaluating a Project

Microsoft Project is a powerful project management program used for planning, scheduling, cost analysis and tracking projects. This hands-on workshop focuses on using MS Project to define, plan, schedule and manage projects, as well as combine concurrent projects and share resource pools. This series of seminars will take you from the basics of creating a project through the full potential of the software and developing Gantt and PERT charts and preparing a variety of reports. Participants must take session one and two to take session three and four. Take all four sessions for $350.00 ****Additional costs for textbooks will be required for each session.
Details

Microsoft Word™ - Mail Merge

Mail Merge is the key to productivity. In this session you will generate form letters, labels, catalog listings, and envelopes with personalized information using two documents - a data source and a main document. Participants will learn how to create mail merge documents as well as sort and filter data.
Details

MS Automation & Customization

Are you spending too much time, money, and talent on business processes involving Microsoft Office? Would you like to learn how to simplify complex tasks,
Details

Pictures & Graphics

This session will incorporate createive use of pictures and graphics into documents and forms. Participants will receive hands-on practice of importing graphics and pictures into different MS Office applications. A good understading of MS Office Suite is required.
Details

PowerPoint™

This seminar is designed for those with intermediate knowledge and experience with PowerPoint™ and wish to move to the advanced level. Each participant will work on an existing project and expand it to include graphics, sound, and other enhancements. You are welcome to bring a current project to work with; if you do not have a current project, you will create one in the seminar. Please bring a flash drive
Details

Scripting for Network Administrators

This seminar will explore technologies that aid network and system administrators in discovering tips and tricks for automating their Win32/64 environments. Participants will explore an extensive array of scripting capabilities built into the Windows 2003/XP operating system. Topics to be covered in this training include: Win32 Command Shell, NETSH and WSH; Network and Printer Objects; Exploration of WMI; Batch File Subroutines and Regular Expressions; Automation (Software Install, Mail Delivery, Log Collection); File and Registry Access; User and Computer Objects; and Automation with Batch Files. Scripting is taught as a hands-on lab; participants will have time for creating or updating application scripts.
Details

Using Excel to Create Charts

This hands-on seminar will include essential skills for using worksheets when comparison, trends and other relationships can be conveyed more effectively with charts and will include practice exercises for creating column, line and pie charts as well as editing and formatting chart objects.
Details

Using Social Media to Market your Business

Did you know you can use social media to your advantage?! Facebook, Twitter, MySpace……these are all social networking venues that can be used to market your business. Come to this session to learn how!
Details

Using VISIO in the Workplace

Visio is a Microsoft tool that allows you to flowchart. This session is a beginners course and introduction to Visio. Flowcharting allows for picture views of process and all sorts of office tools.
Details

Wireless Networking and Wireless Security

Designed for system and network administrators, participants in this seminar will learn the skills necessary to design, configure, secure, and manage a wireless network environment. Topics include a crash course in wireless Ethernet RF and Antenna Design; 802.11 Wireless Ethernet Standards; Wireless Risks and Vulnerabilities; Wireless Security Protocols; Wireless Policy Development; 802.1x; Commercial Wireless Security Solutions; Wireless Attacks and Exploits; and Wireless Auditing and Monitoring.
Details