Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
COMPUTER APPLICATIONS TECHNOLOGY P1
NOVEMBER 2018
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
Skip to contentAll 2018 papers 





View all





Computer Applications Technology Grade 12 P1 2018 QP (Eng)
Grade 12 Computer Applications Technology Paper 1 question paper from the NSC November Exam 2018 (English), 20 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · NSC November Exam · 2018. Question paper, 20 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2018
- Exam period
- NSC November Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 20
- File size
- 947.6 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 20
This exam
NSC November Exam 2018
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Computer Applications Technology/P1 2 DBE/November 2018
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. If you are working on the network, or if the data files have been preloaded, you
must follow the instructions provided by the invigilator/educator. Alternatively,
the invigilator will give you a CD/DVD/flash drive containing all the files needed
for the examination. If a CD/DVD/flash drive has been issued to you, you must
write your examination number and centre number on the CD/DVD/flash drive.
3. At the end of the examination, you must hand in ALL your answer files saved
onto the given CD/DVD/flash drive, OR you should make sure that ALL the
answer files are saved on the network/computer as explained to you by the
invigilator/educator.
4. Make absolutely sure that ALL files can be read. Do NOT save unnecessary
files/folders and do NOT hand in duplicate answer files/folders. Do NOT
delete any original files that you did not work on.
5. The information sheet that has been provided with the question paper MUST
BE COMPLETED AFTER THE THREE-HOUR EXAMINATION SESSION and
handed to the invigilator.
6. A copy of the master files will be available from the invigilator. Should there be
any problems with a file, you may request another copy from the invigilator.
7. This question paper consists of SEVEN questions. Answer ALL the questions.
8. Read through each question before answering or solving the problem.
Do NOT do more than is required by the question.
9. 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.
10. You may NOT use any resource material.
11. Accuracy will be taken into account, e.g. if a question requires the answer to be
in cell F3 in a spreadsheet, and you enter the answer in cell G4, it will NOT be
marked.
12. Ensure that the regional settings are set to South Africa and that date and time
settings, number settings and currency settings are correctly set.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 3 DBE/November 2018
NSC
13. In all questions involving word processing, you should set the language to
English (South Africa). The paper size is assumed to be A4 Portrait, unless
otherwise instructed. Use centimetre as the unit of measurement.
14. Use formulae and/or functions for ALL spreadsheet calculations. Use absolute
cell references only where necessary to ensure that formulae are correct when
you copy them to other cells in a spreadsheet.
NOTE: All formulae and/or functions should be inserted in such a manner
that the correct results will still be obtained even if the existing data
changes.
15. You may NOT use a word processing program such as Word to answer the
HTML question.
16. The examination folder/CD/DVD/flash drive that you receive with this question
paper contains the files listed below. Ensure that you have ALL the files before
you begin with this examination.
• 1Impression Word processing file
• 2Pic Image
• 2Vote Word processing file
• 3Flowers Image
• 3Paintings Spreadsheet
• 4Famous Spreadsheet
• 5ArtWorld Database
• 5Girl Image
• 6Michelangelo Image
• 6PabloPicasso Image
• 6Quirks HTML file
• 6Salvadore Image
• 7ArtForm Spreadsheet
• 7Guests Database
• 7Lecture Word processing file
• 7Summary Spreadsheet
• 7Timeline Spreadsheet
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 4 DBE/November 2018
NSC
SCENARIO
Impressionism is an art movement that focuses on the use of vibrant colours.
Impressionists often painted outdoors to catch a certain colour and light.
You must assist to finalise some documents on Impressionism.
QUESTION 1: WORD PROCESSING
Open the 1Impression word processing document, which contains information on
Impressionism, and insert your examination number in the header or footer.
1.1 Change the font of the heading 'Welcome to Impressionism' to Wide Latin. (1)
1.2 Find the paragraph below the heading 'What is Impressionism' and do the
following:
1.2.1 Justify the paragraph. (1)
1.2.2 Set the paragraph spacing so that no space appears after the
paragraph. (2)
1.3 Insert a bookmark on the text 'history' found in the paragraph below the
subheading 'Impressionist Art Roots'.
Name the bookmark 'Monet'. (2)
1.4 Find the text that starts with 'Impression …' and ends with '… scene.' and
format the text as shown below.
Impression – I was certain of it. I was just telling myself that, since I
was impressed, there had to be some impression in it ... and what
freedom, what ease of workmanship! Wallpaper in its embryonic
state is more finished than that scene. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 5 DBE/November 2018
NSC
1.5 Format the SmartArt as shown below.
• Add another art form, 'Futurism'.
• Add 'Analytical' as a sub-art form for 'Cubism'.
• Arrange the different art forms to display in the order shown below.
• Apply any colourful variation to the shapes.
Suprematism
Futurism
Cubism
•Analytical
Post-Impressionism
Impressionism
(4)
1.6 Replace all occurrences of the text 'colours' with a red-coloured symbol,
(Wingdings character code 122). (4)
1.7 Change the 'Artistic' style as follows:
• Change the font to small caps.
• Set the width of the border to 3 pt.
• Update all the occurrences of the style. (3)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 6 DBE/November 2018
NSC
1.8 Two images appear below the subheading 'Themes of Impressionism'. Change
the images so that they appear as shown below.
• Resize the second image to the same size as the first image.
• Place the two images side by side, as shown below.
• Add a caption 'A Meadow in Springtime' to the second image and ensure
that the caption position matches that of the first image.
Figure 1: Le Pont de L'Europe Figure 2: A Meadow in Springtime
(6)
1.9 Find the text that starts with 'The Painting of Modern Life' and ends with '… the
blue sky.' and do the following:
• Change the orientation of the selected text to Landscape. The rest of the
document must remain in Portrait.
• Place the text in two columns.
• Use a word processing feature to ensure that the heading 'En Plein Air –
The Passing Moment' will always appear at the beginning of the second
column. (4)
1.10 Find the text that starts with 'Composition and Content' and ends with '… up to
Cubism.' and add page numbers in the footer of ONLY the pages of the
selected text in the format a, b, c, etc. (5)
1.11 Insert an automatic table of figures below the text 'Table of Figures'. (1)
1.12 Update the index below the text 'Index' on the last page of the document. (1)
Save and close the 1Impression document. [36]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 7 DBE/November 2018
NSC
QUESTION 2: WORD PROCESSING
Open the 2Vote word processing document, where people can vote for their favourite
painting, and insert your examination number in the header or footer.
2.1 Change the text direction of the callout shape next to the heading 'VOTE FOR
YOUR FAVOURITE PAINTING', as shown below.
ONE
VOTE
(1)
2.2 Insert a footnote on the text 'works' containing the text 'Impression.org'.
Use the default footnote number format. (2)
2.3 Change the bullets in the bulleted list under the heading 'Voting Rules:' to the
2Pic image found in your examination folder. (1)
2.4 Find the text 'Vote by completing the details below:' and do the following:
• Set the format of the text form field next to the text 'Name', so that it will
always appear in uppercase.
• Replace the text 'Current date here' with an appropriate form field to always
display the current date in the format yy/MM/dd.
• Add the option 'Critic' to the drop-down form field next to the text 'Voting as'. (5)
2.5 Find the text 'Voting as' and the drop-down form field next to this text.
Match the appearance of this text with the previous two lines by changing the
tab setting of the text and the drop-down form field. (3)
2.6 Find the two tables at the bottom of the page and do the following:
• Merge the two tables into ONE table.
• Apply a shading of your choice to the heading row (first row) of the table. (2)
Save and close the 2Vote document. [14]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 8 DBE/November 2018
NSC
QUESTION 3: SPREADSHEET
NOTE:
• Use formulae and/or functions for ALL calculations in the spreadsheet.
• Use absolute cell references ONLY where necessary to ensure that formulae are
correct when you copy them to other cells in the same column (copy down).
• Insert formulae and/or functions in such a manner that the correct results will still be
obtained even if the existing data changes.
• Should you need to use building blocks, use the allocated space in the
spreadsheet.
Open the 3Paintings spreadsheet, which contains a list of paintings from the
Impressionist Movement.
Work in the Impress worksheet.
3.1 Format the merged cells A1:J1 as follows:
• Change the border colour to red.
• Set the fill colour to black. (2)
3.2 Insert a function in cell G3 to determine the earliest year (column C) in which
a painting was painted. (2)
3.3 Insert a function in cell G4 to determine the number of paintings for which the
place where the painting was painted (column G) is not given. (2)
3.4 The function in cell G5 displays the average width of all the paintings in the
worksheet.
Add another function to cell G5 so that the given formula displays a value
formatted to the nearest highest decimal value, e.g. 271.32 becomes 271.40.
NOTE: TWO decimal places should still be displayed. (2)
3.5 Insert a SUMIFS function in cell G6 to determine the total insurance value
(column J) of all the paintings painted before 1900 AND where the city in
which they are exhibited is Chicago. (5)
3.6 Cells B9:B120 contains the full names of the artists of the paintings.
Use a spreadsheet feature to automatically apply a two-coloured gradient fill to
unique values in these cells. (4)
3.7 Column C contains the year in which the paintings were created.
Insert a formula in cell D9 to determine the age of a painting by using the
current year.
The formula must work for any year. (3)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 9 DBE/November 2018
NSC
Work in the Dupl worksheet.
3.8 Use any spreadsheet feature to remove all duplicate artists from the list. (1)
Work in the Chart_Grafiek worksheet.
3.9 Follow the instructions below to change the chart/graph to appear as the
example below.
• Change the chart/graph to include ONLY the data of all locations with
names starting with the letters 'L' to 'P'.
• Change the vertical axis display units to billions.
• Display 'Location' as the horizontal axis title.
• Add any 'moving average' trend line to the chart/graph.
• Change the legend text 'Series 1' to read as 'Value'.
• Fill the plot area background with the 3Flowers image found in your
examination folder.
Insurance Value per Current Location of Paintings
3.5
Billions 3
2.5
Insurance Value
2
1.5
1
0.5
0 Value
Musee d'Orsay
National Gallery of Art
Metropolitan Museum of Art Philadelphia Museum of Art
Princeton University Art Museum
Museum of Fine Arts
Minneapolis Institute of Art Musee Marmottan Monet National Museum of Serbia
Private Collection
Musee des Beauz-Arts
Louvre Museum Musee Maltraux
Museum of Modern Art
New Art Gallery
2 per. Mov. Avg. (Value)
Location
(7)
Save and close the 3Paintings spreadsheet. [28]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 10 DBE/November 2018
NSC
QUESTION 4: SPREADSHEET
NOTE:
• Use formulae and/or functions for ALL calculations in the spreadsheet.
• Use absolute cell references ONLY where necessary to ensure that formulae are
correct when you copy them to other cells in the same column (copy down).
• Insert formulae and/or functions in such a manner that the correct results will still be
obtained even if the existing data changes.
• Should you need to use building blocks, use the allocated space in the spreadsheet.
Open the 4Famous spreadsheet, which contains the details of famous Impressionist
artists.
Work in the Art_Kuns worksheet.
4.1 Centre the row headings in row 7 vertically. (1)
4.2 The number of artworks created by each artist is stored in column K.
Insert a function in cell H3 to determine the total number of artworks that were
painted. (2)
4.3 The nationality of an artist is stored in column H.
Insert a formula in cell H4 to determine what percentage of artists is NOT of
French nationality (column H). Refer to the formula below.
Number of non-French artists/Total number of artists x 100 (6)
4.4 The art forms practised by each artist are stored as an art form code in
column I. The first letter of the art form code refers to the preferred art form of
the artist.
Insert a VLOOKUP function in cell J8 to display the preferred art form of an
artist using the first letter of the art form code in column I and the lookup table
in the Code_Kode worksheet. (5)
4.5 Column L shows the number of 'for' votes an artist receives for his/her artwork.
Insert a function in cell N8 to determine whether the artist has one of the three
highest 'Votes For' counts (column L).
Display the message 'Top3' if the artist is in the top three, or otherwise leave the
cell empty.
Ensure that the function can be copied down to the other cells in the range. (8)
Save and close the 4Famous spreadsheet. [22]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 11 DBE/November 2018
NSC
QUESTION 5: DATABASE
Open the 5ArtWorld database, which contains details of artists and paintings.
5.1 Open the tblPaintings table in Design View.
5.1.1 Change the format of the Painting field so that the text displays in
capital letters. (1)
5.1.2 Change the field properties of the YearPainted field so that:
• The field accepts a year from 1494 to 1970
• Appropriate validation text is inserted (4)
5.1.3 Create an input mask on the ID field to ensure that the user inserts a
painting ID in the following format:
• The letters 'IMP'
• Followed by any compulsory character or space
• Followed by a compulsory number in the range 0 to 9
• Followed by TWO optional numbers
Examples of a valid ID: IMP@4, IMP$34, IMP 78 or IMP#135 (4)
5.1.4 Insert a new field called Area as the last field and do the following:
• Change the data type of the Area field so that it will store the
calculation of the area of the painting.
• Insert the calculation for the Area field:
[Height] * [Width] (4)
Change the tblPaintings table to Datasheet View.
5.1.5 Ensure that the Age field displays in Datasheet View. (1)
Save and close the tblPaintings table.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 12 DBE/November 2018
NSC
5.2 Open the frm5_2 form, which is based on the tblArtists table, in Design View.
• Add the 5Girl image found in your examination folder to the form header.
Ensure that the image stretches to the size of the image box.
• Shade the background of the Detail section with a light green colour.
• Add the option 'Poor' to the list of items in the Rating field combo box.
Save and close the frm5_2 form. (6)
5.3 Open the qry5_3 query in Design View.
Modify the query so that it displays the total number of paintings created by male
artists, per birth country (BirthCountry field), as shown below.
BirthCountry Gender SumOfNumberOfPaintings
France Male 7230
Germany Male 476
Great Britain Male 407
Italy Male 235
Lithuania Male 474
Netherlands Male 2100
Puerto Rico Male 356
Romania Male 843
Russia Male 1166
Spain Male 243
United States Male 4989
Save and close the qry5_3 query. (3)
5.4 Open the qry5_4 query in Design View.
Change the criteria so that the query displays the records of paintings where
the ID field is six or more characters long and the Place field has no data.
Save and close the qry5_4 query. (4)
5.5 Open the qry5_5 query in Design View.
• Add a calculated field called Diff to determine the difference between the
For field and the Against field.
• Display only artists whose nationality is NOT French or American.
Save and close the qry5_5 query. (7)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 13 DBE/November 2018
NSC
5.6 Create a report called rpt5_6, which is based on the tblArtists table, to
appear as shown in the extract of the report below.
• Group the report according to the year the artist was born AND the country
of birth.
• Ensure that the Born field is grouped per year.
• Insert a function to determine the total number of artists per country per
year.
rpt5_6
Born by Year BirthCountry ArtistName ArtistSurname
1452
Italy
Leonardo da Vinci
1
1824
France
Eugene Boudin
Pierre-Purvis de Chavannes
2
Save and close the rpt5_6 report. (6)
Save and close the 5ArtWorld database. [40]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 14 DBE/November 2018
NSC
QUESTION 6: WEB DESIGN (HTML)
You are required to complete a web page about the quirks of artists.
Open the incomplete 6Quirks web page in a web browser and also in a text/HTML
editor. You may NOT use a word processing program such as Word to answer the
HTML question.
NOTE:
• Question numbers appear as comments in the coding to guide you where to insert
the answer(s). DO NOT delete these comments.
• An HTML tag sheet is attached for your reference.
Your final web page should look like the example below.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 15 DBE/November 2018
NSC
NOTE: Use the example on the previous page to guide you in answering the questions
below.
ONE mark will be allocated for closing tags, triangular brackets and nesting correctly
used. (1)
6.1 Change the font of the level 1 heading to 'Vivaldi'. (1)
6.2 Set the width of the horizontal line to 60% and set the alignment to right. (2)
6.3 Display the text 'Believe it or Not!!!' as a level 2 heading AND in italics. (2)
6.4 Create a link on the text 'ECCENTRICITY' to link to a target location that has
already been created towards the end of the web page. (3)
6.5 Add tags to display the items 'Stealing pens', 'Carrying around guns' and
'Making time capsules' in a list with the number format A., B., C. (3)
6.6 Modify the table as follows:
• Set the cell spacing to 6.
• The first cell should span over three rows and contain the text 'Weird
Quirks'.
• The image 6Michelangelo found in your examination folder, should display
correctly.
• The text 'Stole pens', 'Never bathed' and 'Carried a gun' must appear in the
third row of the table. (6)
6.7 Modify the code of the text 'SHOCKING BUT TRUE' to display in bold.
Ensure that the text will appear below the table instead of above the table. (2)
Save and close the 6Quirks web page. [20]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 16 DBE/November 2018
NSC
QUESTION 7: GENERAL
Art institutions contribute to the art world on a regular basis by hosting lectures and
art shows.
7.1 Open the 7Lecture word processing document.
7.1.1 Follow the instruction in the comment in the document AND then
remove the comment. (2)
7.1.2 Reject all the track changes in the document. (1)
7.1.3 Invitations to the lecture must go out to guests.
Complete a mail merge as follows:
• Use the 7Guests database as a data source for the 7Lecture mail
merge document.
• Edit the data source recipient list to include ONLY the data of
those members who have 'Painting' as an art form and who have
painted more than 60 paintings.
• Replace the text '<<Name>>' with the merge field Name.
• Replace the text '<<Surname>>' with the merge field Surname.
Save the document, but do NOT close it. (5)
7.1.4 Complete the merge and save the merged document as
7LectureMerge. (1)
Save and close the 7Lecture document and the 7LectureMerge document.
7.2 Open the 7ArtForm spreadsheet.
Use a spreadsheet feature to split the data stored in column A into different
columns. The comma (',') must be used to split the data into columns.
HINT: Use the spreadsheet feature 'Text to Columns' on the Data tab in the
Data Tools group. (2)
Save and close the 7ArtForm spreadsheet.
7.3 Open the 7Summary spreadsheet.
Use the SUBTOTAL feature to determine the greatest number of artworks
painted by an artist according to the birth country. (3)
Save and close the 7Summary spreadsheet.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 17 DBE/November 2018
NSC
7.4 Open the 7Timeline spreadsheet.
The art gallery manager wants to know which paintings were created by the
same artist in consecutive years (where one year follows the previous year).
Use the following steps to assist the art gallery manager:
Step 1: Sort the data alphabetically according to artist AND then from the
earliest to the latest year in which the painting was completed.
Step 2: Insert a formula in column D to perform the following checks:
• Check 1: Start from row 2 and check whether the artist in the current row is
the same artist as in the previous row.
• Check 2: Check whether the artist painted a painting in the previous year
by checking if the difference between the year in the current row and the
year in the previous row is 1.
• If Check 1 and Check 2 are both TRUE, then display 'True', or otherwise
display 'False'.
Example of output:
Painting Artist Year Completed Question 7.4
Skildery Kunstenaar Jaar Voltooi Vraag 7.4
Molesey Weir Alfred Sisley 1874
Street in Moret Alfred Sisley 1877 FALSE
Sand Heaps Alfred Sisley 1878 TRUE
View of the Seine Armand Guillaumin 1871 FALSE
Grain Field Bethe Morisot 1875 FALSE
The Artistist's Daughter Bethe Morisot 1884 FALSE
Two Women Chatting by the Sea Camille Pissarro 1856 FALSE
Self Portrait Chaim Soutine 1918 FALSE
View of Ceret Chaim Soutine 1919 TRUE
View in Montmartre Paris Childe Hassam 1889 FALSE
Late Afternoon Childe Hassam 1900 FALSE
John Singer Sargent Dennis Miller Bunker 1888 FALSE
The Pool, Medfield Dennis Miller Bunker 1889 TRUE
Woman with Chrysanthemums Edgar Degas 1865 FALSE
The Bellelli Family Edgar Degas 1867 FALSE (6)
Save and close the 7Timeline spreadsheet. [20]
TOTAL: 180
Copyright reserved
Downloaded from hlayiso.com
Computer Applications Technology/P1 DBE/November 2018
NSC
HTML TAG SHEET
Basic Tags Formatting Tags continued
Tag Description Tag Description
<body></body> Defines the body of the web page Inserted before each list item,
<li></li> and adds a number or symbol
<body Sets the background colour of the depending on the type of list
bgcolor="pink"> web page selected
<body
Sets the colour of the body text <img src="name"> Adds an image
text="black">
<head></head> Contains information about the
<img src="name" Aligns an image: can be "left",
web page
align="left"> "right", "bottom", "top"
Creates an HTML document – <align="center"> Aligns an image in the "center",
<html></html>
starts and ends a web page <img src="name"> can also be "middle"
<img src="name" Sets the size of the border
<title></title> Defines a title for the web page border="1"> around an image
<br/> Inserts a line break <img src="name"
Sets the height and width of an
<!-- --> Comment width="200"
height ="200"> image
Text Tags
Tag Description Displays alternative text when
<img src="name"
alt="alternative the mouse hovers over the
<h1></h1> Creates the largest heading
text"> image or when the image is not
<h6></h6> Creates the smallest heading found
<hr/> Inserts a horizontal line
<b></b> Creates bold text <hr size="3"/> Sets size (height) of a line
<i></i> <hr width="80%"/> Sets the width of a line, in
Creates italic text
percentage or absolute value
<font <hr color=
size="3"></font> Sets size of font, from "1" to "7" "ff0000"/> Sets the colour of the line
<font color= Table Tags
"green"> </font> Sets font colour
Tag Description
<font face="Times <table></table> Creates a table
New Roman"></font> Sets font type
<tr></tr> Creates a row in a table
Links Tags <td></td> Creates a cell in a table
Tag Description Creates a table header (a cell
<th></th>
<a href="URL"></a> Creates a hyperlink with bold, centred text)
<a href="URL"><img <table
src="name"></a> Creates an image link width="50"> Sets the width of the table
Creates a target location in the <table Sets the width of the border
<a name="NAME"></a>
document border="1"> around the table cells
<table Sets the space between the
<a href= Links to a target location created cellspacing="1"> table cells
"#NAME"></a> somewhere else in the document
<table Sets the space between a cell
Formatting Tags cellpadding="1"> border and its contents
Tag Description Sets the alignment for cell(s)
<tr align="left"> ("left", can also be "center" or
<p></p> Creates a new paragraph "right")
Aligns a paragraph to the "left" Sets the vertical alignment for
<p align="left"> (default), can also be "right" or <tr valign="top"> cell(s) ("top", can also be
"center" "middle" or "bottom")
<br/> Inserts a line break Sets the number of columns a
<td colspan="2">
<ol></ol> Creates a numbered list cell should span
<ol type="A","a", Defines the type of numbering Sets the number of rows a cell
<td rowspan="4">
"I","i","1"></ol> used should span
<ul></ul> Creates a bulleted list
<ul type="disc",
"square","circle"> Defines the type of bullets used
</ul>
Copyright reserved
Downloaded from hlayiso.com
Computer Applications Technology/P1 DBE/November 2018
NSC
INPUT MASK CHARACTER SHEET
CHARACTER DESCRIPTION
0 Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed)
9 Digit or space (entry not required, plus [+] and minus [–] signs not allowed)
Digit or space (entry not required; spaces are displayed as blanks while in Edit
# mode, but blanks are removed when data is saved; plus [+] and minus [–] signs
allowed)
L Letter (A to Z, entry required)
? Letter (A to Z, entry optional)
A Letter or digit (entry required)
a Letter or digit (entry optional)
& Any character or a space (entry required)
C Any character or a space (entry optional)
Decimal placeholder and thousand, date and time separators (The actual
.,:;-/ character used depends on the settings in the Regional Settings Properties
dialog box in the Windows Control Panel.)
< Causes all characters to be converted to lowercase
> Causes all characters to be converted to uppercase
Causes the input mask to display from right to left, rather than from left to right.
! Characters typed into the mask always fill it from left to right. You can include
the exclamation point anywhere in the input mask.
Causes the character that follows to be displayed as the literal character (e.g.
\
\A is displayed as just A).
Copyright reserved
Downloaded from hlayiso.com
Computer Applications Technology/P1 DBE/November 2018
NSC
Examination sticker 180
COMPUTER APPLICATIONS TECHNOLOGY P1 – NOVEMBER 2018
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 (Specify)
FOR QUESTION 6
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
File name Marker SM CM IM/EM
number () () Mark
1 1Impression 36
2 2Vote 14
3 3Paintings 28
4 4Famous 22
5 5ArtWorld 40
6 6Quirks 20
7Lecture
7LectureMerge
7 7ArtForm 20
7Summary
7Timeline
TOTAL 180
Comment (for office/marker use only)
__________________________________________________________________________________
__________________________________________________________________________________
Copyright reserved
Study this subject
Recommended for this subject

Question paper
Computer Applications Technology Grade 12 P1 2018 QP (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2018 Memo (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2018 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2023 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P1 2020 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2020 QP (Eng)
More from Grade 12 Computer Applications Technology

Memorandum
Computer Applications Technology Grade 12 P1 2025 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P2 2025 Memo (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2025 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P1 2024 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P2 2024 Memo (Eng)

Errata