SEARCH
Shopping Catalogue
Printed Courseware Catalogue
 
CatalogueIT & CertificationIC3
IC3:
      
Axzo Press
760 pages


Purchase Price
1-9 manuals: $220 per manual
10+ manuals: $196 per manual


Trainer Material: Instructor's Edition $240 each

 
Code: CT22-850
Series: IT & Certification
Format: A4
Duration: 4 day(s)
Format: Qty:

Download Data Files

Printer friendly version of this outline
Outline
Basics of information technology
Overview of information technology
Computer parts and storage devices
Introduction to software
Networks

Computers and society
Computers in daily life
The impact of IT on society
Security and legal issues

Getting started with Windows XP
Introducing the Windows XP desktop
Using the taskbar and Start menu
Working with window components
The Help and Support Center
Shutting down Windows XP

Working with My Computer
Browsing My Computer
Working with the folder hierarchy

Working with files
Creating files and folders
Managing files and folders
Working with floppy disks
Working with the Recycle Bin

Customizing your workstation
Creating and deleting shortcuts
Using the Control Panel

Word basics
Exploring the Word window
Creating and saving documents
Printing documents
Using help

Editing documents
Opening and navigating a document
Using AutoCorrect
Editing text
Using Undo and Redo

Moving and copying text
Selecting text
Moving and copying text
Finding and replacing text

Formatting characters and paragraphs
Character formatting techniques
Using tabs
Paragraph formatting techniques
Advanced paragraph formatting techniques

Creating and managing tables
Creating tables
Modifying tables
Enhancing tables
Using borders and shading with tables
Using Table AutoFormat
Controlling page layout
Creating headers and footers
Working with margins
Working with page breaks

Using proofing tools
Checking spelling and grammar

Using styles and AutoText
Defining and applying styles
Using AutoText and AutoFormat

Working with graphics and symbols
Inserting graphics
Inserting symbols
Drawing in a document
Applying borders and shading

Introduction to templates
Using a template

Excel basics
Spreadsheet terminology
Exploring the Excel window
Opening and navigating workbooks
Closing workbooks

Entering and editing data
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks

Modifying a worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges

Using functions
Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX

Formatting worksheets
Formatting text
Formatting rows and columns
Number formatting
Other formatting features

Advanced formatting
Borders and shading
Using special number formats
Working with dates
Working with styles
Other advanced formatting

Printing
Preparing to print
Page Setup options
Printing Creating charts
Chart basics
Modifying charts

Using graphic elements
Using graphic elements

List management
Working with lists
Sorting and filtering lists

Working with large worksheets
Viewing options
Hiding and displaying data
Printing large worksheets

Working with multiple worksheets and workbooks
Using multiple worksheets

Customizing Excel
Customizing toolbars ad menus

Outlook mail
An introduction to Outlook 2002
Creating and sending messages
Handling messages
Using Address Books

Managing e-mail
Managing e-mail

Inbox management
Finding, filtering and sorting messages

Introduction to Internet Explorer
Overview of the Internet
Introduction to Internet Explorer 6.0

Surfing the Web
Working with Favorites
Using Help

Searching the Web
Searching the Internet
Performing advanced searches
Customizing the search features

Manipulating Web information
Working offline
Printing Web content

Security issues and the Internet
Security issues

After completing this course, students will know how to:
  • Explain the basics of Information Technology Explain the influence of computers in society Identify and open objects on the Windows desktop.
  • Navigate the folder hierarchy and search for files by using My Computer.
  • Manage files and folders and work with the Recycle Bin.
  • Customize the desktop by creating desktop shortcuts and using the Control Panel and understand software installation.
  • Explain the Word environment and use it to create, save, and print a document as well as use the Help system.
  • Navigate in a document and explain and use basic editing techniques.
  • Use selection techniques, copy and move text, and use the Find and Replace commands to modify a document.
  • Format characters and paragraphs and work with tabs and indents in a document.
  • Create, edit, and enhance tables.
  • Add headers and footers and control page layout using margins and page breaks.
  • Proof documents using the Spelling and Grammar feature.
  • Create and use paragraph styles and AutoText entries.
  • Insert graphics and symbols in a document; use the Drawing Canvas and the Diagram Gallery, and apply page borders.
  • Use templates to create consistent-looking documents.
  • Start Microsoft Excel, identify the main components of the Excel window and an Excel workbook, and use the Help feature.
  • Enter and edit labels, values, and formulas in a worksheet, use the Undo and Redo commands, and find and replace a formula.
  • Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas.
  • Use functions such as SUM, AVERAGE, MIN, and MAX to perform calculations in a worksheet and use the AutoSum feature.
  • Format text, numbers, rows and columns in a worksheet.
  • Add borders and shading, apply special formats, create, apply, and modify styles, and change the orientation of cells.
  • Preview and control Page Setup options for a worksheet, print a worksheet, and set and clear a print area.
  • Create, format, and modify charts based on worksheet data.
  • Add and format graphic elements.
  • Sort lists.
  • Navigate large worksheets effectively by using magnification and frozen panes and control the printing of large worksheets.
  • Navigate, manage, and print multiple worksheets, link workbooks by using 3-D formulas, and summarize data by using the Consolidate command.
  • Change the view settings of Excel and customize toolbars.
  • Communicate by creating and sending e-mail messages, handling messages, and using the Address Book.
  • Flag a message and define delivery options.
  • Organize the Inbox by searching for and sorting.
  • Start Internet Explorer and work with the browser interface.
  • Organize frequently visited Web sites by using the Favorites folder and use Help.
  • Find Web pages and people by using Autosearch and the Search Assistant.
  • Use Web content by taking it offline and printing it.
  • Work with security and privacy settings.

Prerequisites
None
Privacy Statement  |  Terms Of Use  |  Login
Copyright 2012 Appcon| Sydney Web Design