COMPUTER CLASSES
by Tania (Tatiana) Gnesdilova
tania.gnesdilova@wbfn.org—703-920-0901;
MS Windows Vista
Basic features of computers
Time: 9:30am-12:30pm
Venue: J Building, Room JB1-065, 701 18th Street NW
Dates: September 13-15; November 29-December 1, 2010; February 2-4, 2011
Prerequisite: none; this course is a prerequisite to all other courses here
Fee: for members $80; for non members $100.00
A 3-day course that explains the basic features of the Windows system. It is highly recommended if you are just beginning to work with computers.
Highlights
Half-hour presentation on how computers work; organization of the computer’s memory and the place of Windows system in it. Desktop organization: dealing with Windows files and programs, saving files, organizing files and folders; using the control panel for screen savers, customization of desktop wallpaper, mouse, keyboard, colors, etc.; using Help.
MS Internet Explorer
Internet basics, e-mail
Time: 9:30am-12:30pm
Venue: U Building, 3rd Floor, Room 500, 1800 G Street NW
Dates: October 14-15, 2010; February 14-15, 2011
Prerequisite: knowledge of the Windows system
Fee: for members $120; for non members $140.00
A 2-day course will give you a general idea of the Internet and how it works, and teaches you how to use Internet Explorer, a special program that helps you browse the Internet, send and organize your email messages, perform Internet searches and other useful tips.
Highlights
Learn how to navigate and search the Internet efficiently, send and organize your email messages properly.
Introduction to MS Word 2007
Text Formatting
Time: 9:30am-12:30pm
Venue: U Building, 3rd Floor, Room 500, 1800 G Street NW
Dates: September 27-October 1; December 6-10, 2010; Febrauary 28-March 4, 2011
Prerequisite: knowledge of the Windows system
Fee: for members $140; for non members $170.00
A 5-day course that teaches all the main features of the popular text-processing application MS Word. Actually, it is much more than an introduction, you will learn how to make a table of contents and even work with tables. If you want to edit text quickly and efficiently, this course is for you.
Highlights
Customizing the standard toolbar, saving text, insertion/override modes, undo, select/copy/move blocks of text, the formatting toolbar, margins, paragraph formatting, page numbers, printing, checking spelling/grammar, setting up the language, headers and footers, footnotes/Endnotes, style boxes, format painter, tables of contents, AutoText and AutoCorrect, AutoSummarize, comparing documents, working with tables.
Intermediate MS Word 2007
Mail merge, drawing
Time: 9:30am-12:30pm
Venue: J Building, Room JB1-065, 701 18th Street NW
Dates: November 8-10, 2010; April 18-20, 2011
Prerequisite: knowledge of the Windows system, Introduction to MS Word or equivalent
Fee: for members $120; for non members $140.00
A 3-day course that teaches advanced techniques of MS Word, such as making flyers, envelopes, mailing labels and mail merge using databases.
Highlights
Creating a main document; creating a data source; entering records into a data form; altering field names in an existing data source (editing the data source); inserting fields into the main document; merging the main document & the data source; querying the data source; dealing with pictures, text animation; sending a flyer by e-mail; creating charts, and much more.
Introduction to MS Excel 2007
Accounting Oriented Program
Time: 9:30am-12:30pm
Venue: J Building, Room JB1-065, 701 18th Street NW
Dates: October 12-13, 2010; February 16-17, 2011
Prerequisite: knowledge of the Windows system
Fee: for members $120; for non members $140.00
A 2-day course that teaches how to create a spreadsheet and database in this accounting-oriented program. You could, for example, create your home budget. It is a practical introduction to the creation, design, and use of spreadsheets in the business environment. Emphasis will be placed on basic functions including creation, formatting, maintenance, graphing, and printing of spreadsheets. This course is designed for beginning spreadsheet users.
Highlights
Dealing with an Excel worksheet and workbook moving techniques; add/delete/resize columns and rows; learn what are Excel types of data; creating formulas; undo; selecting and manipulating ranges, naming ranges; functions with 3-dimensional references; moving/copying data; copying formulas with cell references; relative and absolute references; filling in a series of data; formatting techniques; charts, pictures; print preview and setup, printing techniques.
Lessons can be applied to budgets, marketing and sales reports, expense reports, invoices and purchase orders, basic financial statements, and spreadsheet information for use on the Intranet/Internet.
Advanced to MS Excel 2007
Accounting Oriented Program
Time: 9:30am-12:30pm
Venue: J Building, Room JB1-065, 701 18th Street NW
Dates: January 20-21, 2011
Prerequisite: Basic knowledge of the MS Excel
Fee: for members $120; for non members $140.00
A 2-day course that teaches how to deal with conditional formatting, advanced formulas such as VLookup, HLookup, Match, Concatination, etc., as well as working with Pivot Tables and Charts, IF and Nested If functions and many more.
Highlights
Lessons can be applied to budgets, marketing and sales reports, expense reports, invoices and purchase orders, basic financial statements, and spreadsheet information for use on the Intranet/Internet.
Introduction to MS Access 2007
Database Program
Time: 9:30am-12:30pm
Venue: U Building, 3rd Floor, Room 500, 1800 G Street NW
Dates: March 14-16, 2011
Prerequisite: knowledge of the Windows system
Fee: for members $120; for non members $140.00
This 3-day course teaches how to design and create a database, make queries, reports and forms. Practice by creating your own database for your book collection/wine/spices or address book.
Highlights
Introduction and general information; definition of table and record; toolbars; opening/creating a database; table views; design; types of queries; creating and designing a query using a wizard, forms, design view; wizard for creating forms, reports, relationships; saving databases; copying and transferring data from one database into another.
Intro to MS PowerPoint 2007
Slide Shows, Presentations
Time: 9:30am-12:30pm
Venue: J Building, Room JB1-065, 701 18th Street NW
Dates: September 16-17; November 11-12, 2010; January 31 - February 1, 2011
Prerequisite: knowledge of the Windows system
Fee: for members $120; for non members $140.00
This is a 2-day course that teaches how to create slide-shows and presentations using text, shapes, Clip Art pictures, photos, transitions, etc.
Highlights
Orientation to the PowerPoint screen; presentation views; formatting; using the HELP system, Word Art tool, Clip Art tool, tables, Microsoft chart, templates and slide master, slide sorter, transactions and animation in a slide show; running a show; using speaker notes; printing the presentation.
Web Page Creation
HTML, Dreamweaver - Part 1
Time: 9:30am-12:30pm
Venue: U Building, 3rd Floor, Room 500, 1800 G Street NW
Dates: October 25-27, 2010; January 10-12, 2011; April 4-6, 2011
Prerequisite: Knowledge of the Windows system
Fee: for members $120; for non members $140.00
This is a 3-day course that teaches how to design and create a basic web page and how the Web works. Come and see that it is not so hard at all!
Highlights
Page mapping; organization of the website; tags, comments, head, title, meta, body, headings, lists, preformatted text, formatting, colors, hypertext links, email links, pictures, tables, frames.
Web Page Creation
HTML, Dreamweaver - Part 2
Time: 9:30am-12:30pm
Venue: U Building, 3rd Floor, Room 500, 1800 G Street NW
Dates: October 28-29, 2010; January 18-19, 2011; April 7-8, 2011
Prerequisite: Basic Knowledge of Dreamweaver
Fee: for members $120; for non members $140.00
This is a 2-day course. Learn advanced topics such as frames, CSS, styles, templates and more.
Introduction to Adobe InDesign
Newsletters, Brochures
New as of May 2008: Transition from PageMaker to InDesign!
Time: 9:30am-12:30pm
Venue: U Building, 3rd Floor, Room 500, 1800 G Street NW
Dates: TBA
Prerequisite: knowledge of the Windows System
Fee: for members $120; for non members $140.00
This 2-day course teaches the basics of this professional industry standard page layout program to produce newsletters (Mosaic for example), brochures, catalogs, etc.
Highlights
Getting familiar with the InDesign document window, guides or help lines; open publication; page management; tool box/palette; text blocks and stories; text formatting; working with graphic objects; text wrap; master pages; columns, footers/headers, folios/page numbers, the style palette; saving files; some good practice rules for desktop publishing when starting a publication from scratch.
Adobe Photoshop Intro
Edit, enhance digital photos
Time: 9:30am-12:30pm
Venue: U Building, 3rd Floor, Room 500, 1800 G Street NW
Dates: TBA
Prerequisite: knowledge of Windows System
Fee: for members $120; for non members $140.00
This 3-day course teaches you how to handle images—size, resolution; file format; how to store and exchange pictures.
Highlights
Basic features of Photoshop will be covered along with the Photoshop interface, toolbox, palettes and layers.
Please, bring your digital camera if you wish to learn how to download and edit photos.