| |
|
Windows XP or Vista Basics:
(This course
is a prerequisite for all other courses. Students who are new
computer users or are unfamiliar with the Windows Operating
System are required to take this course before progressing on
to Application Software training courses.)
|
- Learn
about different Hardware components and their functions
- Learn
about Software and what role it plays when using the personal
computer
- Learn
to identify the type of programs that should be used to perform
specific tasks with the personal computer
- Learn
to physically manipulate a Window
|
- Learn to use a
Word-processor/Spreadsheet program to create, save, and print
a document
- Learn
the rules for naming Files
- Learn
about what defines Files, Folders, Disks, and Memory
- Learn
how to manage Files using Windows Explorer
- Learn
what defines the Internet and World Wide Web
- Learn
how to browse the World Wide Web using a Browser
|
| |
|
Navigating the World
Wide Web
Using Internet Explorer - Basics
|
-
Learn about the
Origin of the Internet, including Internet Terminology and
Concepts
-
Learn about
Toolbars and Menus
-
Learn various
Navigating Techniques
-
Understand how to
set up Bookmarks and Save Favorite Web sites
|
-
Learn how to use
Search Engines to Search the Internet
-
Understand how to
Save Information located on the Internet on your own Computer
-
Understand how to
use Internet-based Email
-
Learn how to
Download Email Attachments (Pictures and other file types)
|
| |
|
eBay: The Basics
|
- Learn
how to become an eBay Seller
- Learn
how to do Research and create Listings
-
Understand how to improve your Listings with better
Descriptions and Photography
|
·
Learn how to Set Pricing
·
Learn how to Open and use a PayPal Account
·
Understand how to Monitor your Listings
·
Understand how to Complete Transactions |
| |
|
Word Level 1
|
- Understand
the objects on the Screen and use the Menu system
- Learn
how to Enter and Edit text
- Learn
how to Open and Save documents
- Understand
how to use the Help feature
- Learn
how to use Spell Check to edit the document
- Understand
how to Select and Delete Blocks of text
- Learn
how to Move and Copy text
|
- Learn
to use formatting techniques to change Character formats
- Understand
how to change Paragraph Alignment and Indents
- Learn
how to create Numbered or Bulleted Lists
- Learn
how to Create and Edit text in Columns using Tables
- Understand
how to Set Page Margins and create Page Breaks
- Learn
how to Insert Headers and Footers
|
|
Word: Level 2
|
- Learn
how to position text with Tabs
- Understand
how to perform advanced Character, Paragraph, and Page formatting
- Learn
how to use Sections for complex page formatting
- Learn
how to create different Headers in sections
|
- Learn
how to create and revise Templates
- Understand
how to change the Normal template
- Learn
how to Create, Revise, and Delete AutoText
- Learn
how to Create a Style by Example and apply Styles to formatted
text
|
| |
|
Excel: Level 1
|
- Learn
how to identify Objects on the Excel screen
- Learn
about Commands and how to use Toolbars
- Learn
how to move around a Worksheet and Workbook
- Understand
how to enter Text, Numbers, and Dates in a Worksheet
-
Learn
how to Save, Close, Open, and manipulate a Workbook
|
·
Understand how to Edit Data within a Worksheet
·
Learn how to Create and Apply Formulas
·
Understand how to Move, Copy, and Fill data
·
Learn how to use Print Preview and how to Print a Worksheet
·
Understand how to Change Print Options
·
Understand how to Format data in a Worksheet |
|
Excel: Level 2
|
- Learn
how to create Absolute and Mixed Cell References in Formulas
- Learn
how to use the Round, Date, Pmt, If, and Vlookup Functions
- Understand
how to use the Find and Replace Cell Contents feature
|
·
Learn how to work with multiple Sheets within a Workbook
·
Understand how to Drag cells between Worksheets and Workbooks
·
Learn how to create a Name for a Range of cells
·
Learn how to Link multiple Worksheets and Workbooks together |
| |
|
PowerPoint: Level 1
|
- Learn
how to create a new Presentation and open an existing one
- Understand
how to create Title and Bulleted List Slides
- Understand
how to Save and Close a Presentation
- Learn
how to Print the Presentation, individual Slides, or Handouts
- Learn
how to Edit Text Slides
- Understand
how to Spell Check the Presentation
- Learn
how to Move and Copy text within the Presentation
- Understand
how to use the Slide Master to format text
|
- Understand
how to View the Presentation in different ways
- Learn
how to add Notes to the Presentation
- Learn
how to add Graphics such as Circles, Lines, and Boxes to a
slide
- Learn
how to Insert and Learn how to Move and Copy text within the
Presentation Modify Clip Art
- Understand
how to use a Template to format a Presentation
- Learn
how to prepare a Slide Show using Transitions and Animation
Effects
- Learn
how to add a Graph to a slide using Microsoft Graph
|
|
PowerPoint: Level 2
|
- Learn
how to Apply and Customize a Template and Color Scheme
- Learn
how to Add Multimedia and Animation to a Presentation
- Understand
how to Create a Custom Slide Show
- Learn
how to use a variety of the Add-in Programs included with
PowerPoint
|
- Understand
how to use Workgroup Editing Tools such as Tracking and Reviewing
changes
- Learn
how to Protect a Presentation with a Password
- Understand
how to use PowerPoint Web tools such as Email and Creating
a Web page in PowerPoint
|
| |
|
Access: Level 1
|
- Understand
Tables, Queries, Forms and Reports and how to Open each
- Learn
how to Rename an Object
- Understand
how to Create Select Queries
- Understand
how to Rearrange the output of a Query
- Understand
how to Add a field to a Query and Delete a field in a Query
- Understand
how to use Query Design view and Datasheet view
- Learn
how to Sort Queries and Filter the Output of a Query
|
- Understand
Table Field Properties
- Understand
how to Set a Primary Key
- Learn
how to control the Field Size
- Learn
how to Customize Text and Value Formats
- Learn
how to control Input Patterns using an Input Mask
- Learn
how to change the Field Label using the Caption feature
- Learn
how to Specify a Default Value
- Understand
how to use the Prompt an Error feature using the Validation
Rule
- Understand
how to customize an Error Message
|
|
Access: Level 2
|
- Learn
how to create a Form using the Wizard
- Learn
how to use the Show/Hide Field Lists and the Toolbox Toolbar
- Learn
how to Insert, Delete and Change Control and Form Properties
- Understand
how to add multiple Control Types
- Understand
how to make a Form’s Header/Footer visible
|
- Learn
how to add a Bound Text Box Control and an Unbound Text Control
- Learn
how to create a Formula in a Control
- Learn
how to create Calculated Controls
- Understand
how to add an Option Group, Combo Box, List Box, and a useful
Command Button
- Learn
how to create a Main Form and a SubForm
- Learn
how to hide information in a SubForm
|
| |
|
Outlook: Basics
|
- Learn
the main features of Outlook Mail and Calendar
- Understand
how to Read, Delete, Reply, and Forward Mail
- Learn
how to Address, Create, Format, Edit, and Send Mail
- Understand
how to Set Message Priorities and use special features for
Mail
- Learn
how to Attach and work with File Attachments
|
·
Understand how to Manage the Mailbox Address Book and Folders
·
Learn how to Display and Print the Calendar by day, week, and
month
·
Learn how to Schedule and Modify Appointments
·
Learn how to Create and Modify recurring Appointments and Events
·
Understand how to Plan and Modify Meetings and respond to
Meeting Requests |