Via Afrika Computer Applications Technology

1 Fotiene Avrakotos Michael Britton Estelle Llewellyn Sakhile Mthombeni Sharon Oelofsen Brandon Rennie Anton van Kampen Via Afrika Computer Applications Technology Grade 11 Copyright Via Afrika Publishers, Computer Applications Technology Grade 11 ii This is the best Grade 11 Computer Applications Technology study guide you will ever have! Here are some tips to make this a good year. Remember, good learning begins in the classroom! Always: listen and concentrate observe: watch carefully what is happening make notes to help you remember what you are learning ask questions to make sure you understand. Study tips Allocate one hour every week-night as study time in addition to your homework.

2 Decide when your main study time should be. Some learners study better in the early morning, some study better in the evening. Keep to your timetable. Study time is a priority it is one of the most important things in your life at school. Find a quiet place to study. (Try a quiet classroom at school or the local library if possible.) Choose study partners who are serious about doing well to work with you. 7 golden rules for success 1 Always do your homework. 2 Do not fall behind. 3 Study every day. 4 Eat healthy food and sleep at least eight hours each night. 5 Make sure you understand as you go along. 6 Do it now! 7 Do not give up: learning gets easier and faster when you practise. Good luck!

3 The authors Copyright Via Afrika Publishers, Computer Applications Technology Grade 11 iii Contents Welcome Via Afrika Computer Applications Technology Grade 11 ii Chapter 1 Systems technologies 1 Unit 1 General concepts (Term 1) 2 Unit 2 Hardware (Term 1) 5 Unit 3 Hardware (continued) (Term 2) 10 Unit 4 Software (Term 3) 13 Unit 5 Hardware, software and Computer management (Term 3) 15 Chapter 2 Network technologies 16 Unit 1 Networks (Term 2) 17 Chapter 3 Internet technologies 22 Unit 1 The WWW (Term 2) 23 Unit 2 The Internet, WWW and communication (Term 3) 26 Unit 3 Managing e-mail (Term 4) 31 Chapter 4 Word processing 33 Unit 1 Formatting and customising documents (Term 1) 34 Unit 2 Applying styles (Term 2) 43 Unit 3 Mail merge and references (Term 3) 44 Unit 4 Mail merge and integration (Term 4) 48 Chapter 5 Spreadsheets 50 Unit 1 Formatting, formulas and functions (Term 1) 51 Unit 2 IF function, charts and integration (Term 2) 54 Unit 3 Work with and share spreadsheets (Term 3) 56 Unit 4 Solving problems with spreadsheets (Term 4) 59 Chapter 6 Databases 62 Unit 1 Database concepts and basic skills (Term 1) 63 Unit 2 Table design and Queries (Term 2) 69 Unit 3 Reports and external data (Term 3) 73 Unit 4 Integration and problem solving (Term 4) 75 Chapter 7 HTML and web design 80 Unit 1 Introduction to HTML (Term 2)

4 81 Unit 2 Web design and more HTML (Term 3) 86 Chapter 8 Information management and PAT 93 Unit 1 Gathering and managing information (Term 2) 94 Unit 2 Processing information (Term 3) 97 Unit 3 Presenting information (Term 4) 99 Exams Papers and Memorandums 103 Practical Examination Paper 1 103 Theoretical Examination Paper 2 109 Practical Examination Paper 1 Memorandum 118 Theoretical Examination Paper 2 Memorandum 121 Copyright Via Afrika Publishers, Computer Applications Technology Grade 11 iv Copyright Via Afrika Publishers, Computer Applications Technology Grade 11 1 Chapter 1 System technologies Overview To get the most out of this chapter, you need to be familiar with the hardware and software concepts that were covered in Grade 10.

5 In this chapter, you will learn about general concepts of computing: hardware input and output devices; hardware storage devices and processing procedures; software and software management; and basic Computer management. Copyright Via Afrika Publishers, Computer Applications Technology Grade 11 2 Unit 1 General concepts (Term 1) 1 Information processing cycle The information processing cycle consists of input, processing, output and storage. Input is data being entered into a computing device using an input device. Processing is when data is being translated into something useful by the CPU and RAM. Output is when information is presented to the user after processing.

6 Information and data can be stored for future use. Computers can communicate data and information using a communication network. 2 Types of computers and typical features Dedicated computers Dedicated computers are designed to perform a specific task rather than for general use. Examples include ATMs, washing machines and MP3 players. Computers housed in appliances or other equipment are called embedded computers. Mobile computers and devices Mobile computers are designed to be easily portable. Mobile devices include PDAs, laptops and smart phones. A PDA (Personal Digital Assistant) is a small touch screen device that acts as an electronic diary. PDAs are primarily used for appointments and reading documents.

7 A smart phone is a cellular phone with functions and features normally found on computers. PDA features include: ability to run third -part y software an up-to -date operating system, such as Android or Symbian greater processing power than cell phones more storage space than a cell phone or PDA programmability e-mail facilities. Laptop computers have the same features and functions as desktop computers, but are designed to be mobile. Features include: smaller size than desktop computers input and output devices are integrated into the unit ability to run from battery power, as well as a power outlet. A tablet Computer uses a touch screen interface.

8 A virtual keyboard is used instead of an actual physical keyboard. A tablet Computer can accept handwritten notes and speech input. Client/server This is a shortened way of saying client/server network. Computers that provide resources on a network are called servers. Computers that use resources on a network are called clients. Copyright Via Afrika Publishers, Computer Applications Technology Grade 11 3 3 Computer categories Portable and non-portable computers Portable computers include computing devices designed to be easily portable. Non -portable computers are designed to remain in one place. Usage Computers can be categorised according to the way they are used, such as: education business use personal use industrial use.

9 Processing power A CPU sends out electrical pulses to synchronise components. The number of pulses governs the speed of the Computer . CPU speed is based on the amount of instructions it can complete in a second. Personal computers Personal computers are used for home and business use. CPUs can have multiple cores, such as a dual core or quad core machine. Mainframes Mainframes are d esigned to handle large amounts of data reliably. Mainframes can store huge amounts of data. Supercomputers Supercomputers are the most powerful computers available. They are used for resource intensive tasks, such as weather forecasting. 4 The role of ICT in the workplace Education and training Computers can adapt to the speed of the learner Lecturers and learners can communicate over any distance Demand for skilled workers in ICT has gone up Communication Networks allow communication between workers.

10 E-mail and video conferencing are more efficient than travelling. Careers Computer Technology enabled the building of robots. Robots can work in places where humans cannot, such as: explore remote areas , such as the moon explore dangerous places Copyright Via Afrika Publishers, Computer Applications Technology Grade 11 4 defuse bombs in urban areas work in toxic areas perform menial work. Knowledge and skills learnt in CAT can be used in ICT careers, such as: communication technician management of computers training workers in the use of ICT Computer technician web designer. 5 Social issues related to the use of hardware and software Hardware theft and protection Laptops can be fastened to a fixture using a Kensington lock.