Brilliant ITQ: What You Need To Know To Pass ITW

537 Pages·2007·10.814 MB·English

by  Mr Nik Taylor, Catherine Jones

What you need to know and how to gain the ITQ certifi cation!
Nik Taylor and Catherine Jones
brilliant
Traditional training guides can be unwieldy and make it hard to get to the info you need right away. Brilliant b
ITQ allows you to fi nd the information you need easily and without fuss. Guiding you through each task
r
using a highly visual, step-by-step approach, you will gain full understanding and practical knowledge of the
subjects covered by the ITQ syllabus, and be able to assess your own training needs. Everything you need to i
know to pass the ITQ assessment – exactly when you need it!! l
l
i
a
brilliant ITQ
n
t
ITQ
ITQ is the new fl exible IT qualifi cation for anyone who uses IT in the workplace. It is designed to give you the tailored I
IT skills set that you need to succeed in your chosen job or career. Whether you use your computer for just a few T
minutes a day or all day everyday, ITQ can help you to do your job more effi ciently and clear you of any frustrations.
Q
ITQ is benchmarked to national standards and sponsored by the government – it is nationally recognised and will add
value to your CV.
Comprehensively covering the requirements of the ITQ syllabus this easy-to-use and accessible book covers all of
the mandatory and optional units. You’ll also fi nd guidelines on how to build your own unit structure and assess and
fi t your existing training and qualifi cations into it to produce the most effective IT training outcome for your particular
needs.
Brilliant guides provide the quick, easy-to-access information that you need …
• Detailed index and troubleshooting guide will help you fi nd exactly what you need to know
• Easy steps guide you through each task or problem
• Numerous screenshots illustrate each step
• ‘See Also’ boxes point you to related tasks and information in the book
• ‘Did you know?’ sections alert you to relevant expert tips, tricks and advice
T
a
y
l
o
r

a
n
d
Visit us on the web at J
www.pearson-books.com COMPUTING o
n
e
s
what you need to know to pass ITQ
£21.99
9780136157588.indd 1 7/11/07 10:27:12
A01.QXD 8/11/07 11:50 Page i
Brilliant ITQ
A01.QXD 8/11/07 11:50 Page ii
PEARSON EDUCATION HIGHER EDUCATION DIVISION
We work with leading authors to develop the strongest
educational materials in computing, bringing cutting-edge
thinking and best learning practice to a global market.
Under a range of well-known imprints, including Prentice
Hall, we craft high quality print and electronic publications
which help readers to understand and apply their content,
whether studying or at work.
To find out more about the complete range of our
publishing, please visit us on the World Wide Web at:
www.pearsoned.co.uk
A01.QXD 8/11/07 11:50 Page iii
Brilliant ITQ
Nik Taylor
Catherine Jones
A01.QXD 8/11/07 11:50 Page iv
Pearson Education Limited
Edinburgh Gate
Harlow
Essex CM20 2JE
England
and Associated Companies throughout the world
Visit us on the World Wide Web at:
www.pearsoned.co.uk
First published 2008
© Pearson Education Limited 2008
The right of Nik Taylor and Catherine Jones to be identified as authors of this work has
been asserted by them in accordance with the Copyright, Designs and Patents Act 1988.
All rights reserved. No part of this publication may be reproduced, stored in a retrieval
system, or transmitted in any form or by any means, electronic, mechanical, photocopying,
recording or otherwise, without either the prior written permission of the publisher or a
licence permitting restricted copying in the United Kingdom issued by the Copyright
Licensing Agency Ltd, Saffron House, 6–10 Kirby Street, London EC1N 8TS.
All trademarks used herein are the property of their respective owners. The use of any
trademark in this text does not rest in the author or publisher any trademark ownership
rights in such trademarks, nor does the use of such trademarks imply any affiliation with or
endorsement of this book by such owners.
Microsoft product screenshots reprinted with permission from Microsoft Corporation.
ISBN: 978-0-13-615758-8
British Library Cataloguing-in-Publication Data
A catalogue record for this book is available from the British Library
Library of Congress Cataloging-in-Publication Data
Taylor, Nik.
Brilliant ITQ / Nik Taylor, Catherine Jones. - - 1st ed.
p. cm.
“National Vocational Qualification (NVQ) for IT.”
Includes index.
ISBN 978-0-13-615758-8 (pbk.)
1. Electronic data processing personnel--Certification--Great Britain. 2.
Information technology--Great Britain--Study guides. 3. National Vocational
Qualifications (Great Britain)--Study guides. I. Jones, Catherine. II. Title.
QA76.3.T38 2007
004.0941--dc22
2007039843
10 9 8 7 6 5 4 3 2 1
11 10 09 08 07
Typeset in Helvetica Roman 9pt on 12pt by 30
Printed by Ashford Colour Press Ltd., Gosport
The publisher’s policy is to use paper manufactured from sustainable forests.
A01.QXD 8/11/07 11:50 Page v
Contents
Introduction 1
Using This Book 1
Real Advice from Real ITQ Assessors 1
Choosing Your Units 2
Software Used 3
Creating Evidence 4
About the Authors 4
A Free Gift for You, Dear Reader 4
Thanks to … 5
1 Make Selective Use of IT 7
1.1 About This Unit 7
1.2 Using IT 8
1.3 Key Skills 9
1.4 Techie Terms 12
1.5 Test Your Knowledge 15
1.6 Evidence 16
2 Operate a Computer 17
2.1 About This Unit 17
2.2 What Your Computer’s Made of 18
2.3 Computer Accessories 19
2.4 Getting Started 23
2.5 The Desktop 26
2.6 Desktop Icons 29
2.7 The Desktop Settings 32
2.8 Working with Windows 34
2.9 Finding Files 35
2.10 Windows Explorer 38
2.11 My Computer 39
A01.QXD 8/11/07 11:50 Page vi
2.12 Changing the View 41
2.13 Navigating Your Folders 44
2.14 Storing Data 47
2.15 Working Safely with Computers 49
2.16 Test Your Knowledge 52
2.17 Evidence 52
3 IT Troubleshooting for Users 55
3.1 About This Unit 55
3.2 Spotting Errors 55
3.3 Fixing Errors Yourself 60
3.4 Dealing with a Frozen Computer 62
3.5 Getting Technical Support 66
3.6 Cleaning Up Your PC 68
3.7 Compatibility 69
3.8 Test Your Knowledge 70
3.9 Evidence 71
4 IT Maintenance for Users 73
4.1 About This Unit 73
4.2 Cleaning your PC 74
4.3 Maintaining Hardware 76
4.4 Managing Files 77
4.5 Default File Locations in Office 80
4.6 Upgrading Your System 82
4.7 Health and Safety 83
4.8 Test Your Knowledge 84
4.9 Evidence 84
5 IT Security for Users 87
5.1 About This Unit 87
5.2 Keeping Your Files Secure 87
5.3 Staying Safe from Threats 96
5.4 Laws and Guidelines 103
5.5 Test Your Knowledge 106
5.6 Evidence 107
vi CONTENTS
A01.QXD 8/11/07 11:50 Page vii
6 Internet and Intranets 109
6.1 About This Unit 109
6.2 Introduction to the Internet 110
6.3 Connecting to the Internet 112
6.4 Using an Internet Browser 115
6.5 Customising your Browser 122
6.6 Images 128
6.7 Searching for Information 130
6.8 Exchanging Information Online 133
6.9 Internet Security 138
6.10 Test Your Knowledge 140
6.11 Evidence 141
7 Email 143
7.1 About This Unit 143
7.2 Understanding Email 143
7.3 Email Security 145
7.4 Opening Outlook 146
7.5 Outlook Screen 147
7.6 Opening the Inbox 148
7.7 Using Help in Outlook 148
7.8 Creating a Message 149
7.9 Formatting a Message 152
7.10 Receiving Email 154
7.11 Forwarding and Replying to Email 155
7.12 Sending and Receiving Attachments 157
7.13 Using Instant Messaging 161
7.14 Organising Your Emails 163
7.15 Deleting Email 166
7.16 Finding Messages 166
7.17 Using Archiving 168
7.18 Creating Contacts 169
7.19 Editing and Deleting Contacts 171
7.20 Using Personal Distribution Lists 172
7.21 Working with the Calendar 174
7.22 Working with Tasks 175
7.23 Test Your Knowledge 175
7.24 Evidence 176
CONTENTS vii
A01.QXD 8/11/07 11:50 Page viii
8 Word-processing Software 177
8.1 About This Unit 177
8.2 What is Word? 178
8.3 Entering and Deleting Text 178
8.4 Saving, Closing, Opening and New 180
8.5 Printing 185
8.6 Changing the Look of Text 186
8.7 Aligning Text 188
8.8 Inserting Special Characters and Symbols 189
8.9 Bullets and Numbering 190
8.10 Customising Bullets 192
8.11 Customising Numbers 192
8.12 Indenting Text 193
8.13 Borders and Shading 195
8.14 Styles 198
8.15 Page Numbering 200
8.16 Improving Efficiency 201
8.17 Moving and Copying Text 202
8.18 Page Breaks 204
8.19 Margins and Page Set-up 205
8.20 Line Spacing 206
8.21 Headers and Footers 207
8.22 Tabs 209
8.23 Spelling and Grammar 210
8.24 Go To, Find and Replace 212
8.25 Proofing 215
8.26 Creating and Editing Tables 215
8.27 Selecting Parts of a Table 218
8.28 Inserting and Deleting Rows and Columns 220
8.29 Resizing Rows 222
8.30 Resizing Columns 222
8.31 Moving and Resizing Tables 223
8.32 Borders 223
8.33 Shading 226
8.34 Table AutoFormat 227
8.35 Adding Graphics 228
8.36 Selecting, Moving and Resizing Pictures 229
8.37 Charts 230
viii CONTENTS
A01.QXD 8/11/07 11:50 Page ix
8.38 Excel Worksheets in Word 231
8.39 Excel Charts in Word 232
8.40 Advanced Saving 234
8.41 Mail Merge 235
8.42 Creating your Data Document 236
8.43 Carrying out a Mail Merge 237
8.44 Test Your Knowledge 240
8.45 Evidence 241
9 Spreadsheet Software 243
9.1 About This Unit 243
9.2 What is Excel For? 244
9.3 Starting and Closing Excel 246
9.4 Opening and Closing Workbooks 246
9.5 Creating a New Workbook 248
9.6 Saving your Workbook 248
9.7 Using Shortcuts 250
9.8 Entering Text and Numbers 251
9.9 Correcting Mistakes 253
9.10 Selecting Cells 254
9.11 Adding Numbers up with AutoSum 255
9.12 Typing the Sum Function to Add Up Numbers 257
9.13 Entering Simple Formulae 258
9.14 Error Messages 261
9.15 Cut, Copy and Paste 263
9.16 Using AutoFill to Copy Text and Formulae 263
9.17 Find and Replace 265
9.18 Sorting 266
9.19 Filtering 268
9.20 Subtotals 268
9.21 Importing Data 270
9.22 Using Absolute Cell References 273
9.23 Relative Cell References 274
9.24 Finding the Average 274
9.25 Print Preview 277
9.26 Page Break Preview 278
9.27 Printing a Worksheet 279
9.28 Changing the Page Set-up 279
CONTENTS ix