Computer Applications Technology English P1

November 2012 — Grade 12 / Matric — Computer Applications Technology

Past Paper 2012 Grade 12 English

↓ Download PDF 📄 390 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 200 marks ⏱️ 3h 📄 18 pages 📝 69 items found 📚 6 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.1Set the right hand margin of the document to

1.5cm. (1\

1.2Change the layout of the document as follows: Apply automatic hyphenation to the whole document. Justify the text Place a 3 pt wide double line page border around al

0.35cm below to the first paragraph starting with Most of the ... (1\ Change the properties of the image on page so that it appears in co our. Change the caption

1.1he text from Tropical Storms ... to ... global climate change at the end of the document must be placed in columns as follows: The text must appear in two columns The

5.5cm wide A vertical line must appear between the columns from the heading Heat Waves to the end of the document. Ensure that the heading Heat Wave will always appear at the top of a

1.1Move the graph/chart nd its caption that appear at the end of the document to the second page as follows: The picture/image position of the graph/chart must

1.12Replace all occurrences of the word storms so that the words appear in a red font, and are no longer underlined. NOTE Do NOT

1.13Insert a diagonal text watermark in Arial font to read Weather_Weer (3\ Save Climate_Klimaat and close the document. [33]33

Q2— Section header —

2.1dd your examination number to the author prope of the document 2Wind_Wind (1\ Open the Wind_Wind document.

2.2Replace the words linked to the bookmark BoyGirl with the word gender without deleting the bookmark (2\ Indent the names of the storms starting with Alex (m ale\

2.4Correct the spelling error found in the document. NOTE: he names of places, towns and hurricanes are NOT misspelt (1\ Locate the sub

2.8+ +

2.8.1Convert the text in the first table to upper case. (1\

2.8.2Merge the two tables without deleting any data. NOTE: If y ou did NOT complete QUESTION

2.8.2, continue to apply the instructions in QUESTIONS

2.8.3to 2.8. the second table only. (1\

2.8.3

8.4Set the height of all the rows in t he table to exactly 1 cm (2\

2.8.5Vertically align the cell contents of the table to the centre. (1\

2.8.6Select all the cells in the bottom row of the table EXCEPT the cell containing <<Formula>> , and erge these cells ight

2.8.7Replace the text <<Formula>> with a formula to calculate the t tal number of deaths. (1\

2.8.8Sort the data in the table by year from the most recent to the first time hurricane was listed (2\

2.9Apply outline numbering to the THREE rivia questions to appear as shown low: Trivia Questions Which of these hurricanes had the strongest winds? Sea Islands Hurricane in 1893 Hurricane Katrina in Lake Okeechobee Hurricane in 1928

2.10Add automatic page numbering to the document as f ollows: The page number must appear anywhere in the footer The f irst page of the document is NOT numbered. In other words, page numbering

3.2Add a function in cell L15 to calculate the average yearly rainfall in hannesburg from 2002 to 2011. (2\

3.3The wind speed in Cape Town seem s to be more or less the same from year to year Add a function in cell D18 that will determine the most

3.4Add a function cell S18 to determine the maxim um yearly rainfall in Durban from 2002 to 2011. (2\

3.5Columns G contain values showing the number of days with snow per year in each of the three cities. Add a function or formula cell F21 to display the total number of days on which snow fell in

3.6Use conditional formatting in column O to add a blue fill to the three cells containing the three

2.82cm (1\ Insert a double line border to the bottom of the merged cells (2\

3.1a function cell to display the average annual maximum tem perature for Durban

3.1Use IF statement cell to add a c lassification for Johannesburg This is based on the difference between the average

3.1The average number o f rainy days per year in each of the cities as o served from 2002 to 2011 is shown in

3.1Insert a column graph in the worksheet Summary_Opsomming to co pare the basic climate value of the three cities in cells :D7

Q4— Section header —

4.1Add a function i cell to determine the number of towns for which wind data exists in column

4.2cell display the difference between the minimum temperature in cell the maximum temperature cell

4.3The daily temperature for Bhisho for one week are recorded in cells in the

4.5Use a VL OOKUP function in cell to display the wind speed for Bhisho on Thursday. Use the data in the worksheet Wind_Wind as lookup values.

4.6Each town is given a co ee column made up as fo lows: An asterisk (*\ followed by the abbreviation of the name of the province found in

4.7Use a function in cell to display the number of days which there was wind for ALL

Q5— Section header —

5.1The c lub wishes to maintain databases concerning the weather.

5.1.1Change the data type of the Experience_Ondervinding field to a ore suitable field type.

5.1Delete the record of Jackson.

5.1Add a drop down list control to the Gender_Geslag field which will allow the user to choose or

5.1.4Set a validation rule and appropriate suitable \ validation sage on the Departure_Vertrek field so that the dates of departure are from 1 October 201

5.2The queries below are based on the database table called nfo_Inlig in the same database The Des

5.3Modify the QryDays_Dae query insert ing a calculated field called Days_Dae to display the number of d ays the travellers will be out of the

5.4Create a new query called QryFlood based on the data in the Info_Inlig able. It must display the following

5.5Export the results from the QryInfo _Inlig query to a spreadsheet and save it as yInfo (2\

5.7.1Make the following changes to the form header Create a label in the form h eader and type in your examin tion number Move the image from the form

5.7Make the following changes to the form footer Place a horizontal line at the top of the form footer. Add today's date as a field

5.8Create a report called MyReport _Verslag sed on the Info_Inlig table as follows

5.9Open the existing report called RepInfo_Inlig Modify the report as fo lows: Use a function to display the number of records for each group

Q6— Section header —

6.2.1and 6.2.2 Change the title Daily record of weather conditions as follows: n outline font style small caps small capitals effect (2\ Insert a

6.5Place a text form control next to the word Name with the following pro erties: The default text is Enter t he name here A name entered in the text control may NOT

6.6Place a field showing the file name and path for 6Record_Opname at the bottom of the page. (1\

6.7Weather data been entered into a spreadshee t called 6Day_Dag Paste the contents of cell as a linked

Q7— Section header —

7.1Enter the number of characters found in the word processing file 7Extreme_Uiters in the s pace provided in the

7.2On which template was the word processing file 7Flood_Vloed based Enter your answer in the space provided in the file 7Answer_Antwoord (1\

7.3se the password to open the file Password Wagwoord Remove the password from the file and close Password_Wagwoord (1\

7.4How much space would you need to save 7Extreme_Uiters disk Enter your answer in the space provided in the fil 7Answer_Antwoord (1\

7.5Save the image found in the word processing file 7Storm_Storm as an image file. Name the image file

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total200 marks

Sections33 + 32 + 40 + 26 + 6 = 137 marks

Key Information

Websitewww.climate.org

Paper information

SubjectComputer Applications Technology

Year2012

SessionNovember

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages18

Downloads4

Examination context

Decade2010s

Years ago14y

SeasonSpring (SH)

Start dayMonday

Exam periodNovember 2012

Days since exam5,101

About Computer Applications 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 Applications Technology English P1 memo →

File details

File size390 KB

Pages18

Archived on8 September 2026

File age46d

ContributorFreeMode

FingerprintBF8FA90F3C9E

Questions and learner discussion

No questions or discussions have been posted yet.