COMPUTER SERVICES DIVISION

COMPUTER CLASSES

COMPUTER BASICS

Introductory class for new user.

WINDOWS

An introduction to Windows 95/98.

MICROSOFT OFFICE

WORD

 

Beginning Level

Creating & saving documents, document formatting and editing, setting & using tabs, creating headers & footers and printing.

Intermediate Level

Advanced editing, multiple column documents, creating and using tables, reference tools and mail merge.

Advanced Level

Using styles, working with outlines, using sections, inserting graphics, creating macros and templates.

EXCEL

 

Beginning Level

Creating, modifying & saving workbooks; selecting & filling cell ranges; relative vs. absolute referencing; creating formulas; formatting; charts and printing.

Intermediate Level

Database creation, sorting & filtering data, linking & protecting worksheets and creating & editing macros.

Advanced Level

Advanced data management, using IF logic, creating user-defined functions and customizing Excel.

ACCESS

 

Beginning Level

Creating a database; using tables, forms, queries & reports; searching & sorting data; importing & exporting; setting data relationships.

Intermediate Level

Creating advanced queries, linking tables, creating look-up tables, inserting graphics and customizing forms.

Advanced Level

Creating and using macros and events, Structured Query Language (SQL) and using modules.

POWERPOINT

 

Beginning Level

Creating & editing slides, using drawing tools & inserting graphics, transitioning slides, creating speaker’s notes and printing.

Intermediate Level

Adding data charts; advanced formatting; working with templates; creating & printing handouts and applying movie, sound & animation effects.

OUTLOOK

 

Beginning Level

Sending e-mail messages, using Calendar, making entries into Contacts and using Notes.

Intermediate Level

Creating address books & distribution lists, attaching files & hyperlinks to e-mail messages, sharing information and customizing Outlook.

FINANCIAL PROGRAMS

QUICKBOOKS PRO

 

 

Setting up account, customer & vendor lists; employees and inventory; invoicing; paying bills; payroll; tracking inventory; job estimating and reports.

DESKTOP PUBLISHING PROGRAMS

PAGEMAKER

 

Beginning Level

Creating, saving & printing a document; working with objects; flowing text; text formatting; using the word processor and laying out a newsletter.

Intermediate Level

Using master pages, formatting & manipulation of text, graphics & color and using style sheets.

Advanced Level

Fine-tuning the layout, book management, using Adobe Table and advanced graphics.

CORELDRAW

 

Beginning Level

Creating & saving a drawing, working with the drawing tools, using the drawing rules and the transformation roll-ups.

Intermediate Level

Working with layers, using artistic text and paragraph text, filling objects & creating custom fills and creating special drawing effects.

Advanced Level

Advanced drawing techniques, creating styles, using object data and drawing using perspective.