|
|
|
|
|
|
|
|
NORTH AMERICAN SCHOOL OF INFORMATION TECHNOLOGY
|
|
|
|
 |
|
|
|
3609 Sheppard Ave. East, Scarborough, ON M1T 3K8
Tel:
416-335-6178, Fax: 416-335-6179
|
|
Course Outline
MICROSOFT OFFICE 2007
PROGRAM OBJECTIVE
MS-OFFICE is highly effective and fully
integrated office management software. Whether you are a novice or a more
experienced user, this course will have you master the tips and techniques needed
to get up and running fast on the most popular office management tool in the
market.
EMPLOYMENT OPPORTUNITIES
- Office Administrator
- Secretary/Receptionist
CURRICULUM
·
Microsoft Word 2007
·
Microsoft Excel 2007
·
Power Point 2007
·
Microsoft Access 2007
·
Microsoft Outlook 2007
FUTURE COURSES:
o
WEB PAGE DEVELOPER: HTML, JavaSript,
Front Page
o
A+ Certification
INTRODUCTION
TO WORD 2007
Level Beginner
What will I learn?
You'll learn to create, format, proof,
print and save documents in Word. This means you'll be able to write letters
make a simple report or even open a document of someone else's to edit it.
The following topics will be covered:
Ø
Windows XP
Ø
Inserting text
Ø
Using word wrap
Ø
Moving the insertion point
Ø
Using the arrow keys
Ø
Moving the insertion point using
special keys
Ø
Using key combination shortcuts
Ø
Removing text
Ø
Using the overtype mode
Ø
Highlighting text in a document
Ø
Deselecting text
Ø
Formatting a document
Ø
Changing a font
Ø
Using the font dialog box
Ø
Applying font styles
Ø
Using underline options
Ø
Applying character effects
Ø
Using the formatting toolbar
Ø
Aligning text
Ø
Saving a document
Ø
Starting a new document
Ø
Using templates to create a new
document
Ø
Setting margins
Ø
Setting page orientation
Ø
Using indentation options
Ø
Setting line spacing options
Ø
Adjusting tabs and Inserting date and
time
Ø
Inserting auto text
Ø
Using the spelling and grammar
features
Ø
Previewing a document and Printing
Ø
Saving files
Ø
Adding bullets and numbering
Ø
Inserting a chart
Ø
Editing a graph's datasheet and
resizing
Ø
Using the language tools
Ø
Using the thesaurus
Ø
Changing text case
Ø
Using format paint
Level Intermediate
What will you learn?
You'll learn how to apply more detailed
formatting and options to a document. You'll also be able to create and modify
many items that will enhance basic documents. You'll learn to create and modify
headers and footers, tables, lines, objects and 3D shapes. Finally, You'll be
able to perform a mail merge from start to finish using Word 2007.
The
following topics will be covered:
Ø
Starting Word 2007
Ø
Opening files
Ø
Applying automatic hyphenation
Ø
Using soft/non-breaking hyphens
Ø
Inserting/Removing page breaks
Ø
Inserting symbols
Ø
Explaining tab stops
Ø
Using tab commands
Ø
Setting tabs with leaders
Ø
Adjusting margins
Ø
Adding/Modifying page numbers
Ø
Creating a header/footer
Ø
Formatting a header/footer
Ø
Applying a page border
Ø
Modifying a page border
Ø
Opening a document
Ø
Entering text
Ø
Creating an outline
Ø
Saving HTML files
Ø
Organizing text in Outline view
Ø
Collapsing/Hiding text
Ø
Moving text
Ø
Saving documents
Ø
Keying/Editing text in columns
Ø
Balancing column lengths
Ø
Creating/Formatting tables
Ø
Adding a border/shading
Ø
Revising a table
Ø
Entering table text
Ø
Modifying table structure
Ø
Aligning text vertically
Ø
Adding rows
Ø
Merging cells
Ø
Adding graphics
Ø
Positioning/Sizing graphics
Ø
Deleting graphics
Ø
Editing pictures
Ø
Drawing/Modifying lines
Ø
Adding/Altering a 3-D effect
Ø
Preparing charts
Ø
Replacing data
Ø
Titling a chart
Ø
Importing data
Ø
Using the Mail Merge Helper
Ø
Creating a main document
Ø
Locating an alternate data source
Ø
Inserting text
Ø
Examining query options
Ø
Sorting/Merging records
Ø
Printing envelopes
Ø
Creating labels
INTRODUCTION
TO EXCEL 2007
Level
Beginner
After completing this course you’ll be on
your way to creating your own spreadsheets; whether it's for tracking sales or
investments, recording inventory, comparing income and expenses or for any
other type of data. This means you'll have the necessary skills to create,
edit, format, calculate and print your spreadsheet data.
The topics
will be covered.
Ø Exploring the
Excel workspace
Ø Examining a
worksheet
Ø Locating/Opening
an existing workbook
Ø Moving between
worksheets in a workbook
Ø Selecting
cells and Go to a specific cell
Ø Entering text and
numbers
Ø Applying number
formats
Ø Modifying the
size of columns
Ø Using
AutoFit and Modifying the size of rows
Ø Creating a new
workbook
Ø Inserting
worksheets
Ø Moving/Deleting
worksheets
Ø Renaming a
worksheet
Ø Working with
series (AutoFill)
Ø Editing cell
content
Ø Using Save/Save
As
Ø Modifying
alignment of cell content
Ø Merging cells
Ø Applying Font
Styles
Ø Entering formulas
in a cell
Ø Using Copy/Paste
commands
Ø Entering a
formula using the Formula bar
Ø Entering a
function using the formula palette
Ø Using AutoSum
Ø Clearing cell
content/formatting
Ø Using Undo/Redo
Ø Copying a
worksheet
Ø Checking Spelling
Ø Examining Print
Settings
Ø Printing an
entire workbook
Ø Setting page
margins/centering
Ø
Setting up headers/footers and Setting
Level Intermediate
After completing this course, you'll be on your way to creating,
formatting, and setting up data; whether it's for tracking your company’s
profits or budgeting household expenses. In addition, you'll be able to view
and compare data, work with named ranges and complete routine tasks quickly by
using and creating your own templates.
The
following topics will be covered.
Ø
Changing zoom settings
Ø
Zooming
specific cells
Ø
Splitting a worksheet
Ø
Freezing columns and rows
Ø
Unfreezing panes
Ø
Hiding/Unhiding columns and rows
Ø
Inserting/deleting selected cells
Ø
Deleting individual cells
Ø
Inserting columns and rows
Ø
Inserting multiple columns/rows
Ø
Moving selected cells
Ø
Utilizing the office clipboard
Ø
Merging and centering
Ø
Adding named ranges and Selecting
named ranges
Ø
Naming single cells
Ø
Inserting rows in a named range
Ø
Preparing formulas
Ø
Deleting named ranges
Ø
Revising formulas and Printing
selections
Ø
Changing page scaling
Ø
Applying borders/shading
Ø
Using Paste Special
Ø
Removing a format style
Ø
Hiding/Displaying gridlines
Ø
Rotating text and Changing indents
Ø
Defining/Applying styles
Ø
Merging styles
Ø
Applying AutoFormats
Ø
Creating templates
Ø
Customizing an invoice
Ø
Applying templates
Ø
Editing templates
Ø
Saving templates
Ø
Applying date formats
INTRODUCTION TO POWER POINT 2007:
Level
Beginner to Intermediate
What will you learn?
After you complete this course, you'll be
able to identify the components in PowerPoint 2007 to create a presentation.
You'll learn how to add clip art, charts, speaker notes and handouts to
PowerPoint slides. After learning how to create and modify a slide show, you’ll
learn how to present the show to an audience.
The following topics will be covered.
Ø
Opening a presentation
Ø
Viewing a slide show
Ø
Discussing the PowerPoint window
Ø
Using menus
Ø
Demonstrating toolbars
Ø
Changing views
Ø
Using the AutoContent wizard
Ø
Entering data in a presentation
Ø
Using the Outline view
Ø
Moving between slides
Ø
Adjusting text
Ø
Using the Slide Master
Ø
Adding Clip Art to a slide
Ø
Creating/editing a chart
Ø
Changing chart types
Ø
Modifying a chart
Ø
Saving a presentation
Ø
Creating speaker notes
Ø
Making handouts
Ø
Adding transition effects
Ø
Discussing advancement options
Ø
Using the Pen option
Ø
Printing a presentation
INTRODUCTION TO OUTLOOK 2007
LEVEL BEGINER TO
INTERMEDIATE
Course Contents:
Ø
Create a hyperlink
Create a
hyperlink to connect a word or phrase in one document to another Document or
web page
Ø
Display the web toolbar
J3Display the
web toolbar to help browse documents containing hyperlinks
Ø
Move between documents
After selecting
hyperlinks in documents, easily move back and forth between these documents
Ø
Open the document
Open the
document that is on the computer.network.corporate Intranet or the Internet
Ø
Return to a document
Ø
Stop the Connection
If a web page is
taking a long time to appear, you can stop the transfer of information.
Ø
Refresh a Document
While you are
viewing a document, the author may changes to the document. You can easily
transfer a fresh copy of the document to your computer.
Ø
Display the start page
The start page
is the first page that appears when you start a web browser
Ø
Display the search page
The search page
helps you find information of interest.
Ø
Add document to favorites
You can add
documents you frequently use to the favorites folder. This let you quickly open
these documents at any time.
Ø
Open document in a favorites
Ø
Save document as a web page
You can save
document as a web page. This lets you place the document on your company’s
Intranet or on the web.
Ø
Start outlook
Outlook can help
you mange your messages.appointments.contracts.tasks, and activities
Ø
View Inbox
The Inbox lets
you exchange electronic mail (e-mail) messages with friends, family members,
colleagues and clients.
Ø
Display the mail folders
Outlook stores
your messages in different folders
Ø
Open a message
You can easily
open a message to view its contents.
Ø
Delete a message
You can delete a
message you no longer need. This
prevents your folders from become cluttered with messages.
Ø
Send a message
You can send a
message to exchange ideas or request information.
Before you can
send and receive message, you must be connected to a service that allows you to
exchange messages. These services include an office network, a commercial
online service or an Internet service provider.
Ø
Reply to a message
You can reply to
a message to answer a question, express an opinion or supply additional
information.
Ø
Forward a message
After reading a
message, you can add comments and then send the message to a friend or
colleague.
Ø
Create a note
You can create
electronic notes that are similar to paper sticky notes
Ø
Open a note
You can easily
open note to view its contents.
Ø
Resize the note
You can change
the size of a note. This is useful when the window is too small to display all
the text.
Ø
Create a Task
You can create a
list of related tasks that you want to accomplish.
Ø
View Calendar
The Calendar
helps you keep track of your appointments.
Ø
Add an Appointment
You can add
appointment to the Calendar to remind you of activates such as meetings, lunch
dates and doctor’s appointments.
Ø
Day. Week and Month view
You can view
your appointments by day, week or month.
Ø
Add a Contact
Outlook supplies
an address book where you can keep detailed information about your friends,
family members, colleagues and clients.
Ø
Update a Contact
You can easily
update or add additional information to a contact in your list.
Ø
Print
You can produce a paper copy of
your e-mail messages, contacts, tasks, notes journal and
calendar.
INTRODUCTION TO MS ACCESS 2007:
LEVEL BEGINER TO
INTERMEDIATE
Course Contents:
Ø
What is a Database
Ø
Planning your Database
Planning is
important
Determining what
table you’ll need
What form you
will use
What Report will
you want to produce?
Ø
Starting and Exiting Access
Starting Access
Parts of the
Screen
Exiting Access
Ø
Creating a New Database
Choosing the
right way to create your Database
Creating a Blank
Database
Creating a
database with Database wizard
Ø
Saving Closing and Opening a
Database
Ø
Creating a Table with the Table
wizard
Why create Table
Creating Table
using the Table wizard
Ø
Creating a Table without a wizard
Why not use a
wizard
Creating a Table
in table design view
Understanding
Data typed and Formats
Setting the
primary key
Switching
between design and Data sheet views
Ø
Modifying a Table
Editing fields
and their properties
Adding fields
Deleting fields
Hiding a fields
Deleting a Table
Ø
Entering Data into a Table
Entering a Record
Moving around in
a Table
Printing a Table
Closing a Table
Ø
Editing a Data in a Table
Changing a
cell’s content
Replacing a
cell’s content
Editing cell’s
content
Selecting
Records
Inserting New
Records
Dele