Computer Application Technology P1 MS Office_DATA

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

Past Paper 2016 Grade 12 English

↓ Download PDF 📄 537.6 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 180 marks ⏱️ 3h 📄 18 pages 📝 74 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.1Edit the first page by doing the following:

1.1Insert the 1Music_Musiek picture found in the examination folder in

1.1Insert a text box in the bottom left hand corner of the first page and add the text Elvis High School

1.2Create a new style called Music as follows: Format the font size to 48 Centre the text

1.3Insert any page border on the first page only.

1.4Insert the text First raft as a watermark. The watermark should appear on the first page

1.5Remove the comment found at the top of the second page.

1.6Apply an orange gradient ext fill effect to the heading The ffect Music Has On Me' (2\

1.7Apply a dropped cap effect to the first letter of the word Music in the first paragraph, so that it appears over TWO lines and .6 cm/16 pt away from the

1.8Correct the line spacing of the second paragraph so that it is the same as the other paragraphs in the document. (1\

1.9Locate the text Rap and Rock in the third paragraph. Insert an endnote to the words as follows: The endnote must

1.10Manual line breaks ( soft enters \ were used to separate some of the paragraphs in the document. Use the find and replace feature to replace all the manual line breaks in the

Q2— Section header —

2.1Insert automatic page numb ering in the footer of the document as follows: The page numbers in the footer must be centre

2.2Insert an automatically generated table of contents below the heading TABLE OF CONTENTS' . Use the following options: se the Fancy format style. how TWO

2.3Apply the Heading 1 style to the heading 60s Music Facts on the page after the table of contents and update the

2.4Locate the text Placeholder1 and do the following: Add interview source with the interviewee named Steve Johnson

1.1Ensure that the sub headings always appear at the top of a column. Justify all the text in the columns.

2.6Locate the text that starts with Influences and ends with at the time and change it as follows: Place ONLY the pages with

2.7Locate the text that starts with Monterey International Pop Festival and ends with Cre dence Clearwater Revival Create a multilevel list to automatically number the tex

2.8Locate the table on the last page of the document. Insert a word processing function in the bottom right hand (shaded\ cell of the table that will determine and display the average

Q3— Section header —

3.1Merge and centre the contents of cells A1: (1\

3.2nsert a function in cell that will always display the current date. (1\

3.3Insert a function in cell B3 to determine the number of members listed (2\

3.4The surname should appear in capital letters. Use a function in cell to display the surname in cell B5 in capital letters.

3.5Set the print area of the Member_Lid worksheet to include a list of only the members' surnames, names and their year of birth with

3.7The telephone numbers in column not include the area code. Use a function/ formula to add the area code 011 to the

3.8The club needs to send an e mail to every person who does NOT have a cellphone number column J Insert function

3.9In order to create mailing lists the secretary would like to separate the ISP domains from the rest of the mail address EXAMPLE: For t mail

3.10Copy the information of only the members born in December to the Dec_Des worksheet. Save and close the 3Learners_Leerders spreadsheet

Q4— Section header —

4.1Adjust the width of column B so that all the data in this column is displayed and visible

4.2Display the contents of column G to TWO decimal places.

4.3The different storage types for songs are stored in the Code_Kode worksheet. Add a LOOKUP function in cell F2 in the Music_Musiek

4.4There has been a increase in the prices of the songs since the last update of the spreadsheet. The increase in price is as follows: Code 1 songs increased by 20%

4.5The function in cell L2 works correctly. Change the function so that it can be copied to cells L17 and still give the correct results for all the years. (2\

4.6Use a function in cell L21 to determine the total value of all the Pop albums using the original prices

4.7cell J2 display the number of different owners in the list. Explain the met hod you used to determine the answer in

4.8Edit the graph in the raph _Grafiek worksheet to display as shown in the example below (5\

Q5— Section header —

5.1Edit the Learner _Leerders table as follows:

5.1.1Set the default value of the Gender_Geslag field to (1\

5.1.2Change the properties of the Grade_Graad field to sure that a user has to enter a value in this field. (1\

5.1.3Change the properties of the Class_Klas field to display the following four options in a drop down list:

5.1.4Change the DOB_Geboortedatum field as follows: Format the field to display

5.1.5Create a validation rule for the Cell_Sel field so that the user has to enter exactly 10 characters (of any type\ in this field. dd suitable validation text for this field.

5.2Create a form called frm based on the Learner s_Leerder table as

5.3Create a query called qry5_3 based on the Music_Musiek table as follows: Display only the Title_ Tit Artist_Kunstenaar

5.4Open the qry5_4 query and do the following: Add the Cost_ oste field and format it

5.5Adjust the qry5_5 query so that it displays the total cost for each of the three genre of

5.6Open the qry5_6 query hange the query to display all the records with an address that ha street number of 13 the word

5.7Create a report called rpt5_ based on the Music_Musiek table as follows: isplay the Artist_Kunstenaar

Q6— Section header —

6.1Locate the title and the title tags at the bottom of the HTML code and move them to the correct position that the text ' 60s Music is displayed in the browser tab.

6.2The image tag is supposed to display the Sixty_Sestig.jpg picture stored in the examination folder. Add the missing part of the tag so that the picture is displayed correctly (2\

6.3Change the alignment of the heading Music so that it appear in the centre of the page (1\

6.4Change the HTML code for the horizontal line so that: The size is 3 The l ine stretches across 70% of the screen width (2\

6.5Apply a eading 2 ' style to the text Before 1963

6.6Locate the text The Beatles towards the end of the first paragraph and add tags so that the text appears in bold.

6.7

6.8Edit the table as follows: Change the background colour of the table to orange. Insert a new row at the top of the table. Add the headings Artist and Hits

6.9Add b ullet s to the text in the column to the right of the text The Beach Boys so that it appears as follows:

Q7— Section header —

7.1Open the 7Form_Vorm document. Change the comments propert of the document to

7.3Open the 7Compet_Kompet document. Complete a mail merge as follows: Use the Learners_Leerders worksheet in the 7Data spreadsheet as the data source for the mail merge.

7.4Open the 7Sixties_Sestigs database Use any method to combine the information in the two tables in this database ( 60sMusic_Musiek \n one new table called 7Comb

7.5Details of the songs that topped the American and British charts appear in the 7Music_Musiek spreadsheet. Open the 7Answ_Antw document and insert your examination number in the

7.5.1Which title appeared in both the American and British charts 1 August 1964 (2\

7.5.2How many different or unique titles by Elvis Presley reached the charts (2\

7.5.3Which chart featured the most titles (2\

7.5.4Which year featured the most titles on the charts? (2\ Save and close the 7Answ_Antw document [19] TOTAL:19

Q6— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total180 marks

Sections26 + 25 + 25 + 19 = 95 marks

Key Information

Contact Number0113672211

Paper information

SubjectComputer Application Technology

Year2016

SessionMay-June

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages18

Downloads9

Examination context

Decade2010s

Years ago10y

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 size537.6 KB

Pages18

Archived on11 October 2026

File age12d

ContributorFreeMode

FingerprintC4B9427CE1F9

Questions and learner discussion

No questions or discussions have been posted yet.