Office Data Processing NCV Level 4 — Document

November 2018 — NCV Level 4 — Office Data Processing

NCV Level 4 2018 NCV Business

↓ Download PDF 📄 496.9 KB

Preparing document

📋 Document Analysis

🎯 300 marks ⏱️ 3h 📄 7 pages 📝 137 items found 🔑 1 key info

See full analysis

Questions — A Preview of What to Expect in the Document

137

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 —

Q2— Section header —

Q1— Section header —

Q2— Section header —

Q3— Section header —

Q4— Section header —

Q5— Section header —

Q6— Section header —

Q1— Section header —

1.5or 2 (Double\ PAPER: A4 ortrait TIME ALLOCATION: 10 minutes MARKS: 20 FONT:

1.5Insert your EXAMINATION NUMBER and QUESTION NUMBER as a header against the left margin as follows: EXAMINATION NUMBER

Q1— Section header —

Q2— Section header —

2.1.1Open the Microsoft Access program and create a database named

Q2— Section header —

2.1.2Create the able structure below and name it Q2A and your EXAMINATION N UMBER. FIELD NAME

2.1.3DO NOT select a primary key. (1\

2.1.4Save and print the database structure.

2.1.5Enter the following records in the able (1 MEMBER NUMBER SURNAME AND

2.1.6Save the table as TABL 1 and YOUR EXAMINATION NUMBER. Make printout in landscape orientation ensuring a ll fields are

2.2Edit the able as set out below:

2.2.1Add a new field named PAID with a YES/NO field type between the DOB and FEES fields. (3

2.2.2Fill the PAID field for each member as follows: SURNAME AND INITIALS PAID N JACOBS YES

2.2.3Delete the DOB field. (1

2.2.4Save the edited table as TABLE 2 and your EXAMINATION NUMBER . Make a printout of the table on ONE page ensuring all data is clearly displayed. Close the table.

Q2— Section header —

2.3.1Create a query from T ABLE 2 using the following fields: SURNAME AND INITIALS , PAID and FEE

2.3.2Add more than one criterion to filter only those who paid their FEE S and more than R36 ,00. (2

Q2— Section header —

2.4.1Use T ABLE 1 to create a report with default setting and the following fields: SURNAME AND INITIALS, AD DRESS, TOWN and FEE

2.4.2ange the report title to SUMMARY OF MEMBERS and EXAMINATION NUMBER (2\

2.4.3Format the FEES field to display as currency with NO decimals. (2\

2.4.4Format the report title in the centre of the header as shown below: SUMMARY OF MEMBERS EXAMINATION NUMBER (2\

2.4.5Change the font of the report header to Goudy Stout 14 pt

2.4.6Insert the logo named MEMBER from the STUDENT FILES folder to appear both on the left and right of the title.

2.4.7Resize the logo on both sides so that the title is clearly visible in the centre. (2 (3061024\ 10 NC2200

2.4.8Use Goudy Stout 12pt Black to insert the following footer in the centre. SMOKE LESS!

Q2— Section header —

Q3— Section header —

3.1Retrieve the presentation named SMOKING! from the STUDENT FILES folder (1\

3.2Edit Slide 1 as follows:

3.2.1Change t he layout to a Title Only slide. (1\

3.2.2dd the following text in the title placeholder SMOKING TO DIE FOR! (2\

3.2.3Insert the image named STOP from the STUDENT FILES folder in the centre of Slide

3.2.4Resize the image in as follows: Height: 11.4 cm Width: 10.6 cm (2

3.3Delete the following three slides: Slide 2: Why do people start smoking? Slide 4: Symptoms of nicotine withdrawal Slide 5: Barriers of quitting smoking (1\ 3. Edit

3.4.1 Change the layout to a Two Content layout. (1\

3.4.2 Customize the bullets on the left to Webdings 122 (2\ (3061024\ 11

3.4.3 Insert a Clustered Column chart on the right of the Two Content slide and replace the content of the datasheet

3.5.1 Reuse all the s lides from presentation file SINCE in the STUDENT FILES folder

3.6.2 Insert the following shapes including the text within the shapes. (5

3.6.3 Insert the image named SMOKING from the STUDENT FILES folder between the two shapes as illustrated above (2\

3.6.4 Resize the shape to height and width to (1\

3.6.5 Join (group\e objects above to become a single object. (2\ 3. Edit Slide 6 as follows:

3.7.1 Insert a Title and Content slide to become Slide

3.7.2 Insert the title below BARRIERS TO QUITTING SMOKING (2\

3.6.6 Select the object and make a print screen image of the slide showing the grouped objects. Paste the image in the space provided in the answer sheet. (1\

3.7.3 Insert a Horizontal Multi evel Hierarchy SmartArt shape in Slide as set out below

3.7.4 Insert the following text within the shapes as follows: (4 3. .5 Change the colours

3.8Use the Slide Master view to do the following:

3.8.1 Format the font of the entire presentation to Comic Sans. (1\ 3. .2

3.8.3 Insert slide numbers to appear on ALL slides. (2\

3.8.4 Make a print screen image of the Slide Master view and paste the image in the

3.9.1 Add a customised Slide Transition to ALL slides as follows: a\ransition: Uncover b\ound: Drum roll c\ Activate: On Click d\ration: 01:00 (4\

3.9.2 Make a print screen image of the screen showing the transition and paste the image in the

3.9.3 Save, print and close the answer sheet. (1\ (3061024\ 13 NC2200 (E\

3.1Print the presentation as follows:

3.10.4Notes and Handouts: A header with your EXAMINATION NUMBER and QUESTION Colour: Grayscale Page numbers Handouts, 3 slides per pages (4

Q4— Section header —

4.1Re trieve the spreadsheet COSTING from the STUDENT FILES folder Retrieve

Q4— Section header —

4.2Effect the following changes to the workbook:

4.2.1Rename Sheet 1 as COST. (2\

4.2.2Rename Sheet 3 as PER PACKET. (2\

4.2.3Delete Sheet 2. (2\

4.2.4In the COST worksheet, hide the comment in C4. (2\

4.2.5Make a print screen image to show the renaming of the worksheets and the hidden comment. Paste the image in the pace provided in the answer

4.2.6Insert your EXAMINATION NUMBER in the header of the answer sheet (1\

4.2.7Change the row height of Row 1 to 81.75 (109 pixels\ (2\

4.2.8Insert the image saved as BANNER in A1. (2\

4.2.9Resize the image to fill the range A1:D 1. (1\

4.2.10Update headings in Rows and 4 as seen below in bold print and centred.

4.2.11Insert your EXAMINATION NUMBER and

Q4— Section header —

4.3Create a new worksheet as follows:

4.3.1Insert a new worksheet. (2\

4.3.2Rename the new worksheet DUPLICATE. (2\

4.3.3Make a print screen image to show the inserted worksheet and its renaming. Paste the image in the space provided in the answer sheet. (1\

4.4Edit the DUPLICATE worksheet as follows:

4.4.1Copy and paste the range A3:A14 from the COST worksheet to A1:A12 in the DUPLICATE worksheet using the Keep Source Column Widths (paste special\function. (3\

4.4.2Copy and paste the range E3:E14 from the COST worksheet to B1:B12 in the DUPLICATE worksheet range us ing the

4.4.3Hide Row 2. (1\

4.4.4Insert your EXAMINATION NUMBER and QUESTION NUMBER as a header in the centre section of the DUPLICATE worksheet as follows: EXAMINATION

Q4— Section header —

4.4.5Save the spreadsheet and make a printout of the DUPLICATE worksheet showing the row and column headings. (2\

4.5Use the worksheet named PER PACKET to do the following:

4.5.1Sort olumn C in descending order according to the countries. (2\

4.5.2App ly the filter function to Row 5. (1\

4.5.3Use the filer function in the range C6:C55 to extract only the prices from R99,00 and above. (2\

4.5.4Make a print screen image show ing the sort and filter functions performed and paste the image in the space provided

4.6Use the worksheet named PER PACKET to do the following:

4.6.1Protect the current worksheet with the password 'smoking' , so that it cannot

4.6.2Make a print screen image of the Protect S heet dialog box with the pass word nd paste the

4.6.3Make a print screen image of the Confirm Password dialog box after inserting the password before confirm ing the protection

4.6.4Test the protection by inserting text in D4. Make a print screen image of the Warning dialog box that appears on screen and paste the image in the space provided in the answer sheet. (2\

4.7Print o ne copy of the answer sheet

Q4— Section header —

4.8mport an Excel object into a MS Wo rd document as instructed below.

4.8.1Ope n the MS Word document saved as SURVEY from the STUDENT FILES folder and insert your EXAMINATION NUMBER in the header in the space provided.

4.8.2Import the MS Excel obje ct from the Excel file saved as RESULTS from the STUDENT FILES folder to appear

4.8.3Save the MS Word document with the same file name and make a PRINTOUT of the first page only. (1\ [60]60

Q5— Section header —

5.1Open the file

Q5— Section header —

5.2Open the Microsoft Outlook program and do the following: (1\

5.2.1Create a distribution list ( ontact group\amed ABC MEMBERS in the Contacts folder. (2\ (3061024\

5.2.2Add the following onta cts to the distribution list: S Dingani: s.d@gmail.com N Mugadza: mugadzan@hotmail.com C Gouws:

5.2.3Make a print screen image of the dialog box in 5

2.2and paste it in

Q5— Section header —

5.2.4Use the Outlook Calendar to create an invitation as follows: (2\ To: ABC MEMBERS (2\ Subject: GENERAL COMMITTEE MEETING (3\ Location: BOARDROOM

5.2.5Use the Outlook Calendar to do the following: (a\ (b\ (c\ (d\ (e\ (f\ Attached the file AGENDA

Q5— Section header —

5.2.6Make a print screen image of the appointment and paste it in the space provided in the answer sheet. (1\

5.2.7Save and print

Q5— Section header —

Q6— Section header —

2.54Calibri 12pt PAPER JUSTIFICATION LINE SPACING A4 Left/Off

Q6— Section header —

Mark Allocation

Total60 marks

Sections20 + 60 + 60 + 60 + 40 + 60 = 300 marks

Key Information

Email Addresss.d@gmail.com · mugadzan@hotmail.com

Paper information

TitleDocument

SubjectOffice Data Processing

LevelNCV Level 4

Document typeQuestion paper

Year2018

MonthNovember

Pages17

Downloads3

Examination context

Decade2010s

Years ago8y

SeasonSpring (SH)

Start dayThursday

Exam periodNovember 2018

Days since exam2,899

About Office Data Processing examination preparation

This TVET 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 TVET 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.

File details

File size496.9 KB

Pages17

Archived on8 September 2026

File age45d

ContributorFreeMode

Fingerprint1AD3BD0AD038

Questions and learner discussion

No questions or discussions have been posted yet.