# Computer Applications Technology Grade 12 P1 2021 QP (Eng)

> Grade 12 Computer Applications Technology Paper 1 question paper from the NSC November Exam 2021 (English), 21 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/computer-application-technology-p1-nov-2020-eng/931179d5-89bc-42e0-a90e-c67b6903d0a0
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2021
- Exam period: NSC November Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 21

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-12/computer-applications-technology) › [Computer Applications Technology Grade 12 P1 2021 QP (Eng)](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2020-eng/931179d5-89bc-42e0-a90e-c67b6903d0a0)

## About this document

Computer Applications Technology · Grade 12 · NSC November Exam · 2021. Question paper, 21 pages. Read online or download the PDF.

Read it free online on the page above; download the PDF from there.

## Document text

Text extracted from the PDF. Layout, diagrams and tables may not survive extraction.

### Page 1

Downloaded from hlayiso.com

                              SENIOR CERTIFICATE
                         NATIONAL SENIOR CERTIFICATE

                                     GRADE 12

                     COMPUTER APPLICATIONS TECHNOLOGY P1

                                 NOVEMBER 2020

MARKS: 180

TIME: 3 hours

            This question paper consists of 18 pages, an HTML tag sheet,
           an input mask character sheet and a separate information sheet.

Copyright reserved                                                    Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Technology/P1            2                           DBE/November 2020
                                            SC/NSC

INSTRUCTIONS AND INFORMATION

1.        Owing to the nature of this practical examination, it is important to note that,
          even if you complete the examination early, you will NOT be permitted to
          leave the examination room until all the administrative functions associated
          with the examination have been finalised. During the examination, the normal
          rules regarding leaving the examination room apply.

2.        If you are working on the network, or the data files have been preloaded, you
          must follow the instructions provided by the invigilator/educator. Alternatively,
          the invigilator will give you a CD/DVD/flash drive containing all the files
          needed for the examination. If a CD/DVD/flash drive has been issued to you,
          you must write your examination number and centre number on the
          CD/DVD/flash drive.

3.        At the end of the examination, you must hand in the CD/DVD/flash drive given
          to you by the invigilator with ALL your answer files saved onto the
          CD/DVD/flash drive, OR you should make sure that ALL the answer files are
          saved on the network/computer as explained to you by the
          invigilator/educator.

4.        Make absolutely sure that all files can be read. Do NOT save unnecessary
          files/folders and do NOT hand in duplicate answer files/folders. Do NOT
          delete any original files that you did not work on.

5.        The information sheet that has been provided with the question paper MUST
          BE COMPLETED AFTER THE THREE-HOUR EXAMINATION SESSION.
          Hand it to the invigilator at the end of the examination.

6.        A copy of the master files will be available from the invigilator. Should there
          be any problems with a file, you may request another copy from the
          invigilator.

7.        This question paper consists of SEVEN questions. Answer ALL the questions.

8.        Read through each question before answering or solving the problem.
          Do NOT do more than is required by the question.

9.        Read the question carefully as accuracy will be taken into account.

10.       Ensure that you save each document using the file name given in the
          question paper. Save your work at regular intervals as a precaution against
          possible power failures.

11.       You may NOT use any resource material.

12.       Ensure that the regional settings are set to South Africa and that date and
          time settings, number settings and currency settings are correctly set.

Copyright reserved                                                              Please turn over

### Page 3

Downloaded from hlayiso.com
Computer Applications Technology/P1            3                            DBE/November 2020
                                            SC/NSC

13.       In all questions involving word processing, you should set the language to
          English (South Africa). The paper size is assumed to be A4 Portrait, unless
          instructed otherwise. Use centimetres as the unit of measurement.

14.       Formulae and/or functions must be used for ALL calculations in questions
          involving spreadsheets. Use absolute cell references only where necessary to
          ensure that formulae are correct when you copy them to other cells in a
          spreadsheet.

          NOTE:       All formulae and/or functions should be inserted in such a manner
                      that the correct results will still be obtained even if changes are
                      made to the existing data.

15.       You may NOT use a word processing program such as Word to answer the
          HTML question.

16.       The examination folder/CD/DVD/flash drive that you receive with this question
          paper contains the files listed below. Ensure that you have all the files before
          you begin with this examination.

             1Pyramids                              Word processing file
             1Structure                             Word processing file
             2Building                              Word processing file
             3Tourists                              Spreadsheet
             4Visitors                              Spreadsheet
             5Andrews                               Image
             5Egypt                                 Database
             6_1NatGeo                              HTML file
             6_2Facts                               HTML file
             6Group                                 Image
             7Invitation                            Word processing file
             7Mail                                  Database
             7Years                                 Spreadsheet

Copyright reserved                                                             Please turn over

### Page 4

Downloaded from hlayiso.com
Computer Applications Technology/P1           4                             DBE/November 2020
                                           SC/NSC

SCENARIO

The pyramids at Giza, Egypt, is one of the Seven Wonders of the Ancient World.

You are required to assist with documents about the pyramids.

QUESTION 1: WORD PROCESSING

Open the 1Pyramids word processing document that contains information about the
pyramids and insert your examination number in the header or the footer.

1.1     Change the picture found at the top of the first page as follows:

          Set the width of the picture to 21 cm.
          Move the picture to the top edge of the page so that it extends over the top,
           left and right margins of the page, as shown below.
          Remove all the empty paragraphs below the picture.

                                                                                                  (3)

1.2     Edit the heading 'Amazing Facts about the Great Pyramids of Giza' below the
        picture as follows:

           Remove the strikethrough.
           Expand the character spacing by 1.5 pt.
           Centre the heading.                                                                   (4)

1.3     Use the author and the date given in the text below the heading 'Amazing
        Facts about the Great Pyramids of Giza' to add a website source in the APA
        style to the document.                                                                    (4)

1.4     Use a word processing feature to replace all the nonbreaking spaces in the
        document with normal spaces.

        Ensure that only ONE normal space appears in the place of a nonbreaking
        space.                                                                                    (2)

Copyright reserved                                                             Please turn over

### Page 5

Downloaded from hlayiso.com
Computer Applications Technology/P1                 5                  DBE/November 2020
                                                 SC/NSC

1.5     Change the indentation settings on the ruler of the paragraph that starts with
        'One of …' as follows:

           Set the first line indent to 2 cm.
           Set the right indent to 14 cm.                                                    (3)

1.6     Change the line and paragraph spacing of the second paragraph that starts
        with 'The grand …' as follows:

           Set the paragraph spacing after to 8 pt.
           Set the line spacing to multiple at 1.4.                                          (3)

1.7     Use a paragraph setting to ensure that the heading 'Insert here' will always
        appear as the first line of a new page.                                               (1)

1.8     Find the heading 'Insert here'.

        Insert the 1Structure word processing document found in your examination
        folder below the heading so that it appears as an icon.                               (3)

1.9     Find the picture below the heading 'Dimensions' and do the following:

           Format the picture so that the text below the picture does not display.
           Change the caption 'Dimensions of the Great Pyramid' so that the caption
            label displays as 'Structure'.
           Set the caption label numbering to the a,b,c, … numbering format.                 (3)

1.10    Insert a text watermark as follows:

          Use the text 'Ancient'.
          Display the watermark only on the first page.                                      (3)

Save and close the 1Pyramids document.                                                        [29]

Copyright reserved                                                         Please turn over

### Page 6

Downloaded from hlayiso.com
Computer Applications Technology/P1            6                           DBE/November 2020
                                            SC/NSC

QUESTION 2: WORD PROCESSING

Open the 2Building word processing document, which contains information about the
mysteries of the pyramids, and insert your examination number in the header or the
footer.

2.1     Edit the cover page as follows:

           Carry out the instruction in the Author form control.
           Remove the Abstract form control.                                                      (2)

2.2     Remove page borders from the document.                                                     (1)

2.3     Use Styles and insert a table of contents on the second page as follows:

           Change ALL headings formatted with the 'Heading 2' style to the 'Heading
            1' style.
           Insert a two-level table of contents by setting the 'Title' style as level 1 and
            the 'Heading 1' style as level 2.                                                      (3)

2.4     Insert automatic page numbering of your choice in the Page Margins position
        on the left side of the page.

        The page number after the Table of Contents page must start as 'Page 1'.                   (3)

Copyright reserved                                                              Please turn over

### Page 7

Downloaded from hlayiso.com
Computer Applications Technology/P1               7                                DBE/November 2020
                                               SC/NSC

2.5     Find the table below the heading 'The overall precision of the Great Pyramid is
        breathtaking' and convert the table to text to display as follows:

        Take note of the following:

         The tab setting is set at 4 cm.
         The indent settings
         The alignment
         The paragraph border

        Topic               Facts
        Base length         750 feet long at each base

        Four corners        Situated along the four cardinal points: north, south, east and west

        Circumference       The ratio of its circumference to its original height is equal to the
                            value of pi: 3.14. This is something that's not supposed to have been
                            known for more than another millennium. Their mathematical and
                            astronomical knowledge, and the acquisition of it remains a
                            complete mystery to modern-day scholars.

        Geography           They were also amazing geographers, perhaps one of the greatest
                            mysteries is the fact that the Great Pyramid is positioned exactly at
                            the latitude and longitude lines that contain more land and less sea
                            than any other place on Earth. It's right in the 'geographical' centre
                            of the Earth. This fact alone (out of many) suggest that the builders
                            also knew a great deal about the geography of our planet. It's hard
                            to imagine they could complete all of this without some sort of aerial
                            view. The manner that this knowledge was obtained remains a
                            mystery.

        Position on earth   There is a meridian running through the pyramids that divides the
                            continents and oceans into two equal halves.
        Ratio               The Great Pyramid's base is at 1:43,200 which is a mathematical
                            representation of the Northern Hemisphere.
                                                                                                           (5)

2.6     Find the citation to the source 'Hancock' and edit the citation to display only the
        author's name and the page number as 433. The source must NOT be
        changed.                                                                                           (2)

Copyright reserved                                                                      Please turn over

### Page 8

Downloaded from hlayiso.com
Computer Applications Technology/P1                 8                                DBE/November 2020
                                                 SC/NSC

2.7     Find the picture of the pyramids at the top of the last page and format the
        picture to display as shown below.

        NOTE: The text surrounding the outline of the pyramids may display differently.

        "It's the precise configuration for 10,450 BC that we see on the Giza plateau – as though a
        master-architect came here in that period and decided to lay out a huge map on the ground
        using a mixture of natural and artificial                   features. He used the course
        of the Nile Valley to depict the                                   Milky Way, as it looked then.
        He built the three pyramids to                                        represent the three stars,
        exactly as they looked then.                                           And he put the three
        pyramids in exactly the                                                same relationship to the
        Nile Valley as the three                                               stars then had to the
        Milky Way. It was a very clever, very ambitious, very exact way to mark a period – to freeze a
        particular date into architecture if you like." – Robert Bauval (Reference)
                                                                                                             (3)

2.8     Insert a cross reference on the text 'Reference' to the bookmark 'ForEver'.

        Display only the page number.                                                                        (2)

Save and close the 2Building document.                                                                       [21]

Copyright reserved                                                                        Please turn over

### Page 9

Downloaded from hlayiso.com
Computer Applications Technology/P1              9                          DBE/November 2020
                                              SC/NSC

QUESTION 3: SPREADSHEET

NOTE:

     Use formulae and/or functions for ALL calculations in the spreadsheet.
     Use absolute cell references ONLY where necessary to ensure that formulae are
      correct when you copy them to other cells in the same column (copy down).
     Insert formulae and/or functions in such a manner that the correct results will still
      be obtained even if changes are made to the existing data.
     Should you need to use building blocks, use the allocated space in the
      spreadsheet.

Open the 3Tourists spreadsheet which contains data about the number of tourists
to Egypt.

Work in the Data worksheet.

3.1       Format row 1 as follows:

             Merge and centre cells A1:I1.
             Increase the font size of the text to 13.                                             (2)

3.2       Insert an appropriate date function in cell C3 to extract the month from the
          date in cell A3. Ensure that the number of the month displays correctly.                  (2)

3.3       Enter a function in cell C4 to determine the average number of tourists who
          visited Egypt (column H) per month.

          Format the answer to NO decimal places.                                                   (3)

3.4       The peak tourist season in Egypt is from October to May and the off-peak
          season is from June to September.

          Use the SUMIF function in cell C5 to determine the total number of tourists
          who visited Egypt during the peak season (column B) in 2019 (column G).                   (3)

3.5       The totals in column H should calculate the total number of tourists per month
          from 2015 to 2019; however, this does not happen as expected for all the
          months.

          Insert a formula in cell I8 to display the text 'Correct' if the total in column H
          corresponds with the total number of tourists from 2015 to 2019, or else the
          text 'Error' must display.

          Copy the formula down to the other cells.                                                 (7)

3.6       Use a spreadsheet feature to apply a fill colour of your choice to the cell
          range C8:G19 when the number of tourists is lower than the average for the
          five years (2015 to 2019).                                                                (3)

Copyright reserved                                                               Please turn over

### Page 10

Downloaded from hlayiso.com
Computer Applications Technology/P1                   10                                 DBE/November 2020
                                                    SC/NSC

Work in the Chart_Grafiek worksheet.

3.7     Edit the chart to appear as follows:

                                                Egypt Tourism
          1 400 000

          1 200 000

          1 000 000

                                                                                                   2015
           800 000
                                                                                                   2016
                                                                                                   2017
           600 000
                                                                                                   2018
                                                                                                   2019
           400 000

           200 000

                 0
                      Jan   Feb   Mar   Apr   May   Jun   Jul   Aug   Sep   Oct   Nov   Dec
                                                                                                                 (7)

Save and close the 3Tourists spreadsheet.                                                                        [27]

Copyright reserved                                                                            Please turn over

### Page 11

Downloaded from hlayiso.com
Computer Applications Technology/P1              11                            DBE/November 2020
                                               SC/NSC

QUESTION 4: SPREADSHEET

NOTE:

     Use formulae and/or functions for ALL calculations in the spreadsheet.
     Use absolute cell references ONLY where necessary to ensure that formulae are
      correct when you copy them to other cells in the same column (copy down).
     Insert formulae and/or functions in such a manner that the correct results will still be
      obtained even if changes are made to the existing data.
     Should you need to use building blocks, use the allocated space in the
      spreadsheet.

Open the 4Visitors spreadsheet which contains data about visitors to the pyramids.

Work in the Pyr_Pir worksheet.

4.1       Format the worksheet as follows:

             Change the page orientation to landscape.
             Ensure that row 2 will be repeated at the top of each page when you print
              the worksheet.                                                                          (2)

4.2       Use a combination of text functions in cell D3 to extract ONLY the text after the
          '@' sign from the e-mail address in column C.

          Example: If the e-mail address is zulul@in.com, then ONLY in.com must
          display.                                                                                    (5)

4.3       Use an appropriate lookup function in cell F4 to determine the location of the
          pyramid in row 4 by using the code in column E and the lookup table in the
          Code_Kode worksheet.

          Ensure that this function will return the correct results if copied to the other cells
          in column F.

          NOTE: Do NOT copy the function to the other cells.                                          (5)

4.4       Use a formula in cell H5 to determine the age of 'Gabriel Wilmar' in completed
          years by using the date of birth in column G and the current date.                          (6)

4.5       Insert a nested IF function (formula) in cell I14 to display 'Yes' if a visitor is
          under the age of 60 (column H) AND visited Giza (column F), or else 'No'
          must display.                                                                               (5)

Save and close the 4Visitors spreadsheet.                                                             [23]

Copyright reserved                                                                 Please turn over

### Page 12

Downloaded from hlayiso.com
Computer Applications Technology/P1             12                         DBE/November 2020
                                              SC/NSC

QUESTION 5: DATABASE

A database was created to store data about tourists and the pyramids they choose to
visit.

Open the 5Egypt database.

5.1     Change the tbl5_1 table as follows:

        5.1.1    Change the Indexed field property of the TSurname field to allow for
                 duplicate values.                                                                (1)

        5.1.2    Display the date in the TBirthDate field in the Short Date format.               (1)

        5.1.3    Change the TAge field properties to display the age without decimals.            (1)

        5.1.4    Set the field properties of the EContact field so that the user can
                 only enter text that contains an '@' sign.                                       (3)

        5.1.5    Set the TType field to an appropriate field size.                                (1)

        5.1.6    Create an input mask for the user to enter data in the following format:

                    Lowercase letters
                    The first character is a full stop (.), followed by
                    TWO compulsory letters, followed by
                    ONE optional letter

                 NOTE: The full stop must display when a record is selected.                      (4)

        5.1.7    Centre the content of the PyramidCode field.                                     (1)

        5.1.8    Create a combo box for the PyramidSite field by using the tblSites
                 table.                                                                           (2)

        5.1.9    Switch to Datasheet View.

                 Insert the 5Andrews picture found in your examination folder in the
                 TPhoto field for the traveller 'Andrews Peter'.                                  (2)

        Save and close the tbl5_1 table.

Copyright reserved                                                             Please turn over

### Page 13

Downloaded from hlayiso.com
Computer Applications Technology/P1        13                         DBE/November 2020
                                         SC/NSC

5.2      Open the form called frm5_2 in Design View and do the following:

            Change the order of the fields to TSurname, TName, EContact, TPhoto.
            Replace the heading in the form header with your examination number.
            Insert the Date field in the form header.
            Shade the EContact field to any light colour of your choice.

         Save and close the frm5_2 form.                                                       (4)

5.3      Open the qry5_3 query in Design View.

         Modify the query so that it displays the total number of pyramids at the Giza
         site.

         Save and close the qry5_3 query.                                                      (3)

5.4      Open the qry5_4 query in Design View and do the following:

            Sort the query first according to the Surname field and then according to
             the Name field.
            Display the records of those visitors who were born before 1960 and
             whose domain type is 'org' or 'edu'.
            Tourists receive a 15% discount on the visitors' cost (VisitorsCost).
             Insert a calculated field called Payable to determine the amount payable
             after the discount has been deducted.

         Save and close the qry5_4 query.                                                      (9)

Copyright reserved                                                          Please turn over

### Page 14

Downloaded from hlayiso.com
Computer Applications Technology/P1            14                        DBE/November 2020
                                             SC/NSC

5.5      Create a report named rpt5_5, based on the tblVisitors table, to display the
         records as follows:

          rpt5_5
             Pyramid              Name                Surname          VisitorsCost
             Bent Pyramid
                                  Fulton              Morale           R 14 955.00
                                  Athena              Patel            R 14 835.00

                                                      Maximum Amount: R 14 955.00
             Buried Pyramid
                                  Jan-Harm            Steenkamp        R 14 759.00
                                  Ernst               Jordaan          R 13 980.00
                                  James               Murray           R 10 986.00
                                  Troy                Gentry           R 14 210.00
                                  Harriet             Delane           R 13 221.00
                                  Nozipho             Cele             R 13 030.00
                                  Andries             Bester           R 10 075.00

                                                      Maximum Amount: R 14 759.00
             Headless Pyramid
                                  Hendrik             Fourie           R 14 670.00
                                  Kaitlin             Cusana           R 14 314.00
                                  Sylvia              Hebert           R 14 164.00
                                  Sammy               Nel              R 13 016.00
                                  Alexis              Stone            R 12 225.00

                                                      Maximum Amount: R 14 670.00

         Take note of the following:

            The fields that display
            Grouping
            A calculation
            The format of the VisitorsCost field

         Save and close the rpt5_5 report.                                                       (8)

Save and close the 5Egypt database.                                                              [40]

Copyright reserved                                                            Please turn over

### Page 15

Downloaded from hlayiso.com
Computer Applications Technology/P1              15                              DBE/November 2020
                                               SC/NSC

QUESTION 6: WEB DESIGN (HTML)

NOTE:

     An HTML tag sheet has been attached for reference.
     All files needed to complete this question are found in the examination folder.

ONE mark will be allocated for the correct use of tags, triangular brackets and correct
nesting for both the web pages.                                                                          (1)

6.1       Open the incomplete 6_1NatGeo web page in a web browser and also in a
          text/HTML editor (NOT a word processing program such as Word).

          NOTE: Question numbers appear as comments in the coding to guide you
                where to insert the answer(s). DO NOT delete these comments.

                          [Adapted from https://www.nationalgeographic.com/archaeology-and-history/
                                                                    archaeology/giza-pyramids.html]

Copyright reserved                                                                    Please turn over

### Page 16

Downloaded from hlayiso.com
Computer Applications Technology/P1            16                       DBE/November 2020
                                             SC/NSC

        NOTE:        Use the example on the previous page as a guide for answering this
                     question.

        6.1.1    Insert HTML tags to centre the text that starts with 'PYRAMIDS …' and
                 ends with '… other features'.                                                 (2)

        6.1.2    Locate the heading 'PYRAMIDS' and format it as follows:

                     Apply the 'Heading 1' style to this heading.
                     Set the font of this heading to 'Papyrus'.                               (3)

        6.1.3    Insert the image 6Group.jpg below the first paragraph that ends with
                 the text '… complex mortuary temple'.                                         (2)

        6.1.4    An attempt was made to create a link on the heading 'The Future of the
                 Pyramids' to the website 'www.crystal.com'.

                 Modify the link so that the website 'www.crystal.com' will open in the
                 web browser.

                 NOTE:      Do NOT click on the link.                                          (2)

        Save and close the 6_1NatGeo web page.

6.2     Open the incomplete 6_2Facts web page in a web browser and also in a
        text/HTML editor (NOT a word processing program such as Word).

        HINT: Use tags given in the attached HTML tag sheet.

        Complete the web page to appear as follows:

        Save and close the 6_2Facts web page.                                                  (10)
                                                                                               [20]

Copyright reserved                                                          Please turn over

### Page 17

Downloaded from hlayiso.com
Computer Applications Technology/P1               17                                  DBE/November 2020
                                                SC/NSC

QUESTION 7: GENERAL

References to pyramids are found in many other places.

7.1       Open the 7Years spreadsheet.

          7.1.1      Copy the data from cells A1:B6 in the Chart worksheet
                     to cells A2:F3 in the Data worksheet.

                     The copied data in the Data worksheet must appear as follows:

                                      Tourists in Egypt from 2015 to 2019
                                        Year        2015       2016     2017   2018    2019
                           Number of tourists
                                    per year       11532       9464     9878   9328    4847                 (2)

          7.1.2      Work in the Chart worksheet. Modify the chart to display as follows:

                                        Number of tourists per year

                                                        4847
                         100%

                          80%                           9328
                          60%

                          40%                           9878
                          20%

                           0%

                                                 2017    2018    2019
                                                                                                            (3)

          7.1.3      Save the pyramid chart as a 7Chart.jpg image file in your
                     examination folder.                                                                    (2)

          Work in the Visitors worksheet.

          7.1.4      A named range has already been created for the amounts in
                     column F.

                     Insert a function in cell J3 that uses the named range to determine
                     how many of the amounts in the named range are greater than
                     R14 000.                                                                               (3)

Copyright reserved                                                                       Please turn over

### Page 18

Downloaded from hlayiso.com
Computer Applications Technology/P1           18                         DBE/November 2020
                                            SC/NSC

          7.1.5      A validation rule has been set on cells E2:E194 to obtain data from
                     the list in cells M4:M9. However, there are errors and omissions in
                     the validation list (cells M4:M9), which cause data in column E to
                     be invalid.

                     Correct the Validation List AND update the Validation Rule so that
                     the data in column E becomes valid.

                     HINT: To identify the invalid data in column E, use the Circle
                           Invalid Data option from the Data Validation icon in the Data
                           Tools group.                                                      (3)

          Save and close the 7Years spreadsheet.

7.2       Open the 7Invitation word processing document.

          Complete a mail merge as follows:

          7.2.1         Use the 7Mail database as a data source for the 7Invitation mail
                         merge document.
                        Edit the data source recipient list to include ONLY the data of
                         those visitors who have an edu domain type AND who are born
                         after 1960.
                        Replace the text <<Name>> with the merged field Name.
                        Add a field in the footer of the document to show the date and
                         time when the document is opened.                                   (6)

          Save the 7Invitation document.

          7.2.2      Complete the mail merge and save the merged document as
                     7InvitationMerge.                                                       (1)
                                                                                             [20]

                                                                                TOTAL:       180

Copyright reserved

### Page 19

Downloaded from hlayiso.com
   Computer Applications Technology/P1                                                       DBE/November 2020
                                                          SC/NSC

                                                       HTML TAG SHEET
                        Basic Tags                                            Formatting Tags continued
           Tag                        Description                           Tag                   Description
<body></body>             Defines the body of the web page                              Inserted before each list item,
                                                                   <li></li>            and adds a number or symbol
<body                     Sets the background colour of the                             depending on the type of list
bgcolor="pink">           web page                                                      selected
<body text="black">       Sets the colour of the body text         <img src="name">     Adds an image
<head></head>             Contains information about the
                                                                   <img src="name"         Aligns an image: can be "left",
                          web page
                                                                   align="left">           "right"; "bottom", "top", "middle"

<html></html>             Creates an HTML document –               <align="center">
                                                                   <img src="name">        Aligns an image to the "center"
                          starts and ends a web page
                                                                   <img src="name"         Sets the size of the border
<title></title>           Defines a title for the web page         border="1">             around an image
<br/>                     Inserts a line break                     <img src="name"
                                                                   width="200"             Sets the height and width of an
<!-- -->                  Comment
                                                                   height ="200">          image
                        Text Tags
           Tag                        Description                                          Displays alternative text when
                                                                   <img src="name"
                                                                   alt="alternative        the mouse hovers over the
<h1></h1>                 Creates the largest heading
                                                                   text">                  image or when the image is not
<h6></h6>                 Creates the smallest heading                                     found
                                                                   <hr/>                   Inserts a horizontal line
<b></b>                   Creates bold text                        <hr size="3"/>          Sets size (height) of a line
<i></i>                                                            <hr width="80%"/>       Sets the width of a line, in
                          Creates italic text
                                                                                           percentage or absolute value
<font                                                              <hr color=
size="3"></font>          Sets size of font, from "1" to "7"       "ff0000"/>              Sets the colour of the line
<font color=                                                                            Table Tags
"green"> </font>          Sets font colour
                                                                          Tag                       Description
<font face="Times                                                  <table></table>         Creates a table
New Roman"></font>        Sets font type
                                                                   <tr></tr>               Creates a row in a table
                        Links Tags                                 <td></td>               Creates a cell in a table
        Tag                           Description                                          Creates a table header (a cell
                                                                   <th></th>
<a href="URL"></a>        Creates a hyperlink                                              with bold, centred text)
<a href="URL"><img                                                 <table
src="name"></a>           Creates an image link                    width="50">             Sets the width of the table

                          Creates a target location in the         <table                  Sets the width of the border
<a name="NAME"></a>
                          document                                 border="1">             around the table cells
                                                                   <table                  Sets the space between the
<a href=                  Links to a target location created       cellspacing="1">        table cells
"#NAME"></a>              somewhere else in the document
                                                                   <table                  Sets the space between a cell
                   Formatting Tags                                 cellpadding="1">        border and its contents
           Tag                   Description                                               Sets the alignment for cell(s)
                                                                   <tr align="left">       ("left", can also be "center" or
<p></p>                   Creates a new paragraph                                          "right")
                          Aligns a paragraph to the "left"                                 Sets the vertical alignment for
<p align="left">          (default), can also be "right" or        <tr valign="top">       cell(s) ("top", can also be
                          "center"                                                         "middle" or "bottom")
<ol></ol>                                                          <td colspan="2">        Sets the number of columns a
                          Creates a numbered list
                                                                                           cell should span
<ol type="A","a",         Defines the type of numbering                                    Sets the number of rows a cell
                                                                   <td rowspan="4">
"I","i","1"></ol>         used                                                             should span
<ul></ul>                 Creates a bulleted list
<ul type="disc",
"square","circle">        Defines the type of bullets used
</ul>

   Copyright reserved

### Page 20

Downloaded from hlayiso.com
Computer Applications Technology/P1                                                DBE/November 2020
                                                SC/NSC

                              INPUT MASK CHARACTER SHEET

  CHARACTER                                               DESCRIPTION
         0             Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed)

         9             Digit or space (entry not required, plus [+] and minus [–] signs not allowed)

                       Digit or space (entry not required; spaces are displayed as blanks while in Edit
         #             mode, but blanks are removed when data is saved; plus [+] and minus [–]
                       signs allowed)

         L             Letter (A to Z, entry required)

         ?             Letter (A to Z, entry optional)

         A             Letter or digit (entry required)

         a             Letter or digit (entry optional)

         &             Any character or a space (entry required)

         C             Any character or a space (entry optional)

                       Decimal placeholder and thousand, date and time separators (The actual
      .,:;-/           character used depends on the settings in the Regional Settings Properties
                       dialog box in the Windows Control Panel.)

         <             Causes all characters to be converted to lowercase

         >             Causes all characters to be converted to uppercase

                       Causes the input mask to display from right to left, rather than from left to right.
          !            Characters typed into the mask always fill it from left to right. You can include
                       the exclamation point anywhere in the input mask.

                       Causes the character that follows to be displayed as the literal character (e.g.
          \
                       \A is displayed as just A).

Copyright reserved

### Page 21

Downloaded from hlayiso.com
Computer Applications Technology/P1                                                  DBE/November 2020
                                                 SC/NSC

                                          Examination sticker
                                                                                               180

           COMPUTER APPLICATIONS TECHNOLOGY P1 – NOVEMBER 2020

INFORMATION SHEET (to be completed by the candidate AFTER the 3-hour session)
CENTRE NUMBER __________________________________________________________
EXAMINATION NUMBER _____________________________________________________
WORK STATION NUMBER ____________________________________________________
SUITE USED
                             Microsoft Office     Microsoft Office     Microsoft Office
(Mark appropriate box                                                                          Office 365
                                  2013                 2016                 2019
with a cross (X))
WEB BROWSER USED                                                                           Other (Specify)
(Mark appropriate box          Mozilla Firefox    Google Chrome       Internet Explorer
with a cross (X))

FOLDER NAME ______________________________________________________________
File names have been entered for each answer. Tick if saved and/or attempted.

Question                          Saved   Attempted    Maximum
                File name                                            Marker     SM        CM       IM/EM
number                             ()        ()        Mark

    1          1Pyramids                                  29

    2           2Building                                 21

    3           3Tourists                                 27

    4           4Visitors                                 23

    5            5Egypt                                   40

              6_1NatGeo
    6                                                     20
                6_2Facts

                 7Years

                 7Chart
    7                                                     20
               7Invitation

            7InvitationMerge

                      TOTAL                               180

Comment (for office/marker use only)
__________________________________________________________________________________
__________________________________________________________________________________

Copyright reserved

## Related documents

- [Computer Application Technology P1 Nov 2020 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2020-memo-eng/29afe53d-081b-47cd-88fe-246bb4374530) — Computer Applications Technology · Memo · 2021 · Eng
- [Computer Application Technology P1 May June 2021 Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2021-eng/5be0bf0e-69bd-4481-9ce4-d56745874ad6) — Computer Applications Technology · QP · 2021 · Eng
- [Computer Applications Technology P1 Nov 2023 Eng](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2023-eng/60311585-04c7-46dc-bcf6-87da09dc1ea5) — Computer Applications Technology · QP · 2023 · Eng
- [Computer Application Technology P1 Nov 2021 Afr](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2021-afr/1470e04d-3b82-4358-bb65-bb03f0dfd093) — Computer Applications Technology · QP · 2020 · Afr
- [Computer Application Technology P1 Nov 2021 Eng](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2021-eng/16875b30-a18d-4a9a-b7ea-711d6393e5a4) — Computer Applications Technology · QP · 2020 · Eng
- [Computer Application Technology P1 Nov 2019 Eng](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2019-eng/b91547f0-b4ca-4f13-97a6-41dff1f1cae0) — Computer Applications Technology · QP · 2019 · Eng

## More from Grade 12 Computer Applications Technology

- [CAT P1 MEMO GR12 SEPT 2025 ENG watermark](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2025-eng-watermark/9df1288f-0f95-46d9-8231-26c401ed1a1b) — Memo · 2025 · Eng
- [CAT P2 GR12 MEMO September 2025 - AFR watermark](https://www.hlayiso.com/library/cat-p2-gr12-memo-september-2025-afr-watermark/3e182b7b-5d5f-4afc-b54c-b286289512f6) — Memo · 2025 · Afr
- [Computer Applications Technology P1 May-June 2025 MG Eng](https://www.hlayiso.com/library/computer-applications-technology-p1-may-june-2025-mg-eng/8beb5c31-24fa-4cf4-b90c-aedcc234a4dd) — Memo · 2025 · Eng
- [CAT P1 MEMO GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2024-english/91df7fb9-ea6b-4fed-8f93-a1466ec697c3) — Memo · 2024 · Eng
- [Computer Applications Technology P2 May-June 2024 MG Eng](https://www.hlayiso.com/library/grade-12-computer-applications-technology-2024-nsc-june-exam-memorandum-paper-2-english/a32bb637-25b5-4469-8be9-e72527e65d8a) — Memo · 2024 · Eng
- [ERRATA CAT P1](https://www.hlayiso.com/library/errata-cat-p1/363f4b7e-98be-46d4-9d47-fcfea8705198) — Errata · 2022

## Collection

- [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers)

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.
