Confidential
NATIONAL
SENIOR CERTIFICATE
GRADE 12
COMPUTER APPLICATIONS TECHNOLOGY P1
NOVEMBER 2024
MARKS: 150
TIME: 3 hours
This question paper consists of 16 pages, an HTML tag sheet,
an input mask character sheet, two pages for planning and
a separate information sheet.
Copyright reserved Please turn over
Skip to contentAll 2024 papers 





View all





Computer Applications Technology Grade 12 P1 2024 QP (Eng)
Grade 12 Computer Applications Technology Paper 1 question paper from the November 2024 NSC (English), 21 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · November 2024 NSC · 2024. Question paper, 21 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2024
- Exam period
- November 2024 NSC
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 21
- File size
- 1.0 MB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 21
This exam
November NSC 2024
Questions in this paper
Document textSearch extracted text and jump to a page.
Computer Applications Technology/P1 2 DBE/November 2024
NSC Confidential
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 tasks associated with the
examination have been finalised. During the examination, the standard
examination rules regarding leaving the examination room apply.
2. If you are working on the network, or the data files have been preloaded on
your system, you must follow the instructions provided by the invigilator/
educator.
3. At the end of the examination, you must make sure that ALL your answer files
are saved on the network/computer as explained to you by the invigilator/
educator.
4. Make absolutely sure that all files can be read. Do NOT save unnecessary
files/folders and do NOT hand in duplicate answer files/folders. Do NOT
delete any original files that you did not work on.
5. The information sheet that has been provided with the question paper MUST
BE COMPLETED AFTER THE THREE-HOUR EXAMINATION SESSION.
Hand it to the invigilator at the end of the examination.
6. A copy of the master files will be available from the invigilator. Should there
be any problems with a file, you may request another copy from the
invigilator.
7. This question paper consists of SEVEN questions. Answer ALL the questions.
8. Read through each question before answering or solving the problem. Do NOT
do more than is required by the question.
9. Ensure that you save each document using the file name given in the question
paper. Save your work regularly as a precaution against possible power
failures.
10. You may NOT use any resource material.
11. Accuracy will be taken into account.
12. Ensure that the regional settings are set to South Africa and date and time
settings, number settings and currency settings are correctly set.
13. In all questions involving word processing, you should set the language to
English (South Africa). The paper size is assumed to be A4 Portrait, unless
instructed otherwise. Use centimetres as the unit of measurement.
14. Ensure that the Developer tab and Ruler are activated.
Copyright reserved Please turn over
Computer Applications Technology/P1 3 DBE/November 2024
NSC Confidential
15. Ensure that the decimal symbol is set as a full stop ('.') and the list separator is
set as a comma (','). Nov
16. Formulae and/or functions must be used for ALL calculations in questions
involving spreadsheets. Use absolute cell references only where necessary to
ensure that formulae are correct when you copy them to other cells in a
spreadsheet.
NOTE: All formulae and/or functions should be inserted in such a manner that
the correct results will still be obtained even if changes are made to
the existing data.
17. You may NOT use a word processing program such as Word to answer the
HTML question.
18. Borders around images or screenshots in this question paper are intended for
clarity. Do NOT insert borders unless you are instructed to do so.
19. Use the correct settings or features in an application as required by a question.
20. The data files that you need to complete this question paper have been
provided to you on the disk/CD/DVD/flash disk or on the disk space allocated
to you. The files are provided in the form of a password-protected executable
file.
Do the following:
Double-click on the password-protected executable file:
CAT P1 Nov 2024 DATA.exe
Click on the 'Extract' button.
Click the 'Show Password' check box.
Enter the following password: N#24@
Once extracted, verify the contents of the folder by opening one or more
files.
Delete the .exe file.
Once the contents of the files have been verified, rename the folder
CAT P1 Nov 2024 DATA with your examination number.
The list of files on the next page will be available in the folder.
Copyright reserved Please turn over
Computer Applications Technology/P1 4 DBE/November 2024
NSC Confidential
1Back Image
1Solar Word processing file
2Moon Word processing file
3Sales Spreadsheet
4Shows Spreadsheet
5Events Spreadsheet
5Inventory Database
5Logo Image
6_1Button Image
6_1Galaxy Image
6_1Gift Image
6_1Star HTML
6_2Mars HTML
6_2Planet Image
7Chart Word processing file
7Envelope Word processing file
7Inventory Spreadsheet
7Members Spreadsheet
7Stock Spreadsheet
Copyright reserved Please turn over
Computer Applications Technology/P1 5 DBE/November 2024
NSC Confidential
SCENARIO
There are many stars and planets in the solar system, including asteroids, comets and
meteoroids. Outer space is the area directly outside of the Earth's atmosphere. Many
humans have travelled into space and to the moon.
QUESTION 1: WORD PROCESSING
Open the 1Solar word processing document that contains information about our solar
system.
Insert your examination number in the header of the document.
1.1 Edit the author properties to display your examination number. (1)
1.2 Modify the shadow effect for the style 'Solar' to any blue colour and change the
distance to 50 pt from the text. (3)
1.3 Ensure the heading '4. The solar system …', paragraph and image always
remain together. (1)
1.4 Insert a cross-reference on the text 'Question/Vraag 1.4' that goes to the
'Venus' bookmark. (2)
1.5 Find the word 'NASA' and insert an endnote on the word as follows:
Apply the 'a, b, c, …' number format.
Add the endnote text 'America'. (3)
1.6 Edit the image below the heading 'Planets:' to appear as shown below.
NOTES:
The thickness of the image border is 3 pt.
Ignore the colour.
(4)
1.7 Convert the text below the heading 'Differences between the …' to a table and
apply any List Tables style. (2)
Copyright reserved Please turn over
Computer Applications Technology/P1 6 DBE/November 2024
NSC Confidential
1.8 Format and change the current list style, 'Planets', of the list that starts with
'1. Mercury: …' and ends with '… 14 known moons.' to display as shown in the
example below.
(3)
1.9 Add page numbering in the footer as follows:
Insert automatic page numbers in the format Page X of Y.
Align odd page numbers to the left and even page numbers to the right. (4)
1.10 Insert the 1Back image as a watermark on the last page only. (2)
Save and close the 1Solar document. [25]
Copyright reserved Please turn over
Computer Applications Technology/P1 7 DBE/November 2024
NSC Confidential
QUESTION 2: WORD PROCESSING
Open the 2Moon word processing document that contains information about the moon.
Insert your examination number in the header of the document.
2.1 Insert the Slice (Dark) cover page and remove the additional content control,
besides the title. (2)
2.2 Change the line spacing of the paragraphs that start with 'Introduction' and end
with '… Moon since then.' to be exactly 20 pt with a hanging indentation of 1 cm. (3)
2.3 Find and replace all the occurrences of the exact word 'planet' with a small caps
effect formatting and raise the position of the text by 3 pt. (3)
2.4 Insert an automatic bibliography below the text 'Question/Vraag 2.4' in the APA
style. (2)
2.5 Find the text below the heading 'Moon Phases for 2024' and format the text to
appear as shown below.
(4)
2.6 Change the page orientation of the last page only to landscape. (2)
2.7 Replace the text watermark with the symbol (Webdings character code 224)
of a 800 pt size. (3)
2.8 Add the file path in the footer of the document. (1)
Save and close the 2Moon document. [20]
Copyright reserved Please turn over
Computer Applications Technology/P1 8 DBE/November 2024
NSC Confidential
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 it to other cells in a spreadsheet.
Insert formulae and/or functions in such a manner that the correct results will still be
obtained even if values are changed in the existing data.
Should you need to use building blocks, use the space allocated for this in the
spreadsheet data file.
Open the 3Sales spreadsheet that contains information about the most popular products
sold by the SPACE OUT shop during September 2024.
Work in the Target worksheet.
3.1 Move the Target worksheet to a new workbook. Save the new workbook as
3Target in your examination folder. (2)
Save and close the 3Target spreadsheet.
Work in the Sales worksheet.
3.2 Insert a comment in cell A1 with the text 'Popular'. (1)
3.3 Insert a function in cell D3 to display the price of the cheapest product sold. (1)
3.4 Insert a COUNTIFS function in cell D5 to determine how many products have
a delivery shipment method with a total cost of R1 000 or more. (4)
3.5 Insert a combination of functions in cell A12 to create the receipt number for
the Galaxy (T-shirt) product.
The receipt number is created as follows:
The day of the month on which the product was bought, followed by
The first three letters of the product, followed by
@SO (5)
3.6 Insert a formula in cell F11 to calculate the total VAT (15%) payable on the
price for the product sold. (3)
3.7 Apply a spreadsheet feature to column G to display all cells with a yellow
background fill where the shipment method is the same as the selection made
in cell H3. (5)
Save and close the 3Sales spreadsheet. [21]
Copyright reserved Please turn over
Computer Applications Technology/P1 9 DBE/November 2024
NSC Confidential
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 it to other cells in a spreadsheet.
Insert formulae and/or functions in such a manner that the correct results will still be
obtained even if values are changed in the existing data.
Should you need to use building blocks, use the space allocated for this in the
spreadsheet data file.
Open the 4Shows spreadsheet which contains information about the planetarium shows
that are booked for November 2024 to December 2024 at the SPACE OUT shop.
Work in the Sheet1 worksheet.
4.1 Rename Sheet1 to Shows. (1)
4.2 Insert a function in cell D3 to determine the fourth highest number of people
that will attend a show. (2)
4.3 Insert a function in cell D5 to calculate the total number of people who will
attend the Milky Way shows. (3)
4.4 Insert a function in cell C10 to determine the session for Pieterse, B. Use the
show time and the Session worksheet. (4)
4.5 Insert a formula in cell D12 to determine the number of days from the current
date until the show begins. (2)
4.6 The final cost is calculated by multiplying the cost per person with the number
of people, and then give discount, if applicable.
Discount is given as follows:
If the session is a morning session and the organisation is a school, 5%
discount is given.
If the organisation is a business, 3% discount is given.
No discount is given in all other cases.
Insert a nested IF in cell J10 to calculate the final cost. (7)
Save and close the 4Shows spreadsheet. [19]
Copyright reserved Please turn over
Computer Applications Technology/P1 10 DBE/November 2024
NSC Confidential
QUESTION 5: DATABASE
The database contains details about the SPACE OUT shop's employees, customers and
stock.
Open the 5Inventory database.
5.1 Open the tbl5_1 table in Design View and edit it as follows:
5.1.1 Edit the field properties of the Name field so that the name will appear
in capital letters. (1)
5.1.2 Change the IDNo field as follows:
Ensure that an employee can only be captured once.
Edit the field size to accept a South African ID number without
spaces. (2)
5.1.3 Insert a validation rule for the StartDate field to make sure that valid
dates are entered as follows:
The company started on 1 June 2021.
Employees cannot be appointed after the current date.
Add appropriate validation text. (4)
5.1.4 Modify the lookup properties for the Designation field for the values to
appear as shown in the example below when viewed in Datasheet
View.
(2)
Save and close the tbl5_1 table.
5.1.5 Import the 5Events spreadsheet as a new table tblEvents into the
database. Make sure that there is no primary key in the table. (3)
Copyright reserved Please turn over
Computer Applications Technology/P1 11 DBE/November 2024
NSC Confidential
5.2 Modify the form frm5_2 based on the tblMembers table to display as shown
in the example below.
NOTE:
The size of the image 5Logo is 5 cm x 3 cm.
An input mask was added to the CellNo field so that data is captured in the
correct format.
Save and close the frm5_2 form. (6)
5.3 Open the query called qry5_3 based on the tblStock table in Design View.
Insert a calculated field Profit to calculate the amount of profit that will be made
on each product.
Save and close the qry5_3 query. (3)
5.4 Open the qry5_4 query based on the tblStock table in Design View.
Create a list to display the T-shirt products that have less than five items in
stock or any other product with 15 of more items in stock.
Save and close the qry5_4 query. (5)
Copyright reserved Please turn over
Computer Applications Technology/P1 12 DBE/November 2024
NSC Confidential
5.5 Open the qry5_5 query based on the tblStock table in Design View.
Modify the query to display as shown in the example below.
qry5_5
Category SumOfInventoryValue
Puzzle R15 020.00
Coffee Mug R16 400.00
Building Blocks R16 791.00
Bedding R17 964.00
Astronomy R29 234.00
Clothing R29 935.00
Toys R59 000.00
Decorative R76 774.00
Save and close the qry5_5 query. (5)
5.6 Open the rpt5_6 report based on the tblStock table in Design View and make
the following changes:
Replace the report header with the text 'Stock'.
Add a function in the Category footer to display the number of products per
category.
Add a suitable label to the function.
Save and close the rpt5_6 report. (4)
Save and close the 5Inventory database. [35]
Copyright reserved Please turn over
Computer Applications Technology/P1 13 DBE/November 2024
NSC Confidential
QUESTION 6: WEB DESIGN (HTML)
NOTE:
You may NOT use a word processing program such as Word to answer the
HTML questions.
An HTML tag sheet has been attached for reference.
All files needed to complete this question can be found in the examination folder.
A web page was created to promote the initiative of naming a star.
6.1 Open the incomplete 6_1Star file in a web browser and also in a text/HTML
editor (NOT a word processing program such as Word).
Your final web page should look like the example below.
Copyright reserved Please turn over
Computer Applications Technology/P1 14 DBE/November 2024
NSC Confidential
NOTE:
Use the example on the previous page as a guideline when answering this
question.
Question numbers appear as comments in the coding to indicate where you
should insert the answer(s). DO NOT delete these comments.
6.1.1 Insert your examination number as a comment in the web page. (1)
6.1.2 Insert the image 6_1Gift so that it appears as in the example on the
previous page. (2)
6.1.3 Format the table as follows:
Set the space between the text and the cells to 15 pt.
Edit the columns and the list to appear as in the example on the
previous page. (6)
6.1.4 Insert tags on the image 6_1Button that links it to the URL at the
bottom of the web page. (2)
Save and close the 6_1Star file.
Copyright reserved Please turn over
Computer Applications Technology/P1 15 DBE/November 2024
NSC Confidential
6.2 Open the incomplete 6_2Mars file in a web browser and also in a text/HTML
editor (NOT a word processing program such as Word).
Modify the existing HTML code so that your final web page displays like the
example below.
NOTE: Do NOT change the background colour.
Save and close the 6_2Mars file. (3)
ONE mark will be allocated for closing tags and correct nesting in both the web
pages. (1)
[15]
Copyright reserved Please turn over
Computer Applications Technology/P1 16 DBE/November 2024
NSC Confidential
QUESTION 7: GENERAL
Open the 7Envelope document.
7.1 Prepare envelopes using mail merge as follows:
Only new members from the SPACE OUT shop will receive a letter.
Use the 7Members spreadsheet as the data source for the 7Envelope
document.
Replace the text <<ADDRESS>> with the Address field.
Save the 7Envelope document in your examination folder, but do NOT
close it.
Complete the merge and save the document as 7Merged. (5)
Close the 7Envelope document.
Open the 7Chart document.
7.2 Modify the chart in the 7Chart document to appear as follows:
(4)
7.3 Insert a linked icon to the 7Stock spreadsheet, below the text
'Question/Vraag 7.3', that automatically updates. (2)
Save and close the 7Chart document.
Open the 7Inventory spreadsheet.
7.4 Work in the Total worksheet.
Apply a spreadsheet feature to display the total inventory value for each
category. Make sure that each category displays on a new page. (4)
Save and close the 7Inventory spreadsheet. [15]
TOTAL: 150
Copyright reserved
Computer Applications Technology/P1 DBE/November 2024
NSC Confidential
HTML TAG SHEET
Basic Tags Formatting Tags continued
Tag Description Tag Description
Defines the body of the web Inserted before each list item,
<body></body>
page and adds a number or symbol
<li></li>
<body Sets the background colour of depending on the type of list
bgcolor="pink"> the web page selected
<body text="black"> Sets the colour of the body text <img src="name"/> Adds an image
Contains information about the <img src="name" Aligns an image: can be
<head></head>
web page align="left"/> "right", "bottom", "top"
Creates an HTML document – <p align="center"><img Aligns an image in the
<html></html>
starts and ends a web page src="name"/></p> "center", 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
width="200" height
<!-- --> Comment image
="200"/>
Text Tags Displays alternative text when
Tag Description <img src="name" the mouse hovers over the
alt="alternative text"/> image or when the image is
<h1></h1> Creates the largest heading 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
<i></i> Creates italic text
Sets the width of a line, in
<u></u> Creates underlined text <hr width=”80%”/>
percentage or absolute value
<font size="3"></font> Sets size of font, from "1" to "7"
<font color= "green">
Sets font colour <hr color= "ff0000"/> Sets the colour of the line
</font>
<font face="Times New Table Tags
Sets font type
Roman"></font> Tag Description
Links Tags <table></table> Creates a table
Tag Description <tr></tr> Creates a row in a table
<a href="URL"></a> Creates a hyperlink <td></td> Creates a cell in a table
<a href="URL"><img
Creates an image link
src="name"></a> Creates a table header (a cell
<th></th>
Creates a target location in the with bold, centred text)
<a name="NAME"></a>
document
Links to a target location
<a href="#NAME"></a> created somewhere else in the <table width="50"> Sets the width of the table
document
<a href= Sets the width of the border
Links to an e-mail address <table border="1">
"mailto:#NAME"></a> around the table cells
Formatting Tags Sets the space between the
<table cellspacing="1">
Tag Description table cells
Sets the space between a cell
<p></p> Creates a new paragraph <table cellpadding="1">
border and its contents
Aligns a paragraph to the "left"
Sets the alignment for cell(s)
<p align="left"> (default), can also be "right" or
<tr align="left"> ("left", can also be "center" or
"center"
"right")
Horizontally centres text, a
<center></center>
section, table or an image
Sets the vertical alignment for
<ol type="A","a", Defines the type of numbering
<tr valign="top"> cell(s) ("top", can also be
"I","i","1"></ol> used
"middle" or "bottom")
<ol></ol> Creates a numbered list
<ol type="A","a", Defines the type of numbering Sets the number of columns a
<td colspan="2">
"I","i","1"></ol> used cell should span
<ul></ul> Creates a bulleted list
Sets the number of rows a cell
<ul type="disc", <td rowspan="4">
Defines the type of bullets used should span
"square","circle"> </ul>
Copyright reserved
Computer Applications Technology/P1 DBE/November 2024
NSC Confidential
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 mark 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
Computer Applications Technology/P1 DBE/November 2024
NSC Confidential
YOU MAY USE THIS PAGE FOR ANY PLANNING PURPOSES.
Copyright reserved
Computer Applications Technology/P1 DBE/November 2024
NSC Confidential
YOU MAY USE THIS PAGE FOR ANY PLANNING PURPOSES.
Copyright reserved
Computer Applications Technology/P1 DBE/November 2024
NSC Confidential
Examination sticker
150
COMPUTER APPLICATIONS TECHNOLOGY P1 – NOVEMBER 2024
INFORMATION SHEET (to be completed by the candidate AFTER the 3-hour session)
CENTRE NUMBER ________________________________________________________
EXAMINATION NUMBER ____________________________________________________
WORK STATION NUMBER __________________________________________________
SUITE USED
Microsoft Microsoft Microsoft
(Mark appropriate Office 365
Office 2016 Office 2019 Office 2021
box with a cross (X))
WEB BROWSER USED Other
Mozilla Google Internet Microsoft (Specify)
(Mark appropriate
Firefox Chrome Explorer Edge
box with a cross (X))
FOLDER NAME ___________________________________________________________
Candidate must enter the file name(s) used for each answer. Tick if saved and/or attempted.
Marker
Question Saved Attempted Maximum Mark
File name Initial/
Number () () Mark Achieved
Code
1 1Solar 25
2 2Moon 20
3Sales
3 21
3Target
4 4Shows 19
5 5Inventory 35
6_1Star
6 15
6_2Mars
7Envelope
7Chart
7 15
7Inventory
7Merged
TOTAL 150
Comment: (for office/marker use only)
________________________________________________________________________
________________________________________________________________________
Copyright reserved
Study this subject
Recommended for this subject

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

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

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

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

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

Question paper
Computer Applications Technology Grade 12 P1 2020 QP (Afr)
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 P2 2024 Memo (Eng)

Errata
Computer Applications Technology Grade 12 P1 2022 Errata

Memorandum