Computer Aplication Technology P1 LibreOffice_DATA

Feb-March 2014 — Grade 12 / Matric — Computer Aplication Technology

Past Paper 2014 Grade 12 English

↓ Download PDF 📄 344.9 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 200 marks ⏱️ 3h 📄 18 pages 📝 64 items found 📚 1 topics

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.1Change the paper setting to A4 Portrait (2\

1.2

1.3Locate the text 'Name of Contestant' and 'Name of School' and apply a solid leader tab at 15 cm so that lines are created to fill in the details, as shown in the example below Name of Contestant ____________________________________

1.5Convert the text 'Height: Dress size : Waist: Hips:' to a table with four column as shown below. Height Dress size Waist:

1.6

1.7Locate the two paragraphs below the heading 'DECLARATION' and: Align the text to both the left and right margins. Apply an orange paragraph shading to these two paragraphs. (2\

1.816

2.1Make the following changes to the header:

2.1.1Insert your examination number against the left margin of the header and highlight it in a yellow colour

2.1.2Insert and align the text 'Rules' to the right of the header. (1\

2.1Add horizontal line below the text in the header of the document. (1\ Refer to the screenshot below to answer QUESTIONS and 2.

2.7Insert page numbering in the page footer as follows: Page numbers must start on the third page of the document and appear in the format 'Page 1'. age numbers on the numbered

2.8

2.8.1Apply green heart shaped customised bullets to this list. (3\

2.8.2Set the distance of the text from the bullet to 1.5 cm and set the ition of the bullet at 0.5 cm. (2\

2.9Apply an Emboss font effect to the text 'Wh o may enter?' found on the third page of the document. (1\ Locate the

2.1

2.1Locate the text 'CD' on the fourth page of the document. Insert a bookmark called 'CD' on this text (1\

2.1Locate the first instance of the text 'Fantastic Evening Creation' just below the text 'CD' Insert a hyperlink from this te xt to the bookmark 'Fantastic'. (2\

2.14Locate the first table towards the end of the document, containing information about the prizes Remove all the borders of this table. (1\

2.1Locate the second table , on the last page of the document, containing information about the contestants

2.1Merge the cells in the first row of the t able so that t form one cell. (1\

2.1Move the text 'Order of appearance of contestants' which is located just above the table into the first row o f the table. Centre this text

2.1Change the outside single line border of the whole tabl e to a 3 pt dotted line border. (3\

2.1

Q3— Section header —

3.1Change the height of row so that all the text in the merged cells A1:G1 is visible (1\

3.2Hide column H (1\

3.3Format cells as follows: Change the vertical alignment of these two cells to istribute Add a patterned fill effect to these two cells.

3.4Enter a function in cell K9 to determine the lowest final score found in column G (2\

Q4— Section header —

4.1Remove heet1 from the spreadsheet. (1\ Work in the 4Winners_Wenners worksheet.

4.2Add a formula in cell E4 to calculate the score out of 100 that Thembisa Barnard obtained in the Introduction category. Use the raw score in cell D4 and the maximum possible score in cell D2

4.3Contestants are scored on each of the four categories as follows: Column Introduction Bekendstelling Column Dance

4.3.1Column contains the final score of the contestants out of 100 The Interview category column H \ is the most important part of the

4.3.2Column displays the best category for each contestant. Use a nested IF function in cell and the value in cell J to display the

4.6column C , the letter 'S' is used to indicate a s chool. Use a spreadsheet feature to change all occur ences of the letter 'S' in

4.1In cell B3 display the total amount pai d by contestants from istrict 4. The districts appear in column F

4.1The chart /graph in the 4Fees_Gelde worksheet shows the outstanding registration fees owed by each district. Modify the chart/graph

Q4— Section header —

Q5— Section header —

5.1Create a table called with one field called Save and close 51Tbl (2\

5.2Work in the 52Planning_Beplanning table.

5.2.1Move the primary key the most suitable field.

5.2.2Modify a property of the Leader_Leier field so that the user has to enter value in that field for any new records they add.

5.2.3Change the data type of the Task_Taak field to allow a user to enter a description longer than 255 characters. (1\

5.2.4Add a new field called Date_Datum with an appropriate data type that will contain the date by which the task should be completed. (2\

5.2.5Change the data type /format of the Cost_Koste field to display the 'R' symbol for each amount. (1\

5.2.6Modify the validation rule already set on the Cost_Koste field to match the validation text so that an amount larger than 0 and smaller than 500 must be entered. LibreOffice Work in the table called 52Filter_Filter

5.3Remove the record of Bonisile Xhasa as she is no longer able to participate in the competition. (1\ Open the 5Final_Finaal

5.4nsert the values found in cells G4:G41 in the 5Final_Finaal spreadsheet into the Score_Punt field in the

5.5Create a query based on the 53Contestants_Deelnemers table to display the district, name and surname of learners who did not hand in all their documents on time (see the InTime_Betyds field\. Arrange the list in alphabetical

6.1Use the data in the 6Scores_Punte spreadsheet to create a table in the space provided, in the 6Interview_Onderhoud document. Display only the name, surname and final score columns (in that specific

6.2Add a link to the 6Scores_Punte spreadsheet in the 6Interview_Onderhoud document. (Do NOT use a hyperlink.\ Display the link as an icon in the space provided

Q7— Section header —

7.1Delete the sub folder called Today_Vandag found in the Oud folder (1\

7.2Create a shortcut in the Old_Oud folder to the file called 7Beauty_Skoonheid (found in your examination folder\. ave the

7.4Display continuous line numbers in the 7Doc_Dok document. (1\

7.5The header of the 7Doc_Dok document space for the answers of QUESTIONS

7.5.1and 7.5.2

7.5.1How many paragraphs are found on the first page of the 7Doc_Dok document, excluding the header (1\

7.5.2Insert the file path and file name of the document found in the Old_Oud folder which could be read on a computer that does not have a word processor (2\ Save and close the 7Doc_Dok

Topics Identified

Leadership

Mark Allocation

Total200 marks

Sections16 + 46 + 19 + 46 + 47 + 18 + 8 = 200 marks

Paper information

SubjectComputer Aplication Technology

Year2014

SessionFeb-March

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages18

Downloads61

Examination context

Decade2010s

Years ago12y

Season—

Start day—

Exam period—

Days since exam—

About Computer Aplication 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 Aplication Technology Memo 1 (English) →

File details

File size344.9 KB

Pages18

Archived on11 October 2026

File age12d

ContributorFreeMode

Fingerprint7FFF870F0072

Questions and learner discussion

No questions or discussions have been posted yet.