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

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

- Page: https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-eng/7b24721e-e1a0-4536-907b-b0c0fcce6d48
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2017
- Exam period: NSC November 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-nov-2017-eng/7b24721e-e1a0-4536-907b-b0c0fcce6d48)

## About this document

Computer Applications Technology · Grade 12 · NSC November 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

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

Copyright reserved                                                  Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Technology/P1           2                           DBE/November 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 your answer files are saved on the
          network/computer as explained to you by the invigilator/educator. Make
          absolutely sure that all files can be read. Do NOT save unnecessary
          files/folders. 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 consult the offline help functions of the
          programs that you are using. You may NOT use any other resource material.

Copyright reserved                                                            Please turn over

### Page 3

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

12.       Unless instructed otherwise, use formulae and/or functions for ALL
          calculations in spreadsheet questions. 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 derived 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
          instructed otherwise.

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

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

          •   1Harvest                                 Word processing file
          •   2Pic                                     Image file
          •   2Stay                                    Word processing file
          •   3Acc                                     Spreadsheet file
          •   4Coin                                    Image file
          •   4Quest                                   Spreadsheet file
          •   5Visit                                   Database file
          •   6Hectare                                 Image file
          •   6More                                    Image file
          •   6SAStats                                 Word processing file
          •   6Viti                                    HTML file
          •   7Calc                                    Spreadsheet file
          •   7Rep                                     Database file

Copyright reserved                                                                 Please turn over

### Page 4

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

SCENARIO

Every year several festivals are held all over South Africa. These festivals include food
festivals, flower festivals, cherry festivals and wine festivals.

The Harvest Food Festival is held in November every year. You were asked to
research the Harvest Food Festival.

QUESTION 1: WORD PROCESSING

Open the 1Harvest word processing document, which contains an overview of the
Harvest Food Festival, and insert your examination number in the header.

1.1     Follow the instructions below to change the cover page so that it appears similar
        to the one in the example below.

        NOTE:        The WordArt and changed picture may appear slightly different from
                     that which is shown below.

                A FEAST FOR THE SENSES

                Date        24 to 26 November 2017
                Venue       Coetzenburg Sports Ground

        1.1.1          Format the heading 'HARVEST FOOD FESTIVAL' as follows:

                       •   Apply any WordArt of your choice to the heading.
                       •   Rotate the WordArt by 90°.                                               (2)

Copyright reserved                                                               Please turn over

### Page 5

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

        1.1.2        Make the following changes to the picture below the text 'A FEAST
                     FOR THE SENSES':

                     •   Crop the image to display only the basket with the grapes, as
                         shown on the previous page.
                     •   Change the height to exactly 10 cm and the width to exactly 12 cm.
                     •   Apply any oval picture style or shape of your choice to the picture.         (4)

        1.1.3        Find the table with the date and venue and format it as follows:

                     •   Set the default value of the top cell margin of the table to 0.1 cm.
                     •   Do not display any cell borders.                                             (2)

1.2     Insert a page break before the heading 'General overview'.                                    (1)

1.3     The 'Display1' and 'Display2' styles appear in the document.

        1.3.1        Remove the 'Display1' style so that it is not part of the 'Quick Style
                     Gallery' any more.                                                               (1)

        1.3.2        Modify the 'Display2' style as follows:
                     • Add numbering in the format 1., 2., etc.
                     • Add any border around the text.
                     • Decrease the indent of the text so that it is aligned to the left
                       margin.
                     • Update all text currently formatted with the 'Display2' style.                 (4)

1.4     Find the text 'Gourmet Lane ()' on the second page and create a cross
        reference to 'Figure 3: Gourmet Meals' to appear within the brackets '()'.                    (2)

1.5     Find the word 'explore'.

        Change this word's language to English (South Africa).                                        (1)

1.6     Find the text under 'Festival opening times:'. Note the tab settings and
        tab positioning and format the text using tabs, as shown below.

                          Friday ____________________ 15h00-21h00

                          Saturday __________________ 10h00-18h00

                          Sunday ___________________ 10h00-18h00
                                                                                                      (6)

Copyright reserved                                                                 Please turn over

### Page 6

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

1.7     Find the text 'Coetzenburg' below the heading '4. Gourmet Lane' and do the
        following:

        •   Insert a citation next to this text after the book source: Jean Ward,
            'Coetzenburg: A Tourist Site'.
        •   Do not display the year.                                                                (2)

1.8     The entry 'Jumping Castles' for the picture below the subheading '7. Health
        Kiddies Area' does not appear in the table of figures on the last page.

        1.8.1            Make the necessary changes to ensure that the reference to the
                         picture will be included in the table of figures when it is updated.       (2)

        1.8.2            Update the table of figures on the last page.                              (1)

1.9     Insert an automatically generated bibliography on the last page immediately
        below the text 'Bibliography'.

        The bibliography should appear in the APA style.                                            (2)

1.10    Format the page numbering in the document as follows:

        •   Do not display a page number on the first page of the document.
        •   In section 2 on the last page of the document, change the page numbering
            format to i, ii, iii, etc. AND start the numbering from i.
        •   Keep the style of the page number with the 'i' the same as the style of the
            previous pages, as shown below.

                     i
        NOTE: Ignore the position of the page number of section 2.                                  (4)

Save and close the 1Harvest document.                                                               [34]

Copyright reserved                                                               Please turn over

### Page 7

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

QUESTION 2: WORD PROCESSING

The 2Stay word processing document provides information about the types of
accommodation available to the Harvest Food Festival visitors. Open the document
and insert your examination number in the header or the footer.

2.1     Change the page layout as follows:

        •   Set the page size to 'Legal'.
        •   Set the multiple pages to 'Book fold'.                                             (2)

2.2     The oldest Cape Dutch or Victorian villa is 600 years old.

        Find the comment on the first page of the document. Respond to the question
        with a comment that answers the question.                                              (2)

2.3     Add a watermark to the document as follows:

        •   Use the 2Pic image (found in the examination folder).
        •   Scale the watermark image to 200%.                                                 (3)

2.4     Find the text 'Booking Form' on the last page of the document and do the
        following:

        •   Find the check box form field next to the text 'Special Shopper' and set the
            default value of the check box to checked.
        •   Add the 'B and B' option to the combo box control next to the text 'Type of
            Accommodation'. Ensure that this option appears first.
        •   Format the text form field control next to the text 'Total' to:
            o Accept only numbers
            o Display the value in South African currency
            o Display help text 'Days*Rate' when the Help key (F1) is pressed                  (7)

2.5     Find the text 'Insert SaveDate field' at the bottom of the document and replace
        it with a field containing the date on which the document was saved.                   (2)

Save and close the 2Stay document.                                                             [16]

Copyright reserved                                                          Please turn over

### Page 8

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

QUESTION 3: 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 them to other cells in the same column
    (copy down).
•   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 3Acc spreadsheet that contains information about accommodation.

Work in the Accom_Verblyf worksheet.

3.1     Format row 6 as follows:

        •   Change the height of row 6 to 45 pt.
        •   Wrap the headings in row 6.                                                            (2)

3.2     Insert a formula in cell H7 to determine the total number of nights
        Elmarie Raymond will stay at her accommodation.                                            (2)

3.3     Use a VLOOKUP function in cell I8 to determine the rate per night for the
        accommodation booked by Marsden Santos. Use the accommodation
        information in column D and the lookup table in the Rate_Tarief worksheet.

        Ensure that the function will work correctly if it is copied to the rest of the cells
        in the column.                                                                             (4)

3.4     Insert a formula in cell J9 to determine the total amount due for
        accommodation for the number of nights given in column H and at the rate per
        night given in column I.

        Change the format to currency.                                                             (3)

3.5     Discount is awarded based on the star rating of the accommodation of a
        person (column K) and on the amount (column J).

        Each star represents 1% discount.

        EXAMPLE:
        • A visitor who stays in accommodation with a one-star rating ('*') will get 1%
          discount on the amount due.
        • A visitor who stays in accommodation with a four-star rating ('****') will get
          4% discount on the amount due.

        Insert a function/formula in cell L10 to determine the amount of discount the
        guest will receive.                                                                        (4)

Copyright reserved                                                              Please turn over

### Page 9

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

3.6     The 7th character of the identity number (column C) refers to the gender of a
        person:

        EXAMPLE:          8102182331045:     810218         2      331      045

                                                          Gender

        The steps to obtain the gender of a person are:

         Step 1: Extract the character representing the gender from the identity
                 number.
         Step 2: Use a text function to convert this character to a number.
         Step 3: Determine whether the number represents a male or female:
                 A number greater than or equal to 5 represents a male, while
                 a number smaller than or equal to 4 represents a female.

        The function in cell M7 attempts to extract the character representing the
        gender from the identity number. The function, however, currently returns more
        than one character.

        Modify the function to correctly extract the character in step 1 and add steps 2
        and 3 to the function to complete it, so that 'Male' or 'Female' is displayed
        in cell M7.                                                                            (6)

3.7     Insert a function in cell G2 to determine the third lowest rate per night
        (column I).                                                                            (3)

3.8     Insert a function in cell G3 to determine the most frequently occurring rate per
        night (column I).                                                                      (2)

3.9     Insert a function in cell G4 to determine the total amount earned (column J) by
        all the 'Country' accommodation types (column E).

        EXAMPLE: 'Country House' or 'Country Inn'.                                             (5)

Save and close the 3Acc spreadsheet.                                                           [31]

Copyright reserved                                                          Please turn over

### Page 10

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

QUESTION 4: 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 them to other cells in the same column
      (copy down).
•     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 4Quest spreadsheet that contains the results of a questionnaire.

Work in the Respons worksheet.

4.1        The answers to the question regarding the reason for visiting festivals are
           stored in column H.

           Insert a function in cell H3 to determine how many visitors did NOT respond
           to this question.                                                                      (2)

4.2        The end time (column K) for the completion of a questionnaire is obtained by
           adding 20 minutes to the starting time (column J).

           Insert a TIME function in cell K6 to determine the end time for the completion
           of the questionnaire.

           NOTE:      You may assume that the seconds in the time function will always
                      be set to 0.                                                                (4)

4.3        The total number of visitors is stored in cell K2.

           Insert a formula in cell K3 to determine the percentage of visitors who gave a
           reason (column H) in the questionnaire for visiting festivals.                         (4)

4.4        Use conditional formatting so that the names and surnames in column A and
           column B display with any fill colour only if the frequency in column G equals
           the frequency selected in cell B3.

           HINT:     Use a formula in the conditional formatting feature.                         (4)

Copyright reserved                                                             Please turn over

### Page 11

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

Work in the Earn_Verdien worksheet.

4.5       The column chart/graph was created using the data in the range B4:C10 in
          the Earn_Verdien worksheet.

          •       Add the title 'Amount' to the vertical axis.
          •       Display the 4Coin image in the second column, stacked and scaled in
                  units of 100 000.
          •       The horizontal axis labels should be displayed, as shown in the
                  chart/graph below, AND in major units of two days.

                                               Festival Earnings per Day
                       R900 000
                       R800 000
                       R700 000

              Amount
                       R600 000
                       R500 000
                       R400 000
                       R300 000
                       R200 000
                       R100 000
                            R0

                                  2017-11-22                 2017-11-24    2017-11-26

                                                          Dates                                               (5)

Save and close the 4Quest spreadsheet.                                                                        [19]

Copyright reserved                                                                         Please turn over

### Page 12

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

QUESTION 5: DATABASE

Open the 5Visit database that contains visitors' accommodation details.

5.1      The accommodation details of all visitors are stored in the tbAccom table.

         Open the tbAccom table in design view.

         5.1.1       Set the field size for the Name field to 30.                                     (1)

         5.1.2       Ensure that a user has to enter a surname in the Surname field.                  (1)

         5.1.3       Create an input mask for the IdentityNumber field to accept data in
                     the following format only: 9007185285083.                                        (2)

         5.1.4       Add 'EC' as the first option in the existing drop-down list of the
                     Province field.                                                                  (2)

         5.1.5       Change the field properties of the DateIn field so that:

                     •   The user can only enter a date between 2017/11/18 and
                         2017/11/28 (inclusive)
                     •   Appropriate validation text is entered as a message                          (4)

         5.1.6       Modify the expression of the calculated field Code to return the first
                     THREE letters of a visitor's SURNAME.                                            (2)

         Save and close the tbAccom table.

5.2      Open the frm5_2 form.

         Modify the form as follows:

         •   Change the form header text to your examination number.
         •   The date picker control for the DateIn field must NOT be displayed when
             the form is switched to form view.
             HINT: The date picker property is found in the DateIn text box properties
                      under the Format tab.
         •   Format the Rate field to currency.
         •   Insert the date and time in the form footer so that it automatically updates
             every time the form opens.

         Save and close the frm5_2 form.                                                              (6)

Copyright reserved                                                                 Please turn over

### Page 13

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

5.3      Open the qry5_3 query.

         •   Modify the query to display all visitors from Limpopo (LP) or Mpumalanga
             (MP).
         •   Sort the data alphabetically according to surnames.

         Save and close the qry5_3 query.                                                     (4)

5.4      Open the qry5_4 query.

         Modify the query to display the total number of nights each accommodation will
         be visited, as shown in the table below.

         NOTE: The SumOfNumberOfNights field uses the NumberOfNights field and
               will be calculated.

                     Accommodation        SumOfNumberOfNights
         Alverie Guest House                                  8
         Avenir Country Lodge                                11
         Eenheid Self Catering                               18
         Everyellow Lodge                                     1
         Everyellow Manor and Spa                            14
         Groen Guest Farm                                    19
         Hazyview Country House and Spa                      13
         Heaven Valley Hotel                                 11
         Klein Stel Lodge                                     5
         LaMain                                              19
         Lanrac Hotel and Spa                                 8
         Montvue                                              2
         Rosenview Guest House                               16
         Roseview Guest House                                14
         Sara Wine Estate and Hotel                          24
         Serenity Hotel                                      21
         Sun Guest House                                      9
         Vreden Estate                                        6
         Vreede Self Catering                                11
         Werent Hotel and Spa                                28

         Save and close the qry5_4 query.                                                     (2)

5.5      Create a query called qry5_5 based on the tbAccom table, which will display
         only the Name and Surname fields for all the visitors who:

         •   Stayed for 5 nights or less AND
         •   Spent an amount less than R800 or more than R2 000 AND
         •   Did not give a date of birth (DOB)

         Save and close the qry5_5 query.                                                     (7)

Copyright reserved                                                         Please turn over

### Page 14

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

5.6      Open the qry5_6 query.

         •   Create and display a calculated field with the name Discount to calculate
             the discounted amount after 10% has been deducted from the amount.
         •   Ignore the formatting.

         Save and close the qry5_6 query.                                                     (4)

5.7      Open the rpt5_7 report that is based on the tbAccom table.

         •   Apply blue shading to the Province field in the Province group header.
         •   Sort the Amount field in descending order.
         •   Use a function to calculate the total amount spent on each accommodation.

         Save and close the rpt5_7 report.                                                    (5)

Save and close the 5Visit database.                                                           [40]

Copyright reserved                                                         Please turn over

### Page 15

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

QUESTION 6: WEB DESIGN (HTML)

A web page was created, but has not been completed. Follow the instructions below to
complete the web page.

Open the incomplete 6Viti 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 as guidelines to indicate
    approximately where the answer(s) should be inserted.
•   An HTML tag sheet has been attached for reference.

Your final web page must look like the example below.

Copyright reserved                                                       Please turn over

### Page 16

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

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

6.1       Set the font type of the body to 'Arial'.                                               (1)

6.2       Format the text 'Growing Grapes' as follows:

          •   Set the alignment to centre.
          •   Set the font colour to blue.                                                        (2)

6.3       Add a horizontal line of size 3 below the heading 'Growing Grapes'.                     (2)

6.4       Apply bullets to the items under the text 'The choice of variety will depend on:'
          as shown below. Note the shape of the bullets.

          The choice of variety will depend on:
             o the composition of the soil
             o the climate
             o situation of vineyard                                                              (3)

6.5       Insert the picture 6Hectare.png (found in the examination folder) below the
          heading 'Distribution of grape vineyards' and set the height to 250 and the
          width to 350.                                                                           (4)

6.6       Edit the table as follows:

          •   Change the table border to 5.
          •   Merge row 1, as shown below.
          •   Add an additional row, as shown below, and place the text in the
              appropriate cells.

              Variety of grapes
              Vine types               Sales
              Table grapes             275 487 952
              Rootstocks               215 587
              Currants*                987 125
              Sultana                  148 759 871                                                (5)

6.7       Find the image 6More.jpg at the end of the web page. Create a link on the
          image so that, when the image is clicked, it will open the document
          6SAStats.docx (found in the examination folder).                                        (3)

Save and close the 6Viti document.                                                                [20]

Copyright reserved                                                             Please turn over

### Page 17

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

QUESTION 7: GENERAL

Visitors can win many prizes at the Harvest Food Festival.

Open the 7Calc spreadsheet and work in the Num_Nom worksheet.

7.1       A palindromic number is a number that is the same when written forward and
          backward. Examples of palindromic numbers: 343, 121, 242, 535 and 787.

          Determine whether a random number is a palindromic number by completing
          the following steps:

          •   Replace the number in cell A3 with a randomly generated 3-digit number.
          •   Extract the first digit of the randomly generated number in cell B3.
          •   Extract the last digit of the randomly generated number in cell C3.
          •   In cell D3, check whether the number is palindromic. If it is palindromic,
              display the text 'Yes', or else display 'No'.                                         (10)

7.2       Work in the Vouch_Bewys worksheet.

          7.2.1      All visitors who celebrate their birthdays from today onwards will
                     receive a wine voucher.

                     Insert a function in cell E2 to display 'True' if the visitor qualifies for
                     a voucher, or 'False' if a visitor does not qualify. Copy the function
                     for the rest of the visitors.                                                  (7)

          Save the 7Calc spreadsheet.

          7.2.2      Use the data in the Vouch_Bewys worksheet of the 7Calc
                     spreadsheet to create a report called rpt7_2 in the database 7Rep,
                     as shown below.

                     rpt7_2
                        Name_Naam        Surname_Van      Gender_Geslag         DOB_Geboortedatum
                        Ocean            Rojas            Female                       1971/06/20
                        Sonia            Barlow           Female                       1962/10/08
                        Caryn            Mack             Female                       1991/08/17
                        Philip           Vinson           Male                         1969/10/12
                        Kylie            Koch             Female                       1982/04/04
                        Maggy            Riggs            Female                       1975/07/12
                        Iola             Gray             Female                       1967/11/21
                        Jelani           Myers            Female                       1972/01/26
                        Paul             Robbins          Male                         1975/11/18
                        Brennan          Maddox           Male                         1984/12/08   (3)

                     NOTE: Only a part of the report is shown above.

          Save and close the 7Calc spreadsheet and 7Rep database.                                   [20]

                                                                                      TOTAL:        180

Copyright reserved

### Page 18

Downloaded from hlayiso.com
   Computer Applications Technology/P1                                                         DBE/November 2017
                                                                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, and
                                                                  <li></li>           adds a number or symbol
<body                      Sets the background colour of the
                                                                                      depending upon 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
                                                                  <img src="name"     Aligns an image: can be "left",
<head></head>              Contains information about the         align="left">       "right"; "bottom", "top", "middle"
                           web page
                                                                  <p align=
                                                                  "center"><img       Aligns an image to the "center"
<html></html>              Creates an HTML document –             src="name"></p>
                           starts and ends a web page
                                                                  <img src="name"     Sets size of the border around an
<title></title>           Defines a title for the web page        border="1">         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                 <img src="name"
                                                                                      Displays alternative text when the
<hl></hl>                 Creates the largest heading             alt=
                                                                  "alternative        mouse hovers over the image or
                                                                  text">              when the image is not found
<h6></h6>                  Creates the smallest heading
                                                                  <hr/>               Inserts a horizontal line
<b></b>                    Creates bold text                      <hr size="3"/>      Sets size (height) of a line
                                                                  <hr                 Sets width of a line, in percentage
<i></i>                    Creates italic text                    width="80%"/>       or absolute value
<font                                                             <hr
size="3"></font>           Sets size of font, from "1" to "7"     color="ff0000"/> Sets the colour of the line
<font                                                                                Table Tags
color="green">             Sets font colour
</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 cell with
                                                                  <th></th>
<a href="URL"></a>         Creates a hyperlink                                           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 around
<a name="NAME"></a>
                           document                               border="1">            the table cells
                                                                  <table                 Sets the space between the table
<a                         Links to a target location created     cellspacing="1">       cells
href="#NAME"></a>          somewhere else in the document
                                                                  <table                 Sets the space between a cell
                 Formatting Tags                                  cellpadding="1">       border and its contents
          Tag                     Description                     <tr                    Sets the alignment for cell(s) ("left",
<p></p>               Creates a new paragraph                     align="left">          can also be "center" or "right")
                      Aligns a paragraph to the "left"                                   Sets the vertical alignment for
                                                                  <tr
<p align="left">      (default), can also be "right", or                                 cell(s) ("top", can also be "middle"
                                                                  valign="top">
                      "center"                                                           or "bottom")
<br/>                 Inserts a line break                                               Sets the number of columns a cell
                                                                  <td colspan="2">
<ol></ol>             Creates a numbered list                                            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 19

Downloaded from hlayiso.com
Computer Applications Technology/P1                                                DBE/November 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 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 Technology/P1                                                    DBE/November 2017
                                                        NSC

                                               Examination sticker

                                                                                                          180
        COMPUTER APPLICATIONS TECHNOLOGY P1 – NOVEMBER 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
(Mark appropriate                                                                                  Office 365
                                   2010                  2013                 2016
box with a cross (X))
WEB BROWSER USED                                                                                     Other
(QUESTION 6)                                                                                       (Specify)
                                Mozilla Firefox      Google Chrome        Internet Explorer
(Mark appropriate
box with a cross (X))

FOLDER NAME ______________________________________________________________
Tick if saved and/or attempted.

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

  1            1Harvest                                   34
  2              2Stay                                    16
  3              3Acc                                     31
  4             4Quest                                    19
  5              5Visit                                   40
  6               6Viti                                   20
                 7Calc
  7                                                       20
                 7Rep
                      TOTAL                              180

Comment (for office/marker use only)
__________________________________________________________________________________________________________________

__________________________________________________________________________________________________________________

 Copyright reserved

## Related documents

- [Computer Application Technology P1 Nov 2017 Memo Afr Rewrite](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-afr-rewrite/4c3ced4d-1987-42e1-85c6-38ce6cec21d3) — Computer Applications Technology · Memo · 2017 · Afr
- [Computer Application Technology P1 Nov 2017 Memo Eng Rewrite](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-eng-rewrite/f3f97e51-029e-44ca-83f9-dff3eec080ff) — Computer Applications Technology · Memo · 2017 · Eng
- [Computer Application Technology P1 Nov 2017 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-eng/e08c3996-9c1b-4cac-ba21-51c38b866294) — Computer Applications Technology · Memo · 2017 · Eng
- [Computer Application Technology P2 Nov 2017 Eng](https://www.hlayiso.com/library/computer-application-technology-p2-nov-2017-eng/6c8784b9-60df-4307-87e9-d5f335ee48d1) — 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 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

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