Computer Application Technology Paper 1 (English)

Feb-March 2017 — Grade 12 / Matric — Computer Application Technology

Past Paper 2017 Grade 12 English

↓ Download PDF 📄 400.8 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 180 marks 📄 20 pages 📝 65 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.1

1.1.2Set the proofing language of all the text to English (South Africa\. Just ify the text (1\ (1\

1.2Find the image on the first page. Crop the image to any shape of your choice AND sharpen the image to 50%. (2\

1.3Find the 'Subtitle' text control on the first page and remove this control WITHOUT deleting the text contained in the control. (1\

1.4Insert 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

1.5Insert 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

1.6Find the word 'Our' on the 'INTRODUCTION' page. Apply a dropped cap effect on the whole word. Set the spacing to 0.5 cm from the text. (2\

1.7Find the text 'table 1' in the fourth paragraph on the page after the map. Add a cross reference on this text that links to the 'Water Source Area' table on the next page. (2\

1.8Adjust the 'Water Source Area' table on the next page as follows:

1.8.2Apply any predefined table style to this table. Use a table property to ensure that the headings are repeated if the table flows over to the next page. (1\ (1\

1.8.3Find the text 'Grootwinterhoek' and add a footnote to this text as follows: The footnote text must contain 'Strategic water sources'. Use the '*' as the custom symbol for the footnote. (3\

1.9Find the image below the heading 'WESTERN CAPE WATER SOURCE AREAS'. Add 'Image 1' as an automatic caption to the image. (2\

1.10Find the bulleted list below the 'BOLAND MOUNTAINS' heading. Change the bullet characters to the ' ' symbol (Wingdings, code 165\. (1\

1.11Find the text 'Did you know?' below the heading 'TSITSIKAMMA' Apply any WordArt of your choice to this text. Change the text wrapping to top and bottom. (2\

1.12Find the chart/graph below the heading 'MPUMALANGA DRAKENSBERG' Change the data of the chart/graph as follows: Cultivated Natural NOTE: Do not simply change the labels of the chart/graph.

1.13

1.14Find the table of figures on the second last page. The table of figures only displays the tables. Add an additional automatic table of figures that will also display the images. (2\

1.15Change the orientation of only the last page to portrait. The rest should remain in landscape. (2\ Save and close the 1Areas document. [37]37

2.1Add a date field next to the word 'DATE'. Ensure that it will always display the current date. (2\

2.4Fill the second text box with the 2Drops image found in the examination folder AND bold the text in the text box. Correct the spelling of 'Female' in the drop down form field control next to the text 'Gender'.

2.5Find 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\

2.6Edit the format of the control next to 'How much do you pay a month?' so that it will always display an 'R' in front of the amount(s\ displayed. (1\

2.7Apply leader tabs at the bottom of the form so that it displays as below (4\

2.8You want to send the survey to some people for completion. Prepare a mail merge as follows: Use the Details worksheet of the 2Det_Bes spreadsheet as the data source. Sort the surnames in ascending order.

3.1Format the cells in row 1 as follows:

3.1.2Change the merged cell to only include cells A1:O1 Apply a 'Thin Diagonal Stripe' pattern style fill effect to the merged cell. (1\ (2\

3.4Freeze the panes so that all the headings in row 2 and the city and year columns display when you scroll down Insert a function in cell D3 to convert the text that appears in cell C3

3.5Insert a function in cell H49 to determine the average rainfall for May for all the cities throughout all the years. Display the average rounded to the next highest whole number. EXAMPLE: If the average is 6.4

3.6Insert a function in cell K50 to determine the third highest rainfall in August. (2\

3.7Insert a function in cell M51 to determine the total rainfall that fell in the four cities during October 2015. NOTE: Ensure that the correct results will be obtained even if the existing data changes.

3.8Apply conditional formatting to cells D3:O46 to automatically apply a colour scale to the numbers in the three different categories shown below The lowest point

3.9The rainfall in a city is categorised by comparing the total rainfall of the city for a specific year to an expected rainfall of 650. It is categorised as follows: More than the expected rainfall of 650: High

3.10Sort the data in cells A3:O46 according to the year from 2005 to 2015 and then according to the city alphabetically. (2\ Work in the Durban

3.11The cell range used in the function in cell C6 is incorrect. Correct the cell range of the function by including the data for January from the data table. Ensure that the function in cell C6

3.12Filter the data so that only the rainfall data for Durban is displayed. (1\ ch

3.13A chart/graph displaying the total rainfall per year for Bloemfontein has been created. Change the chart/graph in the worksheet to appear as shown below Ensure that the chart/graph displays the rainfall per month and also the

4.2Remove the hyperlink set on the heading 'Water Games'. 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\

4.3Data validation has been applied column G Remove the value 'Black' as an option in the validation list for the whole column. (2\

4.4A participant ID should be created for each participant. Create the participant ID in cell as follows: The first two letters of the surname in column C Followed by a space Followed by a random number in the range 0 and 99

4.5Use an appropriate LOOKUP function in cell J3 to display the award that Jemima Garrison will receive based on her score in cell H3 Use the data in the Awards_Toekennings worksheet. (4\

5.1Open the Dam table.

5.1.2Insert a primary key on the most appropriate field. Ensure that any data currently stored in the Town field will appear in capital letters. (1\ (1\

5.1.3Add 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

5.1.4Create an input mask for the Completed field to accept dates in the format dd/MMM/yyyy. EXAMPLE: 01/JAN/2001 or 31/DEC/2010 (5\

5.1.5Change the field properties of the Capacity field so that no value smaller than zero will be accepted. (1\

5.1.6Change the data type the Illustration field so that you can add an image to the field. Add the 5AlbertFalls image found in the examination folder in the Illustration

5.2Open the qry5_2 query. Insert the Town field. Add criteria to display the names, provinces and towns of all the dams in Limpopo. Save and close the

5.3Create a query called qry5_3 based on the Dam table to appear as shown below. NOTE: The Avg Of Capacity

5.4Open the qry5_4 query. Display only the names and towns of the dams that have data entered for the surface of the dam and that were completed from 1 January 1990 to December 2000 (inclusive\. Save and close the

5.5Open the qry5_5 query. Create and display a calculated field called Volume to calculate the volume of water currently in each dam. The calculation for the volume of the dam is Surface

0.3Format this field to display ONE decimal place. Save and close the qry5_5 query. (4\

5.6Open the frm5_6 form. Add the 5AlbertFalls image found in the examination folder as a background image to the form. Insert a hyperlink as follows: Place the hyperlink next to the

5.7Open the rpt5_7 report based on the Dam table. Remove the Illustration label AND the field. Group the report by the

6.4Add your examination number to display in the browser tab. Add an additional cell to the first table and insert the 6Life image found in the examination folder inside this cell. Add a horizontal line below the

6.5Find the second table. Set the border size to 1 and the cell padding to 12. (2\ Change the first row of the second table to appear as shown below. The kitchen, bathroom, and laundry are three areas in the home where

6.9Set the bullet style of the unordered list to circle AND ensure that all the bullets appear correctly. Insert the text 'waterwize.co.za' AND create a link from the text

7.1Open the 7Rivers_Riviere spreadsheet.

7.1.1Add the worksheet name as a field in the left section of the header. (3\

7.1.2The names of the rivers have been defined as a named range. Change the named range to 'Name_River'. (1\

7.1.3Protect column A to column so that users cannot enter text. Add 123 as the password. (2\ Do NOT close the 7Rivers_Riviere

7.2Open the 7River_Rivier database and import the data from the 7Rivers_Riviere spreadsheet into a new table into the database. Use the worksheet name as the table name. (2\ Save and close the 7Rivers_Riviere

7.3.3What is the gutter position setting of the document? How many paragraphs appear in the document? How many occurrences of the letter 'm' (upper case and lower case\ appear in the document? (1\ (1\ (1\

7.3.6What is the first word that appears on line 100 in the document? What is the line weight/width of the 'Intense Quote' style? Which word is marked as an item to appear in an index? (1\ (1\ (1\

7.3.7What is the title of the single source citation that appears in the document? (1\ Save and close the 7Antw_Answ document. [15] TOTAL:15

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total180 marks

Sections37 + 17 + 38 + 17 + 37 + 19 + 15 = 180 marks

Key Information

Email Addresswaterwize@water.co.za

Paper information

SubjectComputer Application Technology

Year2017

SessionFeb-March

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages20

Downloads6

Examination context

Decade2010s

Years ago9y

Season—

Start day—

Exam period—

Days since exam—

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 size400.8 KB

Pages20

Archived on7 September 2026

File age47d

ContributorFreeMode

Fingerprint67A00575EF1D

Questions and learner discussion

No questions or discussions have been posted yet.