Computer Application Technology P1 LibreOffice_DATA

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

Past Paper 2015 Grade 12 English

↓ Download PDF 📄 603.1 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 180 marks ⏱️ 3h 📄 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.1This document has a cover page. Make the following changes to the cover page:

1.1.1Add any page border of your choice. (1\

1.1Ensure that the watermark that currently appears on all the pages in the document appears only on the cover page.

1.2Insert n automatic table of contents below the heading 'Table of Contents' as follows: Use the Title style

1.3Apply automatic page numbering to the document as follows: Display the page numbers in the page header Start the page numbering from

1.4Locate the image on the page after the table of contents that shows th e three parts of sustainability

1.5Locate the text 're ources' in the paragraph under the image on the third page of the document Create a hyperlink this text that links to the heading 'Where does

1.6Locate the text below the heading 'The difference between sustainable and sustainable resource use'. Create a table using the tab delimited text

1.7Locate the text 'Insert Citation' below the heading 'Energy'. Insert a citation applying the APA style this te xt using the following

1.8Locate the automatic caption 'Table 1' below the picture under the heading 'Energy' and do the following: Change this caption to a figure that displays

1.9Locate the bullet ed list under the heading 'What can we do? Change the format of the bullet to the picture 1Bullet_Kolpunt found in the

1.10Create a new style named 'Energy' . Set the font size to 16 pt and the font colour to red. Locate the text 'Decommissioning' aft er the heading 'Nuclear power' and a pply the 'Energy' style to the heading

1.11The word sustainable has been spelt incorrectly as 'sustainnable' in some places Replace all occurrences of the word 'sustainnable' with the correct spelling highlight the corrected text

1.12

1.13Locate the Table of Figures/Illustration Index on the last page of this document. Update the Table of Figures/Illustration Index to appear as indicated below. TABLE OF FIGURES/ILLUSTRATION INDEX Figure 1: Electricity

Q2— Section header —

2.1Change the document orientation of the first page only to andscape The orientation of the second page

2.2Change the top margin of the page border pt from the edge of the page. (2\

2.3Centre the heading 'Climate change and nergy use'. (1\

2.4Place the paragraphs that start with Electricity at school and end with '... used in schools

0.6Ensure that the three headings will always appear at the top of a column. (3\ Edit the text box

2.6Use the two pictures on the first page to create the picture below. NOTE The pictures must be grouped (2\

2.7Set the hyphenation of the whole document to automatic (1\

2.8Locate the heading Electricity Usage Survey Form' on the second page of the document and make the following changes:

2.9Insert a symbol the last line of the document to appear as follows: Use Electricity paringly Microsoft Office: Wingdings, character code 75 LibreOffice: Wingdings, character code U+F04B (1\

2.10Use the image 2Back _Agter as a watermark and set the scaling to 120%. (3\ Save and close the 2School_Skool document. [22]22

Q3— Section header —

3.1A value attempting to display the current date, appears in cell B3 Replace this value with a function that will automatically display the current date.

3.2The report will expire in two years and three months from the current date Add a calculation in cell B4 to automatically determine the expiry date of the

3.3Use suitable text functions to c reate a code in cell B7 The code is created by combining the following First

3.4Enter a function in cell C19 to display the most frequently occurring percentage for all the years from 1990 to 2014. (1\

3.5Use a spreadsheet feature to force the user to enter a whole number that cannot be greater than 100 in column Add a suitable error message that the user will receive

3.6Change the page setup as follows: Set the range A1: as the print area. Ensure that gridlines will be printed the worksheet is printed.

3.7Copy the range A14:I16 on the Main _Hoof worksheet to the Transp worksheet starting at

Q4— Section header —

Q5— Section header —

5.1Edit the Cur_Kur table as follows:

5.1.1Change the Type Tipe field by adding a combo bo so that the user can choose

5.1.2Format the table as follows: Remove all the gridlines. Change the background colour of the table grey. (2\ Save and close the

5.2Export the Course_Kursus table and save it as a file named 5Exp_ Uit , which

5.3Create a query called qry5_ based on the Cur_Kur table as follows: Display o nly the Title_Titel Cost_Koste

5.4Open the qry5_ query Display only the courses that contain the word 'sustainable' anywhere in the title AND that

5.5Create a query called qry5_5 based on the Cur_Kur table The query must display only the information

5.6Create a form called frm5_ based on Cur_Kur table Insert only the fields CourseID_KursusID Title_Titel

5.7A report called rpt5_ has been created. Base the report on the qry5_7 query. Group the records in the report according to the Avail_Beskik

Q6— Section header —

6.1Add HTML code so that the text 'Energy Tips' appear in the browser tab. (2\

6.2Change the background colour of the web page to white. (1\

6.3Format the text 'Energy Saving Tips' so that it as a level heading and is horizontally centred. (2\

6.4Change the size of the horizontal line to 10. (1\

6.5The web page includes a table containing two rows and two columns. Extend the table by adding a new row above the current first row. Place the text 'Tip 1' in the first cell of

6.6Insert the 6Save_Spaar image below the table. Set t he height and width of the image to 200.

6.7Edit the unordered list that appears on the web page as follows: Change the list to an ordered list. Change the font size of all the items in the list (2\

6.8Add the text 'Link to Google' between the paragraph tags at the bottom of the web page and ink to the website www.google.com Save and close the

Q7— Section header —

7.1Extract the file from the 7Video compressed file your examination folder (1\

7.2Open the 7Act_Akt word processing document.

7.2.1Locate the text 'Temperatures' and add a cross reference to the bookmark called Graph. (3\

7.2.2An equation showing electricity consumption appears at the end of the first page. A part of the equation has been omitted. 2204 tonnes Emissions

7.2.3Locate the organogram on page 2. Add a shape for 'Human Resources' in the diagram as shown below (2\ Resources Natural Resources

7.3Open the 7Temp spreadsheet. A chart/graph was created in the spreadsheet 7Temp . Edit the chart/graph as follows: Sort the

7.4Continue working on the 7Act_Akt document. Use a function to calculate the average temperature in the last row of the table. (2\

7.5Change the text form field next to the text 'Completed by' as follows: Set the text form field property to accept no more than 30 characters. Add default text that reads 'Add your name here'.

7.6Change the author property of the document to your examination number nsert the author field to display in capital letters next to the text 'Created by:'

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total180 marks

Sections28 + 22 + 18 + 31 + 40 + 20 + 21 = 180 marks

Key Information

Websitewww.google.com

Paper information

SubjectComputer Application Technology

Year2015

SessionFeb-March

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages20

Downloads14

Examination context

Decade2010s

Years ago11y

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 size603.1 KB

Pages20

Archived on11 October 2026

File age12d

ContributorFreeMode

Fingerprint07E3CAC7055E

Questions and learner discussion

No questions or discussions have been posted yet.