IC3
Topic-Level Outline
Days: 4
Prerequisites: None
Unit 1 : Basics of information technology
Topic A: 0 Overview of information technology
A-1: Understanding hardware and software devices
A-2: Identifying the types of computers
Topic B: 0 Computer parts and storage devices
B-1: Understanding the features of a CPU
B-2: Identifying the input and output devices
B-3: Identifying the types of memory
B-4: Identifying the types of storage devices
B-5: Working with storage units
B-6: Factors affecting a computer’s performance
Topic C: 0 Introduction to software
C-1: Understanding an operating system
C-2: Identifying application software
C-3: Understanding the software development process
Topic D: 0 Networks
D-1: Understanding networking
D-2: Understanding e-mail
D-3: Understanding different Internet utilities
Unit 2 : Computers and society
Topic A: 0 Computers in daily life
A-1: Using computers in daily life
Topic B: 0 The impact of IT on society
B-1: Understanding the Information Superhighway and e-commerce
B-2: Understanding the health hazards
Topic C: 0 Security and legal issues
C-1: Understanding the security features of a computer
C-2: Understanding software copyrights and data protection
Unit 3 : Getting started with Windows XP
Topic A: 0 Introducing the Windows XP desktop
A-1: Logging on to your workstation
A-2: Identifying the desktop components
A-3: Using the mouse
Topic B: 0 Using the taskbar and Start menu
B-1: Using the Start button to open applications
B-2: Switching between applications
Topic C: 0 Working with window components
C-1: Moving a window
C-2: Sizing a window
C-3: Using the Control menu buttons
C-4: Working with menus
C-5: Working with toolbars
C-6: Using the scrollbars
C-7: Working with the Save As dialog box
Topic D: 0 The Help and
D-1: Picking a help topic
D-2: Using the Index
D-3: Searching for help topics
Topic E: 0 Shutting down Windows XP
E-1: Logging off the computer
E-2: Shutting down the computer
Unit 4 : Working with My Computer
Topic A: 0 Browsing My Computer
A-1: Using the View menu
A-2: Browsing the local disk
Topic B: 0 Working with the folder hierarchy
B-1: Navigating the folder hierarchy
B-2: Searching for files and folders by name
B-3: Searching for files that contain specific text
Unit 5 : Working with files
Topic A: 0 Creating files and folders
A-1: Creating a folder
A-2: Creating a text file
Topic B: 0 Managing files and folders
B-1: Moving a file and a folder
B-2: Copying a file or folder
B-3: Copying multiple files
B-4: Renaming a folder
Topic C: 0 Working with floppy disks
C-1: Formatting a floppy disk
C-2: Copying files to a floppy disk
Topic D: 0 Working with the Recycle Bin
D-1: Deleting files and folders
D-2: Examining the contents of the Recycle Bin
D-3: Restoring deleted files
D-4: Emptying the Recycle Bin
Unit 6 : Customizing your workstation
Topic A: 0 Creating and deleting shortcuts
A-1: Creating a desktop shortcut
A-2: Pinning a shortcut to the Start menu
A-3: Deleting a desktop shortcut
A-4: Unpinning and removing a Start menu shortcut
Topic B: 0 Using the Control Panel
B-1: Changing mouse properties
B-2: Changing keyboard properties
B-3: Setting display properties
Unit 7 : Word basics
Topic A: 0 Exploring the Word window
A-1: Examining the Word window
Topic B: 0 Creating and saving documents
B-1: Entering text in a document and displaying non-printing characters
B-2: Saving a document by using the Save As command
B-3: Saving a document in a new folder
B-4: Setting a Save AutoRecover time
Topic C: 0 Printing documents
C-1: Previewing a document
C-2: Using the Print dialog box to print
C-3: Closing a document
C-4: Creating a new document
Topic D: 0 Using help
D-1: Using the Ask a Question box
D-2: Using the Office Assistant
D-3: Using the Microsoft Word Help window
Unit 8 : Editing documents
Topic A: 0 Opening and navigating a document
A-1: Opening a file
A-2: Using the scrollbars to navigate in a document
A-3: Moving in a document
A-4: Using the Go To command to move to a specific page
A-5: Using the Browse Object button
Topic B: 0 Using AutoCorrect
B-1: Examining the AutoCorrect feature
B-2: Using the AutoCorrect Options button
B-3: Adding an entry to AutoCorrect
Topic C: 0 Editing text
C-1: Inserting and deleting text
C-2: Inserting text in different modes
C-3: Inserting date and time
Topic D: 0 Using Undo and Redo
D-1: Using the Undo command
D-2: Using the Redo command
Unit 9 : Moving and copying text
Topic A: 0 Selecting text
A-1: Selecting text by using the keyboard
A-2: Using the mouse to select text
A-3: Selecting text by using the selection bar
Topic B: 0 Moving and copying text
B-1: Moving text and using Paste Options
B-2: Copying text in a document
B-3: Copying text to another document
Topic C: 0 Finding and replacing text
C-1: Searching for a word in a document
C-2: Replacing text in a document
Unit 10 : Formatting characters and paragraphs
Topic A: 0 Character formatting techniques
A-1: Using the formatting toolbar to apply font styles
A-2: Applying character formatting
A-3: Applying character and text effects
A-4: Applying highlights
A-5: Repeating formatting in a document
A-6: Formatting multiple selections at the same time
A-7: Using the Format Painter to apply character formats
A-8: Using the Reveal Formatting task pane
A-9: Applying character styles
Topic B: 0 Using tabs
B-1: Examining tab stops
B-2: Setting and moving a custom tab stop
B-3: Clearing and setting other types of tabs
B-4: Setting a tab and leader in the Tabs dialog box
Topic C: 0 Paragraph formatting techniques
C-1: Using paragraph alignments
C-2: Applying borders and shading to a paragraph
C-3: Adding bullets and numbering to a document
C-4: Editing bullets and numbering in a document
Topic D: 0 Advanced paragraph formatting techniques
D-1: Setting left and right indents
D-2: Setting a hanging indent
D-3: Comparing new lines and new paragraphs
D-4: Setting Before and After line spacing for a paragraph
D-5: Setting line spacing in a paragraph
Unit 11 : Creating and managing tables
Topic A: 0 Creating tables
A-1: Creating a table by using the Insert Table dialog box
A-2: Moving in a table
A-3: Selecting table elements
A-4: Creating a table by using the Insert Table button
A-5: Entering text in a table
Topic B: 0 Modifying tables
B-1: Adding rows and columns to a table
B-2: Deleting columns, rows, and a table
B-3: Changing the width of a column
Topic C: 0 Enhancing tables
C-1: Formatting text in a table
C-2: Aligning a table
C-3: Aligning text in table cells
C-4: Merging table cells
C-5: Changing text orientation
C-6: Changing row height
C-7: Distributing columns evenly across a table
Topic D: 0 Using borders and shading with tables
D-1: Adding borders to a table
D-2: Adding shading to table cells
Topic E: 0 Using Table AutoFormat
E-1: Using AutoFormat to format a table
E-2: Setting a default table format
Unit 12 : Controlling page layout
Topic A: 0 Creating headers and footers
A-1: Exploring the Header and Footer area
A-2: Adding information to headers and footers
A-3: Editing headers and footers
Topic B: 0 Working with margins
B-1: Adjusting margins using the Print Preview window
B-2: Using the Page Setup dialog box to adjust margins
B-3: Setting page orientation and vertical alignment
B-4: Applying text flow options
Topic C: 0 Working with page breaks
C-1: Adding manual page breaks
C-2: Deleting a page break
Unit 13 : Using proofing tools
Topic A: 0 Checking spelling and grammar
A-1: Using the automatic spell checker
A-2: Manually spell-checking a document
A-3: Using the grammar checker
Unit 14 : Using styles and AutoText
Topic A: 0 Defining and applying styles
A-1: Applying a standard style
A-2: Creating a style by example
A-3: Using the Styles and Formatting task pane
A-4: Defining and applying a list style
A-5: Defining and applying a table style
Topic B: 0 Using AutoText and AutoFormat
B-1: Using AutoText to add standard text to a letter
B-2: Creating a new AutoText entry
B-3: Using AutoFormat to format a document
Unit 15 : Working with graphics and symbols
Topic A: 0 Inserting graphics
A-1: Inserting Clip Art
A-2: Modifying and moving a graphic
A-3: Adding a border to a graphic
A-4: Formatting text around a graphic
Topic B: 0 Inserting symbols
B-1: Inserting a symbol
Topic C: 0 Drawing in a document
C-1: Using the drawing canvas to create lines and figures
C-2: Grouping drawing objects
C-3: Creating and modifying a text box
C-4:
Inserting a conceptual diagram
C-5: Creating a callout
Topic D: 0 Applying borders and shading
D-1: Creating page borders
D-2: Modifying page borders
Unit 16 : Introduction to templates
Topic A: 0 Using a template
A-1: Using a template to create a new document
A-2: Using a template wizard to create a letter
Unit 17 : Excel basics
Topic A: 0 Spreadsheet terminology
A-1: Discussing spreadsheet terminology
Topic B: 0 Exploring the Excel window
B-1: Starting Excel
B-2: Showing or hiding the Office Assistant
B-3: Examining Excel window components
Topic C: 0 Opening and navigating workbooks
C-1: Opening a workbook
C-2: Navigating a worksheet
Topic D: 0 Closing workbooks
D-1: Closing a workbook and Excel
Unit 18 : Entering and editing data
Topic A: 0 Creating workbooks
A-1: Creating a default Excel workbook
Topic B: 0 Entering and editing labels and values
B-1: Entering labels and values
B-2: Editing labels and values
Topic C: 0 Entering and editing formulas
C-1: Entering a formula by typing
C-2: Using the mouse to enter cell references
C-3: Editing a formula
C-4: Using Undo and Redo
C-5: Finding and replacing a formula
Topic D: 0 Saving and updating workbooks
D-1: Saving a workbook
D-2: Changing and updating a workbook
Unit 19 : Modifying a worksheet
Topic A: 0 Moving and copying data
A-1: Moving data by using the Edit menu
A-2: Moving data by using the Standard toolbar
A-3: Copying data in a worksheet
A-4: Moving data by using the drag an drop method
A-5: Copying data by using the drag an drop method
A-6: Copying data by using the clipboard
Topic B: 0 Moving and copying formulas
B-1: Using shortcut menus to move formulas
B-2: Copying formulas
B-3: Using the fill handle to copy formulas
Topic C: 0 Using absolute references
C-1: Observing the limitations of relative references
C-2: Using absolute references
Topic D: 0 Inserting and deleting ranges
D-1: Inserting a range
D-2: Inserting an entire row
D-3: Deleting a range
Unit 20 : Using functions
Topic A: 0 Entering functions
A-1: Entering a SUM function
A-2: Using the mouse to enter a function argument
A-3: Inserting a SUM function
Topic B: 0 Using AutoSum
B-1: Using AutoSum
B-2: Using AutoSum to enter several functions at once
Topic C: 0 Using AVERAGE, MIN, and MAX
C-1: Using AVERAGE
C-2: Using MIN
C-3: Using MAX
Unit 21 : Formatting worksheets
Topic A: 0 Formatting text
A-1: Formatting text by using the toolbar
A-2: Formatting a non-contiguous range
A-3: Using the Format Cells dialog box to format text
Topic B: 0 Formatting rows and columns
B-1: Changing column widths and row heights
B-2: Setting alignment
B-3: Applying borders
B-4: Using the border-drawing pencil
Topic C: 0 Number formatting
C-1: Using the Formatting toolbar to format numbers
C-2: Exploring the Number tab of the Format Cells dialog box
C-3: Creating a conditional format
Topic D: 0 Other formatting features
D-1: Copying and clearing formatting
D-2: Using the AutoFormat dialog box to format a range
D-3: Using Find and Replace to change cell formats
Unit 22 : Advanced formatting
Topic A: 0 Borders and shading
A-1: Adding borders to a cell or range
A-2: Adding shading to a cell or range
Topic B: 0 Using special number formats
B-1: Using special formats
B-2: Controlling the display of zero values
B-3: Creating custom formats
Topic C: 0 Working with dates
C-1: Using date and time formats
C-2: Using the NOW and DATE functions
C-3: Performing calculations on dates
Topic D: 0 Working with styles
D-1: Observing built-in styles
D-2: Creating and applying styles
D-3: Modifying styles
Topic E: 0 Other advanced formatting
E-1: Merging cells
E-2: Changing a cell's orientation
E-3:
Splitting cells
Unit 23 : Printing
Topic A: 0 Preparing to print
A-1: Checking spelling on a worksheet
A-2: Previewing a worksheet
Topic B: 0 Page Setup options
B-1: Controlling page orientation
B-2: Controlling margins
B-3: Creating headers and footers
B-4: Displaying gridlines and observing sheet options
Topic C: 0 Printing
C-1: Printing a worksheet
C-2: Working with print areas
Unit 24 : Creating charts
Topic A: 0 Chart basics
A-1: Creating a chart
A-2: Examining the chart elements
A-3: Creating an embedded chart
Topic B: 0 Modifying charts
B-1: Changing chart type
B-2: Formatting chart elements
B-3: Modifying an embedded chart
Unit 25 : Using graphic elements
Topic A: 0 Using graphic elements
A-1: Adding graphic elements
A-2: Formatting graphic elements
A-3: Adding a picture to a worksheet
Unit 26 : List management
Topic A: 0 Working with lists
A-1: Examining the structure of a list
Topic B: 0 Sorting and filtering lists
B-1: Sorting a list by using the Standard toolbar
B-2: Sorting a list by using the Sort command
B-3: Filtering a list by using AutoFilter
Unit 27 : Working with large worksheets
Topic A: 0 Viewing options
A-1: Zooming in and out on a large worksheet
A-2: Using the Freeze Panes command
Topic B: 0 Hiding and displaying data
B-1: Hiding columns
B-2: Unhiding columns
B-3: Creating an outline
Topic C: 0 Printing large worksheets
C-1: Setting print titles
C-2: Setting page breaks
C-3: Using Page Break Preview
Unit 28 : Working with multiple worksheets and workbooks
Topic A: 0 Using multiple worksheets
A-1: Navigating multiple worksheets
A-2: Naming worksheets and coloring tabs
A-3: Working with multiple worksheets
A-4: Previewing and printing multiple worksheets
Unit 29 : Customizing Excel
Topic A: 0 Customizing toolbars ad menus
A-1: Showing and hiding toolbars
A-2: Moving and docking toolbars
A-3: Customizing and restoring toolbars
A-4: Customizing menus
A-5: Exploring short and smart menus
Unit 30 : Outlook mail
Topic A: 0 An introduction to Outlook 2002
A-1: Exploring the Outlook 2002 window
Topic B: 0 Creating and sending messages
B-1: Exploring the Inbox interface
B-2: Reading a message in the Message window
B-3: Creating and sending a message
B-4: Working with XP features
B-5: Replying to a message
B-6: Formatting a message
B-7: Spell-checking a message
Topic C: 0 Handling messages
C-1: Attaching a file to a message
C-2: Saving an attachment
C-3: Saving a message as a file
C-4: Forwarding a message
C-5: Deleting and undeleting a message
Topic D: 0 Using Address Books
D-1: Addressing a message from an Address Book
D-2: Addressing a message to multiple people
Unit 31 : Managing e-mail
Topic A: 0 Managing e-mail
A-1: Flagging an e-mail message
A-2: Defining delivery options
A-3: Reading a Read receipt message
Unit 32 : Inbox management
Topic A: 0 Finding, filtering and sorting messages
A-1: Using the Find command to search for messages
A-2: Finding messages by using Advanced Find
A-3: Applying Advanced Find criteria to incoming messages
A-4: Applying filters to messages
A-5: Removing filters from messages
A-6: Sorting messages
A-7: Grouping messages in Inbox
A-8: Removing groups from Inbox
A-9: Assigning categories to messsages
Unit 33 : Introduction to Internet Explorer
Topic A: 0 Overview of the Internet
A-1: Discussing Internet components
A-2: Discussing Internet addresses
Topic B: 0 Introduction to Internet Explorer 6.0
B-1: Launching Internet Explorer
B-2: Navigating in Internet Explorer
Unit 34 : Surfing the Web
Topic A: 0 Working with Favorites
A-1: Navigating in the Favorites folder
A-2: Adding a new Favorite
A-3: Creating a new subfolder while adding to the Favorites menu
A-4: Organizing Favorites
Topic B: 0 Using Help
B-1: Navigating in Internet Explorer Help
B-2: Using Web Help to contact Support Online
B-3: Discussing the Error Reporting tool
Unit 35 : Searching the Web
Topic A: 0 Searching the Internet
A-1: Using the Search Companion
A-2: Searching for a person’s address
A-3: Using Autosearch
Topic B: 0 Performing advanced searches
B-1: Performing a multiple word search
B-2: Using the advanced search options
Topic C: 0 Customizing the search features
C-1: Customizing the Autosearch feature
C-2: Changing the Search Companion preferences
Unit 36 : Manipulating Web information
Topic A: 0 Working offline
A-1: Taking a Favorite offline and synchronizing it
A-2: Examining synchronization options
Topic B: 0 Printing Web content
B-1: Printing the current Web page
B-2: Examining Print options
B-3: Using the Image toolbar to print pictures
Unit 37 : Security issues and the Internet
Topic A: 0 Security issues
A-1: Examining security levels
A-2: Customizing security level settings
A-3: Examining the privacy settings
A-4: Blocking cookies from a specific Web site
A-5: Viewing a Privacy Report