Computer Aplication Technology P1 MSOffice

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

Past Paper 2011 Grade 12 English

↓ Download PDF 📄 175.2 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 200 marks ⏱️ 3h 📄 4 pages 📝 74 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.1Move all the pictur e files found in the folder into the

1.2Add the password Payment_Betaling folder. (1\

1.3The file found in the Question1_Vraag1 folder is a presentation file. Save this file as a web page in the Question1_Vraag1

1.4Change the author property of the Budget_Begroting file in the 1Answer_Antwoord in the Question1_Vraag1 folder and type your

1.5Find the number of paragraphs in the document found in the folder. Type your answer in the space provided in the 1Answer_Antwoord

1.6Type the name of the compressed file in the Question1_Vraag1 folder in the 1Answer_Antwoord

1.7Type the name of t he file found in the Question1_Vraag1 folder that can only be opened with an Adobe (Acrobat\ the space allocated in file 1Answer_Antwoord

1.8Sort the files in the by size from smallest to largest. Show only the size and folder/file name fields. The size field must appear to the left of the folder/file 1Answer_Antwoord

Q2— Section header —

2.1Change the paper size to A4. (1\

2.2Change the bottom page margin to 2.5 cm or 0.98". (1\

2.3Format the jigsaw puzzle object on 3-D effect The orange piece is mov ed away from the group All the elements are combined to form one object

2.4Rearrange and resize all objects to fill the whole page to resemble the example alongside. table of contents simila r to the example below. page 2.

2.5Generate an automatic The table of contents must appear bel ow the words 'Table of Contents' on The table of contents must be based on the Heading 1 and Heading 2 Change the format to formal.

2.6Insert a footer on page 3 as shown below. The footer must appear under a Use a font style of Arial 10 pt. The text 'Career Choice Gui The page numbering must appear on the right-hand side. Page numbering appears from page 3,

2.7Create a paragraph style call A box border Green shading

2.8Apply the style choices. Seneca' (1\

2.9

2.10Correct the alignment of the firs t paragraph beginning wit

2.11Insert an endnote based on the first main heading 'Career Choices'. The endnote should be referenced with a custom mark copyright symbol and

2.12Insert a bookmark called anchored to t

2.13Create a hyperlink linking the heading ' Career Personality Tests' on page 5 to

2.14Bullet the list of questions found under the heading 'Career Ed ucation' on page The bullets must appear as 'hand' symbols, for example (found in the The tab space after the symbol/bullet pos ition must be set at 1 cm or 0.39"

2.15Apply automatic numbering to t he paragraphs under the heading 'Choosing a 1. Talk to Program Coordinators, But Be Sceptical 2. Talk to Employers in Your Chosen Field 3. Ask the School to Prove Their Brags

2.16Arrange the numbered par

Q2— Section header —

2.17Insert borders around the te Save 2Choice_Keuse and close the document.

Q3— Section header —

3.1Set tab stops as follows: Add a tab stop at 8 cm or 3.5" to align the list of subjects. Add a tab stop at 6 cm or 2.36" t hat will create a dotted line above the

3.2Insert a date field for 'Today's date' in the format yyyy-mm-dd that will update

3.3Add a text field for t he name together with a help me ssage that reads 'Insert name' that will display on t he status bar if the pers on needs help wit for the cellphone number.

3.4Add a table for the cellphone number as follows: Insert a 10 x 1 table Make sure that the contents aut omatically fit into the table. Position the table at 7 cm or 2.

3.5Insert a drop-down list field for th

3.6Format the subject list for 'Possible Ca reer Choice' as shown in the example. Resize the check box for Sciences to exactly 15 pt. Align the subject names to 8 cm or 2.16". and close the document.

Q4— Section header —

4.3angle. upper case for all the surnames. then delete column K.

4.1Insert a unique learner number in ce lls A3:A310. The firs t learner will be

4.2Merge and centre the heading in row 1 across cells A1:J1. (1\ Change the headings in row 2 to appear at a 45 (1\

4.4In column B some surnames appear in upper case while others are in lower case. In column K the UPPER function was applied to change the text to Replace all the surnames in column B with the surnames in upper case AND

4.5Learners may only apply for bursaries if they have a mark of 70 or more in column E. Using an appropriate oper ation/feature change the background of all the cells for those who may appl

4.6Learners can only go to university if they Use an IF-function in cell to insert the word 'Yes' if the learner will be able The universities wish to have information a bout the top learnersas they would like to

4.7Use a function in cell to determine the second highest score. (3\

4.8Use COUNTIF functions in cell to display the number of learners who wish

4.9Change the page scaling of the worksheet so that it will

4.10Sort the table A1:E310 according to the column and then according to the column, placing the l earner with the highest mark first.

4.11The universities require a graph to show the proportions of learners who qualify to attend university and those who do not. Use the data in cells found in the Summary_Opsomming worksheet to create a graph to show

4.12Remove the gridlines from the Summary_Opsomming worksheet (1\ and close the document.

Q5— Section header —

5.7

5.1Wrap the text to display the headings in row 2. (1\

5.2Place borders around all the cells c ontaining headings in row 2. (1\

5.3Change column so that all the values display as South African rand. (1\

5.4The code in column The first 3 letters of the The first 3 letters of the surname (sto

5.5Use a Vlookup-function in cell to display the distan ce from Thohoyandou to Johannesburg according to the table given in the Distance_Afstand Make sure that the function can be copied down to the other cells in

5.6Calculate in cell the time Y MADIKANE would travel to the school from Travel time is the distance divided by a 100 Add the stopping time (column G\ Representatives can claim for the days they are away from home as follows:

5.8Calculate in cell the travel claim for Y MADIKANE who is travelling from and the rate in cell

5.9Guests can claim their travelling (in column J\llowance (in the total claim for O ADAM. Work in the worksheet.

5.10The graph displaying the total clai Change the type of the Show only the first 10 r Insert the title 'Claims' on the y-axis. Remove the data labels and legend. Change the colour of the column r epresenting Y MADIKANE only, to red.

Q6— Section header —

6.2The Career_Beroep for universities: ID Address_Adres Code_Kode Phone_Foon Fax_Faks Accommodation_Verblyf

6.1Create a new table called STUDENT Name_Naam as a lookup wizard with Humanities, Sciences and Informatics as options. as an integer number. Al Close the table STUDENT table contains the following fields of contact information

6.3Change the query qryCodes_Kodes so that only the field, field and field of those institut ions that have a code between 2000 and 3000 (inclusive\ Save and close the query.

6.4Open the query qryCosts_Koste. Add a new field called to calculate the cost of tr avelling to the city centre back by taxi if the taxi charges R5.50 per kilometre. Format this field as Save and close the query.

6.5Amend the query qryWebaddress_Webadres so that the records are sorted according to the field and only the information of those institutions that do have web addresses is displayed. The Webaddress_Webadres

6.6Make the following changes to the form The heading of the form must be changed to Wonderful Careers and Place a yellow line under the heading. Add the Add the current date as a field in the footer. Save and close the amended form.

6.7Make the following changes to the report Career_Beroep. Group the records according to the field and sort Display the number of Save and close the amended

6.8Change the name of the determine the longes

6.9Create a new report called repMyReport. Display the information generated by the query qryCosts_Koste Give the report the heading Travel Costs Set the page orientation to landscape. Use a formula in your report to

Q7— Section header —

7.1Paste the information found in the document.

7.2Modify the tear-off slip as shown below. Change the row height of all the rows of the table to exactly 0.75 cm/0.3". Vertically centre the contents of the cells. Merge the top row of the table. Insert a row at the

7.3Insert the image as a watermark, scaled to 500%. (3\

7.4Insert a 3 pt shadow page border. Save the document. (3\ [22]22

Mark Allocation

Total200 marks

Sections12 + 43 + 17 + 34 + 30 + 42 + 22 = 200 marks

Per-question sum177 marks

Paper information

SubjectComputer Aplication Technology

Year2011

SessionFeb-March

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages20

Downloads12

Examination context

Decade2010s

Years ago15y

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

Pages20

Archived on11 October 2026

File age12d

ContributorFreeMode

Fingerprint452D90ED1F38

Questions and learner discussion

No questions or discussions have been posted yet.