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

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

- Page: https://www.hlayiso.com/library/computer-application-technology-p1-feb-march-2017-eng/d8a94e3b-7f8e-418b-8ee7-a6ca53d42120
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2017
- Exam period: NSC Supplementary Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 20

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 2017 QP (Eng)](https://www.hlayiso.com/library/computer-application-technology-p1-feb-march-2017-eng/d8a94e3b-7f8e-418b-8ee7-a6ca53d42120)

## About this document

Computer Applications Technology · Grade 12 · NSC Supplementary Exam · 2017. Question paper, 20 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

                                   NATIONAL
                              SENIOR CERTIFICATE

                                      GRADE 12

                  COMPUTER APPLICATIONS TECHNOLOGY P1

                             FEBRUARY/MARCH 2017

MARKS: 180

TIME: 3 hours

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

Copy right reserved                                                    Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1          2                           DBE/Feb.–Mar. 2017
                                             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 normal
          rules regarding leaving the examination room apply.

2.        Enter your examination number in the header or footer of EVERY document
          that you create or save, where applicable.

3.        The invigilator will give you a CD/DVD/flash disk containing all the files
          needed for the examination OR you will be told where the files can be found
          on the network or computer. If a CD/DVD has been issued to you, you must
          write your examination number and centre number on the CD/DVD. If you are
          working on the network, you must follow the instructions provided by the
          invigilator/educator.

4.        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.

5.        This question paper consists of SEVEN questions.

6.        Answer ALL the questions.

7.        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.

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

9.        At the end of the examination, you must hand in the CD/DVD/flash disk given
          to you by the invigilator with ALL your answer files saved onto it, OR you
          should make sure that ALL the answer files are saved on the
          network/computer as explained to you by the invigilator/educator. Make
          absolutely sure that all the files can be read. Do NOT save unnecessary
          files/folders and do NOT hand in duplicate answer files/folders.

10.       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.

11.       During the examination, you may use the help functions of the programs
          which you are using. You may NOT use any other resource material.

Copy right reserved                                                           Please turn over

### Page 3

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1          3                           DBE/Feb.–Mar. 2017
                                             NSC

12.       Unless instructed otherwise, use formulae and/or functions 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.

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

14.       If data is obtained from a previous question that you could not answer, you
          should still proceed with the questions that follow.

15.       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
          stated otherwise.

16.       Use centimetres as the unit of measurement when answering this question
          paper.

17.       Generally, one mark is allocated per action; therefore, a 2-mark question
          would usually require TWO actions, et cetera.

18.       The examination folder/CD/DVD/flash disk 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.

          •   1Areas                               Word processing file
          •   2Det_Bes                             Spreadsheet file
          •   2Drops                               Image file
          •   2Water                               Word processing file
          •   3Rain_Reën                           Spreadsheet file
          •   4Game_Speel                          Spreadsheet file
          •   5AlbertFalls                         Image file
          •   5Dam                                 Database file
          •   6House                               Image file
          •   6Life                                Image file
          •   6Out                                 Image file
          •   6Wise_Wys                            HTML file
          •   7Answ_Antw                           Word processing file
          •   7River_Rivier                        Database file
          •   7Rivers_Riviere                      Spreadsheet file
          •   7Water                               Word processing file

Copy right reserved                                                           Please turn over

### Page 4

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1             4                            DBE/Feb.–Mar. 2017
                                                NSC

SCENARIO

Water is very important for life. We need water to drink, to wash our
hands, to cook and to do many other things.

Your community leader has decided to contact your school to gather some facts about
water as a natural resource.

QUESTION 1: WORD PROCESSING

A document about South Africa's water sources was created.

Open the 1Areas word processing document and insert your examination number in
the header or footer.

1.1       Find the text ('The availability of … floods and droughts.') in the Abstract
          control on the first page and make the following changes:

          1.1.1       Set the proofing language of all the text to English (South Africa).           (1)

          1.1.2       Justify the text.                                                              (1)

1.2       Find the image on the first page.

          Crop the image to any shape of your choice AND sharpen the image to 50%.                   (2)

1.3       Find the 'Subtitle' text control on the first page and remove this control
          WITHOUT deleting the text contained in the control.                                        (1)

1.4       Insert an automatically generated table of contents below the heading
          'Contents' on the second page as follows:

          •   Apply the 'Classic' table of contents format.
          •   Use the 'Water' style for the first level and the 'Heading 1' style for the
              second level of headings.
          •   Set the tab leader for the page numbers to solid.

          NOTE: Accept any warning messages that may appear.                                         (4)

1.5       Insert automatic page numbers in the footer of the document as follows:

          •   Page numbering should start on the 'Contents' page as page 1.
          •   The page numbering should appear in the format 'Page 1'.
          •   The page numbers on odd-numbered pages should be left-aligned.
          •   The page numbers on even-numbered pages should be right-aligned.                       (5)

Copy right reserved                                                               Please turn over

### Page 5

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1             5                          DBE/Feb.–Mar. 2017
                                                NSC

1.6       Find the word 'Our' on the 'INTRODUCTION' page.

          •   Apply a dropped cap effect on the whole word.
          •   Set the spacing to 0.5 cm from the text.                                              (2)

1.7       Find the text 'table 1' in the fourth paragraph on the page after the map.

          Add a cross reference on this text that links to the 'Water Source Area' table
          on the next page.                                                                         (2)

1.8       Adjust the 'Water Source Area' table on the next page as follows:

          1.8.1        Apply any predefined table style to this table.                              (1)

          1.8.2        Use a table property to ensure that the headings are repeated if the
                       table flows over to the next page.                                           (1)

          1.8.3        Find the text 'Grootwinterhoek' and add a footnote to this text as
                       follows:

                       •   The footnote text must contain 'Strategic water sources'.
                       •   Use the '*' as the custom symbol for the footnote.                       (3)

1.9       Find the image below the heading 'WESTERN CAPE WATER SOURCE
          AREAS'.

          Add 'Image 1' as an automatic caption to the image.                                       (2)

1.10      Find the bulleted list below the 'BOLAND MOUNTAINS' heading.

          Change the bullet characters to the '' symbol (Wingdings, code 165).                     (1)

1.11      Find the text 'Did you know?' below the heading 'TSITSIKAMMA'.

          •   Apply any WordArt of your choice to this text.
          •   Change the text wrapping to top and bottom.                                           (2)

1.12      Find the chart/graph below the heading 'MPUMALANGA DRAKENSBERG'.

          Change the data of the chart/graph as follows:

          Cultivated – 2%
          Natural – 48%

          NOTE: Do not simply change the labels of the chart/graph.                                 (2)

Copy right reserved                                                              Please turn over

### Page 6

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1            6                         DBE/Feb.–Mar. 2017
                                               NSC

1.13      Find the text '… the journey it has taken to reach us.' below the heading
          'PROTECTING SOUTH AFRICA'S WATER SOURCE AREAS'. Create a new
          source AND insert the citation for this source next to this text. The source
          must contain the following information:

          Type of source:        Report
          Title:                 The effects of water
          Year:                  2015

          NOTE: Ensure that the APA style has been selected.                                     (3)

1.14      Find the table of figures on the second-last page. The table of figures only
          displays the tables. Add an additional automatic table of figures that will also
          display the images.                                                                    (2)

1.15      Change the orientation of only the last page to portrait. The rest should
          remain in landscape.                                                                   (2)

Save and close the 1Areas document.                                                              [37]

Copy right reserved                                                           Please turn over

### Page 7

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1           7                            DBE/Feb.–Mar. 2017
                                              NSC

QUESTION 2: WORD PROCESSING

A survey form has been created for distribution.

Open the 2Water word processing document and insert your examination number in
the header or footer.

2.1       Add a date field next to the word 'DATE'.

          Ensure that it will always display the current date.                                      (2)

2.2       Fill the second text box with the 2Drops image found in the examination
          folder AND bold the text in the text box.                                                 (2)

2.3       Correct the spelling of 'Female' in the drop-down form field control next to the
          text 'Gender'.                                                                            (1)

2.4       Add a check box form field control to the left of the text 'Older than 60'.               (1)

2.5       Find the text form field control next to the text 'Number of adults in the
          household'.

          Change the properties so that the user can only enter numerical values.                   (1)

2.6       Edit the format of the control next to 'How much do you pay a month?' so that
          it will always display an 'R' in front of the amount(s) displayed.                        (1)

2.7       Apply leader tabs at the bottom of the form so that it displays as below.

                                                                                                    (4)

2.8       You want to send the survey to some people for completion.

          Prepare a mail merge as follows:

          •    Use the Details worksheet of the 2Det_Bes spreadsheet as the data
               source.
          •    Sort the surnames in ascending order.
          •    Add the merge fields, Name and Surname, in the spaces provided at the
               top of the document.
          •    Save the 2Water document before completing the merge.
          •    Complete the mail merge and save the new merged document as 2Done.                   (5)

Save and close the 2Water document.                                                                 [17]

Copy right reserved                                                              Please turn over

### Page 8

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1            8                            DBE/Feb.–Mar. 2017
                                               NSC

QUESTION 3: SPREADSHEET

Rainfall was measured every month in four cities from 2005 to 2015. The data was
captured in a spreadsheet.

NOTE:

•     Use formulae and/or functions for ALL calculations in the spreadsheet.
•     Use absolute cell references ONLY where it is required by the question to ensure
      that formulae are correct when you copy it to other cells in the spreadsheet.
•     All formulae and/or functions should be inserted in such a manner that the correct
      results will still be obtained, even if the existing data changes.

Open the 3Rain_Reën spreadsheet. Work in the Rain_Reën worksheet.

3.1        Format the cells in row 1 as follows:

           3.1.1       Change the merged cell to only include cells A1:O1.                           (1)

           3.1.2       Apply a 'Thin Diagonal Stripe' pattern style fill effect to the merged
                       cell.                                                                         (2)

3.2        Freeze the panes so that all the headings in row 2 and the city and year
           columns display when you scroll down.                                                     (2)

3.3        Insert a function in cell D3 to convert the text that appears in cell C3 to a
           number.                                                                                   (1)

3.4        Insert a function in cell G48 to determine the most commonly occurring
           rainfall value in April.                                                                  (2)

3.5        Insert a function in cell H49 to determine the average rainfall for May for all
           the cities throughout all the years. Display the average rounded to the next
           highest whole number.

           EXAMPLE: If the average is 6.4, then 7 should be displayed. If the
                    average is 6.6, then 7 should also be displayed.                                 (3)

3.6        Insert a function in cell K50 to determine the third highest rainfall in August.          (2)

3.7        Insert a function in cell M51 to determine the total rainfall that fell in the four
           cities during October 2015.

           NOTE:      Ensure that the correct results will be obtained even if the existing
                      data changes.                                                                  (4)

Copy right reserved                                                               Please turn over

### Page 9

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1            9                             DBE/Feb.–Mar. 2017
                                               NSC

3.8       Apply conditional formatting to cells D3:O46 to automatically apply a
          3-colour scale to the numbers in the three different categories shown below.

          •   The lowest point of 0
          •   A midpoint of 100
          •   The highest point of 630

          Choose any colours of your choice.                                                           (5)

3.9       The rainfall in a city is categorised by comparing the total rainfall of the city for
          a specific year to an expected rainfall of 650.

          It is categorised as follows:

          •   More than the expected rainfall of 650: High
          •   Less than or equal to the expected rainfall of 650: Low

          Insert a function in cell R4 to determine the category for the rainfall in
          Cape Town in 2015.                                                                           (6)

3.10      Sort the data in cells A3:O46 according to the year from 2005 to 2015 and
          then according to the city alphabetically.                                                   (2)

Work in the Durban worksheet.

3.11      The cell range used in the function in cell C6 is incorrect.

          Correct the cell range of the function by including the data for January from
          the data table.

          Ensure that the function in cell C6 will work correctly if it is copied to the other
          months in the summary table.                                                                 (2)

3.12      Filter the data so that only the rainfall data for Durban is displayed.                      (1)

Copy right reserved                                                                 Please turn over

### Page 10

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1                         10                                       DBE/Feb.–Mar. 2017
                                                            NSC

Work in the Bloemfontein worksheet.

3.13      A chart/graph displaying the total rainfall per year for Bloemfontein has been
          created.

          Change the chart/graph in the worksheet to appear as shown below.

          •      Ensure that the chart/graph displays the rainfall per month and also the
                 total for the year.
          •      Add a suitable title to the chart/graph.
          •      Insert a legend as shown in the example below.
          •      Display the horizontal axis labels.
          •      Display data labels only for the 'Total' series.

                                                     Bloemfontein
                         2500

                         2000

                         1500                                                   1024
              Rainfall          629                 698
                                                                                        826
                                                                                                                 750
                         1000                                           625
                                       324                 406                                          467
                          500
                                             199                                               266
                            0
                             2005     2006   2007   2008   2009     2010        2011    2012   2013     2014     2015
                                                                    Year

                          Jan   Feb    Mar    Apr   May    Jun    Jul     Aug     Sep    Oct   Nov     Dec     Total
                                                                                                                                (5)

Save and close the 3Rain_Reën spreadsheet.                                                                                      [38]

Copy right reserved                                                                                          Please turn over

### Page 11

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1          11                          DBE/Feb.–Mar. 2017
                                             NSC

QUESTION 4: SPREADSHEET

The school hosted a water games event to raise funds.

NOTE:

•     Use formulae and/or functions for ALL calculations in the spreadsheet.
•     Use absolute cell references ONLY where it is required by the question to ensure
      that formulae are correct when you copy it to other cells in the spreadsheet.
•     All formulae and/or functions should be inserted in such a manner that the correct
      results will still be obtained, even if the existing data changes.

Open the 4Game_Speel spreadsheet and work in the Scores_Punte worksheet.

4.1        Remove the hyperlink set on the heading 'Water Games'.                                (1)

4.2        Insert a formula in cell E3 to determine the number of weeks that have
           passed between the date in column D and the current date.                             (3)

4.3        Data validation has been applied to column G.

           Remove the value 'Black' as an option in the validation list for the whole
           column.                                                                               (2)

4.4        A participant ID should be created for each participant. Create the participant
           ID in cell I3 as follows:

           •   The first two letters of the surname in column C
           •   Followed by a space
           •   Followed by a random number in the range 0 and 99
           •   Followed by the gender in column F in lower case

           You may use any of the blank columns, such as column K and column L, to
           calculate any interim results.

           EXAMPLE: Ga 23f or Ga 4f                                                              (7)

4.5        Use an appropriate LOOKUP function in cell J3 to display the award that
           Jemima Garrison will receive based on her score in cell H3.

           Use the data in the Awards_Toekennings worksheet.                                     (4)

Save and close the 4Game_Speel document.                                                         [17]

Copy right reserved                                                           Please turn over

### Page 12

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1            12                           DBE/Feb.–Mar. 2017
                                               NSC

QUESTION 5: DATABASE

A database that contains a list of dams and their locations was created.

Open the 5Dam database.

5.1       Open the Dam table.

          5.1.1        Insert a primary key on the most appropriate field.                          (1)

          5.1.2        Ensure that any data currently stored in the Town field will appear
                       in capital letters.                                                          (1)

          5.1.3        Add a combo box to the Province field.

                       The values for the Province field are stored in the Province table.

                       Accept any warning or error messages that may appear.                        (2)

          5.1.4        Create an input mask for the Completed field to accept dates in the
                       format dd/MMM/yyyy.

                       EXAMPLE: 01/JAN/2001 or 31/DEC/2010                                          (5)

          5.1.5        Change the field properties of the Capacity field so that no value
                       smaller than zero will be accepted.                                          (1)

          5.1.6        Change the data type of the Illustration field so that you can add an
                       image to the field.

                       Add the 5AlbertFalls image found in the examination folder in the
                       Illustration field to the Albert Falls Dam record.                           (2)

          Save and close the Dam table.

5.2       Open the qry5_2 query.

          •   Insert the Town field.
          •   Add criteria to display the names, provinces and towns of all the dams in
              Limpopo.

          Save and close the qry5_2 query.                                                          (2)

Copy right reserved                                                              Please turn over

### Page 13

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1            13                        DBE/Feb.–Mar. 2017
                                               NSC

5.3       Create a query called qry5_3 based on the Dam table to appear as shown
          below.

          NOTE:

          •   The Avg Of Capacity field uses the Capacity field.
          •   Only the data for the Free State and North West must appear.

                                 Province            Avg Of Capacity
                                 Free State                   826914
                                 North West                   109436

          Save and close the qry5_3 query.                                                       (5)

5.4       Open the qry5_4 query.

          Display only the names and towns of the dams that have data entered for the
          surface of the dam and that were completed from 1 January 1990 to
          31 December 2000 (inclusive).

          Save and close the qry5_4 query.                                                       (4)

5.5       Open the qry5_5 query.

          •   Create and display a calculated field called Volume to calculate the
              volume of water currently in each dam.
          •   The calculation for the volume of the dam is Surface*Height*0.3.
          •   Format this field to display ONE decimal place.

          Save and close the qry5_5 query.                                                       (4)

5.6       Open the frm5_6 form.

          •   Add the 5AlbertFalls image found in the examination folder as a
              background image to the form.

          •   Insert a hyperlink as follows:
              o Place the hyperlink next to the Province label on the form.
              o The hyperlink links to the Province table in this database.

              HINT: The hyperlink is one of the controls in the Design tab.

          •   Insert your examination number in the form footer.

          Save and close the frm5_6 form.                                                        (5)

Copy right reserved                                                           Please turn over

### Page 14

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1           14                          DBE/Feb.–Mar. 2017
                                              NSC

5.7       Open the rpt5_7 report based on the Dam table.

          •   Remove the Illustration label AND the field.

          •   Group the report by the Province field and sort it by the Town field.

          •   Use a function to determine the largest Capacity of all the dams in the
              report.

          Save and close the rpt5_7 report.                                                        (5)

Save and close the 5Dam database.                                                                  [37]

Copy right reserved                                                             Please turn over

### Page 15

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1       15                     DBE/Feb.–Mar. 2017
                                          NSC

QUESTION 6: WEB DESIGN (HTML)

A webpage has been created on how to be water wise.

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

NOTE:

•   Question numbers are inserted as comments in the coding to show approximately
    where the answer(s) should be inserted.
•   An HTML tag sheet has been attached for reference.

Your final web page should look like the example below.

Copy right reserved                                                   Please turn over

### Page 16

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1           16                           DBE/Feb.–Mar. 2017
                                              NSC

NOTE: Use the example on the previous page to guide you with this question.

6.1       Add your examination number to display in the browser tab.                                   (1)

6.2       Add an additional cell to the first table and insert the 6Life image found in the
          examination folder inside this cell.                                                         (3)

6.3       Add a horizontal line below the first table with a size/thickness of 5.                      (2)

6.4       Centre the heading 'Are you water wise?' AND set the font to 'Arial'.                        (2)

6.5       Find the second table.

          Set the border size to 1 and the cell padding to 12.                                         (2)

6.6        Change the first row of the second table to appear as shown below.

             The kitchen, bathroom, and laundry are three areas in the home where
             huge amounts of water are used. Water consumption in these areas
             can be reduced using a few simple steps. In the summer months,
             outdoor water use causes overall water demand to increase. By using
             water wisely, you can help to reduce this. Here are some suggestions:

                        Inside the house                      Outside the house
                                                                                                       (3)

6.7        Find the HTML code that displays the image 6House.

          Change the code so that the word 'Inside' will display if the image cannot be
          displayed.                                                                                   (1)

6.8       Set the bullet style of the unordered list to a circle AND ensure that all the
          bullets appear correctly.                                                                    (2)

6.9       Insert the text 'waterwize.co.za' AND create a link from the text to the e-mail
          address 'waterwize@water.co.za' that already appears in the web page.                        (3)

Save and close the 6Wise_Wys document.                                                                 [19]

Copy right reserved                                                                 Please turn over

### Page 17

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1           17                            DBE/Feb.–Mar. 2017
                                              NSC

QUESTION 7: GENERAL

A spreadsheet was created that contains data on the longest rivers in the world.

7.1       Open the 7Rivers_Riviere spreadsheet.

          7.1.1       Add the worksheet name as a field in the left section of the header.        (3)

          7.1.2       The names of the rivers have been defined as a named range.

                      Change the named range to 'Name_River'.                                     (1)

          7.1.3       Protect column A to column C so that users cannot enter text.

                      Add 123 as the password.                                                    (2)

          Do NOT close the 7Rivers_Riviere spreadsheet.

7.2       Open the 7River_Rivier database and import the data                       from the
          7Rivers_Riviere spreadsheet into a new table into the database.

          Use the worksheet name as the table name.                                               (2)

          Save and close the 7Rivers_Riviere spreadsheet and 7River_Rivier
          database.

Open the 7Antw_Answ word processing document and use the 7Water document to
enter the answers for the following questions:

7.3       7.3.1       What is the gutter position setting of the document?                        (1)

          7.3.2       How many paragraphs appear in the document?                                 (1)

          7.3.3       How many occurrences of the letter 'm' (upper case and lower
                      case) appear in the document?                                               (1)

          7.3.4       What is the first word that appears on line 100 in the document?            (1)

          7.3.5       What is the line weight/width of the 'Intense Quote' style?                 (1)

          7.3.6       Which word is marked as an item to appear in an index?                      (1)

          7.3.7       What is the title of the single-source citation that appears in the
                      document?                                                                   (1)

Save and close the 7Antw_Answ document.                                                           [15]

                                                                                     TOTAL:       180

Copyright reserved

### Page 18

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1                                                 DBE/Feb.–Mar. 2017
                                                       NSC
                                          HTML TAG SHEET
                     Basic Tags                                        Formatting Tags continued
          Tag                     Description                        Tag                     Description
<body></body>            Defines the body of the web                               Inserted before each list
                         page                                                      item, and adds a number or
                                                             <li></li>
<body                    Sets the background colour of                             symbol depending on the
bgcolor="pink">          the web page                                              type of list selected
<body                    Sets the colour of the body
                                                             <img src="name">       Adds an image
text="black">            text
                         Contains information about
<head></head>                                                <img src="name"        Aligns an image: can be
                         the web page                        align="left">          "left", "right", "bottom", "top"
                                                             <p align="center">     Aligns an image in the
                         Creates an HTML document –
<html></html>                                                <img src="name">       "center", can also be
                         starts and ends a web page          </p>                   "middle"
                                                             <img src="name"        Sets the size of the border
                         Defines a title for the web
<title></title>                                              border="1">            around an image
                         page
<br/>                    Inserts a line break                <img src="name"
                                                             width="200" height     Sets the height and width of
<!-- -->                Comment                                                     an image
                                                             ="200">
                     Text Tags
          Tag                  Description                                          Displays alternative text
                                                             <img src="name"
                                                             alt="alternative       when the mouse hovers over
<hl></hl>                Creates the largest heading                                the image or when the image
                                                             text">
<h6></h6>                Creates the smallest heading                               is not found
                                                             <hr/>                  Inserts a horizontal line
<b></b>                  Creates bold text                   <hr size="3"/>         Sets size (height) of a line
                                                                                    Sets the width of a line, in
<i></i>                  Creates italic text                 <hr width="80%"/>
                                                                                    percentage or absolute value
<font                Sets size of font, from "1" to          <hr color=
                                                                                    Sets the colour of the line
size="3"></font>     "7"                                     "ff0000"/>
<font color=                                                                    Table Tags
                     Sets font colour
"green"> </font>                                                     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
                                                             <th></th>
<a href="URL"></a> Creates a hyperlink                                              cell with bold, centred text)
<a href="URL"><img
                     Creates an image link                   <table width="50">     Sets the width of the table
src="name"></a>
                     Creates a target location in                                   Sets the width of the border
<a name="NAME"></a>                                          <table border="1">
                     the document                                                   around the table cells
                     Links to a target location              <table                 Sets the space between the
<a href=
                     created somewhere else in               cellspacing="1">       table cells
"#NAME"></a>
                     the document                            <table                 Sets the space between a
               Formatting Tags                               cellpadding="1">       cell 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                                  Sets the vertical alignment
<p align="left">         "left" (default), can also be       <tr valign="top">      for cell(s) ("top", can also be
                         "right" or "center"                                        "middle" or "bottom")
<br/>                    Inserts a line break                                       Sets the number of columns
                                                             <td colspan="2">
<ol></ol>                Creates a numbered list                                    a cell should span
<ol type="A","a",        Defines the type of numbering                              Sets the number of rows a
                                                             <td rowspan="4">
"I","i","1"></ol>        used                                                       cell should span
<ul></ul>                Creates a bulleted list
<ul type="disc",
                         Defines the type of bullets
"square","circle">
</ul>                    used

Copyright reserved

### Page 19

Downloaded from hlayiso.com
Computer Applications Tec hnology/P1                                              DBE/Feb.–Mar. 2017
                                                   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 lower case

         >            Causes all characters to be converted to upper case

                      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 (for
         \
                      example, \A is displayed as just A)

Copyright reserved

### Page 20

Downloaded from hlayiso.com
   Computer Applications Tec hnology/P1                                                 DBE/Feb.–Mar. 2017
                                                       NSC

                                                   Examination sticker
                                                                                                          180

             COMPUTER APPLICATIONS TECHNOLOGY P1 – FEB.–MAR. 2017

   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        Office 365
 (Mark appropriate
                                      2010                  2013                 2016
 box with a cross (X))
 WEB BROWSER USED                                                                                Other (Specify)
 (Mark appropriate               Mozilla Firefox       Google Chrome        Internet Explorer
 box with a cross (X))

FOLDER NAME _______________________________________________________________
Candidate to tick if saved and/or attempted.

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

     1       1Areas                                           37

             2Water
     2                                                        17
             2Done

     3       3Rain_Reën                                       38

     4       4Game_Speel                                      17

     5       5Dam                                             37

     6       6Wise_Wys                                        19

             7Rivers_Riviere

     7       7River_Rivier                                    15

             7Answ_Antw
                        TOTAL                                180

Comment (for office/marker use only)
___________________________________________________________________________________________________________________

___________________________________________________________________________________________________________________

   Copyright reserved

## Related documents

- [Computer Application Technology P1 Feb March 2017 Afr](https://www.hlayiso.com/library/computer-application-technology-p1-feb-march-2017-afr/5202d242-87ee-4a25-a640-e1382d1c2f52) — Computer Applications Technology · QP · 2017 · Afr
- [Computer Application Technology P2 Feb March 2017 Afr](https://www.hlayiso.com/library/computer-application-technology-p2-feb-march-2017-afr/4f2b86be-7b1f-410f-8266-238b4f2a258c) — Computer Applications Technology · QP · 2017 · Afr
- [Computer Application Technology P2 Feb March 2017 Eng](https://www.hlayiso.com/library/computer-application-technology-p2-feb-march-2017-eng/8c6f2567-23b3-406f-b644-73975e589ec7) — Computer Applications Technology · QP · 2017 · Eng
- [GR12 CATN P1 Sept2017 QP Eng 2](https://www.hlayiso.com/library/gr12-catn-p1-sept2017-qp-eng-2/7f2741dd-5b56-4f4d-9efb-26c2263be0a2) — Computer Applications Technology · QP · 2017 · Eng
- [Computer Application Technology P1 Feb March 2018 Afr](https://www.hlayiso.com/library/computer-application-technology-p1-feb-march-2018-afr/ef8c6572-bec0-4517-8d2e-4ee873c81aa5) — Computer Applications Technology · QP · 2018 · Afr
- [CAT P1 Feb March 2016 Eng](https://www.hlayiso.com/library/cat-p1-feb-march-2016-eng/c366b6c4-086b-4d0c-a41c-a773bc79cc84) — Computer Applications Technology · QP · 2016 · 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
- [Computer Applications Technology P1 Nov 2023 Eng](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2023-eng/60311585-04c7-46dc-bcf6-87da09dc1ea5) — QP · 2023 · Eng

## 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.
