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

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

- Page: https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2017-eng/92d894a4-6ae9-4e3b-b50f-87945cb07689
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2017
- Exam period: NSC June 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-may-june-2017-eng/92d894a4-6ae9-4e3b-b50f-87945cb07689)

## About this document

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

                     SENIOR CERTIFICATE EXAMINATIONS

                     COMPUTER APPLICATIONS TECHNOLOGY P1

                                         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/2017
                                             SCE

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

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/teacher. Make
          absolutely sure that all 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.

Copyright reserved                                                            Please turn over

### Page 3

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

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.

          •   1Bullet                                 Image file
          •   1Cost                                   Word processing file
          •   2Cars                                   Image file
          •   2Guide                                  Word processing file
          •   3Car                                    Spreadsheet file
          •   4Show                                   Spreadsheet file
          •   5Old                                    Image file
          •   5Sales                                  Database file
          •   6Beware                                 HTML file
          •   6Drive                                  Image file
          •   7Acc                                    Database file
          •   7Answ                                   Word processing file
          •   7Buy                                    Database file
          •   7Chart                                  Spreadsheet file
          •   7Statem                                 Word processing file

Copyright reserved                                                                Please turn over

### Page 4

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

SCENARIO

Many young people would like to buy a car for transport. They must carefully consider
many aspects of owning a car when they make the decision to buy a car.

QUESTION 1: WORD PROCESSING

There are many hidden costs when buying a car.

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

1.1       Find the WordArt, 'What your car is really costing you' and change it as
          follows:

          •   Apply any reflection text effect to the WordArt. Ensure that the entire
              WordArt and its reflection effect are clearly visible.
          •   Apply a text outline of 1.5 pt (1½ pt) around the WordArt (the outline
              appears around each character and not as an outer border).                         (3)

1.2       Find the text 'Document created:' below the WordArt.

          Insert a field next to the text to display the date the document was created.          (2)

1.3       Use the replace feature of the word processor to change any instance of the
          word 'depreciation' so that they appear in bold with a strikethrough effect.           (4)

1.4       Find the text starting with 'Ownership Costs' and ending with '… overnight
          parking, etc.' and do the following:

          •   Place this text in two columns.
          •   Ensure that the text 'The costs of a car are:' will always appear at the top
              of the second column.                                                              (2)

1.5       Find the text starting with 'fuel …' and ending with '… roadworthy' under the
          heading 'Running Costs'.

          Create and apply a multilevel list as follows:

          •   Insert the image 1Bullet for all level-one entries and set the text to be
              1.5 cm away from the bullets.
          •   Insert the numbering 1, 2, 3 … for the level-two numbering, as shown in
              the example below.
          •   Align the number for the level-two numbering to 0 cm.

                     fuel
          1          filling up the tank
                     maintenance
          1          car service
          2          roadworthy                                                                  (5)

Copyright reserved                                                            Please turn over

### Page 5

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

1.6       Find the table under the text ending with '… my example are:' and make the
          following changes to the table:

          •   Change the row height of all the rows in the table to exactly 0.9 cm.
          •   Format the table by applying any table style of your choice to the table.
          •   Centre the contents of the entire table vertically.
          •   Insert a caption for the table by using the text in the cell of column 1 and
              row 5 as the caption of the table. The caption should start with 'Table 4'.        (5)

1.7       Find the text starting with 'Summary: What …'.

          Place the text from this point to the end of the document in landscape
          orientation. The rest of the pages in the document must remain in portrait
          orientation.                                                                           (2)

1.8       Insert any automatic table of figures at the end of the document.                      (1)

Save and close the 1Cost document.                                                               [24]

Copyright reserved                                                            Please turn over

### Page 6

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

QUESTION 2: WORD PROCESSING

A guideline document was created to assist car buyers.

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

2.1       Remove the comment on the first page of the document.                               (1)

2.2       Make the following changes to the first page as follows:

          •   Apply the 'Car Front' style to the heading 'GUIDELINES TO BUYING
              A CAR'.
          •   Insert the image 2Cars.jpg as a watermark WITHOUT any washout
              effect. This watermark must appear ONLY on the first page of the
              document.                                                                       (5)

2.3       Find the table of contents below the text 'TABLE OF CONTENTS' on the
          second page of the document and do the following:

          •   Change the format of the table of contents to 'Modern' and DO NOT
              display page numbers.
          •   Update the table of contents.                                                   (3)

2.4       Find the citation 'Wisebuyer's Guides' at the beginning of page 3 and edit
          the source of the citation by adding the name of the web page 'Facts for
          car buyers'.                                                                        (1)

2.5       Find the numbered paragraphs on page 3 of the document.

          Format paragraphs 2 and 3 respectively to have the same indentation as the
          first numbered paragraph.                                                           (2)

2.6       Change the 'Heading 1' style as follows:

          •   Change the font size to 20.
          •   Change font colour to red.
          •   Change the paragraph spacing after the paragraph to 12 pt.                      (3)

2.7       Find     the  text   'emissions'  in   the     paragraph    under    the
          heading '6. Fuel consumption to the fore'. Insert a footnote on the text
          as follows:

          •   The footnote must always appear below the text.
          •   Use the symbol  (Webdings character code 113).
          •   Add the text 'Carbon dioxide' as the footnote text.                             (4)

Copyright reserved                                                         Please turn over

### Page 7

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

2.8       Find the text 'So you have made your decision' in the last paragraph
          (paragraph 10).

          Insert a link on this text to the website www.cars4you.co.za.                      (2)

2.9       Justify and automatically hyphenate the whole document.                            (2)

Save and close the 2Guide document.                                                          [23]

Copyright reserved                                                        Please turn over

### Page 8

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

QUESTION 3: SPREADSHEET

A list of cars available at the Mzansi Car Sales showroom has been 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 3Car spreadsheet and work in the Info worksheet.

3.1       Insert the text 'MZANSI CAR SALES' in cell A1.                                          (1)

3.2       The code for each car is created as follows:

          •   The first two letters of the name of the car manufacturer (column B)
          •   Followed by the last three digits of the year in which the car was
              manufactured (column F)
          •   Followed by the owner's name (column K)

          Insert a function in cell A3 to create the code for that car.

          EXAMPLE: Chevrolet, 2007, J Bihl will have Ch007J Bihl as code.                         (6)

3.3       Insert a function in cell G4 to calculate the age of the car by using the current
          year and the date the car was released from the factory in column F.

          Ensure that the function will still produce the correct answer for any year,
          for example 2017 or 2018. The age must be displayed as a whole number.                  (4)

3.4       Use a function in column J to display the car's registration number in
          column I in upper case, for example VGG586FS.

          Hide column I.                                                                          (3)

3.5       Insert a function in cell L4 to determine the position of the space located
          between the owner's initials and surname in column K.                                   (3)

3.6       Insert a function in cell M5 using the position of the space in column L to
          display only the surname from column K.

          EXAMPLE: 'HC Burger' will display 'Burger' and 'D Kotze' will display 'Kotze'.          (5)

Copyright reserved                                                             Please turn over

### Page 9

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

3.7       The deposit for a car is calculated using the year (column F) and the selling
          price (column N) as follows:

                             YEAR                         DEPOSIT
                         2014 or newer               10% of selling price
                          2010 to 2013               20% of selling price
                          2009 or older              30% of selling price

          Insert a nested IF function in cell O6 to determine the actual deposit to
          be paid.                                                                                   (4)

3.8       The total amount owed for a car is calculated by adding the interest
          (column P) to the selling price (column N) and then deducting the deposit
          (column O).

          Insert a formula in cell Q7 to calculate the monthly repayment of the car over
          60 months using the total amount owed. (The car will be repaid with 60 equal
          monthly repayments.)                                                                       (2)

3.9       Insert a VLOOKUP function in cell R8 to determine the CO 2 emissions for
          each engine size (column E). Use the table in the CO2 worksheet.

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

Save and close the 3Car spreadsheet.                                                                 [32]

Copyright reserved                                                                Please turn over

### Page 10

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

QUESTION 4: SPREADSHEET

The different types of vehicles in the showroom have been 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 4Show spreadsheet and work in the Type_Tipe worksheet. Refer to the
summary of the vehicles in the showroom (cells I3:J16).

4.1        Insert a function in cell J15 to determine the total number of Toyota vehicles
           in the showroom.                                                                       (3)

4.2        Insert a function in cell J18 to determine the second highest total of all the
           various types of vehicles in the showroom (column J).                                  (3)

4.3        Insert a function in cell J19 to determine the total number of vehicles in the
           showroom.                                                                              (2)

4.4        Insert a function in cell J20 to determine the total value of the VW vehicles in
           the showroom.                                                                          (4)

4.5        Use an appropriate spreadsheet feature to format all unique values in
           cells J3:J16 with a green fill colour.                                                 (3)

Copyright reserved                                                             Please turn over

### Page 11

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

4.6       A chart/graph was created using the data in the range I3:J16. Change the
          chart/graph to resemble the chart/graph below by carrying out the instructions
          that follow.

                                             Makes Available
                               14
                                                                              Audi
                               12
                                                                              Chevrolet
                               10                                             Fiat

              Number of cars
                                                                              Ford
                               8
                                                                              Honda
                               6                                              Hyundai
                                                                              Kia
                               4
                                                                              Mazda
                               2                                              VW

                               0                                              Opel
                                                                              Renault
                                                                              Tata
                                                                              Toyota
                                                Make

          •         Insert the text 'Number of cars' for the vertical axis.
          •         Change the chart/graph title to 'Makes Available'.
          •         Format the columns so that there are no gaps between the columns.
          •         Use a spreadsheet feature to format and display each column in a
                    different/varied colour.
          •         Display the borders of the columns as a solid black line.
          •         Move the chart/graph to the Motor worksheet.                                (6)

Save and close the 4Show spreadsheet.                                                           [21]

Copyright reserved                                                          Please turn over

### Page 12

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

QUESTION 5: DATABASE

A database was created to store details of cars.

Open the 5Sales database.

5.1      Edit the tbSales table as follows:

         5.1.1        Change the field size of the Make field to 70.                                  (1)

         5.1.2        Add the 'SUV' option to the drop-down list in the Type field.                   (1)

         5.1.3        Add a validation rule to ensure that only values later than or equal to
                      the current date can be entered in the SellDate field.

                      An appropriate message must be displayed when an incorrect date
                      is entered.                                                                     (3)

          5.1.4       Change the data type of the Photo field to a suitable data type.                (1)

          5.1.5       Create an input mask on the RegNumber field to ensure that the
                      user inserts a registration number in the following format:

                      •   All the letters must be displayed in upper case
                      •   Two compulsory letters
                      •   Followed by at least one, but possibly two, letters or digits

                      EXAMPLE: ABC, HL8C, GUY1, REFG, MN45                                            (4)

         Save and close the tbSales table.

5.2      Open the query called qry5_2 based on the tbClients table and do the
         following:

         •   Add the Title field from the tbClients table.
         •   Sort the list alphabetically first according to surname and then according
             to initials.

         Save and close the qry5_2 query.                                                             (4)

5.3      Open the query called qry5_3 based on the tbPayments table and do the
         following:

         •   Add a calculated field called Balance to calculate the amount outstanding.
             The amount outstanding is obtained by subtracting the amount paid and
             the deposit from the selling price.
         •   Format the SellingPrice field to currency in rand.

         Save and close the qry5_3 query.                                                             (5)

 Copyright reserved                                                                Please turn over

### Page 13

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

5.4      Open and modify the query called qry5_4 based on the tbCars table to
         display only vehicles manufactured by Nissan or Ford that have a purchase
         price of less than or equal to R100 000.

         Save and close the qry5_4 query.                                                         (4)

5.5      Open the frm5_5 form which is based on the tbCars table and do the
         following:

         •   Insert the picture 5Old.jpg in the form header.
         •   Add the Colour field to the form.
         •   Set the default value of the 'Popular' check box not to be selected.
         •   Insert a function in the text box next to the label 'Function_Funksie' to
             determine the selling price of the vehicle. The selling price is calculated by
             adding 10 per cent to the purchase price.

         Save and close the frm5_5 form.                                                          (8)

5.6      Open and edit the rep5_6 report as follows:

         •   Change the report orientation to landscape.
         •   Add a second grouping on the Year field.
         •   An incorrect attempt was made to determine the total value of the vehicles
             per manufacturer. Correct the function and display the calculation in
             currency.
         •   The year of the current date is displayed in the report header. Change the
             formula to display the month of the current date.
         •   Insert a function and display the average price of a vehicle for a particular
             manufacturer.

         Save and close the rpt5_6 report.                                                        (8)

Save and close the 5Sales database.                                                               [39]

 Copyright reserved                                                            Please turn over

### Page 14

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

QUESTION 6: WEB DESIGN (HTML)

A web page has been created. Follow the instructions below to complete the web page.
Open the incomplete 6Beware web page in a web browser and also in a text editor
(NOT a word processing program such as Word).
NOTE:
•     Question numbers are inserted as comments in the coding as guidelines to show
      approximately where the answer(s) should be inserted.
•     Your web page may display differently, depending on the browser used.
•     An HTML tag sheet has been attached for reference.
Your final web page should look like the example below.

    Copyright reserved                                                    Please turn over

### Page 15

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

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

6.1      Format the heading 'Unsafe Driving in the Cellphone Era' as follows:

         •   Change the font type to Tahoma.
         •   Change the font size to 24 pt.                                                         (2)

6.2      Insert a horizontal line under the heading 'Unsafe Driving in the Cellphone
         Era'.                                                                                      (1)

6.3      Centre the picture horizontally and place a border of 5 pt around it.                      (2)

6.4      Find the text 'Driver Behaviour: Distracted While Driving'. Change this to a
         level-two heading.                                                                         (1)

6.5      Find the text 'driver distraction' under the heading 'Rise in Potentially
         Dangerous Vehicular Events'.

         Create a link on this text to the anchor 'Distraction' that already exists in the
         document.                                                                                  (3)

6.6      Find the text starting with 'Handling the phone ...' and ending with '… on the
         road'.

         Place this information in a bulleted list, as shown in the example on the
         previous page.                                                                             (2)

6.7      Find the table under the heading 'Things drivers do that take their eyes and
         focus off the road:'.

         6.7.1        Change the table as follows:

                      •   Change the table background colour to light blue.
                      •   Set the space between the text and the cell borders to 3 pt.
                      •   Set the width of the table to 80%.                                        (3)

         6.7.2        Change the first row of the table as follows:

                      •   Set the height of the first row to 80 pt.
                      •   Vertically align the content of the first row to appear at the
                          bottom.
                      •   Change the heading 'Action' to italics.                                   (3)

         6.7.3        Add the data 14% to the cell in the third column of the fourth row.           (1)

         6.7.4        Merge the cells in the last row of the table.                                 (1)

Save and close the 6Beware web page.                                                                [19]

 Copyright reserved                                                              Please turn over

### Page 16

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

QUESTION 7: GENERAL

Open the 7Statem word processing document which will be used for a mail merge with
the tbClients table in the 7Acc database.

7.1      Link the 7Statem mail merge document to the tbClients table in the
         7Acc database as a data source.                                                                       (2)

7.2      Replace the text '<Insert Initials>' and '<Insert Surname>' with the initials field
         and surname field respectively from the data source.

         Do NOT complete the merge.                                                                            (1)

7.3      Complete the form as follows:

         •   Insert a form control in the cell next to the text 'Current Date' so that a date
             can be entered.
         •   Edit the form control in the cell next to the text 'Amount Due' to accept only
             the rand currency with two decimal places.
         •   Insert a drop-down form control in the cell next to the text 'Payments'. The
             drop-down form control must display the options 'Up to date' and 'Behind'.                        (6)

Save and close the 7Statem document.

Open the 7Chart spreadsheet.

7.4      Use the data in the spreadsheet to create a chart similar to the example
         shown below.

               50000
                                   37963                                         39933
               40000                               36788                 35366
                                           34413
                           32883                           30873 32982
               30000

               20000                                                                     Cars Sold

               10000

                      0
                          Jan 2014             Apr 2014              Jul 2014

         NOTE:

         •   Only the data for the months of 2014 are displayed.
         •   The way in which the monthly labels are displayed.
         •   The scale used on both axes.
         •   The legend is 'Cars Sold'.
         •   The data labels are added.                                                                        (6)

Save and close the 7Chart spreadsheet.

 Copyright reserved                                                                         Please turn over

### Page 17

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

7.5      Details of the car buyers appear in the tbInfo table of the 7Buy database.

         Open the 7Answ word processing document and insert your examination
         number.

         This question requires you to give the answer and briefly explain the specific
         method/criteria/function you used to obtain the answer.

         EXAMPLE:

                QUESTION                  ANSWER            BRIEF EXPLANATION
           How many boys are in             24         Filter to obtain the boys in
           the Grade 12A class?                        Grade 12A and then use the
                                                       Count function.

         Use the tbInfo table in the 7Buy database to answer the questions below.

         7.5.1        How many records contain the text 'wood' in the city name?                 (2)

         7.5.2        How many records contain buyers with two initials only?                    (2)

         7.5.3        What is the average price paid by car buyers from Durban?                  (3)

         Save and close the 7Answ document and 7Buy database.                                    [22]

                                                                                   TOTAL:        180

 Copyright reserved

### Page 18

Downloaded from hlayiso.com
Computer Applications Technology/P1                                                                DBE/2017
                                                        SCE
                                            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
<head></head>             Contains information about
                                                              <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
<html></html>             Creates an HTML document –          <img src="name">        "center", can also be
                          starts and ends a web page          </p>                    "middle"
                                                              <img src="name"         Sets the size of the border
<title></title>           Defines a title for the web         border="1">             around an image
                          page
<br/>                     Inserts a line break                <img src="name"
                                                              width="200" height      Sets the height and width of
<!-- -->                 Comment
                                                              ="200">                 an image
                      Text Tags
          Tag                   Description                                           Displays alternative text
                                                              <img src="name"
                                                              alt="alternative        when the mouse hovers over
<hl></hl>                 Creates the largest heading
                                                              text">                  the image or when the image
<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
<i></i>                                                       <hr width="80%"/>       Sets the width of a line, in
                          Creates italic text
                                                                                      percentage or absolute value
<font                 Sets size of font, from "1" to          <hr color=
size="3"></font>                                              "ff0000"/>              Sets the colour of the line
                      "7"
<font color=                                                                      Table Tags
"green"> </font>      Sets font colour
                                                                      Tag                     Description
<font face="Times                                             <table></table>         Creates a table
New Roman"></font>    Sets font type
                                                              <tr></tr>               Creates a row in a table
                  Links Tags                                  <td></td>               Creates a cell in a table
        Tag                    Description                                            Creates a table header (a
                                                              <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>

<a name="NAME"></a>     Creates a target location in          <table border="1">      Sets the width of the border
                        the document                                                  around the table cells
                        Links to a target location            <table                  Sets the space between the
<a href=                                                      cellspacing="1">
                        created somewhere else in                                     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 Technology/P1                                                          DBE/2017
                                                         SCE

                               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 Technology/P1                                                             DBE/2017
                                                          SCE

                                                    Examination sticker
                                                                                                            180

                  COMPUTER APPLICATIONS TECHNOLOGY P1 – SCE 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       1Cost                                            24

     2       2Guide                                           23

     3       3Car                                             32

     4       4Show                                            21

     5       5Sales                                           39

     6       6Beware                                          19

             7Answ

     7       7Chart                                           22

             7Statem

                         TOTAL                                180

Comment (for office/marker use only)
____________________________________________________________________________________________________________________

____________________________________________________________________________________________________________________

    Copyright reserved

## Related documents

- [Computer Application Technology P1 May June 2017 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2017-memo-eng/7e7366e7-46e1-4300-a0da-3e88eb4b2ece) — Computer Applications Technology · Memo · 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
- [Computer Application Technology P1 May June 2021 Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2021-eng/5be0bf0e-69bd-4481-9ce4-d56745874ad6) — Computer Applications Technology · QP · 2021 · Eng
- [Computer Application Technology P1 May June 2016 Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2016-eng/da15995d-25c5-4cb8-a14a-08bf723c628c) — Computer Applications Technology · QP · 2016 · Eng
- [CAT P1 June July 2015 Afr](https://www.hlayiso.com/library/cat-p1-june-july-2015-afr/67e7c672-7961-430c-8360-5aa92c095466) — Computer Applications Technology · QP · 2015 · 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.
