Computer Aplication Technology P1 LibreOffice_DATA

November 2013 — Grade 12 / Matric — Computer Aplication Technology

Past Paper 2013 Grade 12 English

↓ Download PDF 📄 505.2 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 200 marks ⏱️ 3h 📄 18 pages 📝 67 items found

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 size to A5. (1\

1.2Change the page orientation to landscape. (1\

1.3Insert a pt shadowed page border (3\

1.4Format the wrapping style of the starburst/explosion shape so that the hidden word 'NOW' is still displayed

1.1Change the table as follows: Add a third column the table on the right hand side Locate the text '

1.1size the table to fit across the whole page of the document (1\

1.1Centre the headings in row 1 of the table vertically and horizontally. (1\

1.1Locate the web address in the footer. nsert a hyperlink that links to the website together with a screen tip that reads '

Q2— Section header —

2.1Change the bottom page margin to 2 cm. (1\

2.2Locate the main heading 'Cyberbullying' a t the beginning of the document. Change this text to WordArt/Fontwork with a textured fill (2\ Find all occurrences of the words 'cyber bullying' and ensure that the

0.5/14 pt between the columns. (3\

2.9Apply a drop ped cap effect to the first letter of the word ' Interpretation (found at the top of page 3 so that it appears over four

2.1Locate the paragraph 'It can be ...' to '... pain of cyberbullying'. hange the paragraph spacing of the paragraph

0.3510 pt before and the line spacing to exactly

0.92cm 26 pt. (3\

2.12Locate the heading How do I deal with it?' and add bookmark called Stats to this text. (1\

2.13Locate the heading 'Cyberbullying Statistics' towards the end of the document Insert an endnote attached to this heading using the web addre ss at the end of the document as the reference

2.14

Q3— Section header —

3.1Delete Sheet1 as it is no longer required. (1\ Work in the Policy_Beleid worksheet.

3.2ormat the worksheet as follows:

3.2.1Apply a re coloured fill to the merged cells A1: (1\

3.2.2ells A2: have been merged. Change t his merged cell so that cell is also included in the merged cell

3.2.3Change the font colour of the text the merged cells A2:H2 to white and left align the text (2\

3.2.4Place a double line outside border around cells A1: (3\

3.2.5Change the width of column F to 8 characters /61 pixels (Excel\/

1.6cm (Calc (1\

3.3nsert a formula in cell G4 to determine how long policy has been in existence at Bona Secondary School (2\

3.4As cyberbullying is a newer type of behaviour, it is not included in some policies. Add an IF statement in cell to display an asterisk ( if the policy include

3.5Hide column I and column as t he values displayed have been summarised in the table L1:M2 (1\

3.9Create a doughnut chart/ graph across cells K15:N30 based on the data in cells L1 to resemble the example below.

3.1nsert a function in cell C4 to extract the first two letters of the school name in cell A4 (2\

3.1nsert a function in cell D4 to extract the third and fourth letters of the province in cell B4

3.1The code for Bay Secondary chool is displayed in cell F5 nsert formula in cell G5 to

Q4— Section header —

4.1Change the tab colour of the Learners_Leerders works heet to a colour of your choice, other than the default colour. (1\

4.2Some learners have reported bullying. Apply conditional formatting to column G so that all the cells showing learners that have reported bullying ppear in a light grey fill ave

4.3The learners have been divided into three groups according to their age. Insert a nested IF statement in cell to determine the correct group for the learner whose surname appears in cell A2 NOTE: Learners younger than 15 are in Group A

4.4Codes have been developed for each school and are stored in the Data Data worksheet. Use a VLOOKUP function in cell

4.5Cell M2 shows the number of learners who were bullied while cell M3 shows the number of those learners who reported being bullied. Add a formula in cell M4 to calculate the percentage of learners who

Q5— Section header —

5.1Work in the 51School_Skool table and change the design of the table as follows:

5.1.1Change the properties of the Schoolnum_Skoolnom field of the table to ensure that a value has to be entered in this field for every new record added to the table. (1\

5.1.2Insert a field called Visit_Besoek as follows: Place the field directly after the Province_Provinsie field. Set the data type to appear in a l

5.1.3Set a validation rule on the NumLearners_GetalLeerders field so that the minimum number of learners that can be entered is 250 and the maximum number is 2 Add suitable validation text.

5.1.4Change the field size/field type of the Ratio_Verhouding field to Double ', allowing only ONE decimal place. (2\ Save and close the School_Skool

Q6— Section header —

6.1Apply automatic numbering to ll four items below the question. NOTE: Do NOT include the heading 'Biographical data'. (1\

6.2Add a text form field control next to the Age_Ouderdom field that will only allow digits (numbers\ to be entered with a minimum value of 13. (3\

6.3Change t default option for the Gender_Geslag drop down field control read: 'Select one_Kies

6.4Align a ll the form fields, drop down items and check boxes against a left tab setting of exactly cm. (2\

6.5Change the vertical alignment so that the shape containing the text 'DATA COLLECTION SHEET' will always appear the top of the page. (1\

6.6Add a field to show the current date and time at the end of the document. (2\ Save the document 6Data_Data

6.7Continue working in the 6Data_Data document to prepare a mail merge for return slips. Use the 52Type_Tipe table of the 5Cyber_Kuber database as the data

6.8Open the 6Statistics_Statistiek document and the 6Spreadsheet_Sigblad spreadsheet

6.8.1Split the table so that Bullying Statistics Cyberbullying Statistics appear in two separate tables , one

6.8.2Copy the Bullying Statistics table from the 6Statistics_Statistiek word processing document Paste the table to the 6Spreadsheet_Sigblad

6.8.3hange the font colour of all the data that is not given as a percentage (%\ in the data column in the

6.8.4Use the Bullying Statistics table to create a new table at the end of the 6Statistics_Statistiek document. how only the

Q7— Section header —

7.1Rename the folder called MyFolder _MyLeergids to Exam _Eksame (1\

7.2Add your examination number to the author properties of the TIF image file (1\ Open the document called 7Count_Telling

7.3Type in the name and size on disk of the PDF file in your examination folder in the space provided

7.4.1Highlight the word 'bully' in all forms in the 7Count_Telling document in a colour of your choice. (1\

7.4.2Enter the number of times all word forms of the word 'bully' appear in the document called 7Count_Telling , in the space provided. (1\

Mark Allocation

Total200 marks

Sections21 + 41 + 40 + 22 + 45 + 25 + 6 = 200 marks

Paper information

SubjectComputer Aplication Technology

Year2013

SessionNovember

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages18

Downloads18

Examination context

Decade2010s

Years ago13y

SeasonSpring (SH)

Start dayTuesday

Exam periodNovember 2013

Days since exam4,735

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 size505.2 KB

Pages18

Archived on11 October 2026

File age12d

ContributorFreeMode

FingerprintC5A36400514D

Questions and learner discussion

No questions or discussions have been posted yet.