Computer Application Technology P1 MS Office_DATA

May-June 2017 — Grade 12 / Matric — Computer Application Technology

Past Paper 2017 Grade 12 English

↓ Download PDF 📄 499.3 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 180 marks ⏱️ 3h 📄 20 pages 📝 53 items found 📚 6 topics 🔑 2 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.1Find the WordArt 'What your car is really costing you' and change it as follows: Apply any reflection text effect to the WordArt. Ensure that the entire WordArt and its reflection effect are

1.2Find the text 'Document created:' below the WordArt. Insert a field next to the text to display the date the document was created. (2\

1.3Use the replace feature of the word processor to change instance of the word ' depreciation' so that they appear in bold with a strikethrough effect. (4\

1.4

1.5

1.6

1.7

1.8Insert an automatic table of figures at the end of the document (1\ Save and close the 1Cost document. [24]24

Q3— Section header —

3.1Insert the text MZANSI CAR SALES in cell A1

3.2The code for each car is created as follows: The first two letters of the name of the car manufacturer column B Followed by t he last three

3.3Insert a function in cell G4 to calculate the age of the car by using the current year and the date the car was released from the factory in column F Ensure that the function will still produce the correct answer for any

3.4Use a function in column J to display the car registration number column in upper case for example

3.5Insert a function in cell L to determine the position of the space located between the

3.6Insert a function in cell M5 using the position of the space in column L to display only the surname from column K EXAMPLE

Q4— Section header —

4.1Insert a function in cell to determine the total number of Toyota vehicles in the showroom. Insert a function in cell to determine the second highest total of

4.3Insert a function in cell to determine the total number of vehicles in the showroom. (2\ Insert a function in cell to determine the total value of the

Q5— Section header —

5.1Edit the tbSales table as follows:

5.1.1Change the field size of the Make field to (1\

5.1.2Add the SUV option to the drop down list in the Type field. (1\

5.1.3Add a validation rule to ensure that only values later than or equal to the current date can be entered in the Sell Date field An

5.1.4Change the data type of the Photo field to a suitable data type. (1\

5.1.5Create an input mask on the RegNumber field ensure that the user inserts a registration number in the following format: All the letters must be displayed in upper case Two compulsory letters Followed by a

5.2Open the query called qry5_ based on the tbClients table and do the following: Add the Title field from the

5.3Open the query called qry5_ based on the tbPayments table and do the following: Add a calculated field called Balance to calculate the amount outstanding.

5.4Open and modify the query called qry5_4 based on the tbCars table to isplay only vehicles manufactured by Nissan or Ford that have a purchase

5.5Open the frm5_5 form which is based on the tbCars table and do the following: Insert the picture

5.6Open and edit the rep5_6 report as follows: Change the report orientation to landscape. Add a second grouping on the Year field.

Q6— Section header —

6.1Format the heading Unsafe Driving in the Cell hone Era as follows: Change the font type to Tahoma Change the font size to 24 pt. (2\

6.2Insert a horizontal line under the heading Unsafe Driving in the Cell hone Era (1\

6.3Centre the picture horizontally and place a border of 5 pt around it. (2\

6.4Find the text Driver Behaviour: Distracted While Driving . Change this to a level two heading. (1\

6.5Find the text driver distraction under the heading Rise in Potentially Dangerous Vehicular Events Create a link on this text to the anchor Distraction that

6.6Find the text starting with Handling the phone and ending with on the road Place this information in a bulleted list as shown in the example on the previous page. (2\

6.7Find the table under the heading Things drivers do that take their eyes and focus of the road:

6.7.1Change the table as follows: Change the table background colour to light blue Set the space between the text and the cell borders to Set the width of the table to 80%. (3\

6.7.2Change the first row of the table as follows: Set the h eight of the first row to 80 pt Vertical align the content of the first row

6.7.3Add the data 14% to the cell in the third column of the fourth row.

6.7.4Merge the cells in the last row of the table. (1\ Save and close the 6Beware web page. [19] 1619

Q7— Section header —

7.1Link the 7State mail merge document to the tbClients table in the 7Acc database as a data source.

7.2Replace the text <Insert Initials> <Insert Surname> with the initials field and surname field respectively from the data source. Do NOT

7.3Complete the form as follows: Insert a form control in the cell next to the text Current Date so that a date can be entered Edit the form control in the cell next to the text Amount Due to accept only

7.4Use the data in the spreadsheet to create a chart similar to the example shown below NOTE Only the data for the months of 2014 are displayed. way in which

7.5Details of the car buyers appear in the tbInfo table the 7Buy database. Open the 7Answ word processing document

7.5.1How many records contain the text wood in the city name? (2\

7.5.2How many records contain buyers with two initials only? (2\

7.5.3What is the average price paid by car buyers from Durban? (3\ Save and close the 7Answ document and 7Buy atabase

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total180 marks

Sections24 + 39 + 19 + 22 = 104 marks

Key Information

Contact Number0246810121 · 0 20000 3000

Websitewww.cars4you.co.za

Paper information

SubjectComputer Application Technology

Year2017

SessionMay-June

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages20

Downloads7

Examination context

Decade2010s

Years ago9y

Season—

Start day—

Exam period—

Days since exam—

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

File details

File size499.3 KB

Pages20

Archived on11 October 2026

File age12d

ContributorFreeMode

Fingerprint6D6ACBFBBA0F

Questions and learner discussion

No questions or discussions have been posted yet.