HRD/CBI Computer Classes &
Professional Development Workshops
Northern Essex Community College is pleased to serve
as the Northeast Region of the Center for Business and Industry. The
continuing goal is to contribute to the creation of a highly trained
and skilled workforce through expanded training opportunities for both
public employees and citizens in our service area.
The following courses are currently being offered
through the Center for Business and Industry office and being sponsored
and paid for by the Office of Faculty and Staff Development for employees
at NECC to attend.
Please note that all classes will be held at
the North Andover campus (Click
here for directions). Exact
class locations are on the registration form.
Computer Classes &
Professional Development Workshops
Click
here to access a link that provides very helpful tutorials
on software programs, including MS Office 2007.
Intro.
to Computers 1st Time, Monday, 10/19/09, 9:00-4:00:
This course is designed for the "pure beginner." You will
start with a guided tour through operating the hardware, including using
the keyboard, mouse, disks, printers and much more. Learn the basics
of working in MS Windows. Understand the start menu, "My Computer,"
folders, file management and the desktop. Get your first exposure to
cyberspace, including the Internet and the World Wide Web, browsers,
search engines, and email. This is a highly interactive course where
students learn by doing with instructor-led hands-on exercises. Instructor:
Jay Partlan <<Register
for this class>>
Intro.
to Computers: Novice, Monday, 11/16/09, 9:00-4:00:
Designed for the new user who has spent some time with PCs. Learn how
to use MS Windows accessories to manage and configure your PC. Understand
the control panel to customize the user interface including mouse activities,
display screen settings and adding and removing software. Learn basic
troubleshooting, fundamentals of Microsoft Office, and how to protect
your PC locally and in cyberspace. Download and install software from
the web. Discover the necessities of your computer's health, including
temperature, power and backup strategies. Bring your questions and PC
problems with you. Instructor: Jay Partlan <<Register
for this class>>
Making
the Switch to Office 2007, Monday, 10/5/09, 9:00-12:00, OR
Friday, 11/13/09, 1:00-4:00:
For the first time, Microsoft has made major changes to the well known
Menu and Toolbar interface in Microsoft Office. If you have been using
Office 2003 or earlier, but now or soon will need to transition to the
new Office 2007 system, this timesaving workshop will get you up to
speed. With 2003 and 2007 both installed, we will demonstrate (and you
will perform) common tasks in the four major Office applications to
show how to use the new Ribbon interface to accomplish tasks you currently
perform in an earlier Office version. Instructor: Jay Partlan <<Register
for this class>>
Managing
Your Documents, Spreadsheets, Photos and Other Computer Files, Friday,
10/16/09, OR Tuesday, 12/8/09, 9:00-4:00:
One of the computer's biggest assets is that it gives you the ability
to modify and reuse previously created work. Much of the time and effort
you put into creating something, (a document, spreadsheet, presentation,
database, etc) gets wasted if you can't easily find it again when you
need it. Prevent losing work by using techniques covered in this seminar
to create, maintain and back up your own computer file system utilizing
Windows file management tools. <<Register
for this class>>
Introduction
to Word 2007, Friday, 10/23/09,
9:00-4:00:
Learn how to edit and format documents while creating letters, resumes,
flyers, etc. with the most popular word
processing program. Students should have keyboarding and computer experience.
Instructor: Jay Partlan/Ken O'Brien <<Register
for this class>>
Intermediate Word
2007, Friday, 11/20/09, 9:00-4:00:
Learn Word skills beyond the basics, including
desktop publishing, preparing newsletters and employee policy manuals,
organizing long documents and research papers, and Web integration.
Instructor: Jay Partlan <<Register
for this class>>
Advanced Word
2007, Friday, 12/11/09, 9:00-4:00:
Learn expert Word skills: using mail merge
concepts, advanced tables and Excel integration, Internet integration,
workgroup collaboration, macros, toolbars, templates, and XML. Instructor:
Jay Partlan <<Register
for this class>>
Using
Excel Pivot Tables, Monday, 10/5/09, 1:00-4:00:
Consolidate and analyze your Excel data with a PivotTable. This
3 hour hands-on seminar will demonstrate how to transform lists of data
into concise useful interactive summary reports that make it easy to
visualize, use, and present your information. Instructor: Jay Partlan
<<Register
for this class>>
Introduction
to Excel 2007, Tuesday, 9/22/09, OR
Wednesday, 10/21/09, OR Thursday, 11/19/09,
OR Tuesday, 12/22/09, 9:00-4:00:
Learn how to edit, format and create worksheets,
work within a workbook with multiple worksheets, and perform calculations.
Excel can be used to maintain budgets or small business finances. Students
should have keyboarding and computer experience. Instructor: Jay Partlan
<<Register
for this class>>
Intermediate Excel
2007, Tuesday, 10/6/09, OR Wednesday,
11/4/09, OR Thursday, 12/3/09, 9:00-4:00:
Beyond Excel basics: developing templates and
graphics, multiple-sheet workbooks, databases, PivotTables, styles,
and outlines. Instructor: Jay Partlan <<Register
for this class>>
Advanced Excel
2007, Tuesday, 10/13/09, OR Wednesday,
12/16/09, 9:00-4:00:
Learn expert Excel skills: lookup functions,
custom templates, auditing tools, macros, VBA, advanced formatting and
analysis tools, project tracking, Internet integration, integrating
and sharing data, and workgroup collaboration. Instructor: Jay Partlan
<<Register
for this class>>
Moving Data:
Excel to Access, Friday, 11/13/09, 9:00-12:00:
While Excel has some useful database features,
your Excel database may have reached the point where you need a true
Relational Database Management System (DBMS). This workshop will show
how to easily migrate or link your data to an Access database, giving
you the powerful user-friendly data entry, querying and reporting tools
of Microsoft Access. Instructor: Jay Partlan <<Register
for this class>>
Introduction to Access
2007, Friday, 10/9/09, OR Wednesday,
11/18/09, 9:00-4:00:
Learn how to store, locate, and print
just about any type of important information, such as addresses, birthdays,
etc. Create tables, relationships, custom data entry forms, queries,
reports, and mailing labels. Students should have keyboarding and computer
experience. Instructor: Jay Partlan <<Register
for this class>>
Intermediate Access
2007, Friday, 10/30/09, OR Friday,
12/4/09 , 9:00-4:00:
You will learn additional skills to customize
forms, advanced controls, work with sub forms and calculated controls,
import data and customize reports, switchboards, macros, command buttons,
and integration with Word, Excel, and the Web. Instructor: Jay Partlan
<<Register
for this class>>
Advanced Access 2007,
Wednesday, 12/9/09, 9:00-4:00:
You will learn advanced techniques such as:
querying with SQL; using crosstab, parameter, and action queries; creating
and running macros; importing, exporting, and linking database objects;
optimizing, replicating, and synchronizing databases; and basic database
security. Instructor: Jay Partlan <<Register
for this class>>
Introduction to PowerPoint
2007, Wednesday, 10/7/09, OR Tuesday, 11/10/09,
9:00-4:00:
You will learn how to create overhead
transparencies and electronic slide presentations. Learn how to add
clip art, hypertext links, and special effects to your presentations.
Students should have keyboarding and computer experience. Instructor:
Jay Partlan <<Register
for this class>>
Intermediate PowerPoint,
Tuesday, 11/17/09, 9:00-4:00:
You will learn more advanced PowerPoint skills:
charts, tables, office applications, online presentations, online
collaboration, managing template customization and multimedia, and proper
presentation etiquette. Instructor: Jay Partlan <<Register
for this class>>
Advanced PowerPoint,
Wednesday, 12/2/09, 9:00-4:00:
You will learn more advanced PowerPoint skills:
charts, tables, office applications, online presentations, online
collaboration, managing template customization and multimedia, and proper
presentation etiquette. Instructor: Jay Partlan <<Register
for this class>>
Contact Judith Kamber, Dean of Professional Development,
at 978-556-3955 or at jkamber@necc.mass.edu
with any other questions or concerns.
Sponsored by:
Office of Faculty & Staff Development
Directions to
the Corporate & Community Education Center, 1600 Osgood Street,
North Andover, MA:
