1 Computers, part of your life Grade 11. A textbook for computer Applications Technology Sandra Jacobs Reinet Barnard Rinus Brenkman Keith Gibson Ellen Labuschagne Pam Macmillan Pam Miller Chris Noom Karin Stoffberg Ulza Wassermann i Published by Study Opportunities PO Box 52654, Dorandia, 0188. Tel: (012) 565-6469. Fax: (012) 546-5313. E-mail: July 2012. ISBN: 978-1-919867-88-5. Study Opportunities Copyright strictly reserved. No part of this publication may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording or by any information storage or retrieval system, without permission in writing from the publisher. DTP, layout and design by Ronelle Oosthuizen Printed by Intrepid Printers (Pty) Ltd - 7572. ii Foreword Dear learner Congratulations!
2 You have made an incredibly wise and exciting choice in selecting computer Applications Technology (CAT) as a subject. You are going to develop skills which you will be able to use for the rest of your life . irrespective of your career path. The subject can even open up some career paths. We've been involved in writing CAT textbooks for a number of years. As teachers we have seen, first-hand, what works, and we have learned just how to adapt and customise our material to best suit our customers you, the learner. We have left no stone unturned in smoothing the way for you, or in tapping into the fun and enjoyment of the subject. This book will support you and your teacher every step of the way. We know that in two years' time you will look back and say that CAT was one of the best decisions you ever made!
3 The authors iii contents Section 1: System Technologies and Implications Page 1 Module Term It's all about 1. Input and 1. Memory, storage and 2. 3. computer 3. The dark side of 4. Section 2: Network and Internet Technologies Page 83 Module Term Local area 2. The browsing 2. Online lifestyle ..101 3. Managing 4. Section 3: Word Processing Page 133 Module Term Working with 1. Page 1. Paragraph 1. Forms and 1. 2. Mail 3. 3. iv Section 4: Spreadsheets Page 213 Module Term Revising and improving spreadsheet 1. 1. Decisions and 2. Other 3. Section 5: Databases Page 259 Module Term Introduction to 1. 1. 2. Designing a database 2. 3. Section 6: HTML / Web design Page 347 Module Term Basic concepts of web 2. More web design 3. Section 7: Information Management Page 375 Module Term Finding 2. Processing 3.
4 Presenting 4. Section 8: Integrated Skills Page 413 Module Term Working 4. Case 4. Page 427 Appendix A. Changing and formatting Access v Table of contents Section 1. System Technologies and 1. Module It's all about 2. Introduction ..2. The role and value of ICT in the The computer ..5. Protecting your Module Input and 14. What makes it all work?..31. Input and output for physically challenged Input and output and health Module Memory, storage and 37. Memory and storage ..37. Module 52. Application software ..52. Compatibility Updating your Online software ..56. Software for physically challenged Module computer 63. System requirements ..63. Software Managing Dealing with hardware Module The dark side of 73. Human The criminal side of vi Section 2. Network and Internet 83. Module Local area 84.
5 What is a network? ..84. Basic components of a Advantages and disadvantages of a LAN and Basic network Ethical use of Module The browsing 95. The usability of Other factors that affect the browsing Module Online lifestyle ..101. Internet Digital communications ..103. Online Mobile 111. Protecting yourself 112. Workplace and employment 115. Module Managing E-mail Add tokens to e-mail Move messages to another Find messages more Send messages more Best Section 3. Word Module Working with files .. 134. General file Importing of other file formats ..138. Help ..140. Module Page 147. Understanding and using sections ..147. Headers and Cover Module Paragraph 163. Lists with bullets and Customised Module Forms and 174. Word vii Module 185. What is a style?..185. Using existing Creating and changing Module Mail 194.
6 How mail merge Steps that must be Module Table of contents ..201. Citations and bibliography ..207. Section 4. Module Revising and improving spreadsheet 214. Overview of basic Conditional Auto Fill Cell Module 226. Functions ..226. Interpretation of error Module Decisions and 237. The IF Module Other facilities .. 248. Copying Handling a worksheet as a whole ..249. Use different print options ..252. Link data in worksheets ..253. Excel's help Section 5. 259. Module Introduction to 260. What is a database?..260. Structure of a First encounter with Access ..261. Working with Creating a table ..272. viii Module 285. View and use an existing The sections in a Create a new Improving an existing form ..289. Module 297. The design and result of a Formulation of simple criteria ..299. Creating a Queries with criteria for different Module Designing a database 313.
7 Design of the basic table Refining the table structure ..315. Design for more valid data Databases and social Module 328. First acquaintance with a Different sections in a Creating a basic report ..330. Changing the appearance of a report ..333. Creating reports with Calculations in a Section 6. HTML / Web Module Basic concepts of web 348. How is HTML used to create a web page?..349. The structure of an HTML document ..350. Basic markup Create formatted web Module More web design 362. HTML Format the text used on a web Add images ..366. Create Create a ix Section 7. Information 375. Module Finding information .. 376. Problem solving and information management ..376. Formulating a task Deciding what data and information is needed ..380. General tips on setting Surveys for collecting Checking the quality of Module Processing 392.
8 Exporting and importing ..392. Tips, tools and techniques to process data ..396. Module Presenting 406. Using appropriate software tools for Creating a Technical Section 8. Integrated Module Working 414. Using templates to work smarter ..415. Use Excel to solve Using Access to solve problems ..420. Module Case 426. Introduction ..426. Assistance with organising and running a hockey Providing basic computer Appendix Changing and formatting Access x