Brilliant ITQ: What You Need To Know To Pass ITW

Cover
Brilliant ITQ
Contents
Introduction
	Using This Book
	Real Advice from Real ITQ Assessors
	Choosing Your Units
	Software Used
	Creating Evidence
	About the Authors
	A Free Gift for You, Dear Reader
	Thanks to…
1 Make Selective Use of IT
	About This Unit
	Using IT
	Key Skills
	Techie Terms
	Test Your Knowledge
	Evidence
2 Operate a Computer
	About This Unit
	What Your Computer’s Made of
	Computer Accessories
	Getting Started
	The Desktop
	Desktop Icons
	The Desktop Settings
	Working with Windows
	Finding Files
	Windows Explorer
	My Computer
	Changing the View
	Navigating Your Folders
	Storing Data
	Working Safely with Computers
	Test Your Knowledge
	Evidence
3 IT Troubleshooting for Users
	About This Unit
	Spotting Errors
	Fixing Errors Yourself
	Dealing with a Frozen Computer
	Getting Technical Support
	Cleaning Up Your PC
	Compatibility
	Test Your Knowledge
	Evidence
4 IT Maintenance for Users
	About This Unit
	Cleaning Your PC
	Maintaining Hardware
	Managing Files
	Default File Locations in Office
	Upgrading Your System
	Health and Safety
	Test Your Knowledge
	Evidence
5 IT Security for Users
	About This Unit
	Keeping Your Files Secure
	Staying Safe from Threats
	Laws and Guidelines
	Test Your Knowledge
	Evidence
6 Internet and Intranets
	About This Unit
	Introduction to the Internet
	Connecting to the Internet
	Using an Internet Browser
	Customising Your Browser
	Images
	Searching for Information
	Exchanging Information Online
	Internet Security
	Test Your Knowledge
	Evidence
7 Email
	About This Unit
	Understanding Email
	Email Security
	Opening Outlook
	Outlook Screen
	Opening the Inbox
	Using Help in Outlook
	Creating a Message
	Formatting a Message
	Receiving Email
	Forwarding and Replying to Email
	Sending and Receiving Attachments
	Using Instant Messaging
	Organising Your Emails
	Deleting Email
	Finding Messages
	Using Archiving
	Creating Contacts
	Editing and Deleting Contacts
	Using Personal Distribution Lists
	Working with the Calendar
	Working with Tasks
	Test Your Knowledge
	Evidence
8 Word-processing Software
	About This Unit
	What is Word?
	Entering and Deleting Text
	Saving, Closing, Opening and New
	Printing
	Changing the Look of Text
	Aligning Text
	Inserting Special Characters and Symbols
	Bullets and Numbering
	Customising Bullets
	Customising Numbers
	Indenting Text
	Borders and Shading
	Styles
	Page Numbering
	Improving Efficiency
	Moving and Copying Text
	Page Breaks
	Margins and Page Set-up
	Line Spacing
	Headers and Footers
	Tabs
	Spelling and Grammar
	Go To, Find and Replace
	Proofing
	Creating and Editing Tables
	Selecting Parts of a Table
	Inserting and Deleting Rows and Columns
	Resizing Rows
	Resizing Columns
	Moving and Resizing Tables
	Borders
	Shading
	Table AutoFormat
	Adding Graphics
	Selecting, Moving and Resizing Pictures
	Charts
	Excel Worksheets in Word
	Excel Charts in Word
	Advanced Saving
	Mail Merge
	Creating your Data Document
	Carrying out a Mail Merge
	Test Your Knowledge
	Evidence
9 Spreadsheet Software
	About This Unit
	What is Excel For?
	Starting and Closing Excel
	Opening and Closing Workbooks
	Creating a New Workbook
	Saving Your Workbook
	Using Shortcuts
	Entering Text and Numbers
	Correcting Mistakes
	Selecting Cells
	Adding Up Numbers with AutoSum
	Typing the Sum Function to Add Up Numbers
	Entering Simple Formulae
	Error Messages
	Cut, Copy and Paste
	Using AutoFill to Copy Text and Formulae
	Find and Replace
	Sorting
	Filtering
	Subtotals
	Importing Data
	Using Absolute Cell References
	Relative Cell References
	Finding the Average
	Print Preview
	Page Break Preview
	Printing a Worksheet
	Changing the Page Set-up
	Creating Headers and Footers
	Inserting and Deleting Rows and Columns
	Resizing Rows and Columns
	Changing the Font and Font Size
	Changing the Number Format
	Changing the Alignment
	Applying Borders
	Adding Colours to Cells
	Creating Charts
	Moving, Resizing and Deleting Charts
	Using the Chart Toolbar
	Changing Chart Options
	Test Your Knowledge
	Evidence
10 Database Software
	About This Unit
	Access
	Opening, Saving and Closing a Database
	What is a Database?
	The Parts of an Access Database
	Using Tables
	Changing the View of a Table
	Creating New Fields
	Field Properties
	Searching and Sorting Records
	Toolbars
	Creating a Simple Query
	Changing the View
	Adding Criteria to Queries
	Numbers, Dates and Wildcards
	Adding More Than One Criteria
	Sorting Queries
	Using Forms
	Using Reports
	Creating reports
	Summary Options on a Report
	Data Integrity
	Checking Your Work
	Test Your Knowledge
	Evidence
11 Website Software
	About This Unit
	Introduction to the World Wide Web
	Creating Webs
	Creating and Saving Web Pages
	Opening Pages
	Formatting Text
	Horizontal Lines
	Colour
	HTML Tags
	Managing Your Files
	Understanding Templates and Wizards
	Website Templates
	Page Templates and Wizards
	Understanding Links
	Links Between Pages in a Site
	Linking to Other Websites
	Linking to an Email Address
	Linking to a Bookmark
	Hyperlink Colours
	Testing Hyperlinks
	Clear Navigation
	Creating Tables
	Working with Frames
	Images in Your Web Page
	Customising Images
	Placing Text in Your Web Pages
	Importing Files
	Publishing
	Spell Checking
	Uploading Your Site
	Test Your Knowledge
	Evidence
12 Artwork and Imaging Software
	About This Unit
	Thinking About Your Work
	What File Format Should I Use?
	What is a Colour Mode and Which Should I Choose?
	Graphic Types
	Starting with Photoshop
	Handling Files
	Layers
	Selecting
	Drawing Tools
	Working with Images
	Adding Text
	Warped Type
	Test Your Knowledge
	Evidence
13 Presentation Software
	About This Unit
	What is PowerPoint?
	Creating a New Presentation
	Applying a Template
	Saving a Presentation
	Opening and Closing a Presentation
	Adding Text to Slides
	Creating New Slides
	The Different Views Within PowerPoint
	Slide Sorter View
	Adding Slide Transitions
	Adding Sounds
	Adding Animation Effects
	Printing Slides
	Moving, Resizing and Deleting Placeholders
	Moving and Copying Text
	Moving, Copying and Deleting Slides
	Creating Speaker’s Notes
	Changing the Appearance of Text
	Bullets and Numbering
	Changing the Background
	Checking Your Presentation
	Designing Your Presentation
	Importing Text from Word
	Importing Charts from Excel
	Importing Slides from Another Presentation
	What is an Organisation Chart?
	Adding Pictures to Slides
	Using the Clipart Gallery
	Moving, Copying, Resizing and Deleting
	Rotation and Ordering
	Alignment
	Using the Drawing Toolbar
	Test Your Knowledge
	Evidence
14 Specialist or Bespoke Software
	About This Unit
	Using the Software
	Test Your Knowledge
	Evidence
15 Evaluate the Impact of IT
	About This Unit
	IT and Society
	IT Issues
	Learning More About IT
	Test Your Knowledge
	Evidence
16 Use IT Systems
	About This Unit
	Choosing This Unit
	Test Your Knowledge
	Evidence
17 Use IT to Exchange Information
	About This Unit
	Choosing This Unit
	Test Your Knowledge
	Evidence
Index