Computer Application Technology P1 MSOffice_DATA

November 2016 — Grade 12 / Matric — Computer Application Technology

Past Paper 2016 Grade 12 English

↓ Download PDF 📄 646 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 576 marks ⏱️ 3h 📄 21 pages 📝 67 items found 📚 6 topics 🔑 1 key info

See full analysis

Questions — A Preview of What to Expect in the Document

This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.

Q1— Section header —

1.1Format the first page as follows

1.1.1Format the text 'Precious Metals' as follows: Change the font type to Verdana Remove the line that appears through the text (2\

1.1.2The text in the first image below the text Precious Metals is difficult to read Format this image so that the

1.1.3Change the size of the second image (the coin exactly cm x 5 cm.

1.1.4Change the vertical alignment of the page to (1\

1.2Change the name of the 'Coin' style to 'Metal'. Find the table of contents on the second page and do the following: Display FOUR

1.4Find the word nuggets below the subheading Best known recious etals

1.5Format the table below the subheading 'Best known recious etals' by carrying out the instructions below. An example of what the table should look like is shown after the instructions Merge the cells in row 2 and centre the

1.6Find the heading 'Demand for Precious etals' which contains an index entry on the text recious etals'

1.7Correct the spelling error found in the document (1\

1.8Replace any occurrence of the lower case text 'platinum' with the symbol (Wingdings, character code 82\ followed by a space and the letters 'Pt' xample (4\

1.9Find Annexure A on the second last page of the d Automatic numbering has been a pplied to all the subheadings under 'Annexure

Q2— Section header —

2.1Format the document as follows: Add a page border of your choice to the document. Include a watermark in the document as follows: Use the 2PalMetal image

2.2Find the text History of Palladium in the bulleted list under the title Palladium and do the following: ink the text History of Palladium to the bookmark

2.3Format the text box next to the bulleted list as follows: Change the text box to any callout shape. Change the text direction in the shape as shown below. Ensure that all the text is visible.

2.4Find the image below the heading Introduction and add a caption as follows: Use the same caption label format as those used in the other captions in the document.

2.5Find the heading Quiz on the second last page and do the following: Ensure that the word Quiz

2.6Find the text Table of Figures at the end of the document and do the following: Insert n automatically generated table of figures to display a list of the

Q3— Section header —

3.1Rename the Sheet1 worksheet Platinum (1\

3.2Format row 1 as follows: Merge cells A1:E1 but DO NOT centre the text

3.3Remove the comment from the spreadsheet. (1\

3.4Enter a function in cell B6 to determine the t otal supply of platinum for 2014 (1\

3.5he following equation is used t o calculate the percentage increase /decr ease between the platinum supply two different years year

3.6Cells B8:D11 show the gross demand for latinum from different industries from 2014 to 2016. Use a spreadsheet feature to automatically apply border to the

3.8ne star (*\ is awarded for every 550 grams of the weight cells B4:B10 \ of the jewellery. EXAMPLE: The weight cell B7

Q4— Section header —

4.1Apply text wrapping to the headings in row 3

4.2Each piece of jewellery has a jewellery ID , which is obtained as follows: hree letters of the precious metal in column C starting from the second

4.3Each item listed has four possible quality le vels as shown in the table below.

4.4Column should ONLY display n asterisk ('*'\ if the metal in column C is silver and there is a value for the tone

4.5Insert a function in cell to determine the total value of all the rings and earrings in the collection. (4\

4.6Insert a function in cell to determine the number pieces of gold jewellery in the collection. (3\

4.7Insert a function in cell to determine the number of pieces of jewellery that have any type of stone

Q5— Section header —

5.1Jewellery

5.1.1Metal (1\

5.1.2Change the format of the Stones field to display Yes and (1\

5.1Grams forced enter data this field The user can only enter values greater than 10 or less than or equal

5.1The Jewel eryTy currently allows the user to choose from the following options: Ring Ear ings Bracelet

5.1Create an input mask on the JewelleryId field to ensure that the user inserts a jewellery ID in the following format: THREE compulsory letters followed by

5.1.6Set the default value of the ValuationDate to 60 days from the current date. HINT: Use the current date in a calculation to determine what the

5.2Open the frm5_2 form based on the Investor table and do the following: Add your examination number in the form header.

5.3Open the Investor tab Modify the query so that it displays the total number of coins owned by erican United States investors as shown below. InvestorCountry

5.4Open the and do the following Display the records of those investors who invested in coins during the period 1975 to 1989 Add a calculated field called CheckMatch that will check whether the InvestorCountry

5.5Open the rpt5_5 report Replace the Inves tment Date grouping with the Invest

Q6— Section header —

6.1Format the text 'Rhodium Investment: The Rarest of Precious Metals' so that it appears centred and is formatted in a heading style in a red font colour. (3\ Add a horizontal line

6.3The tag used to insert an image as a background is < background="name of file">. Insert the image 6Rh as a background for the (entire\ BODY

6.4Add the following items in a list with square bullets AND leave line break between th e two list items as shown below. iesel catalytic converters diesel catalytic converters

6.56RMine image has been inserted below the bulleted list Edit the image as follows: Set the height to 100 and the width to 200. Set the border to 5.

6.6Display the text 'South Africa' in bold and italics.

6.7attempt was made create link the text www.ResourceInvestor.com' to

6.8tab consisting of three hree Modify the table as follows Set the cell spacing of the table to 10. Place the text 'Rhodium Prices in the first row

Q7— Section header —

7.1Ope Data Work in the Inves worksheet.

7.1.1Set the print area to cells G1 N50 (1\

7.1.2se data validation to v alidate the data in cells 101 to accept only whole numbers greater than or equal to 0. (2\

7.2Open the 7DataImp database and import the data in the Inves worksheet of the

7.3An attempt was made to link the 7Gem_Edel word processing mail merge document with the 7DOB

7.3Change the paragraph spacing of the text in the paragraph with the paragraph border towards the end of the page to 3 pt after.

7.3Apply the same tab setting to the Birthstone_Geboortesteen>> field that was used on the <<Month_Maand>> field. 18

7.3The 7Gem _Edel mail merge document is linked to the data source 7DOB spreadsheet. Ensure that

7.3Complete the merge and save the document as 7Gem Merge (1\ Close the 7Gem_Edel 7GemMerge

7.4Open the 7Answ_Antw word processing document and insert your examination number in the document in the space provided This question requires you to SHOW

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total576 marks

Sections25 + 20 = 45 marks

Key Information

Websitewww.ResourceInvestor.com

Paper information

SubjectComputer Application Technology

Year2016

SessionNovember

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages21

Downloads12

Examination context

Decade2010s

Years ago10y

SeasonSpring (SH)

Start daySaturday

Exam periodNovember 2016

Days since exam3,639

About Computer Application Technology examination preparation

This Grade 12 examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.

How to use this resource for revision

A past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?

For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.

understanding question requirements

applying subject knowledge

working under time constraints

checking answers

identifying revision priorities

A practical revision approach

Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.

Grade 12 subject hubs

Each matric subject has its own dedicated hub on Freemode with every past paper and marking memorandum we have archived for that subject.

➗ Mathematics View papers → 📊 Mathematical Literacy View papers → ⚗️ Physical Sciences View papers → 🧬 Life Sciences View papers → 📒 Accounting View papers → 💼 Business Studies View papers → 📈 Economics View papers → 🌍 Geography View papers → 🏛️ History View papers → 📖 English View papers → 🇿🇦 Afrikaans View papers → 🗣️ IsiNdebele View papers → 🗣️ IsiXhosa View papers → 🗣️ IsiZulu View papers → 🗣️ Sepedi View papers → 🗣️ Sesotho View papers → 🗣️ Setswana View papers → 🌾 Agricultural Sciences View papers →

Corresponding marking memorandum

Marking memorandum available

Use the corresponding memorandum after completing the paper to review your answers and identify areas that require further revision. The memorandum shows the marking approach used by DBE examiners, including method-mark allocations.

Computer Application Technology Memo 1 (English) →

File details

File size646 KB

Pages21

Archived on11 October 2026

File age12d

ContributorFreeMode

FingerprintD36376E29A20

Questions and learner discussion

No questions or discussions have been posted yet.