Additional Information
Book Details
Abstract
Brilliant ITQ
Table of Contents
| Section Title | Page | Action | Price |
|---|---|---|---|
| Cover | Cover | ||
| Brilliant ITQ | i | ||
| Contents | v | ||
| 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 | ||
| About This Unit | 7 | ||
| Using IT | 8 | ||
| Key Skills | 9 | ||
| Techie Terms | 12 | ||
| Test Your Knowledge | 15 | ||
| Evidence | 16 | ||
| 2 Operate a Computer | 17 | ||
| About This Unit | 17 | ||
| What Your Computer’s Made of | 18 | ||
| Computer Accessories | 19 | ||
| Getting Started | 23 | ||
| The Desktop | 26 | ||
| Desktop Icons | 29 | ||
| The Desktop Settings | 32 | ||
| Working with Windows | 34 | ||
| Finding Files | 35 | ||
| Windows Explorer | 38 | ||
| My Computer | 39 | ||
| Changing the View | 41 | ||
| Navigating Your Folders | 44 | ||
| Storing Data | 47 | ||
| Working Safely with Computers | 49 | ||
| Test Your Knowledge | 52 | ||
| Evidence | 52 | ||
| 3 IT Troubleshooting for Users | 55 | ||
| About This Unit | 55 | ||
| Spotting Errors | 55 | ||
| Fixing Errors Yourself | 60 | ||
| Dealing with a Frozen Computer | 62 | ||
| Getting Technical Support | 66 | ||
| Cleaning Up Your PC | 68 | ||
| Compatibility | 69 | ||
| Test Your Knowledge | 70 | ||
| Evidence | 71 | ||
| 4 IT Maintenance for Users | 73 | ||
| About This Unit | 73 | ||
| Cleaning Your PC | 74 | ||
| Maintaining Hardware | 76 | ||
| Managing Files | 77 | ||
| Default File Locations in Office | 80 | ||
| Upgrading Your System | 82 | ||
| Health and Safety | 83 | ||
| Test Your Knowledge | 84 | ||
| Evidence | 84 | ||
| 5 IT Security for Users | 87 | ||
| About This Unit | 87 | ||
| Keeping Your Files Secure | 87 | ||
| Staying Safe from Threats | 96 | ||
| Laws and Guidelines | 103 | ||
| Test Your Knowledge | 106 | ||
| Evidence | 107 | ||
| 6 Internet and Intranets | 109 | ||
| About This Unit | 109 | ||
| Introduction to the Internet | 110 | ||
| Connecting to the Internet | 112 | ||
| Using an Internet Browser | 115 | ||
| Customising Your Browser | 122 | ||
| Images | 128 | ||
| Searching for Information | 130 | ||
| Exchanging Information Online | 133 | ||
| Internet Security | 138 | ||
| Test Your Knowledge | 140 | ||
| Evidence | 141 | ||
| 7 Email | 143 | ||
| About This Unit | 143 | ||
| Understanding Email | 143 | ||
| Email Security | 145 | ||
| Opening Outlook | 146 | ||
| Outlook Screen | 147 | ||
| Opening the Inbox | 148 | ||
| Using Help in Outlook | 148 | ||
| Creating a Message | 149 | ||
| Formatting a Message | 152 | ||
| Receiving Email | 154 | ||
| Forwarding and Replying to Email | 155 | ||
| Sending and Receiving Attachments | 157 | ||
| Using Instant Messaging | 161 | ||
| Organising Your Emails | 163 | ||
| Deleting Email | 166 | ||
| Finding Messages | 166 | ||
| Using Archiving | 168 | ||
| Creating Contacts | 169 | ||
| Editing and Deleting Contacts | 171 | ||
| Using Personal Distribution Lists | 172 | ||
| Working with the Calendar | 174 | ||
| Working with Tasks | 175 | ||
| Test Your Knowledge | 175 | ||
| Evidence | 176 | ||
| 8 Word-processing Software | 177 | ||
| About This Unit | 177 | ||
| What is Word? | 178 | ||
| Entering and Deleting Text | 178 | ||
| Saving, Closing, Opening and New | 180 | ||
| Printing | 185 | ||
| Changing the Look of Text | 186 | ||
| Aligning Text | 188 | ||
| Inserting Special Characters and Symbols | 189 | ||
| Bullets and Numbering | 190 | ||
| Customising Bullets | 192 | ||
| Customising Numbers | 192 | ||
| Indenting Text | 193 | ||
| Borders and Shading | 195 | ||
| Styles | 198 | ||
| Page Numbering | 200 | ||
| Improving Efficiency | 201 | ||
| Moving and Copying Text | 202 | ||
| Page Breaks | 204 | ||
| Margins and Page Set-up | 205 | ||
| Line Spacing | 206 | ||
| Headers and Footers | 207 | ||
| Tabs | 209 | ||
| Spelling and Grammar | 210 | ||
| Go To, Find and Replace | 212 | ||
| Proofing | 215 | ||
| Creating and Editing Tables | 215 | ||
| Selecting Parts of a Table | 218 | ||
| Inserting and Deleting Rows and Columns | 220 | ||
| Resizing Rows | 222 | ||
| Resizing Columns | 222 | ||
| Moving and Resizing Tables | 223 | ||
| Borders | 223 | ||
| Shading | 226 | ||
| Table AutoFormat | 227 | ||
| Adding Graphics | 228 | ||
| Selecting, Moving and Resizing Pictures | 229 | ||
| Charts | 230 | ||
| Excel Worksheets in Word | 231 | ||
| Excel Charts in Word | 232 | ||
| Advanced Saving | 234 | ||
| Mail Merge | 235 | ||
| Creating your Data Document | 236 | ||
| Carrying out a Mail Merge | 237 | ||
| Test Your Knowledge | 240 | ||
| Evidence | 241 | ||
| 9 Spreadsheet Software | 243 | ||
| About This Unit | 243 | ||
| What is Excel For? | 244 | ||
| Starting and Closing Excel | 246 | ||
| Opening and Closing Workbooks | 246 | ||
| Creating a New Workbook | 248 | ||
| Saving Your Workbook | 248 | ||
| Using Shortcuts | 250 | ||
| Entering Text and Numbers | 251 | ||
| Correcting Mistakes | 253 | ||
| Selecting Cells | 254 | ||
| Adding Up Numbers with AutoSum | 255 | ||
| Typing the Sum Function to Add Up Numbers | 257 | ||
| Entering Simple Formulae | 258 | ||
| Error Messages | 261 | ||
| Cut, Copy and Paste | 263 | ||
| Using AutoFill to Copy Text and Formulae | 263 | ||
| Find and Replace | 265 | ||
| Sorting | 266 | ||
| Filtering | 268 | ||
| Subtotals | 268 | ||
| Importing Data | 270 | ||
| Using Absolute Cell References | 273 | ||
| Relative Cell References | 274 | ||
| Finding the Average | 274 | ||
| Print Preview | 277 | ||
| Page Break Preview | 278 | ||
| Printing a Worksheet | 279 | ||
| Changing the Page Set-up | 279 | ||
| Creating Headers and Footers | 282 | ||
| Inserting and Deleting Rows and Columns | 284 | ||
| Resizing Rows and Columns | 286 | ||
| Changing the Font and Font Size | 287 | ||
| Changing the Number Format | 289 | ||
| Changing the Alignment | 290 | ||
| Applying Borders | 291 | ||
| Adding Colours to Cells | 293 | ||
| Creating Charts | 293 | ||
| Moving, Resizing and Deleting Charts | 300 | ||
| Using the Chart Toolbar | 301 | ||
| Changing Chart Options | 302 | ||
| Test Your Knowledge | 302 | ||
| Evidence | 303 | ||
| 10 Database Software | 305 | ||
| About This Unit | 305 | ||
| Access | 306 | ||
| Opening, Saving and Closing a Database | 306 | ||
| What is a Database? | 308 | ||
| The Parts of an Access Database | 309 | ||
| Using Tables | 311 | ||
| Changing the View of a Table | 315 | ||
| Creating New Fields | 315 | ||
| Field Properties | 317 | ||
| Searching and Sorting Records | 321 | ||
| Toolbars | 323 | ||
| Creating a Simple Query | 324 | ||
| Changing the View | 327 | ||
| Adding Criteria to Queries | 328 | ||
| Numbers, Dates and Wildcards | 330 | ||
| Adding More Than One Criteria | 331 | ||
| Sorting Queries | 333 | ||
| Using Forms | 335 | ||
| Using Reports | 337 | ||
| Creating reports | 340 | ||
| Summary Options on a Report | 342 | ||
| Data Integrity | 344 | ||
| Checking Your Work | 346 | ||
| Test Your Knowledge | 347 | ||
| Evidence | 348 | ||
| 11 Website Software | 349 | ||
| About This Unit | 349 | ||
| Introduction to the World Wide Web | 350 | ||
| Creating Webs | 351 | ||
| Creating and Saving Web Pages | 353 | ||
| Opening Pages | 356 | ||
| Formatting Text | 356 | ||
| Horizontal Lines | 358 | ||
| Colour | 359 | ||
| HTML Tags | 362 | ||
| Managing Your Files | 364 | ||
| Understanding Templates and Wizards | 365 | ||
| Website Templates | 366 | ||
| Page Templates and Wizards | 367 | ||
| Understanding Links | 368 | ||
| Links Between Pages in a Site | 368 | ||
| Linking to Other Websites | 369 | ||
| Linking to an Email Address | 370 | ||
| Linking to a Bookmark | 370 | ||
| Hyperlink Colours | 372 | ||
| Testing Hyperlinks | 373 | ||
| Clear Navigation | 374 | ||
| Creating Tables | 375 | ||
| Working with Frames | 379 | ||
| Images in Your Web Page | 382 | ||
| Customising Images | 389 | ||
| Placing Text in Your Web Pages | 390 | ||
| Importing Files | 391 | ||
| Publishing | 393 | ||
| Spell Checking | 394 | ||
| Uploading Your Site | 396 | ||
| Test Your Knowledge | 398 | ||
| Evidence | 398 | ||
| 12 Artwork and Imaging Software | 401 | ||
| About This Unit | 401 | ||
| Thinking About Your Work | 402 | ||
| What File Format Should I Use? | 402 | ||
| What is a Colour Mode and Which Should I Choose? | 405 | ||
| Graphic Types | 406 | ||
| Starting with Photoshop | 407 | ||
| Handling Files | 412 | ||
| Layers | 416 | ||
| Selecting | 419 | ||
| Drawing Tools | 422 | ||
| Working with Images | 428 | ||
| Adding Text | 437 | ||
| Warped Type | 440 | ||
| Test Your Knowledge | 441 | ||
| Evidence | 442 | ||
| 13 Presentation Software | 443 | ||
| About This Unit | 443 | ||
| What is PowerPoint? | 444 | ||
| Creating a New Presentation | 444 | ||
| Applying a Template | 445 | ||
| Saving a Presentation | 446 | ||
| Opening and Closing a Presentation | 447 | ||
| Adding Text to Slides | 448 | ||
| Creating New Slides | 450 | ||
| The Different Views Within PowerPoint | 451 | ||
| Slide Sorter View | 452 | ||
| Adding Slide Transitions | 453 | ||
| Adding Sounds | 453 | ||
| Adding Animation Effects | 455 | ||
| Printing Slides | 455 | ||
| Moving, Resizing and Deleting Placeholders | 457 | ||
| Moving and Copying Text | 457 | ||
| Moving, Copying and Deleting Slides | 459 | ||
| Creating Speaker’s Notes | 461 | ||
| Changing the Appearance of Text | 462 | ||
| Bullets and Numbering | 464 | ||
| Changing the Background | 465 | ||
| Checking Your Presentation | 466 | ||
| Designing Your Presentation | 468 | ||
| Importing Text from Word | 470 | ||
| Importing Charts from Excel | 471 | ||
| Importing Slides from Another Presentation | 472 | ||
| What is an Organisation Chart? | 473 | ||
| Adding Pictures to Slides | 476 | ||
| Using the Clipart Gallery | 477 | ||
| Moving, Copying, Resizing and Deleting | 479 | ||
| Rotation and Ordering | 481 | ||
| Alignment | 483 | ||
| Using the Drawing Toolbar | 485 | ||
| Test Your Knowledge | 486 | ||
| Evidence | 487 | ||
| 14 Specialist or Bespoke Software | 489 | ||
| About This Unit | 489 | ||
| Using the Software | 490 | ||
| Test Your Knowledge | 492 | ||
| Evidence | 493 | ||
| 15 Evaluate the Impact of IT | 495 | ||
| About This Unit | 495 | ||
| IT and Society | 496 | ||
| IT Issues | 499 | ||
| Learning More About IT | 501 | ||
| Test Your Knowledge | 502 | ||
| Evidence | 502 | ||
| 16 Use IT Systems | 505 | ||
| About This Unit | 505 | ||
| Choosing This Unit | 506 | ||
| Test Your Knowledge | 506 | ||
| Evidence | 507 | ||
| 17 Use IT to Exchange Information | 509 | ||
| About This Unit | 509 | ||
| Choosing This Unit | 509 | ||
| Test Your Knowledge | 510 | ||
| Evidence | 511 | ||
| Index | 513 |