Computer Class Descriptions

Computer Class Descriptions

Each class is a one-time workshop lasting two to three hours.  For purposes of skill development, we highly recommend that you repeat the basic classes several times before taking the intermediate and advanced classes. Three of the 'basic' classes  are considered intermediate in terms of skill readiness.  Please note the required skills and objectives for each class.

MAVIS BEACON TEACHES TYPING

Practice tutorials and custom lessons for improving typing and keyboarding skills.

Required Skills 
The ability to read and comprehend English well.

Length: 2 hours

Class Objectives
You will be able to:

  • Practice home-row key typing in self-paced exercises
  • Test your typing skills at various levels of proficiency and speed
  • Customize practice lessons to enhance your typing skill abilities
  • Practice constructing your own résumé using MB's Print Shop Résumé Pro Deluxe program
Please bring your own earbuds for individual listening.

PC BASICS

Learn the basics of personal computing.

Required Skills
The ability to read and comprehend English well.

Length: 2 hours

Class Objectives 
You will be able to:

  • Identify basic computer components and operating system features
  • Execute basic mouse techniques
  • Perform basic keyboard strokes and functions
  • Identify and navigate the features of the Desktop
  • Open and exit software programs
  • Identify and navigate the various toolbars of the Windows environment
  • Create and save a document to the Desktop of to a flash drive (please bring your own flash drive)
  • PC Extra! - a three-hour presentation of the above, when advertised

WORD I BASICS

Learn the basics of Microsoft Office Word.

Required Skills
The ability to read and comprehend English well and the skills acquired in the PC Basics class.

Length: 2 Hours

Class Objectives 
You will be able to:

  • Identify and navigate the basic features and elements of the MS Word window
  • Execute multiple text selection techniques
  • Apply basic formatting features
  • Perform the Copy/Cut and Paste function
  • Execute the 'Find and Replace' and 'Go To' features
  • Explore a variety of templates for creating letters, résumés, faxes, reports, stationery and more
  • Apply themes, page borders, page colors and watermarks
  • Word I Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.

WORD II INTERMEDIATE

Learn more Microsoft Word features.

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics and Word I Basics.

Length: 2 hours - FAST-PACED!

Class Objectives
You will be able to:

  • Navigate and adjust default settings
  • Create and insert stylized headers and footers, footnotes and endnotes, table of contents, indexes and cover pages
  • Insert, move and resize graphics, SmartArt and stylized text boxes
  • Engage and apply the Bullets and Numbering feature of the Format menu
  • Insert special symbols and diacritical (accented) letters
  • Insert captions, page numbers and page breaks
  • Create, modify, enhance a table
  • Word II Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.

EXCEL I BASICS

Learn the basics of Microsoft Excel.

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics and Word I Basics.

Length: 2 hours

Class Objectives
You will be able to:

  • Identify and navigate the basic features and elements of the MS Excel window
  • Build a simple budget spreadsheet, using data entry and cell navigation skills
  • Format and edit spreadsheet data, using common and unique formatting features
  • Create simple formulas and calculate using the AutoSum feature
  • Explore the Insert Function feature for all other mathematical operations available in Excel
  • Create a chart, based on the simple budget database created in class
  • Excel I Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.

EXCEL II INTERMEDIATE 

Learn more Microsoft Excel features.

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics, Word II Intermediate and Excel I Basics.

Length: 2 hours - FAST-PACED!

Class Objectives
You will be able to:

  • Manage the screen view and navigate multiple worksheets in a workbook
  • Construct 3-D formulas, using the Consolidate feature, and execute the Paste Special function
  • Engage and perform the Auto Outline, Data Validation and AutoFilter features
  • Apply the stylized Conditional Formatting feature to spreadsheet data
  • Protect worksheet/workbook environment
  • Excel II Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.


EXCEL III ADVANCED

Learn to calculate, research and display table data using Excel formulas.

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics, Word II Intermediate, Excel I Basics and Excel II Intermediate

Length: 2 hours - FAST-PACED!

Class Objectives
You will be able to:

  • Calculate using the following formulas: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS
  • Research table data using the VLOOKUP and HLOOKUP formulas
  • Organize table data using PivotTables and PivotCharts
  • Trace precedents, show formulas, and apply the Watch Window feature
  • Excel III Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.


ACCESS I BASICS

Learn the basic concepts and structure of the Access application by building a simple relational database

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics, Word II Intermediate, Excel I Basics, Excel II Intermediate and Excel III Advanced

Length: 2 hours - FAST-PACED!

Class Objectives
You will be able to:

  • Identify and navigate the basics features and elements of the MS Access window
  • Create a data table
  • Store and manipulate data
  • Distinguish data types and how to join data based on data types
  • Import data from other sources
  • Use queries to perform basic calculations
  • Access I Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.

POWERPOINT BASICS

Learn the basics of Microsoft PowerPoint.

Required Skills 
The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics and Word II Intermediate.

Length: 2 hours - FAST-PACED!

Class Objectives
You will be able to:

  • Identify and navigate the basic features and elements of the Microsoft PowerPoint window 
  • Create a simple slide presentation using the AutoContent Wizard or design templates
  • Identify and engage the three working panes of the PowerPoint environment, i.e., outline pane, slide pane, notes pane
  • Edit and customize each slide, by engaging PowerPoint's "bells and whistles," e.g. custom animations, transition effects, sound, and insertion of graphics and links
  • Insert additional slides
  • Delete unwanted slides
  • Activate the slide show presentation
  • Save the presentation as a slide show (.pps) and as a presentation (.ppt)
  • Send both files to your e-mail account in order to tweak as an after-class activity
  • PowerPoint Extra! - a three-hour presentation of the above, when advertised


PUBLISHER BASICS

Learn to create exciting documents using the various templates of this powerful desktop publishing software

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics, Word II Intermediate, and PowerPoint

Length: 2 hours - FAST-PACED!

Class Objectives
You will be able to:

  • Identify and navigate the basic features and elements of the MS Publisher window
  • Explore a variety of templates and their document creation requirements
  • Create letterhead, business cards, a greeting card and a calendar suing the installed design templates
  • Format and link text boxes, insert WordArt and other graphics
  • Insert grid and ruler guides, manipulate margin settings
  • Insert additional pages and delete unwanted pages
  • Import a Word document into one of Publisher's stylized formats
  • Publisher Basics Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.

WEB I BASICS

Learn the basics of the World Wide Web.

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics and Word I basics

Length: 2 hours

Class Objectives 
You will be able to:

  • Distinguish between the Internet and the World Wide Web (www.)
  • Identify and navigate the basic elements and features of the Internet Explorer browser
  • Navigate the Web using hyperlinks
  • Explore the features and advantages of various search engines, including job boards
  • Perform simple Web searches and interpret results
  • Copy and paste Web text and graphics to a Word document
  • Web I Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.

WEB II INTERMEDIATE

Learn more about the World Wide Web.

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics, Word II Intermediate and Web I Basics.

Length:  2 hours - FAST-PACED!

Class Objectives 
You will be able to:

  • Identify and navigate the advanced elements and features of the Google search engine
  • Conduct searches using Boolean search terms
  • Modify your search strategy with various punctuations
  • Explore Meetup.com and LinkedIn.com for their advantages as social and professional networking sites
  • Copy and paste Web text and graphics to a Word document
  • Web II Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.

E-MAIL BASICS

Learn the basics of Web-based e-mail.

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics and Web I Basics.

Length: 2 hours

Class Objectives
You will be able to:

  • Identify and navigate the basic feature and elements of a Web-based e-mail environment
  • Read, send, forward and reply to e-mail messages
  • Apply formatting features to e-mail transmissions
  • Attach documents and graphics to an e-mail transmission
  • Activate e-mail options, e.g. signature, vacation responses, etc.
  • Create folders and insert e-mail addresses into an address book
  • Create Group / Distribution Lists
  • Use appropriate e-mail etiquette and identify e-mail abuse
  • E-mail Basics Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.

HTML BASICS

Learn the basics of simple Web page design.

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, WORD I Basics, Word II Intermediate, Web I Basics, Web II Intermediate and E-mail Basics.  A significant amount of typing is required!

Length: 2 hours - FAST-PACED!

Class Objectives 
You will be able to:

  • Use four basic HyperText Markup Language tags
  • Create a simple Web page using a text editor
  • Apply the appropriate enhancement tags for formatting text, inserting images  and creating hyperlinks
  • Apply attributes to existing tags, e.g. background color to the background tag
  • Save your .html document with its imported graphics to a disk (a free disk will be provided)
  • HTML Basics Extra! - a three-hour presentation of the above, when advertised
Please bring your own flash drive to save class documents or send them to your established email account.


INTERNET JOB SEEKING 101

Learn to use online job boards and job search engines to find the right job for you

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, Web I Basics and E-mail Basics. 

Length: 2 hours - FAST-PACED!

Class Objectives 
You will be able to:

  • Search, save alerts and set up an account on various Internet job boards
  • Pick up tips on evaluating and choosing the job board that is right for you
  • Explore why job job boards are just one avenue to finding the right job
Please bring your own flash drive to save class documents or send them to your established email account.


CONSTANT CONTACT, INC. SOCIAL MEDIA MARKETING WORKSHOPS

Social Media Marketing workshops are sponsored in partnership with Constant Contact, Inc. The workshops feature best practices for your social media presence (Facebook, Twitter, LinkedIn & more) that can help you build the necessary relationships to grown your business or organization.  The following are a few of the workshop titles:

  • Gettings Started with Email Marketing and Constant Contact
  • Social Media Marketing Made Simple
  • Power of Email + Social Media
  • Getting Started with Event Marketing
  • Grow Your Own Business with Online Surveys

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, WORD I Basics, Web I Basics, Web II Intermediate and E-mail Basics. 

Length: 2 hours - FAST-PACED!

Please bring your own flash drive to save class documents or send them to your established email account.

HEALTH LITERACY

Learn how to find quality online health information. 

This class is sponsored by the National Library of Medicine (NLM) of the National Institutes of Health (NIH) and the DC Department of Health's HIV/AIDS Administration (DCDH/HAA), and is presented by the Project for Intermediate Advocates (PIA).

Required Skills
The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics and Web I Basics.

Length: 2 hours

Class Objectives 
You will be able to:

  • Navigate medical Websites
  • Evaluate medical Websites for updates and active links
  • Research personal health issues
  • Make informed health decisions based on information retrieved from creditable health Websites
Please bring your own flash drive to save class documents or send them to your established email account.