|
||||||||
|
Daytime Descriptions
**For SECURE online enrollment click here.Select the class you would like to take, enter the required information using your MasterCard, Visa or Discover**
Please check our Daytime Schedule page to verify currently offered classes.
Access 2002- Level 1
Prerequisite=Windows training or experience
Provide training in database concepts, terminology, and relationships using Access 2002. Learn the fundamentals of designing and creating tables as well as entering, editing and manipulating data within tables. Create and use queries to retrieve information, group records and perform calculations. Create and edit forms for viewing and inputting data. Move, size, and align text and label controls in a forms/reports. Generate basic reports that summarize and group data. Learn to add text box controls, label controls, and calculated fields in reports.
Access 2002- Level 2
Prerequisite=Access-Level 1 training or experience
Import data from Excel, enforce referential integrity, set up cascade updates and deletes and document table relationships. Set up default values, required fields, data validation settings and Lookup fields. Use Filtering tools in tables. Create queries to provide summaries of table data. Build single and multiple Parameter queries. Update, append and delete records using queries. Improve Forms design by adding list boxes, combo boxes, option boxes, subforms, text and graphic elements. Enhance reports by grouping, sorting, and summarizing data as well as adding subreports.
Access 2002- Level 3
Prerequisite=Access-Level 2 training or experience
Organize existing data into correctly designed tables. Learn to correct a many-to-many relationship problem. Compact a database. Make a cross tab query, pivot table and pivot chart to summarize data. Create and revise basic Access macros. Add interaction and automation with macros. Create macros that run when specific conditions are encountered. Enhance forms by creating tabs and applying conditional formatting. Use advanced report tools to add charts and format data into columns.
CD Burning with Nero 6 SmartStart
Prerequisite=Windows training or experience
Explore the Nero 6 SmartStart software and learn to burn both data and audio CD’s. Learn about different CD types that you can purchase and their purposes and limitations.
E-Mail Etiquette
Prerequisite=None
Students will learn the importance of practicing etiquette when composing e-mail. Look at ways to eliminate potential irritants to recipients and consider an appropriate tone. Discuss ways to communicate more effectively and avoid misunderstandings. Consider e-mail from the viewpoint of the audience and anticipate reader reactions. This course is beneficial to anyone who communicates via e-mail.
E-Writing Effectively
Prerequisite=None
E-Writing Effectively presents an approach to business writing that is much more effective for business communications than what is commonly used. Important steps to success in writing are covered including a very effective method called the MADE format. The techniques covered will help you to improve writing clarity as well as reduce your writing time. Various methods will be explored to help you organize your thoughts and start your writing projects. This course is beneficial to anyone who writes on a regular basis and is particularly helpful for those communicating via e-mail.
Excel- Charting
Prerequisite=Excel-Level 1 training or experience
Create and modify charts (bar charts/pie charts) that graphically represent worksheet data. Apply formatting such as font and size adjustments as well as add titles, data labels, axis labels and other enhancements.
Excel- Manage Lists
Prerequisite=Excel-Level 1 training or experience
Use the Sort command to organize information in a list. Create subtotals and compose shorter reports that hide the details you want to exclude from your printout. Use Filter tools to locate information that meets specified conditions.
Excel- Input & Edit
Prerequisite=Windows training or experience
Create, save, open and edit workbooks. Learn to recognize and preserve cells containing formulas. Insert and delete columns, rows, cells, and worksheets. Resize columns and rows. Adjust margins and explore printing options. Work with cells and cell data by using a variety of selecting, moving and copying techniques.
Excel- Formulas
Prerequisite=Excel- Input & Edit training or experience
Perform calculations on data by using formulas to add, subtract, multiply and divide. Use functions to sum, average, count, report lowest and highest values, and display the current date and time. Add separate sets of numbers – in separate ranges as well as on different sheets. Learn the meaning of the most common errors that occur in a worksheet.
Excel 2003- Level 1
Prerequisite=Windows training or experience
Create and edit workbooks. Work with cells and cell data by using a variety of moving and copying techniques. Perform calculations on data by using formulas, including functions. Change the appearance of worksheet data by using a variety of formatting techniques including number formats. Work with multiple worksheets by formatting, repositioning, copying, and adding and deleting worksheets within a workbook. Prepare a document for printing by inserting page breaks, adding headers and footers, and exploring a variety of printing and page layout options. This course will benefit people who work with numbers and calculations.
Excel 2003- Level 2
Prerequisite=Excel-Level 1 training or experience
Use Excel templates and user-defined templates to create templates and workbooks. Get started with creating and editing basic charts (bar and pie charts). Work with graphic objects and text boxes. Create and work with named ranges. Edit a 3-D workbook and create formulas that refer to cells on multiple worksheets. Use various functions (such as IF and VLOOKUP functions) as well as add and remove subtotals in a worksheet. Use a variety of techniques to sort data. Locate information quickly in a list that meets specified conditions by using the Filter feature.
Excel 2003- Level 3
Prerequisite=Excel-Level 2 training or experience
Explore the basics of creating and editing macros. Protect workbooks, share workbooks, set revision tracking, merge multiple copies of the same workbook, and track changes. Customize your workbook by applying conditional formatting, adding data validation criteria, and create shortcuts by customizing menus and toolbars. Work with auditing features to evaluate worksheets. Use pivot tables, pivot charts, and other analysis tools to analyze data. Use Group and Outline function to create various printouts from one set of data. Work with multiple workbooks to create a workspace, consolidate worksheets, link cells, and edit links. Explore import and export options.
Excel 2003- Intro to VBA
Prerequisite=Excel-Level 2 training or experience
Automate repetitive tasks in Excel 2003 by creating and editing macros using VBA programming (Visual Basic for Applications software that comes with Office 2003). Apply VBA not only to develop macros but also to format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations.
Excel 2002- Level 1
Prerequisite=Windows training or experience
Create and edit worksheets. Work with cells and cell data by using a variety of moving and copying techniques. Perform calculations on data by using formulas, including functions. Change the appearance of worksheet data by using a variety of formatting techniques including number formats. Work with multiple worksheets by formatting, repositioning, copying, and adding and deleting worksheets within a workbook. Prepare a document for printing by inserting page breaks, adding headers and footers, and exploring a variety of printing and page layout options. This course will benefit people who work with numbers and calculations.
Excel 2002- Level 2
Prerequisite=Excel-Level 1 training or experience
Use Excel templates and user-defined templates to create templates and workbooks. Use a variety of techniques to sort data. Locate information quickly in a list that meets specified conditions by using the Filter feature. Re-use and share data by importing and exporting and saving to the Web. Create and work with named ranges. Edit a 3-D workbook and create formulas that refer to cells on multiple worksheets. Use various functions (such as IF and VLOOKUP functions) and auditing features to evaluate worksheets. Use pivottables, pivotcharts, and other analysis tools to analyze data.
Excel 2002- Level 3
Prerequisite=Excel-Level 2 training or experience
Customize your workbook by applying conditional formatting, adding data validation criteria, and create shortcuts by customizing menus and toolbars. Explore the basics of creating and editing macros. Use Group and Outline function to create various printouts from one set of data. Work with multiple workbooks to create a workspace, consolidate worksheets, link cells, and edit links. Protect workbooks, share workbooks, set revision tracking, merge multiple copies of the same workbook, and track changes. Explore import and export options. Chart non-adjacent data, and modify chart items. Use various graphic objects to enhance your worksheet.
FrontPage 2003- Level 1
Prerequisite=Windows training or experience
Old 2000 description…Create a new FrontPage web. Create internal and external links in web pages. Apply a variety of formatting to characters and paragraphs and utilize FrontPage’s built-in themes. Insert, size, align, and link graphic images. Create, modify, and enhance a table. Perform basic web page management techniques such as organizing web site documents, updating your web site and publishing your web.
FrontPage 2002- Level 2
Prerequisite=FrontPage-Level 1 training or experience
Old 2000 description…Students will apply design concepts as well as add and modify structural elements in an existing web. Create Web pages using frames that display web content in separate windows. Add media, rotating banner ads, hit counters, search forms, marquee text and animation to Web pages; create a form to collect visitor information; Format text and Web pages using styles and style sheets.
Competitive Intelligence
CI is a systematic & ethical program for gathering and analyzing information about your area of business as well as your competitors' activities in order to further your own company's goals. This workshop will introduce you to additional search engine capabilities as well as web sites designed specifically for businesses that will aid you in finding useful business data. You will have an opportunity to use essential tools and techniques for searching for specific information on the internet.
Internet Search Techniques
Expand your search skills on the Internet. Topics include finding specific text within a Web page, doing multiple searches by opening additional internet windows, exploring advanced search tools available on many search engines, using shortcuts that come with the Internet Explorer browser software, and using Boolean search operators in queries,
Introduction to PC’s
Prerequisite=None
This class is geared toward the beginner computer user. Students will explore computer terminology and concepts as well as identify parts of a computer, use input devices (the keyboard and mouse), output devices (monitor and printer), and perform standard Windows and PC tasks and techniques. Learn about computer memory, storage, document management, and get started with Windows Explorer, applications, and various accessories.
Word/Excel/PowerPoint Shortcuts
Prerequisite=Word-Level 1 training or experience
Explore shortcuts that work in Microsoft Office (Word, Excel, and PowerPoint) as well as shortcuts that work in each individual program. Both keyboard and mouse shortcuts will be presented. Using shortcuts will make you more productive in using the Microsoft Office suite.
Outlook 2003- Calendars
Prerequisite=Windows training or experience
Use Outlook 2003 to create appointments as well as explore how to edit, move, copy, and delete them. Create and edit recurring appointments and coordinate meetings and activities. Explore various ways to display the calendar as well as save an e-mail as an appointment.
Outlook 2003- E-Mail
Prerequisite=Windows training or experience
Send, receive, forward, organize, and delete mail as well as send and receive files as attachments with Outlook 2003. The Sent Items and Deleted Items folders will be explored and the necessary maintenance requirements will be discussed. Frequently used e-mail addresses will be saved for easy reuse.
Outlook 2003- Level 1
Prerequisite=Windows training or experience
Create, address, format and send messages. Add an automatic Signature and check spelling and grammar. Open messages in the inbox, reply and forward to others. Delete and restore messages as well as use techniques to select multiple messages. Attach a file and investigate Send options such as marking a message as important or asking for a Read Receipt. Organize your mailbox by creating additional folders, moving and copying messages into folders, and deleting folders. Explore print options. Add appointments to the calendar. Edit, move and copy appointments, and create recurring appointments. Add and edit contacts to the contact folder and view the contact list in different ways. Use Sort and Find tools.
Outlook 2003- Level 2
Prerequisite=Outlook 2003-Level 1 training or experience
Adjust message and delivery settings and explore calendar default settings Outlook 2003. Change e-mail delivery options and create a distribution list. Group, organize, and color-code messages. Search for specific messages in the inbox. Learn to create Rules to help manage the Inbox. Create and modify Views and adjust sorting and filtering settings. Color-code calendar entries and apply conditional formatting. Delegate a task, reply to a task request, specify settings for tracking assigned tasks, and share task information with other users.
Outlook 2002- Calendars
Prerequisite=Windows training or experience
Learn the fundamentals of using Outlook 2002 to coordinate meetings and activities. Create appointments as well as explore how to edit, move, copy, and delete them. Create and edit recurring appointments. Explore various ways to display your schedule as well as save an e-mail as an appointment.
Outlook 2002- E-Mail
Prerequisite=Windows training or experience
Students will learn how to send, receive, forward, organize, and delete mail as well as send and receive files as attachments. The Sent Items and Deleted Items folders will be explored and the necessary maintenance requirements will be discussed. Frequently used e-mail addresses will be saved for easy reuse.
Outlook 2002- Level 1
Prerequisite=Windows training or experience
Create, address, format and send messages. Add an automatic Signature and check spelling and grammar. Open messages in the inbox, reply and forward to others. Delete and restore messages as well as use techniques to select multiple messages. Attach a file and investigate Send options such as marking a message as important or asking for a Read Receipt. Add appointments to the calendar. Edit, move and copy appointments, and create recurring appointments. Schedule a meeting with multiple participants, reply to meeting requests, and track meeting responses. Add and edit contacts to the contact folder and view the contact list in different ways. Use Sort and Find tools. Organize your mailbox by creating additional folders, moving and copying messages into folders, and deleting folders. Explore print options.
Outlook 2002- Level 2
Prerequisite=Outlook-Level 1 training or experience
Modify message and delivery settings and explore other Outlook 2002 default settings. Create and use a distribution list. Share contact information with other users, export contact lists, link items to a contact, and forward a note to a contact. Delegate a task, reply to a task request, specify settings for tracking assigned tasks, and share task information with other users. Sort messages using multiple criteria. Group, organize, and color-code messages. Search for specific messages in the inbox. Learn to create Rules to help manage the Inbox. Use shortcuts and modify the Outlook environment, including the Outlook bar and toolbars. Create and modify Views and adjust sorting and filtering settings. Color-code calendar entries and apply conditional formatting.
Outlook 2002- Level 3
Prerequisite=Outlook-Level 2 training or experience
Manage contact information in Outlook. Create a Mail Merge using Outlook contacts.
Track activities by using the Outlook Journal to record entries automatically and manually record and modify journal entries. Publish free/busy information over the internet. Add an internet shortcut and insert a hyperlink. Compress (zip) and decompress a file or folder in order to reduce file size and work within e-mail size limits. Discuss different approaches used to write e-mail. Make business communications more effective by using the MADE format. Present techniques that will help improve writing clarity as well as reduce writing time. Explore various methods for organizing your thoughts. Examine common spelling and grammar errors.
PowerPoint 2003-Level 1
Prerequisite=Windows training or experience
Course description coming soon.
PowerPoint 2003-Level 2
Prerequisite=PowerPoint-Level 1 training or experience
Course description coming soon.
PowerPoint - Getting Started
Prerequisite=None
Course description coming soon.
PowerPoint 2002- Animation
Prerequisite=PowerPoint-Level 1 training or experience
Learn to add, edit and animate text and graphic objects. Explore tools for adding, reorganizing and removing animated effects. Apply Entrance, Emphasis, Exit, Motion Paths special effects as well as draw custom paths. Group, ungroup, layer, and position ClipArt then animate it in order to create unique effects.
PowerPoint 2002- Level 1
Prerequisite=Windows training or experience
Learn how to navigate through a slide show and become acquainted with the various on-screen features and views. Create a presentation based on a design template. Build a PowerPoint presentation, adding and editing Title and Bullet slides as well as an organization chart, table and a bar chart. Use drawing tools, add Autoshapes, Clipart and WordArt objects. Create and modify drawn objects on slides. Apply formatting to text slides in a presentation and explore printing options. Add transitions and basic animation. Prepare a presentation for delivery.
PowerPoint 2002- Level 2
Prerequisite=PowerPoint-Level 1 training or experience
Define, access, and modify the Slide Master and change background settings. Add, edit and animate graphic elements. Group, ungroup, layer and position ClipArt and graphics. Create a design template that you will apply to a presentation. Work with slide enhancements such as special effects and sound. Set up an automated slide show and prepare speakers notes. Take meeting notes and assign action items during a slide show. Prepare a presentation for use on other PC’s by using the Pack and Go Wizard. Use various techniques to deliver a presentation.
PowerPoint- Design
Prerequisite=PowerPoint-Level 1 training or experience
Learn the Do’s and Don’t's of creating an effective presentation. Explore elements of screen design and color usage that draw the viewer’s attention rather than distract from your content. Practice ways to use and enhance photographs in a presentation, use images to create eye-catching backgrounds and apply custom animation to text and graphics.
Project Management Fundamentals
Prerequisite=Windows training or experience
Course description coming soon.
Microsoft Project 2003-Level 1
Prerequisite=Windows training or experience
Course description coming soon.
Publisher 2003- Level 1
Prerequisite=Windows training or experience
Discover how to produce and manage a publication and modify its layout and structure. Create text boxes and divide information between text boxes by connecting them. Control text wrapping, indents, spacing and paragraph flow. Break text into columns. Create and use a Master Page. Insert, format and crop pictures. Move, copy, and resize text and graphic objects.
Security Awareness for PC’s
Prerequisites=Introduction to the Internet and Introduction to Personal Computer training or equivalent knowledge.
Provide students with an introduction to common security threats and issues, as well as ways to counteract them. Explore settings and features in Windows XP that affect security. Learn to identify and protect yourself and your information against risks associated with using e-mail and e-mail attachments. Identify common social engineering tactics and how to counteract their effectiveness. Determine when security has been compromised and what you should do.
PC Problem Solving
Prerequisite=Windows training or experience
Learn the various steps and features used to analyze problems that may occur on your PC and how to decide when to get professional help. Explore the options for changing automatic Shutdown/Power Off settings. Use the Search tool to locate missing files, restore deleted files from the Recycle Bin and explore basic problem solving techniques. Locate system settings and device management tools.
Getting Started with Windows XP
Prerequisite=Introduction to PC’s training or experience
Learn basic computer concepts for personal computers and be introduced to Windows XP terminology. Explore various methods to access Windows features by using the mouse, menus, icons and shortcut menus. Navigate to information stored on the computer and network. Manipulate open windows, use Help and Support tools, access an object’s properties. Use My Computer and Windows Explorer to manage files and folders, create shortcuts, and work with the Recycle Bin. Use Sort and Search features and cover basic troubleshooting techniques. Practice Windows XP techniques and shortcuts that are useful in various software applications.
Introduction to Microsoft Word
Prerequisite=Windows training or experience
Create a simple document, save a document, use Microsoft Word's automatic text features for entering text, and access online help. Make changes to an existing document using a variety of editing techniques. Apply text formatting to a document. Change the appearance of a document by applying various paragraph formats and effects. Create a table, navigate and enter text in a table, and enhance its appearance through formatting. Use Word's templates and wizards, symbols, fields, Find and Replace, and proofing tools to efficiently do your work. Preview a document, apply and remove formatting that affects entire pages, and print a document.
Mass Mailing Using Microsoft Word
Prerequisite=Word 2002-Level 1 training or experience
It is highly recommended that students have introductory-level knowledge of Microsoft Word. Learn to create form letters, labels and envelopes using the same file for names and addresses with Word’s Mail Merge function. Students will step through the entire process needed to create a complete Mail Merge application. A merge application will also be developed from already existing tables.
Master Headers & Footers using Microsoft Word
Prerequisite=Word-Level 1 training or experience
Use Microsoft Word’s Headers and Footers function to repeat information at the top and bottom of multiple pages. Break Word documents into sections in order to change the header/footer information for different parts of a document. Remove a header and/or footer from a particular page of your file. Edit documents containing multiple headers and footers. Set page numbering and change the page numbering style.
Word 2002- Level 1
Prerequisite=Windows training or experience
Create a simple document, save a document, use Microsoft Word's automatic text features for entering text, and access online help. Make changes to an existing document using a variety of editing techniques. Apply text formatting to a document. Change the appearance of a document by applying various paragraph formats and effects. Create a table, navigate and enter text in a table, and enhance its appearance through formatting. Use Word's templates and wizards, symbols, fields, Find and Replace, and proofing tools to efficiently do your work. Preview a document, apply and remove formatting that affects entire pages, and print a document.
Word 2002- Level 2
Prerequisite=Word 2002-Level 1 training or experience
Create and modify custom templates, apply existing styles, and create a custom style. Enhance a table by merging table cells, sorting and calculating table data, and creating charts based on various table data. Learn how to insert, manipulate, and format graphic images, including clip art, autoshapes, wordart, and organization charts. Create a newsletter using columns, sections, and graphics. Use the mail merge wizard to mail merge form letters, complete with mailing labels. Create a web page, create and edit a hyperlink, save and preview a web page, as well as enhance a web page by applying themes. Include comments in a document and compare and merge documents.
Word 2003- Level 1
Prerequisite=Windows training or experience
Create a simple document, save documents, use Microsoft Word's automatic text features for entering text, and access online help. Make changes to an existing document using a variety of editing techniques. Apply text formatting to a document. Set, change and remove tabs and change the appearance of a document by changing indents and other formats. Create a table, navigate and enter text in a table, and enhance its appearance through formatting. Adjust margins, preview documents, as well as insert symbols and graphics.