Computer Application Technology P1 Optional speed (English)

November 2009 — Grade 12 / Matric — Computer Application Technology

Past Paper 2009 Grade 12 English

↓ Download PDF 📄 287.4 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 200 marks ⏱️ 3h 📄 19 pages 📝 87 items found 📚 7 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.1Create a folder called Tips in the Konnexions folder. (1)1

1.2Create a shortcut to the Shop file (in the Konnexions folder) and place the shortcut in the folder).

1.3Set the author property of the Clients file (in the Konnexions folder) to be (1)1

1.4Konnexions numbered 1.4 in the 1Poster file. (1)1

1.5Konnexions name of the file in the space numbered 1.5 in the 1Poster file. (1)1

1.6Key in the name of a file/folder numbered 1.6 in the 1Poster file. (1)1

1.7Rename the file called Rename (in the Konnexions folder) as Store (1)1

1.8The file (in the Konnexions folder) has been protected with the password k5 . Open the file to get the name

1.9Move all files containing the word Presentations folder. (2)2

1.10folder. (1)1

1.11Sort the files in the Konnexions 'Date modified' field appear ing as the first column on the left. Paste a screenshot/screen dump showin g the contents of the folder, in the space numbered 1.11 in the

Q2— Section header —

2.1advertise Konnexions idea of what she wants, but is battling to create i t. She has given you an Open the file 2Ad

2.1.1Change the inner an given screenshot. (2)2

2.1.2Merge all the cells in the first column. (1)1

2.1.3Place a watermarked picture in The picture is stored as 2Pens (3) Computer Applications Technology/P1

2.1.4Place the text 'Make your drea icker than 0.75pt/0.01".

2.1.5Position the name 'Konnexions' in the first cell of the second column so that it appears at the bottom of the cell. (2)2

2.1.6In the same cell as the one in the logo of the company to the left of the name 'Konnexions'. NOTE: or a thick black arrow must be used.

2.1.7rows/cells and distribute and arr ange the text, as shown in the

2.2You have drafted a bilingual Englis h/Afrikaans booklet which you will document called 2Leaflet. Open the file 2Leaflet

2.2.11

2.2.2Insert the current date in the format DD-MM-YYYY YYYY-MM-DD in the footer, so that it updates automatically. (3)3

2.2.3line of the first paragraph starti (3) Computer Applications Technology/P1 DoE/November 2009 Copyright reserved

Q2— Section header —

2.2.4Use the Styles and Formatting feature of your word-processing application to create a new style called HeadBus . The new style must be: Blue

2.2.5Heading 1 into a business" and ''Van stokperdjie tot besigheid''. (1)1

2.2.6Change the page or ientation of the document to landscape. (1)1

2.2.7Place all the text after the first page in TWO columns. Note the following: in the left-hand column and the Afrikaans text in the right-hand column.

2.2.8Link the title "Turn your hobby into a business" of the leaflet to the subheading "Good Idea" by making the following changes: Idea which can be found on page 2 of the document. ing the title "Turn your hobby into a

2.2.9ct (not a text box) on the first page containing the text as shown below. NOTE:

Q3— Section header —

3.1card to remind them of the road to success. The e-card has been created, but needs finished off before it is distributed. Open the file 3Map

3.1.1Change the paper size to A5. (1)1

3.1.2All the paragraphs in the e- card must be formatted as follows: (2)2

3.1.3Apply an animated text/font journey' in the first line. (1)1

3.1.4with 'Describe your product' and ending resemble the example on the previous page. Ensure that there is a space of exactly 1 cm bet ween the number and the text. (4)4

3.1.5Refer to the example on the pr evious page. Place a border around a 'talking head' symbol as shown in the example. NOTE:

3.2A survey needs to be carried out. Open the file Use tab stops with leaders, and form fiel ds to create a survey form as shown below.

Q4— Section header —

4.1The title of the spreadsheet does not fit in cell A1.

4.1.1Apply text wrapping to cell A1. (1)1

4.1.2(1)1

4.1.3Change the height of row 1 so that the text is visible. (1)1

4.2e the travel cost. The tariff appears in (5)5

4.3Konnexions' clients have a contract for call-outs. A maximum of 2 hours per call-out (Column E) is allo to see which clients have In column E, use conditional formatti the appropriate cells.

4.4Statistics about the work done are to be placed in rows 21 to 36.

4.4.1Use a function in cell E21 to calculate the total number of hours booked. (2)2

4.4.2travelled. (2)2

4.4.3Use a function in cell B24 to determine the second longest job done. (2)2

4.4.4Use a function (not a formula) in cell B27 to calculate the total number of hours worked by Elaine Black. (4)4

4.4.5of jobs done by Khumalo Nkosi. (3)3

4.4.6done by the company. (2)2

4.5Create a pie chart/graph showing t The chart/graph must appear in the Time Sheet worksheet. Show the percentages and include a title and a legend. Pull out the slice for the person who has worked the most hours.

Q5— Section header —

5.1Sheet1 (1) Invoice worksheet.

5.2found in cell C6 in the Time Sheet worksheet. (2)2

5.3Use a double line to underline the headings in row 12. (2)2

5.4in cell C14 to display th e service rendered. The Vlookup table is found in the Service Codes Table worksheet. (4)4

5.5Use a formula in cell E14 to calc ulate the outstanding amount by using the worksheet. (3)3

5.6Use a formula in cell E20 to calculat e the VAT. VAT is charged at 14%. (2)2

5.7In cell E21, use a formula (not a function) to calculate the total amount owed. (1)1

5.8Change the formatting of column E South African currency. (1)1

5.9Use a feature of the program only one page, without changing the page orientation. NOTE: th of the columns.

Q6— Section header —

6.1Konnexions has a database of all their clients. Open the database called 6Konnexions

6.1.1Work on the table Big businesses. formation' that can contain a tion (more than 300 characters) about the businesses. the table so that t

6.1.2Design a query using the table to find out which and save the query as No E-mail. (3)3

6.1.3Design a query using the Big businesses names and telephone numbers of all the restaurants in Club Mykonos. Save the query as (3)3

6.1.4Arts and Crafts document called Arts and Crafts . Save the RTF document in the Konnexions folder. (2)2

6.1.5Design a query to find all using the Big businesses field and save the query as Accommodation

6.1.6Create a report based on the table so that advertising material can be done efficiently.

6.1.7Many new firms are opening in Langebaan. Their details must be added to the database. Big businesses table.

6.1.8Konnexions. You received the in e-mail. 6Activities.txt into a new table in the database. names in the table.

6.2One of the suppliers asked you to Open the file 6Parties

6.2.1Butterflies stock 6Butterfly in the report header section. (2)2

6.2.2Insert a label that will i dentify the total quantity. (3)3

6.2.3Create a query based on the Balloons table. Create a new field called Value of the different products for the Balloons theme and save the query as

Q7— Section header —

7.1The administrative staff of Konnexions wishes to send information about the business to all stakeholders. You will need the following files to answer this question: 2Pens 6Konnexions 7DTP

7.1.1letters on the right-hand side of to place a line above and below the word. MEMORANDUM

7.1.2A spreadsheet named 7DTP offered. Insert a table containing pr Prices worksheet in the 7Memo

Q7— Section header —

7.1.3The Popular

7.27Water file. The file contains a form letter that using the data from the Big Businesses

7.3Konnexions wishes to send out a list of all the party themes available. 7Themes alphabetical list of all the different party themes available, using the data in the Stock table of the

Topics Identified

Word ProcessingSpreadsheetsDatabasesPresentationsProgrammingNetworkingHardware

Mark Allocation

Total200 marks

Sections15 + 50 + 22 + 32 + 17 + 40 + 24 = 200 marks

Per-question sum200 marks

Key Information

Websitewww.orangesolutions.co.za

Paper information

SubjectComputer Application Technology

Year2009

SessionNovember

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages19

Downloads17

Examination context

Decade2000s

Years ago17y

SeasonSpring (SH)

Start dayThursday

Exam periodNovember 2009

Days since exam6,197

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) FAL →

File details

File size287.4 KB

Pages19

Archived on11 October 2026

File age13d

ContributorFreeMode

Fingerprint2FBD81604796

Questions and learner discussion

No questions or discussions have been posted yet.