Computer Aplication Technology P1 Information sheet (English)

November 2011 — Grade 12 / Matric — Computer Aplication Technology

Past Paper 2011 Grade 12 English

↓ Download PDF 📄 232.1 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 200 marks ⏱️ 3h 📄 21 pages 📝 105 items found 📚 1 topics 🔑 1 key info

See full analysis

Questions — A Preview of What to Expect in the Document

105

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 subfolder called General_Algemeen (1\

1.2Create a shor tcut in the folder which links to the file called General_Algemeen

1.3Move ALL the spread sheet files from the folder to the

1.4Save the bitmap image called found in the Question1_Vraag1

1.5Enter the name of the co 1Answer_Antwoord

1.6How many times does the lower-case letter 'e' appear in the file called in the folder? Enter your answer in 1Answer_Antwoord 1Answer_Antwoord Open the file 1Answer_Antwoord in the main folder. Type your examination num

1.7Sort the files in the folder in descending order of their name. Display only the size and name fields in the Paste a screenshot of the fo lder structure of the folder in 1Answer_Antwoord

Q2— Section header —

2.1Apply the style ' ' to the main heading at the top of page 2 of the document. (1\

2.2

2.3Add a dropped-cap effect, that drops over 5 lines, to the first paragraph under Background Your answer should be similar to the screenshot shown below. SETTING UP THE MEDIA EXCHANGE CENTRE AT THE \nd he school you are attending will

2.4Change the paragr aph spacing to 12 pt after to only the paragraph in

Q2— Section header —

2.5Insert right-aligned automatic page num bering in the footer of the document.

2.6Insert an 80 pt horizontal-tex ead 'DRAFT'. (3\

2.7Change the indentation of the second heading ' 2\ ' exactly. (2\ rmat to the highlighted te xt on page 4 of the document.

2.9Apply a two-column fo A 1 cm/0.39 inches space must appear between the columns. A border appears around each of the columns. Ensure that paragraph 'c\ ple Ground Rules:' will always start at the

1.8.1Books

1.8.2Video Materials and

1.8.3Journals Change the outline numbering

8.1Books Materials and

8.3Journals . (3) Save [34] Computer Applications Technology/P1 9 DBE/November 2011 NSC Copyright reserved Please turn over34

2.10Apply the following changes to t he image that appears under the heading '.

2.10.1Flip the image horizontally. (1\

2.10.2Change the colour of the image to greyscale. (1\

2.10.3Move the whole image to the right-hand margin with the text flowing to the left of the image, as shown in the diagram below. wanted to have a variety of books available to discuss. I didn't want to just discuss novels; I

2.11Locate the high lighted text ' Oprah's Book Club ' on the second last page and Use the Wingdings symbol number 38 as a custom mark to indicate the Add the text 'Launched 17 September

2.12A list appears at the end of the document under the heading ' 8\ The outline numbering has be en applied incorrectly as the numbers of the so that it appears as

8.2Video 2MediaW and close the document.

Q3— Section header —

3.1Insert a date field in line with the Be in the format YYYY-MMM-DD, for example 2011-Oct-17 Update automatically Be positioned at 7 cm/2.75 inches (4\

3.2Change the properties of the text fiel d for the 'Borrower Name/Lenernaam' so that the name will automatically appear in Title Ca se when the user enters a name in the field. (1\ mber in line with the heading

3.3Insert a table for the ID Nu Have 13 columns and 1 row (13 x 1\ Have columns of 0.5 cm/0.2 inches wide (4\

3.4Remove the cross from the chec k box for the Afrikaans option. (1\

3.5Use a dotted leader to allow space for a signature below the text 5 inches from the left margin. (2\

3.6Make the following changes to Change the mouth from a sad mout h (downward curve\ Add a shadow effect to the image of the 'face', as shown in the example Add a callout to the 'f ace' image, as shown in the example on the

3.7A table, in draft form, showing the details of some donors, appears on page 2 that follow. Items Total/ WIESEMAN Owen CD 50 3 150 MANTSINA Jannie Book_Boek 80 4 320 ESTERHUIZEN Jan DVD 50 1 50 MSIMEKI Linda CD 40 4 160

3.7.1Merge ALL the cells in the firs t row of the table 'Media donated/ geskenk' of the document. (1\

3.7.2Use a table option to automat ically adjust the width of all the columns to fit the data in the table. (1\

3.7.3Use diagonal lines in the third row of the table to form a cross in the first cell, as shown in the other cells in that row (see diagram above\(1\ example). user can choose are the following ( in the same order

3.7.4A drop-down form-field control has been added in the fourth row in the third column (under the headi ng 'Media'\ shown in the Amend the properties of this control so that the only options that the Book_Boek

3.8An incorrect formula has been added in the shaded cell in the third row of the last column ('Total/Totaal'\l Correct the formula so that the correct value is given. (2\

3.9Use the table on page 2 to create another table on the last page of the document which shows an alphabetical list of those peopl e who donated at The table must show all the colu The headings from the original t

Q4— Section header —

4.1Make the worksheet easier to read by completing the Merge and centre the contents of Apply word wrapping to row headings in row 2. Add cell borders to the headings in row 2. your choice for the cell borders.\

4.2Some of the books in the centre are very old. Use a feature of spreadsheets to format th e contents of the cells in column E ('Year Published/Jaar uit gegee'\

4.3Display all the values in column F as the South African currency with NO

4.4Add a function in cell L6 to calculate the average price of all the media given

4.5

4.6Use a VLOOKUP function in cell C3 to display the name of the Publisher based on the code provided in cell D3 and the data provided in the Ensure that the function will work correctly if it were to be copied down to the

4.7The publisher, Bookworld, has Add IF functions in column G to calculate the new prices of all the media. In the case of media published by Book world, add 10% to the price shown in

4.8The purpose of the chart/g raph shown in the worksheet Resources_Bronne

4.8.1Change the chart/graph ty pe to a column graph. (1\

4.8.2The chart/graph was designed to display the different number of Give the chart/graph a suitable title and display it below the

4.8.3Remove the legend 'Series 1' from the chart/graph. (1\

4.8.4Insert a title on the Y-axis to read 'Units'. (1\

4.8.5Change the graph so that the values on the Y-axis are shown in 4MediaS and close the document.

Q5— Section header —

5.1Apply any fill colour (other than the current merged cell\ (1\

5.2Add a function in cell L3 to dete rmine the second highest number of hours worked, as indicated in column G.

5.3Each learner has to be given a user name in order to use a computer. The user names in column D are formed by combining the learner's surname and initial and converting this to upper case. For example: John Smith becomes SM

5.4Correct the formula in cell F3 which is trying to calculate the age of the learner (in years\s date and the l earner's date of birth in cell E3.

5.5The management of t he media exchange centre has decided to divide the A Learners who worked more than 9 hours B Learners who worked between 5 and 9 hours (inclusive\ C Learners who worked less than 5 hours

5.6Add a function in cell L4 to determi ne the total number of hours worked by the

5.7Use the LEN function to determi ne the length of the longest surname. recorded in the worksheet Work in the worksheet

22.2PODILE Mpho MARX Liena SERUMULA Mohamed PUDIKABEKOA Dzuni The names and times worked by the helper s at the media exch ange centre are Time_Tyd Time_Tyd

5.8A formula was entered in cell D4 to determine the number of hours that Mpho Podile worked during the first shift. T he formula is correct but does not

5.9Enter a formula in cell L5 to calculate the total number of hours worked by The manager of the medi a exchange centre tried to create a chart/graph showing the credits (colum n K\ the first FOUR helpers listed in the

Q6— Section header —

6.1Open the table Donors_Skenkers in Design View. Donors_Skenkers Field Name Data Type Description DonorID_SkenkerID Text ID No./ID nr. Name_Naam Text Name of donor/Naam van skenker Surname_Van Text Surname of donor/Skenker se van

6.1.1Modify the data type of the field to make it more

6.1.2Change the field size of the Surname_Van field to a more suitable

6.1.3Import the data from the file called into the table Make sure that the original field na mes are still used in the table. (3\

6.1.4Design an input mask for the field if the field Save and close the table.

6.2Open the table Field Name Description table.

6.4Create a query called Title_Titel and Author_Skrywer fields from the table. The records must be sorted in descending order of the

6.5Open the query are NOT books (B). (2)2

6.2.1Set a primary key on the most approp riate (suitable\

6.2.2Set a validation rule for the field so that only items that have been published later than (afte r\ered into the Also ensure that nobody can enter a date later than 2011.

6.3Open the form frmITEMS

6.3.1Type your examination (1\

6.3.2Add the graphic/picture in the form header. (2\ Save and close the form. qry6_4 to display only the ItemList_ItemLys Save and close the query. qry6_5 Modify the query to display

6.6Open the query within the title. Format the VAT as currency, as shown in the example below.

6.7Open the report named RepITEMS not the heading) for the Title_Titel field in a different

6.8Create a report called rep6_8 table. Title_Titel Type_Tipe and Year_Jaar fields.

6.7.1Place the data (

6.7.2Insert a field or function for the current date in the text box provided

6.7.3Insert a function in the text box provided in the footer of the report to

6.7.4A function to display the tota l number of items per publisher was created in the report footer. The fo rmula is correct but it displays publisher are displayed. Save and close the report. with the following criteria:

Q7— Section header —

7.1Open the document This document is going to be used as part of a mail merge. The document needs to be modified and corrected before it is sent.

7.1.1Remove the extra highlighted t able (in pink\

7.1.2Delete the word linked to the bookmark

7.1.3Find all instances where the name 'Media Book Club' was used and replace it with the name 'Media Exchange Centre'. The corrected name should display in italics. (3\

7.1.4The hyperlink www.mec.org.za in the document currently links to the Change the properties of the hyperlink so that the website www.mec.org.za

7.2All the donations received were reco rded in a spreadsheet. Information from 7Donations_Skenkings spreadsheet. Keep the

7.2.1Copy data from the spreads heet and paste this data as a linked table into the 7Fax_Faks document in the plac e indicated in the document. (2\

7.2.2Change the amount in the 7Donations_Skenkings spreadsheet, donated by the donor who donated

7.2.3Update the link in the document to reflect the change

Q7— Section header —

7.3A similar letter needs to be sent

7.3.1Use the document as a form letter and the database Use the existing query qry7_3 in the 7Data database as the Sort the recipients (letters\ order of the amount Add the merge fields

7.3.2Complete the mail merge using the 7MergeReady document as Complete the mail merge for onl y the first three recipients. Save the results of the merge fo r the first three recipients as a Save and close all the documents.

Topics Identified

Leadership

Mark Allocation

Total200 marks

Sections11 + 34 + 30 + 30 + 35 + 42 + 18 = 200 marks

Per-question sum136 marks

Key Information

Websitewww.ccn.com · www.mec.org.za

Paper information

SubjectComputer Aplication Technology

Year2011

SessionNovember

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages21

Downloads14

Examination context

Decade2010s

Years ago15y

SeasonSpring (SH)

Start daySaturday

Exam periodNovember 2011

Days since exam5,467

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

Pages21

Archived on11 October 2026

File age12d

ContributorFreeMode

FingerprintAC0EDE464429

Questions and learner discussion

No questions or discussions have been posted yet.