Email or call the Librarian - Tom DeChaine: tld@objective.org. When a CD you have requested becomes available and it is your turn to review it, you will be notified by Email.

If you do not respond (Email or phone) by the next couple days, someone else may be offered that CD; however, you will be next in line after you respond.

You will have use of each CD for 3 days minimum (depending on demand); you should have ample time to go through the instruction as much as necessary.

No one can have more than 1 CD set at a time except where no demand exists.

It will be the responsibility of a new user to obtain the CD from its current user (if checked out from the Library). Each party of an exchange will be notified of the other to enable communications to expedite the exchange. If no one is waiting for a CD in use, the current user will return it to the librarian.

 

Access 00: Database Management

Creating a database, creating tables, entering data, creating and modifying Forms

Using table/form Wizards, creating a table in datasheet view, table relationships, creating Queries, using queries in forms, creating and modifying reports, queries with multiple tables, creating a custom Report

Importing data into an Access database, using the Find Duplicates Query wizard, select queries vs. action queries, using tables between 2 databases, using a union query

Excel 00: Spreadsheets

Excel environment, building a budget, saving Files to disk, working with Formulas, performing "what-if" analysis, formatting, printing

Working with multiple Worksheets, creating Charts, manipulating chart elements, calculating income and expenses, absolute and relative Cell addresses, changing Variables, creating a summary page

Database fundamentals, building a payroll database, using the IF function, modifying an existing database, finding records, sorting data, performing Queries.

Front Page 00-03: Web Page Design

1. Web site basics, FP environment, Views bar, exploring Themes, creating a site, shared Borders

2. Inserting and working with Images, working with Text, developing your site, Hyperlinks, Bookmarks

3. Creating and manipulating Tables, Frames, Publishing your site.

1. How the Internet works, coding your 1st page,   formatting text with HTML, advanced formatting, Hyperlinking, HTML Table basics.

2. Color on the web, understanding web graphics, Image attributes, optimizing images for the web, formatting a page with Tables, advanced table layout, linking with image maps.

1.  Using Earthlink as a connection/exploration example Server, Email (using Earthlink), exploring the WWW, adding custom web site Links to start page, SideCar

2.  Customize a stock portfolio, searching the Web, using Chat Rooms, Bulletin Boards, Newsgroups, downloading files

3.  Customizing IE 5.0, using Stationery, Email an link, attaching files, group Email, the Web integrated desktop, accessing Server from other locations, downloading files and graphics

Outlook 00: Personal Information Manager

1. Setup, Outlook environment; Email basics, advanced and customization

2. Contacts, Calendar, Task Pad, Journal, Notes

3. Folders, locating information, organizing features, importing/exporting data, sharing information

Power Point 00: Graphical Presentations

Power Point environment, entering and modifying text, adding/deleting/arranging Slides, viewing a presentation

Using text Boxes and Auto Shapes in a presentation, using the Slide Sorter view, working with the Clip Art Gallery, checking a presentation for spelling and Styles errors, adding speaker notes and audience handouts

Creating charts, importing an Excel chart, managing a presentation's look, working with the Slide Master

Publisher 02: Desktop Publishing – business cards, brochures, flyers, newsletters, greeting cards, banners, web pages, etc.

1. Publisher environment, easy creativity, inserting text, working with text boxes, Clip Art, layout and design, finishing touches

2. Working with a Logo, creating a Business Card, WordArt, finishing touches, creating Stationary, using Mail Merge, creating an Invitation

3. Brochure design basics, advanced text and graphic editing, outside printing, putting it on the web

Quicken 00: Financial Management

1.  Creating a data file, the Quicken layout, working with the Check Register, editing the Category list, recording Split transactions, creating and printing checks, reconciling bank statements

2.  Using My Finances, working with a Credit Card account, scheduling transactions and automatic entries, setting up a loan, exploring the Planning Center, reports and graphs

3.  Connecting to the Internet, setting up an online checking account, setting up online payees, making online payments, connecting to an online bank account, working with an investing account, working with the Investment register, using Portfolio view, investment research

1.  Computer understanding, desktop interface, elements/contents of a window, Taskbar, Start button, files/folders - saving documents, Control Panel

2.  Using the File command, Files and Folders, creating a shortcut, working with Applets, using the Paint program

3.  Using Utilities, adding/deleting Win98 components, backing up files, multimedia options, creating custom toolbars

Windows ME (Learn2 – somewhat different process)

1. Introduction

Installation and orientation, Personalizing Me

Convenience and protection, Practice exercises

2. Advanced

Installing a digital camera, MP3 files

Games - installing/removing

Transferring pictures to your computer, editing home movies, Win. Media Player, archiving music, importing and playing

MP3s, recording sound

Disk cleanup, defragmentation, maintenance wizard, scandisk, scheduling tasks.

3. Networking

Networks - types, designs, topologies

Home networking requirements, cabling, and protocols

Inventory components needed, expansion slot basics, network adapters, connect computers, setup network software

Choosing an Internet host, Internet connection sharing, naming computers, sharing files and printer, home networking setup disk, configuring/connecting to other computers, managing files remotely

Passwords, logging on/off, sharing a printer, access control

Playing games, Me games

4. Internet

IntelliSense, Search Assistant, Reliving history, Content Advisor, Print preview, Offline browsing, Web accessories, Windows Radio

MP3 players, recommended downloadable sites, downloading music to MP3 player

Downloading MSN Messenger Service, viewing online contacts, Chatting with MSN Messenger, privacy and security

Sending/receiving/transferring files, chatting online, program sharing, security

Me Internet games, connecting to MSN Game Zone, playing games, downloading Skins and Visualizations.

1. Computer components, Desktop interface, elements/contents of a window, Taskbar, Start button, File folders, saving documents, Control Panel

2. Search command, Files & Folders, creating a Shortcut, Window’s Explorer, WordPad, Paint program

3. System tools, add/remove programs, using Backup, System restore, multimedia options

Word 00: Text Documents

1.  Word environment, entering and editing text, saving files, blocking and manipulating text, spell check and thesaurus, print documents, inserting graphics

2.  Exploring the normal Template, working with character formats, manipulating page formats, aligning text, working with Tabs, creating and using Styles

3.  Mail Merge basics, editing Fields, inserting fields in a form letter, adding fields and performing searches, creating Merge Envelops and mail merges