|
COURSE
DESCRIPTIONS |
| |
CONCEPTS |
| |
ESSENTIAL
INTRODUCTION TO COMPUTERS
A thorough, but gentle, introduction to fundamental personal computing
concepts and terminology for the true beginning computer user. Topics
include: how computers work; starting the computer; mouse and keyboard
basics; other input devices; processing data; floppy disks; hard disks;
printers; working with simple applications. |
| |
OPERATING
SYSTEMS |
| |
WINDOWS
XP: Introduction
Syllabus includes: Getting started with Windows XP: introducing the
Windows XP desktop; using the taskbar and Start menu; working with window
components. Getting help: the Help and Support Center; The Favorites
and History lists. Working with My Computer and Windows Explorer. Working
with files: creating files and folders; managing files and folders;
working with floppy disks; working with the Recycle Bin. Working with
WordPad and Paint. Customizing your workstation: creating and deleting
shortcuts; using the Control Panel. |
| |
|
| |
WORD
PROCESSING |
| |
Microsoft
WORD: Introduction
Syllabus includes: Word basics: exploring the Word window; creating and
saving documents; printing documents; using Help. Editing documents:
opening and navigating a document; using AutoCorrect; editing text; using
Undo and Redo. Moving and copying text: selecting text; moving and copying
text; finding and replacing text. Formatting characters and paragraphs:
character formatting techniques; using tabs; paragraph formatting techniques;
advanced paragraph formatting techniques. Creating and managing tables:
creating tables; modifying tables; enhancing tables. Controlling page
layout: creating headers and footers; working with margins; working with
page breaks. Using proofing tools: checking spelling and grammar;
using the Thesaurus. Web features: saving and opening a document as a
Web page; adding hyperlinks; sending Word documents via e-mail.
|
| |
Microsoft
WORD: Intermediate
Syllabus includes: Working with sections and columns: creating sections;
multiple columns; working with text in columns. Formatting tables: table
formatting basics; applying borders and shading; using Table AutoFormat;
drawing tables. Working with imported data: working with Excel data in
tables; performing calculations in tables; moving tables. Using styles
and AutoText: defining and applying styles; modifying and deleting styles;
using styles to create outlines; using AutoText and AutoFormat. Working
with headers and footers: creating different headers and footers; working
with page numbering. Working with graphics: inserting graphics and files;
inserting WordArt and symbols; creating watermarks; drawing in a document;
applying borders and shading. Introduction to templates: using a template;
creating a template. Workgroup collaboration: compare and merge documents;
adding comments. Printing options: advanced printing options; printing
labels and envelopes. |
| |
Microsoft
WORD: Advanced
Syllabus includes: Creating form letters and addressing envelopes: using
the Mail Merge Wizard; using data source files; mergin addresses into
mailing labels. Working with forms: creating forms; exploring form field
data types; modifying forms; protecting forms. Working with large documents:
creating master documents and table of contents; using endnotes and footnotes;
creating indexes; working with bookmarks and cross-references. Managing
document revisions: tracking changes in a document; comparing document
versions; adding comments and highlighting. Automating actions with macros:
recording and running macros; editing macros; using macros in forms; creating
and deleting custom menus and custom toolbars. |
| |
|
| |
SPREADSHEETS
|
| |
Microsoft
EXCEL: Introduction
Syllabus includes: Excel basics: spreadsheet terminology; Excel window
components; getting help; opening and navigating workbooks; closing workbooks.
Entering and editing data: creating workbooks; entering and editing labels
and values; entering and editing formulas; saving and updating workbooks.
Modifying a worksheet: moving and copying data; moving and copying formulas;
using relative references and absolute references; inserting and deleting
ranges. Using functions: entering functions; using AutoSum; using AVERAGE,
MIN, and MAX. Formatting worksheets: formatting text; formatting
rows and columns; number formatting; other formatting features.
Printing: preparing to print; Page Setup options; printing. Creating charts:
chart basics; modifying charts; printing charts. Web features: saving
worksheets as Web pages; hyperlinks; workbooks and e-mail. |
| |
Microsoft
EXCEL: Intermediate
Syllabus includes: Working with large worksheets: viewing options, hiding/displaying
data, printing large worksheets. Working with multiple worksheets and
workbooks: using multiple worksheets; linking worksheets using 3-D formulas;
consolidating data; linking workbooks; managing workbooks. Ccustomizing
Excel: changing options, customizing toolbars and menus. Advanced charting:
chart formatting options; creating combination charts; using graphic elements.
Advanced formatting: borders and shading; special number formats; working
with dates; working with styles; other advanced formatting. List management:
working with lists; sorting and filtering lists; advanced filtering. Documenting
and auditing: comments and text boxes; auditing features; protection;
workgroup collaboration. Using templates: built-in templates; creating
and managing templates. |
| |
Microsoft
EXCEL: Advanced
Syllabus includes: Working with advanced formulas: using names; decision-making
functions; creating nested functions; using financial functions.
Lookups and data tables: working with lookup functions; using MATCH and
INDEX; creating data tables. Advanced list management: creating subtotals;
validating cell entries; exploring database functions; working with data
forms. Working with PivotTables: PivotTables; Rearranging PivotTables;
formatting PivotTables; working with PivotCharts. Exporting and importing:
exporting and importing data; querying external databases. Using analytical
options: work with Goal Seek and Solver; working with Scenarios; working
with views. Working with macros: recording and running macros; working
with VBA code; function procedures. Interactive Web pages: creating interactive
Web spreadsheets; publishing PivotTables on the Web. |
| |
|
| |
DATABASES
|
| |
Microsoft
ACCESS: Introduction
Syllabus includes: Database concepts:database concepts and terminology;
exploring the Access environment; planning and designing databases; getting
help; closing a database and Access. Access basics: exploring tables and
forms; examining queries; exploring reports. Creating databases: creating
a database; using the Table Wizard; working with tables in Design View.
Working with fields and records: changing the design of a table; adding
and deleting records; finding and editing records; sorting and filtering
records. Querying tables: creating and using queries; modifying query
results and queries; using calculations in queries. Creating and
using forms: creating forms by using AutoForm; using the Form Wizard;
using Design view; finding, sorting and filtering records. Creating and
using reports: using the Report Wizard and queries; creating, modifying,
and printing reports. Importing, exporting, and linking objects: importing
Access objects; exporting Access objects; linking Access objects.
|
| |
Microsoft
ACCESS: Intermediate
Syllabus includes: Creating relational databases: database normalization,
relating tables, implementing referential integrity. Working with related
tables: using the lookup wizard; modifying lookup fields; adding data
to related tables. Defining data entry rules: working with input masks;
setting properties; setting validation rules. Using advanced query features:
joining tables in queries; creating calculated fields; using action queries.
Using advanced queries: summarizing and grouping values; creating crosstab
queries; using parameter queries; using indexes. Creating advanced form
design: adding graphics; adding calculations; adding combo boxes; adding
unbound controls. Using advanced report features: creating customized
headers and footers; adding calculated values; working with subreports.
Creating charts: creating charts in forms; creating charts in reports.
|
| |
|
| |
CONTACT
MANAGEMENT |
| |
Microsoft
OUTLOOK: Introduction
Syllabus includes: Outlook basics: an introduction
to Outlook; exploring the Outlook window; examining the shortcut groups;
using the Outlook 2000 shortcuts to access folders; using the folder list
and the advanced toolbar; accessing folders from Outlook Today; customizing
Outlook Today; using Help; creating and sending messages; attaching a
file to a message; saving attachments; replying to and forwarding messages;
deleting and undeleting messages; using address books; printing messages;
flagging e-mail messages; defining delivery options; working with contacts;
managing tasks; working with appointments; recurring appointments; exploring
day, week, and month views; categories; working with events; meeting requests;
working with personal folders; working with the Organize page; managing
junk mail; working with signatures. Prerequisite: WIN101 or equivalent
knowledge. |
| |
|
| |
PRESENTATION
TOOLS |
| |
POWERPOINT:
Introduction
Syllabus includes: PowerPoint basics: exploring the PowerPoint environment;
Help options; closing presentations and closing PowerPoint. Building new
presentations: creating new presentations; saving presentations; working
in the Outline tab; rearranging and deleting slides; using slides from
other presentations. Formatting and proofing: exploring text formatting;
moving and copying text; settings tabs and alignment; using the Spelling
checker; examining AutoCorrect and the Style Checker. Using Drawing
tools: drawing objects; using AutoShapes; working with text in objects;
enhancing objects. Working with WordArt and clip art. Using tables and
charts: working with tables; creating and enhancing charts; creating organization
charts. Enhancing presentations: using templates; working with the slide
master; working with multiple slide masters; adding transitions and timings;
adding speaker notes and footers. Delivering presentations: running presentations;
printing presentations; exporting to other formats; saving presentations
for Web delivery. |
| |
POWERPOINT:
Advanced
Syllabus includes: Building custom presentations: using templates;
building custom templates; building custom slide masters; advanced slide
master techniques; using AutoLayout. Using multimedia in presentations:
advanced clip art and drawing techniques; adding movies and sounds; using
animations; using scanned images. Microsoft Office integration with PowerPoint:
working with Excel; working with Word. Working with organization charts
and tables: advanced organization chart options; formatting and enhancing
tables. Advanced presentation techniques: adding special effects; working
with slide show options; setting up review options. Advanced presentation
delivery options: broadcast presentations; working with the Pack and Go
Wizard; advanced delivery techniques. Customizing the PowerPoint environment:
working with toolbars; automating your work. |
| |
|
| |
INTERNET
|
| |
Surfing
and Searching the World Wide Web
A thorough, but gentle, introduction to the Internet and the World Wide
Web. Topics include: Internet basics, browser basics, visiting
popular web sites, e-mail, favorites, and getting information. Learn how
to choose appropriate Internet search tools, including search engines,
directories, and meta-search engines, and learn to use these tools more
efficiently and effectively. Construct basic queries in variety of search
tools; use engine-specific basic and advanced search operators; use Boolean
operators. |
| |
AMERICA
ONLINE E-mail
AOL is a private, easy-to-use network of content and community. This popular
commercial online service is used by millions of people in the United
States. In this class, learn to read and send messages;
reply to and forward mail; work with the Address Book; print, save, and
delete messages; attach files to a message; download attached files; and
more. |
| |
|
| |
WEB
PAGE CREATION |
| |
FRONTPAGE:
Introduction
Syllabus includes: FrontPage basics: examining the FrontPage environment;
working in Page view. Working with Web pages: designing web pages; formatting
web pages; adding lists to Web pages. Enhancing Web pages: adding active
elements to Web pages; changing page properties; applying themes to Webs.
Creating hyperlinks: linking pages within a Web; linking to external pages;
working with navigation bars and shared borders; renaming pages. Adding
graphic features to Web pages: adding graphic files; using graphics to
link Web pages. Creating tables: adding tables to Web pages; formatting
tables. Creating frames: working with frames and frames pages; modifying
frames pages. Managing and publishing Web and Web pages. |
| |
HTML:
Introduction
Topics include: creating a simple HTML document; adding body text to an
an HTML page; creating headings and paragraphs; adding comments; formatting
body text; setting alignment; inserting and formatting horizontal rules;
adding hyperlinks to another web site; adding a hyperlink to a point within
a page; sending an e-mail from a page; adding images; aligning text around
an image; using a graphic as a hyperlink; adding a background color; adding
a background image; adding lists: unordered, ordered, definition; creating
tables; nested tables; introduction to style sheets. |
| |
|
| |
E-MAIL
|
| |
E-MAIL:
OUTLOOK EXPRESS
Learn to setup Outlook Express, send e-mail, check incoming mail, attach
a file to an e-mail message, save an e-mail attachment, reply to an e-mail
message, forward an e-mail message, file an e-mail message, delete an
e-mail message, maintain an address book, and create a mailing list.
|
| |
E-MAIL:
NETSCAPE MESSENGER
Learn to setup Netscape Messenger, send e-mail, check incoming mail, attach
a file to an e-mail message, save an e-mail attachment, reply to an e-mail
message, forward an e-mail message, file an e-mail message, delete an
e-mail message, maintain an address book, and create a mailing list.
|
| |
|
| |
GRAPHICS
|
| |
PHOTOSHOP
7.0: Basic
Syllabus includes: Exploring the PhotoShop environment: Touring PhotoShop;
creating and saving files. Working with images: using the viewing tools;
modifying image properties; cropping an image. Working with selections:
manipulating selections; using the Marquee and Lasso tools; using the
Move and Magic Wand tools; modifying image areas. Creating an image: using
the Pencil tools; using the Brush and Airbrush tools; using the Clone
Stamp, Pattern Stamp, and Pattern maker plug-in tools. Working with vector
graphics: using the Shape tools; using the Pen tool; using the Direct
Selection and Path Selection tools. Working with Colors and Color Settings:
working with the Color palette; setting the Color gamut; working with
the Color Picker; using the Paint Bucket and Eyedropper tools. Manipulating
layers: working with layers; managing and manipulating layers; adding
Type layers. Modifying photographs: using the retouching tools; using
other retouching tools; using the Gradient tool; working with the Eraser
tools. |
| |
|
| |
DESKTOP
PUBLISHING
|
| |
Microsoft
PUBLISHER: Introduction
Topics include: exploring the Publisher environment;
Help options; creating basic documents; setting page properties; using
text frames; adding pictures; formatting text; changing paragraph properties;
using editing tools; working with multi-page documents; adding a background;
inserting objects and graphics; adding special effects; adding tables;
printing publications. |
| |
PAGEMAKER
7: Introduction
Topics include: exploring the PageMaker environment;
using Help; creating single-page publications; modifying text; working
with text blocks; printing publications; creating a multi-page publication;
managing text flow; working with frames; working with pages; including
drawing objects; adding graphics; formatting characters; applying Kerning;
using Tracking options; arranging text around graphics; formatting paragraphs;
using tabs; using styles; working with Story Editor; using typography
techniques. |
| |
ADOBE
ACROBAT: Introduction
Learn how to create, edit, and manage your library of electronic PDF files.
Topics include: Acrobat overview; creating PDF files; building documents;
annotating and editing documents; adding navigation, sound, and movies;
Acrobat catalog. |
| |
|
| |
FINANCE
|
| |
QUICKEN:
Introduction
Learn to use this very popular personal finance software package. Learn
to set up credit card and checking accounts, to categorize transactions,
to add transactions to the register, to transfer funds, to split transactions,
to use memorized transactions, to balance a checkbook, and to create reports.
Prerequisite: WIN101 or equivalent knowledge. |
| |
|
| |
PALM
PILOTS |
| |
PALM
PILOT
In this workshop, you will learn to use the basic applications: Date Book,
Address Book, To Do List, Memo Pad, Calculator, and Expense. You will
experiment with tapping, typing, and using Graffiti writing for entering
data. Learn how to exchange and update data with HotSync operations,
to synchronize Palm Mail with your desktop e-mail (we will be using Outlook
Express as the desktop mail), to beam information from your Palm Organizer
to another Palm Organizer, and to customize preferences. Bring your own
Palm Pilot. |
| |
|
| |
|
|
|
|
