Computer Class Descriptions
Computer Class Descriptions
- Mavis Beacon Teaches Typing
- PC Basics
- Microsoft Word I Basics
- Microsoft Word II Intermediate
- Microsoft Excel I Basics
- Microsoft Excel II Intermediate
- Microsoft Excel III Advanced
- Microsoft Access I Basics
- Microsoft PowerPoint Basics
- Microsoft Publisher Basics
- Web I Basics
- Web II Intermediate
- E-mail Basics
- HTML Basics
- Internet Job Seeking 101
- Constant Contact, Inc. Social Media Marketing Workshops
- Health Literacy
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
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
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
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
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
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
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
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
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
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
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
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
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
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