education.gov.za NSC Examination Computer Application Technology Question Paper : Department of Basic

Organisation : Department of Basic Education
Exam : National Senior Certificate Examinations
Document Type : NSC Sample Question Paper
Subject : Computer Application Technology
Category : Grade 12
Year : 2017
Website : https://www.education.gov.za/2017FebMarchNSCExamPapers.aspx
Download Sample Question Paper :
Memo 1 :  https://www.southafricain.com/uploads/10869-MemoP1.pdf
Paper 1 : https://www.southafricain.com/uploads/10869-Computer.pdf
Memo 2 :  https://www.southafricain.com/uploads/10869-MemoP2.pdf
Paper 2 : https://www.southafricain.com/uploads/10869-ComputerP2.pdf

Education Computer Application Technology Question Paper

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.

Related : Department of Basic Education NSC Examination Civil Technology Question Paper : www.southafricain.com/10864.html

Instructions & Information

1. Owing to the nature of this practical examination, it is important to note that, even if you complete the examination early, you will NOT be permitted to leave the examination room until all the administrative functions associated with the examination have been finalised. During the examination normal rules regarding leaving the examination room apply.

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

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

4. A copy of the master files will be available from the invigilator. Should there be any problems with a file, you may request another copy from the invigilator.
5. This question paper consists of SEVEN questions.
6. Answer ALL the questions.

7. Ensure that you save each document using the file name given in the question paper. Save your work at regular intervals as a precaution against possible power failures.
8. Read through each question before answering or solving the problem. Do NOT do more than is required by the question.

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

10. The information sheet that has been provided with the question paper MUST BE COMPLETED AFTER THE THREE-HOUR EXAMINATION SESSION. Hand it to the invigilator at the end of the examination.
11. During the examination, you may use the help functions of the programs which you are using. You may NOT use any other resource material.

Sample Question

QUESTION 1: WORD PROCESSING
A document about South Africa’s water sources was created. Open the 1Areas word processing document and insert your examination number in the header or footer.
1.1 Find the text (‘The availability of … floods and droughts.’) in the Abstract control on the first page and make the following changes:
1.1.1 Set the proofing language of all the text to English (South Africa).
1.1.2 Justify the text.

1.2 Find the image on the first page.
Crop the image to any shape of your choice AND sharpen the image to 50%. (2)
1.3 Find the ‘Subtitle’ text control on the first page and remove this control WITHOUT deleting the text contained in the control. (1)

1.4 Insert an automatically generated table of contents below the heading ‘Contents’ on the second page as follows:
Apply the ‘Classic’ table of contents format.
Use the ‘Water’ style for the first level and the ‘Heading 1’ style for the second level of headings.
Set the tab leader for the page numbers to solid.
NOTE: Accept any warning messages that may appear. (4)

1.5 Insert automatic page numbers in the footer of the document as follows :
Page numbering should start on the ‘Contents’ page as page 1.
The page numbering should appear in the format ‘Page 1’.
The page numbers on odd-numbered pages should be left-aligned.
The page numbers on even-numbered pages should be right-aligned. (5)

QUESTION 2: WORD PROCESSING
A survey form has been created for distribution. Open the 2Water word processing document and insert your examination number in the header or footer.
2.1 Add a date field next to the word ‘DATE’.
Ensure that it will always display the curren t date. (2)
2.2 Fill the second text box with the 2Drops image found in the examination folder AND bold the text in the text box.(2)
2.3 Correct the spelling of ‘Female’ in the drop-down form field control next to the text ‘Gender’. (1)
2.4 Add a check box form field control to the left of the text ‘Older than 60’. (1)
2.5 Find the text form field control next to the text ‘Number of adults in the household’. Change the properties so that the user can only enter numerical values. (1)

QUESTION 3: SPREADSHEET
Rainfall was measured every month in four cities from 2005 to 2015. The data was captured in a spreadsheet.
3.1 Format the cells in row 1 as follows:
3.1.1 Change the merged cell to only include cells A1:O1. (1)
3.1.2 Apply a ‘Thin Diagonal Stripe’ pattern style fill effect to the merged cell. (2)

3.2 Freeze the panes so that all the headings in row 2 and the city and year columns display when you scroll down.
3.3 Insert a function in cell D3 to convert the text that appears in cell C3 to a number.
3.4 Insert a function in cell G48 to determine the most commonly occurring rainfall value in April. (2)

QUESTION 4: SPREADSHEET
The school hosted a water games event to raise funds.
NOTE:
** Use formulae and/or functions for ALL calculations in the spreadsheet.
** Use absolute cell references ONLY where it is required by the question to ensure that formulae are correct when you copy it to other cells in the spreadsheet.
** All formulae and/or functions should be inserted in such a manner that the correct results will still be obtained, even if the existing data changes.

Open the 4Game_Speel spreadsheet and work in the Scores_Punte worksheet.
4.1 Remove the hyperlink set on the heading ‘Water Games’.
4.2 Insert a formula in cell E3 to determine the number of weeks that have passed between the date in column D and the current date. (1) (3)
4.3 Data validation has been applied to column G. Remove the value ‘Black’ as an option in the validation list for the whole column. (2)

QUESTION 5: DATABASE
A database that contains a list of dams and their locations was created.
Open the 5Dam database.
5.1 Open the Dam table.
5.1.1 Insert a primary key on the most appropriate field.
5.1.2 Ensure that any data currently stored in the Town field will appear in capital letters. (1)
5.1.3 Add a combo box to the Province field. The values for the Province field are stored in the Province table. Accept any warning or error messages that may appear. (2)