Computer Application Technology Grade 12

Document Sample
Computer Application Technology Grade 12 Powered By Docstoc
					 Computer
Application
Technology
 Grade 12
                                 Table of Contents
                                                                          Page number
Module 1
Unit 1
Chapter 1        Computer hardware, input and output                                 3
Chapter 2        Computer software                                                  14
Chapter 3        Networks                                                           18

Unit 2
Chapter 1        MSWord                                                             26
Chapter 2        Tables in a word-processing program                                29
Chapter 3        Merged documents (Mail Merge)                                      34

Unit 3
Chapter 1        MSExcel                                                            41

Unit 4
Chapter 1        MSAccess                                                           60

Module 2
Unit 1                                                                              71
Chapter 1        MSAccess (Database program)                                        71
Unit 2
Chapter 1        Computer ethics and, information and                               84
                 communication technology
Unit 3
Chapter 1        MSExcel (Spreadsheet program)                                      93
Unit 4
Chapter 1        MSWord: Multipurpose use of table lines                            100
Unit 5
Chapter 1        MSPublisher                                                        109

Module 3
Unit 1
Chapter 1        Ergonomics and social implications                                 115
Unit 2
Chapter 1        MSAccess                                                           124
Unit 3
Chapter 1        Operational knowledge (Revision)                                   138
Unit 4
Chapter 1        MSExcel (Extended IF function and revision                         150
Chapter 2        MSWord (Revision)                                                  158




            Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                       Page 2 of 166
 Unit 1
Activity 1
 Planning
Documents
                                                                                         SUBJECT FRAMEWORK: YEAR PLANNING
                                                                                           VAKRAAMWERK: JAARBEPLANNING
School:                                                                                  Year:                                                                                 Term/Weeks:
                      Grade 10: Module 1                                                             Grade JAARBEPLANNING
                                                                                            VAKRAAMWERK:11: Module 1                                                                                           Grade 12: Module 1
                                                                                          Duration
Duration of                       Learning                                                              36          Learning                                                    Duration of       36         Learning
                   36 hours                                10.1, 10.2, 10.3                  of                                                 11.1, 11.2, 11.3                                                                         12.1, 12.2, 12.3
 module:                         outcomes:                                                             hours       outcomes:                                                     module:         hours      outcomes:
                                                                                          module:
     Learning
                      Assessment standard                       Content                  Learning Outcomes        Assessment standard                    Content                Learning Outcomes        Assessment standard                     Content
    Outcomes
10.1:                10.1.1: Briefly describe      Terminology.                          11.1: Operational      11.1.1: Report on relevant     Computer hardware and           12.1: Operational         12.1.1: Demonstrate a        Computer hardware and
Operational          the basic operation and       Hardware and software.                knowledge of           computer hardware,             software. Network               knowledge of              knowledge of relevant        software. Network
knowledge of         terminology of relevant       Use of the keyboard.                  information and        software and local area        environments.                   information and           computer hardware,           environments.
information and      computer hardware and         Shortcut keys.                        communication          networks.                      End user computer               communication             software and wide area       End-user computer
communication        software and the aims and     Functions of word-processing          technologies: The                                     application programmes.         technologies: The         network environments.        applications programme.
technologies:        objectives of networked       program                               learner is able to                                    Effective use of different      learner is able to                                     Effective use of different
The learner is       environments.                 Use of the Internet.                  demonstrate                                           software (end-user)             demonstrate                                            software (end-user)
able to                                            Effective use of different software   operational                                           programmes: Word-               operational knowledge                                  programmes: Word-
demonstrate                                        (end-user) programmes: Word-          knowledge of                                          processing package              of information and                                     processing packages
operational                                        processing packages.                  information and                                       (advanced).                     communication                                          (advanced).
knowledge of                                       Spreadsheet (on elementary / basic    communication                                         Spreadsheet (on                 technologies and the                                   Spreadsheets (on
information and                                    level).                               technologies and the                                  elementary /basic level).       environment in which                                   elementary/basic level).
communication                                      Integration of general end-user       environment in which                                  Data base (elementary level     they operate.                                          Data base (elementary level –
technologies and                                   computer application skills in a      they operate.                                         – single table data sources).                                                          single table data sources).
the environment                                    variety of new environments and                                                             Additional software                                                                    Additional software programme
in which they                                      contexts.                                                                                   programme of own choice.                                                               of own choice.
operate.                                           Internet and e-mail.                                                                        Integration of general end-                                                            Integration of general end-user
                     10.1.2: Install, configure    Use input and process apparatus.                             11.1.2: Use suitable utility   user computer application                                 12.1.2: Demonstrate an       computer application skills in a
                     and use input and output      Use the keyboard.                                            software to carry out basic    skills in a variety of new                                understanding in trouble     variety of new circumstances
                     devices.                      Overview of different formats.                               trouble shooting functions.    circumstances and                                         shooting simple end-         and contexts.
                                                   Use of hardware as well as aspects                                                          contexts.                                                 user computer-related        Internet and e-mail.
                                                   of installation. Typing blind.                                                              Internet and e-mail.                                      hardware and software        Use an operating system
                                                   Use of the computer.                                                                        Use an operation system                                   problems.                    including file management.
                                                   Application of word-processing                                                              including file management.                                                             General trouble shooting.
                     10.1.3: Describe the          program functions. Process                                   11.1.3: Develop and            General trouble shooting.                                 12.1.3: Adequately           Skilful entering and
                     concept of file               information.                                                 maintain multi-level           Skills regarding entering                                 manipulate files and         manipulation of data. Find,
                     organisation in multilevel    Understand computer terminology.                             organisational structures in   and manipulation of data.                                 folders.                     collect, analyse and critically
                     directories.                  Knowledge of word-processing                                 multiple storage media.        Find, collect, analyse and                                                             evaluate data. Organise and
                                                   programme.                                                                                  critically evaluate data.                                                              process information in various
                     10.1.4: Identify legal,       Master the keyboard. Accuracy.                               11.1.4: Discuss legal,         Organise and process                                      12.1.5: Identify, discuss,   formats. Present and
                     ethical and security issues   Respect for fellow learners.                                 ethical and security issues    information in different                                  value and illustrate         communicate information.
                     related to information        Respect for school property                                  related to information         formats. Present and                                      issues related to the        Information and
                     technology.                   (computers). Neatness. Honesty.                              technology.                    communicate information.                                  impact of information        communication technologies in
                                                   Organise and evaluate information.                                                          Information and                                           and communication            various environments.
                                                                                                                                               communication                                             technologies on the          Computer ethics, security and
                                                                                                                                               technologies in various                                   environment and society      viruses. Social and
                                                                                                                                               environments. Computer                                    in a global context.         environmental issues. Effective
                                                                                                                                               ethics, security and viruses.                                                          communication. Accuracy,
                                                                                                                                               Social and environmental                                                               productivity and flexibility.
                                                                                                                                               issues. Effective
                                                                                                                                               communication. Accuracy,
                                                                                                                                               productivity and flexibility.




                                                                              Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                                                                                                  Page 112 of 130
                                                                                                                                                             Learning
Learning Outcomes               Assessment standard               Content    Learning Outcomes              Assessment standard              Content                                     Assessment standard                   Content
                                                                                                                                                            Outcomes
                          10.1.5: Describe certain basic issues                                       11.1.5: Describe the impact of                   12.2: Integrated      12.2.1: Apply productive methods, procedures
                          related to the impact of information                                        information and communication                    end-user              and techniques to accurately input data.
                          and communication technologies on                                           technologies on the environment                  computer
                          the local environment and society.                                          and society in a national context.               applications skills
                                                                                                                                                       and knowledge in
                                                                                                                                                       problem solving:
                                                                                                                                                       The learner is able
                                                                                                                                                       to apply and
                                                                                                                                                       integrate end-user
                                                                                                                                                       computer
                                                                                                                                                       applications skills
                                                                                                                                                       and knowledge to
                                                                                                                                                       solve problems
                                                                                                                                                       related to the
                                                                                                                                                       processing,
                                                                                                                                                       presentation and
                                                                                                                                                       communication of
                                                                                                                                                       information.
10.2: Integrated          10.2.1: Demonstrate a basic level of              11.2: Integrated end-     11.2.1: Use essential procedures,                                      12.2.2: Apply advanced word processing
end-user computer         competence and accuracy in the                    user computer             techniques and operations in the                                       techniques in various contexts.
applications skills       input of data.                                    applications skills and   accurate input of data.
and knowledge in                                                            knowledge in problem
problem solving:                                                            solving: The learner is
The learner is able to                                                      able to apply and
apply and integrate                                                         integrate end-user
end-user computer                                                           computer applications
applications skills and                                                     skills and knowledge to
knowledge to solve                                                          solve problems related
problems related to                                                         to the processing,
the processing,                                                             presentation and
presentation and                                                            communication of
communication of                                                            information.
information.
                          10.2.2: Enter, edit and format text,                                        11.2.2: Enter, edit and format text,                                   12.2.3: Apply knowledge and skills of a
                          numerical data and graphics using                                           numerical data and graphics using                                      spreadsheet programme in various contexts.
                          basic techniques in a word ─                                                advanced techniques in a word
                          processing programme.                                                       processing programme.
                          10.2.6: Demonstrate understanding                                           11.2.3: Use logical functions and                                      12.2.4: Apply knowledge and skills of a
                          of a variety of communication modes                                         formulae to process data and create                                    database programme in various contexts.
                          and tools.                                                                  and edit charts in a spreadsheet
                                                                                                      programme by applying appropriate
                                                                                                      techniques.
                                                                                                      11.2.7: Use written and simple                                         12.2.6: Apply logical thinking to respond to
                                                                                                      electronic reviewing and editing                                       challenges in a variety of contexts in the end-
                                                                                                      instructions to produce accurate                                       user computer application environment using
                                                                                                      output.                                                                techniques of integration.
                                                                                                      11.2.8: Communicate information                                        12.2.7: Interpret written and electronic layout
                                                                                                      effectively by using a variety of                                      and editing instructions to produce accurate
                                                                                                      communication modes and tools.                                         output in a competent fashion.




                                                                    Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                                                                                       Page 113 of 130
                                                                                                                                                       Learning
Learning Outcomes             Assessment standard              Content    Learning Outcomes               Assessment standard         Content                                    Assessment standard               Content
                                                                                                                                                      Outcomes
                                                                                                                                                12.3: Information    12.2.8: Communicate information effectively
                                                                                                                                                management: The      by selecting and using appropriate
                                                                                                                                                learner is able to   communication modes and tools.
                                                                                                                                                apply information    12.3.1: Make informed decisions in the data
                                                                                                                                                management           collection process.
                                                                                                                                                processes and
                                                                                                                                                skills using end-
                                                                                                                                                user computer
                                                                                                                                                applications.



10.3: Information      10.3.1: Use technologies to locate                11.3: Information          11.3.2: Organise, record and                                     12.3.2: Apply logical thinking skills when
management: the        and collect specific data using                   management: The            summarise information in                                         processing information.
learner is able to     relevant methods.                                 learner is able to apply   appropriate electronic formats.
apply information      10.3.2: Extract and record                        information                                                                                 12.3.3: Formulate responses and present and
management             information in appropriate electronic             management processes                                                                        communicate information in a professional
processes and skills   formats.                                          and skills using end-                                                                       fashion.
using end-user         10.3.3: Present and communicate                   user computer
computer               information in electronic formats.                applications.
applications.




                                                                 Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                                                                                     Page 114 of 130
                                 WORK SCHEDULE

  Week:         Module
                                        Learning
   Date          Unit
                                     Outcomes and                                  Assessment
started:        and/or       Time                                Content
                                      Assessment                                     Tasks
   Date        chapter
                                       Standards
 ended:        numbers
                Mod. 3        8      12.1.2; 12.1.5;
                Unit 1      hours    12.2.1; 12.2.4;      Ergonomics and social
                Chap. 1              12.2.5; 12.3.1;           implications
                                         12.3.2
 Week:          Module
                                        Learning
                 Unit
   Date                              Outcomes and                                  Assessment
                and/or       Time                                Content
started:                              Assessment                                     Tasks
               chapter
   Date                                Standards
               numbers
 ended:
                 Mod. 3       8      12.2.1; 12.2.4;
                 Unit 2     hours    12.2.6; 12.2.7;            MSAccess
                Chap. 1                  12.2.8
  Week:         Module
                                        Learning
   Date           Unit
                                     Outcomes and                                  Assessment
started:         and/or      Time                                Content
                                      Assessment                                     Tasks
   Date        chapter
                                       Standards
 ended:        numbers
                 Mod. 3       6      12.1.1; 12.1.2.;
                 Unit 3     hours    12.1.3; 12.1.4      Operational knowledge
                Chap. 1
  Week:         Module
                                        Learning
   Date           Unit
                                     Outcomes and                Content           Assessment
started:         and/or      Time
                                      Assessment                                     Tasks
   Date         chapter
                                       Standards
 ended:        numbers
                 Mod. 3      14      12.2.1; 12.2.2;
                 Unit 4     hours    12.2.3; 12.2.6;     MSExcel (Extended IF-
                 Chap.               12.2.7; 12.2.8;     function and revision)
                  1-2                12.3.1; 12.3.2;       Revision: MSWord
                                         12.3.3




           Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                    Page 110 of 130
                                   LESSON PLANS


Unit number:             1
chapter number:      1        Duration      2,5     Planned              Actual
                              of            hours   date:                date:
                              activity:

Learning Outcomes and Assessment Standards:
12.1.1; 12.1.2

Content:
Computer hardware, input and output

Activity:
Revision test

Resources:
Computer

Assessment Tasks:


For assessment by the teacher:
Remedial:
Enrichment:
Reflection:
Homework:




           Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                      Page 120 of 130
       P

  Learning and
Teaching Support
 Material (LTSM)
                                                                 1



                                                    1




                         1

Computer hardware, input and output

1.        In Grade 10 and 11 you learnt about the various components of a computer.
          Before we commence, it is essential that we again take a quick look at what
          we already know.

1.1       Study the following pictures and try to name all nine correctly.


      A                               B                                    C




      D                               E                                    F




      G                               H                                    I




          If you named picture G correctly, you will also remember that we learnt about
          the motherboard in Grade 11. Do you still remember that the essential
          electronic components and circuits meet on the motherboard?




             Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                        Page 3 of 166
•     The motherboard forms the core of the computer.
•     The motherboard enables all the other parts of the computer to function.
•     The components of the computer cannot function without the motherboard.

1.2   What is meant by components? They are the different sections of the mother-
      board with which contact is made to enable the computer to function. Read
      through the following information and answer the questions that follow.




A.    The motherboard

      The motherboard is the section of the computer that houses all the components
      of the computer. Components can be plugged into slots or be connected to the
      motherboard in various ways.

      The following components are found on the mother board:

•     the CPU (Central Processing Unit)
•     memory
•     sound card
•     video card
•     network card
•     extension slots
•     system clock
•     control panel for the: hard drive
                             CD or DVD
                             keyboards
                             serial and parallel ports
                             USB, MIDI port, Bluetooth port, Firewire
                             ports for audio input and output

I.    The CPU

      The CPU is the main component that does all the work and is found inside the
      computer. The CPU contains the
•     control unit
•     arithmetical logical unit
•     floating point unit – calculations with numbers
•     registers – storage area for data and instructions
•     cache

The speed of the CPU is measured in MHz (Megahertz).




          Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                     Page 4 of 166
II.    Memory

(i)    Primary memory

       RAM refers to the changeable memory in which data you are working with can
       be stored temporarily. Data is lost if the computer is turned off or if there is a
       power failure.

       ROM refers to the memory that is needed to turn the computer on. The
       content within cannot be changed but it remains stable when the computer is
       turned off.

(ii)   Secondary memory

       This refers to the permanent storage of data. The data is therefore not lost
       when the computer is turned off. The following components can be used for
       this type of memory:

•      Stiffies – are not widely used any more
•      Hard drive
•      CD
•      DVD
•      Flash disk

III.   Expansion slots

       Expansion cards are inserted into expansion stots.

IV.    Controllers

       Controllers are used to connect important components, such as hard drives,
       keyboards and ports.

V.     System clock

       The system clock is a quartz crystal that can be found in the motherboard.
       The crystal vibrates at a set number of times per second. These vibrations are
       called clock pulses. With every clock pulse signals are sent through the
       computer. The faster the clock pulses, the faster the computer is able to
       operate.


1.3    Use different coloured pencils, or draw neat lines, and connect the descriptions
       on the left with the correct term on the right.




          Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                     Page 5 of 166
1.3.1  Each clock pulse sends ... through the
                                                                              CPU
       computer.
1.3.2 Component on the motherboard that
                                                                           megahertz
       controls everything.
1.3.3 Changeable memory.                                                     ROM
1.3.4 Stiffies, CDs, DVDs, flash disks.                                    Controllers
1.3.5 Connects components to the
                                                                              RAM
       motherboard.
1.3.6 Quartz crystal which vibrates at a set
                                                                              ROM
       times per second (clock pulses).
1.3.7 Memory which cannot be changed.                                 Secondary memory
1.3.8 The speed of the CPU is measured
                                                                             signals
       in …
1.3.9 Connecting components such as hard
                                                                          Plug-in slots
       drives, keyboards and ports.
1.3.10 The content is not changed or lost
                                                                          System clock
       during power failures.
                                                                                      (10)
                                                                               Total: (10)

2.      Read the information and answer the questions that follow.




B.      Input

        There are various systems which can be used for input.

I.      The keyboard

        The most common method of feeding data into a computer is by using a
        keyboard. There have been many developments concerning the keyboard.
        There are keyboards that are separated in the middle to reduce strain to your
        arms and wrists, and the latest keyboard is one that can be rolled up!




           Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                      Page 6 of 166
II.    Input device

       The most common input device which is used is the mouse. Other examples
       of input devices are:

•      a trackball,
•      a touchpad,
•      pointing devices,
•      optical pens and
•      touch screens.

III.   Optical scanners

       Optical scanners are used to transfer images or text to the computer. When
       text is scanned, an optical character recognition (OCR) system is used to
       convert the text to ASCII characters which the computer can understand. The
       text can then be edited.

IV.    Digital cameras

       Digital cameras are widely used these days because the photos can be
       downloaded onto the computer by connecting the camera to the computer
       using a USB cable. An application package is however needed to edit the
       photos. Photo Adobe is an example of such a package, but there are other
       packages available for this purpose as well.

V.     Video cameras

       Video cameras are used to send moving images and sound to the computer.
       They are very handy when video conferences take place. Video conferences
       enable people to communicate long distance and to see each other during the
       communication. To set up a video conference, the following is needed:

•      video conference software
•      video camera
•      microphones
•      speakers

       If the computer has a good sound card and you have a microphone and the
       necessary software, you can make use of speech recognition. Certain software
       first has to learn to recognise certain words, but there is software that
       compares sounds to a built-in set of word or sound patterns. This enables the
       program to find the correct word.




          Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                     Page 7 of 166
        As computers are increasingly used these days to operate in areas where fraud
        can easily take place, biometry is used to verify your identity. Certain
        companies use hand scanners to determine whether the person can gain access
        to a building.

        A fingerprint scanner can be used to prevent card fraud, and iris recognition
        systems which determine your identity by scanning the patterns and lines of
        the iris are also used. In certain circles this type of system is seen as more
        effective than fingerprints, as the iris of each person is unique.

        Provision is also made for persons with disabilities. Keyboards can be adapted
        to make the letters easier to read for people with weak sight.

        Mouses can be moved by using either the head or the foot. If the person is
        disabled, fixed movement recognition systems can be used. This means that
        such a person can control the computer using eye movement or by nodding the
        head.


2.1     Why was a keyboard that is separated in the middle developed?              (4)

2.2     Name five types of input devices.                                          (5)

2.3     Name the unique characteristics of an optical scanner and describe the
        function of the optical character recognition system.                      (3)

2.4     Your friend would like to buy a camera. What advice would you give him
        when choosing between a normal camera and a digital camera?            (4)

2.5     How does the use of videoconferencing benefit us? Write down what is
        needed to set up a video conference.                                       (4)

2.6     Choose a term in column B that matches the description in column A.

                            Column A                   No.        Column B
        Apparatus which is commonly used to feed data
2.6.1                                                      Input devices
        into the computer.
2.6.2   Trackball, mouse, optical pen and touch screen     OCR
        Application packages to edit photos on a           Iris recognition
2.6.3
        computer                                           systems
2.6.4   Optical character recognition system               Hand scanners
        Recognises the computer user through the
2.6.5                                                      Cache
        patterns and lines in the eyes.
2.6.6   Can be used to prevent card fraud.                 Keyboard




           Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                      Page 8 of 166
       Column A                                               No. Column B
       A good sound card, microphone and speakers                 Fixed movement
2.6.7
       are necessary if you wish to set up ..............         systems
       Studies that are made to verify a person’s
2.6.8                                                               Fingerprint scanner
       identity.
       Determines that certain persons can gain access
2.6.9                                                               Speech recognition
       to a building or vehicle.
       Systems that enable disabled persons to control
2.6.10                                                              Mouse
       a computer.
                                                                    Photo Adobe
                                                                    Biometry
                                                                    Memory
                                                                                      (10)
                                                                               Total: (30)

3.     Read the information and answer the questions that follow.




C.     Output

       The Central Processing Unit (CPU) processes the data which is fed into the
       computer. Once the data has been processed, a method has to be found to
       make the data accessible to the user. Systems have been designed which
       present the processed data to the computer user in a format she/he can
       understand.

I.     Monitors/screens

       Two types of monitors are widely used these days. The most common
       monitor is the CRT monitor. CRT is the acronym for Cathode Ray Tube.
       These screens are available in different sizes, for example 14”, 17”, 19” or
       21”. This type of monitor is cheaper than other types of monitors but they take
       up work space.

       The image on the screen is formed by electrons that are
       projected against a layer of phosphorus. The dots that are formed
       are called pixels. Due to the fact that the electrons are
       projected against a layer of phosphorus, this action must be
       repeated continuously to prevent the image from fading
       completely. This continuous action causes the image flickering
       on the screen to flicker. This could strain the computer user’s
       eyes and could lead to headaches.




           Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                      Page 9 of 166
      The more modern LCD monitor (Liquid Crystal Display)
      is used more frequently these days. It was initially used only
      in laptops. The advantage of this monitor is that the image is
      not formed through projected electrons, and therefore does not
      fade and also does not need to be refreshed. As the monitor is
      much thinner than the CRT monitor, it takes up much less space.
      It also radiates much less heat and attracts less dust than the
      older types of monitors.

II.   Printers

      As we often need what is shown on the screen, on hard copy (paper), we need
      printers. There are various types of printers. These printers differ in the
      following ways:

•     Interface: older printers connect by means of a parallel port while most new
      printers use a USB interface.
•     Speed: speed is measured by the number of pages printed per minute.
•     Print quality: different tasks need different print quality. When you merely
      want to print a page to see what the document will look like, it is not necessary
      to print in high quality. If you want to print photos, however, the quality will
      be much higher.
•     Running costs: refers to the items which are used by the printer that need to
      be replaced on a regular basis. Ink can be a very expensive item. To lower the
      costs, certain ink cartridges can be refilled.
•     Memory: because the computer operates at a higher speed than the printer, it
      is important that the printer has its own RAM. The work that must be printed
      can then be stored in the RAM until the printer can print it.
•     Paper: certain printers have a paper drawer which can hold a large quantity of
      paper. It is also important to know if the printer can print on different types of
      paper as well as on transparencies. The type of printer you buy will also be
      determined by what your printing needs are.

(i)   Types of printers

      Although dot matrix printers are still available, they
      are seldom used these days. They operate by using
      pins that hit against a ribbon to form characters.
      This hitting action makes this type of printer perfect
      for printing duplicates of invoices and accounts.
      Take a look at the printer used to print deposit slips
      in a bank the next time you are making a bank deposit.




         Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                   Page 10 of 166
       Laser printers operate in the same way as a photocopier. They do not use
       liquid ink but a powder that is burnt onto the paper. This type of printer
       produces very high quality printing and is cost-effective for large volumes of
       printing. The printing process is fast.




       An inkjet printer uses liquid ink that is sprayed onto the paper and is a good
       choice if colour printing needs to be done. This type of printer uses a large
       amount of ink and, although the ink cartridges can be refilled a few times, the
       ink is expensive and does not last long.
       Tip: If you are using Windows 98, you will need to load the driver programs
       for the printer from a CD. Windows XP as well as Vista make provision for
       most driver programs and should install this on its own when you connect the
       printer to the computer.
(ii)   Problems with the printer? (Trouble shooting)
       If you are experiencing problems with a printer, you could first try the
       following before consulting a technician:
•      Click on Start
•      Go to Printers and faxes
•      Select the printer that has a problem
•      Click on Troubleshoot printing. A list of questions will appear which you
       must answer. The problem may possibly be solved by using the suggestions
       given. If not, online help is available by clicking on Get help with printing.
III.   Input and output systems for the disabled
       There are systems available to facilitate the disabled. People who are hard of
       hearing can have output shown in words or images instead of sound. People
       who have a sight impediment can have the text enlarged or have the output
       printed on braille paper. They can also make use of the audio output systems
       to listen to information instead of reading it. The text to speech program can
       be used, where the text is read out loud.



          Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                    Page 11 of 166
3.1     Complete the sentence by filling in the missing words:

        Data is given through to the computer so that ______________ can take place
        in the CPU. Once processed, the results are given back to the computer user
        through _____________.                                                 (2)

3.2     Your friends ask your advice on buying a new monitor. They do not mind
        how much they pay, as long as they have a high quality monitor. Help them to
        make a choice and give reasons for your answer.                         (5)

3.3     You are working temporarily in a small business that specialises in selling
        printers. Which type of printer would you advise client 1, client 2 and client 3
        to buy? Give reasons, as they are very good clients.

        Client 1
        She would like to buy a printer for her teenage daughter to enable her to print
        out her school projects.                                                   (3)

        Client 2
        He works from home and prints and copies a large quantity of documents. (3)

        Client 3
        The owner of a small shop that delivers a large quantity of milk to clients. He
        would like to print invoices and accounts in duplicate.                      (3)

3.4     Find the term in column B that matches the description in column A. Write
        the correct number of the description next to the correct term in column B.

                            Column A                          No.         Column B
         Most printers are connected to a computer by
3.4.1                                                               Printing quality
         means of a …
3.4.2    Number of pages per minute.                                LCD monitor
3.4.3    Quality of the hard copy.                                  Dot matrix printer
         Printer items that are replaced on a regular
3.4.4                                                               CRT monitor
         basis.
         If the printer has this, the printing jobs can be
3.4.5                                                               Inkjet printer
         saved here till the printing process starts up.
         A printer which uses pins that hit against a               USB interface
3.4.6
         ribbon.
3.4.7    A printer which burns powder onto a paper.                 Running costs
         A printer which sprays liquid ink onto paper in            Microscopic printer
3.4.8
         small microscopic particles.
         Image on this monitor is formed by projecting              Speed
3.4.9
         electrons on a layer of phosphorus.



           Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                      Page 12 of 166
3.4.10                      Coloumn A                          No.        Coloumn B
          A monitor which takes up very little working               Laser printer
          space.
                                                                     RAM
                                                                     ROM
                                                                                       (10)
                                                                                Total: (26)




D.       Upgrading your computer

         The lifespan of computers is very short. After two to three years your
         computer might not perform according to your needs. This does not mean that
         you have to replace your PC. Upgrading is a cheaper and better alternative to
         replacement.

         People want to upgrade their computers
●        if they want the computer to perform tasks that are currently impossible;
●        if they want to improve the computer’s performance;
●        if the computer is unable to run the latest operating system or the latest version
         of the software they prefer to use.

         Upgrading can be done by
●        adding RAM to increase the speed of the computer
●        adding an extra hard drive and connecting it up with the USB, thus increasing
         the storage capacity.
●        removing the old video card and inserting a new one to improve the graphics;
●        adding or replacing the optical drive with something better, e.g. replacing the
         CD-ROM with a DVD-Writer.

         It might be necessary to replace a computer with a new one if
●        it is older than 3 years;
●        there are not enough USB-ports;
●        it is not possible to add more RAM;
●        the CPU is not sufficient and there are not enough expansion slots on the
         motherboard and
●        if the motherboard is outdated.

         You can upgrade your computer if
●        you have had it for less than three years;
●        there are DIMM slots on the motherboard to add RAM;
●        the speed of the CPU is more than 1.3 GHz;
●        there are enough USB ports and it is possible to insert a new video card.



            Grade 12 Computer Applications Technology Learner’s Book Module 1 - 3
                                      Page 13 of 166
                                                                   1



                                                      1




                       1


ASSIGNMENT

Computer hardware, input and output
(12.1.1; 12.1.2)

1.    Learners answer questions as revision of previous knowledge.
1.1   Learners study pictures and name them.
1.2   Learners read information.
1.3   Use different coloured pencils, or draw neat lines, and connect the descriptions on the
      left with the correct term on the right. The answers that follow are the content of the
      right column that has been rearranged to match the description on the left.

      1.3.1      Each clock pulse sends ....... through the computer.                  signals
      1.3.2      Component on the motherboard that controls
                                                                                        CPU
                 everything.
      1.3.3      Changeable memory.                                                RAM
      1.3.4      Stiffies, CDs, DVDs, Flash disks.                          Secondary memory
      1.3.5      Connects components to the motherboard.                        plug-in slots
      1.3.6      Quartz crystal which vibrates at a set number of
                                                                                System clock
                 times per second (clock pulses).
      1.3.7      Memory which cannot be changed.                                   ROM
      1.3.8      The speed of the CPU is measured in this.                        Megahertz
      1.3.9      Connecting components such as hard drives,
                                                                                 Controllers
                 keyboards and ports.
      1.3.10     The content is not changed or lost during power
                                                                                       ROM
                 failures.
                                                                                                (10)
                                                                                         Total: [10]




               Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                          Page 6 of 130
2.     Learners read the information in the Learner’s Book.

2.1    More and more people are experiencing strain on their arms and wrists which causes
       carpal tunnel syndrome and results in painful joints. By adapting the keyboard, this
       problem can be reduced.                                                        (4)

2.2    mouse, optical pen, trackball, pointing devices, touch pad                             (5)

2.3    Optical scanners are used to transfer images or text to the computer. When text is
       scanned, an optical character recognition (OCR) system is used to convert the text to
       ASCII characters which the computer can understand. The text can then be edited.
                                                                                        (3)

2.4    Photos can be downloaded onto the computer by connecting the camera to the
       computer using a USB cable. An application package such as Photo Adobe can be
       used to edit the photos.                                                 (4)

2.5    Video conferences enable people to communicate long distance and see each other
       during the communication if they have the following equipment:
       video conference software
       video camera, microphones and speakers                                     (4)

2.6    Learners select an answer in column B to match the description in column A.

       Column A                                                No.       Column B
       Apparatus which is commonly used to feed data           2.6.2
2.6.1                                                                    Input devices
       into the computer.
2.6.2 Trackball, mouse, optical pen and touch screen           2.6.4     OCR
       Application packages to edit photos on a                2.6.5     Iris recognition
2.6.3
       computer                                                          systems
2.6.4 Optical character recognition system                     2.6.9     Hand print scanners
       Recognises the computer user through the
2.6.5                                                                    Cache
       patterns and lines in the iris.
2.6.6 Can be used to prevent card fraud.                       2.6.1     Keyboard
       Good sound card, microphone and speakers are            2.6.10    Fixed movement
2.6.7
       necessary if you wish to set up ...                               systems
2.6.8 Studies that are made to verify a person’s identity.     2.6.6     Fingerprint scanner
       Determines that certain persons can gain access to      2.6.7
2.6.9                                                                    Speech recognition
       a building or vehicle.
       Systems that enable disabled persons to control a       2.6.3
2.6.10                                                                   Mouse
       computer.
                                                               2.6.8     Photo Adobe
                                                                         Biometry
                                                                         Memory
                                                                         Fixed movement
                                                                         systems
                                                                                           (10)
                                                                                  Total: [30]



              Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                         Page 7 of 130
3.      Learners read the information in the Learner’s Book.
3.1     Learners complete the sentence by filling in the missing words.

        Data is given through to the computer through input so that processing can take place
        in the CPU. Once processed, the results are given back to the computer user through
        output.                                                                          (2)

3.2     The modern LCD monitor is a better choice. The advantage of this monitor is that the
        image is not formed through projected electrons, therefore the image does not fade
        and does not need to be refreshed. As the monitor is much thinner than the CRT
        monitor, it uses up much less space. It also radiates much less heat and attracts less
        dust than the older types of monitors.                                            (5)

3.3     Learners must recommend three different printers to three different clients.

        Client 1
        Inkjet printer: This printer uses liquid ink that is sprayed onto the paper and is a good
        choice if colour printing needs to be done. This type of printer uses a large amount of
        ink and, although the ink cartridges can be refilled a few times, the ink is expensive
        and does not last long.                                                               (3)

        Client 2
        Laser printer: It does not use liquid ink but a powder that is burnt onto the paper.
        This type of printer produces very high quality printing and is cost effective for a
        large volumes of printing.                                                      (3)

        Client 3
        Dot matrix printer: They operate by using pins that hit against a ribbon to form
        characters. This hitting action makes this type of printer perfect for printing
        duplicates of invoices and accounts.                                         (3)

3.4     Learners find the term in column B that matches the description in column A. Write
        the correct number of the description next to the correct term in column B.

                           Column A                          No.          Column B
3.4.1    Most printers connect by means of                 3.4.3    Printing quality
3.4.2    Number of pages per minute.                       3.4.10 LCD monitor
3.4.3    Quality of the hard copy.                         3.4.6    Dot matrix printer
         Printer items that are replaced on a regular      3.4.9
3.4.4                                                               CRT monitor
         basis.




               Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                          Page 8 of 130
                             Column A                          No.         Column B
          If the printer has this, the printing jobs can be   3.4.8
3.4.5                                                                 Inkjet printer
          saved here till the printing process starts up.
          A printer which uses pins that hit against a        3.4.1   USB interface
3.4.6
          ribbon.
3.4.7     A printer which burns powder onto a paper.          3.4.4   Running costs
          A printer which sprays liquid ink onto paper                Microscopic
3.4.8                                                                 printer
          in small microscopic particles.
          Image on this monitor is formed by             3.4.2        Speed
3.4.9
          projecting electrons on a layer of phosphorus.
          A monitor which takes up very little working        3.4.7   Laser printer
3.4.10
          space.
                                                              3.4.5   RAM
                                                                      ROM
                                                                                      (10)
                                                                               Total: [26]



                         2


ASSIGNMENT

Computer software
(12.1.1; 12.1.3)

1.       Learners answer the questions as revision.

1.1
1.1.1 MSWord
1.1.2 MSExcel
1.1.3 MSAccess
1.1.4 MSPowerPoint
1.1.5 MSFrontpage
1.1.6 Outlook Express
1.1.7 Windows Internet Explorer

2.       Learners read through the information.
2.1      System software and application software
                                                                                             (4)




                Grade 12 Computer Applications Technology Teacher’s Book Module 1 – 3
                                           Page 9 of 130

				
DOCUMENT INFO