Office Data Processing NCV Level 4 — Document

November 2019 — NCV Level 4 — Office Data Processing

NCV Level 4 2019 NCV Business

↓ Download PDF 📄 587.4 KB

Preparing document

📋 Document Analysis

🎯 30 marks ⏱️ 3h 📄 8 pages 📝 130 items found 📚 2 topics 🔑 3 key info

See full analysis

Questions — A Preview of What to Expect in the Document

130

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 —

Q3— Section header —

Q4— Section header —

Q5— Section header —

Q6— Section header —

Q7— Section header —

Q1— Section header —

Q2— Section header —

Q1— Section header —

Q2— Section header —

3.1Information Day The information day will be held on 21 September 201 in the Civic 2019

3.3Mr Pillay was appointed as the planner of all th e activities at organiser

Q3— Section header —

3.1reate a database and table using appropriate data types, distinguishing between text, numbers, currency, et etera

3.1.1Open the database progr am on your computer and create the database COLDMEAT. Create the table below and use the file name COLDMEAT and your EXAMINAT ION NUMBER: (2\

3.1.2Do NOT select a primary key. (1\

3.1.3Save the table and print the structure of the database. (1

3.1.4Enter the following records in the database (10\ CODE ITEM PACKAG IN

3.1.5Print the table in landsca pe orientation ensuring that all the data is displayed on one page. (2\

3.1.6Copy and paste the database structure with data and change the table name to COLDMEAT2.

3.1.7Make a print screen image of the Paste Table As dialog box and pas te

Q3— Section header —

3.1Delete t he DESTROYED field and contents in the COLDMEAT2 table. (2\

3.1.9Sort the COLDMEAT2 table from oldest to newest according to the DATE DESTROYED field. (2\ .1.10 Change the code S345 to P453. (1\

3.1.11Change the word Cheesy for item code R129 to Cheese. (1\

3.1.1Print the table in landscape orientation ensuring that all the data is displayed on one page. (2\

Q3— Section header —

3.2In this question you are required to create and edit a QUERY

3.2.1Use the table COLDMEAT and create a query using the following fields: ITEM , PACKAGING SIZE (g\STOCK LEVEL and DATE DESTROYED. (5

3.2.2Use the defaul t settings to create the q uery and save as DESTROYED COLDMEAT and your EXAMINATION NUMBER. (1

3.2.3Add more than one criterion to filter only the French Polonies whose packaging size is bigger than 500 g. (4\

3.2.4Print and save the query. (1\

Q3— Section header —

3.3In this question you are required to c reate and edit a REPORT.

3.3.1Use the table COLDMEAT2 to create a report with the following fields ITEM , STOCK LEVEL, PRICE PER UNIT and DATE DESTROYED (5

3.3.2Create the report using the default setti ngs to create the report and change the t itle to

3.3.3Insert a logo saved as ANNOUNCE in the STUDENT FILES folder to appear in the centre of the report footer. (4

3.3.4Change the font type and colour of the report header to Chiller 20pt in black. (2\

3.3.5Print the report in portrait orientation and save as DESTROY DATE and your EXAMINATION NUMBER. (1\ 60 (3061024\ 12

Q4— Section header —

4.1Open the saved presentation called PRESENTATION from the STUDENT FILES folder

Q4— Section header —

4.2Do the follow ing changes using the Slide Master:

4.2.1Select the title placeholder to edit the m aster title style and change the font to Britannic Bold. (3

4.2.2Select the m aster text styles and change the font to Berlin Sans FB Demi. (2\

4.2.3In sert a footer to the left to appear on ALL slides: LISTERIOSIS CAN AFFECT ALL OF US (3\

4.2.4Insert the slide number to appear on all slides in the footer on the right side (1\

4.2.5Select the title placeholder and apply the following cus tom animation . S how the animation pane Lighten Start on the click

4.2.6Bef ore closing the Slide Master v iew, reate a print sc reen image of the Slide Master v iew to show ALL the above action

Q4— Section header —

4.2.7Insert your EXAMINATION NUMBER in the space provided in

Q4— Section header —

4.2.8Insert the text below in the title placeholder of Slide 1 LISTERIOSIS (2\ (3061024\ 13

4.2.9Select the subtitle placeholder and add the following text: LISTERIOSIS IS A SERIOUS INFECTION CAUSED BY EATING FOODS CONTAMINATED WITH THE BACTERIUM LISTERIA

4.2.10 Insert the image BUG from the STUDENT FILES folder to appear above the title placeholder . Resize the image to fit above the title. (4

4.2.11Insert a new Title and Content slide to become Slide 2 (2\

4.2.12Add the text below as title in Slide 2. (1

4.2.13Add the text below, using bullets of your choice, in the content placeholder of Slide 2. Pregnant women Newb orn Adults with weakened immune systems

4.2.14nsert/Reuse the slides from the presentation saved as LISTERIOSIS in the STUDENT FILES folder to become Slides

4.2.15Create a print screen image to show the dialog box t hat appears when executing the function above . Paste it in the space provided

4.2.16Format the bu lleted list on Slide 3 to a numbered list. (2\

4.2.17Insert the Basic Radial SmartArt graphic on Slide 5 and format to look like the image below: (6\

4.2.18Format the chart type on Slide 6 o a Column. (2\

4.2.19Insert a new Title and Content slide to become Slide 7 (2\

4.2.20Insert the text below as title on Slide 7 SHARE THI (1\

4.2.21Insert the sound clip named LISTEN from the STUDENT FILES folder in Slide 7 and enlarge the icon ensuring that it does not cover any t

4.2.22Delete Slide 4 (1\

4.2.23Insert a header against the left margin as follows: EXAMINATION NUMBER

Q4— Section header —

4.2.24Save and print as hand outs, 2 slides per page.

Q4— Section header —

Q5— Section header —

5.1Retrieve th e workbook saved as NUMBERS from the STUDENT FILES folder.

Q5— Section header —

5.1.1(a\ (b\ (c\ Copy the range A2:A11 from the PROVINCES worksheet and paste in A1 i

Q5— Section header —

5.1.2Format the FILTER worksheet as indicated below. (a\ (b\ (c\ Copy the range A1:C10 and paste i A12:C21

Q5— Section header —

5.1.3(a\ (b\ (c\ Custom Sort the range A2:C10 in the FILTER worksheet according to the Discharged column from Smallest to

5.1.4Move the dialog box to the right if it is covering the worksheet content to ens ure all information is visible and fits on one page. (2\

5.1.5Create a print screen image of the worksheet window and paste in the space provide

Q5— Section header —

5.2Format the PROVINCES worksheet as indicated below.

5.2.1(a\ (b\ Delete the comment in C9. Edit the comment in C5 to read as indicated below: At least ONE can treat Liste

5.2.2(a\ (b\ Select column A and activate the Freeze Fir st Column function. Display

5.2.3Create a print screen image of the PROVINCES worksheet to show the Freeze Panes function. Paste the image in the space provided in

Q5— Section header —

5.2.4Print the spreadsheet showing the comments as displayed in the worksheet wi thout Row and Column headings.

5.3Import the chart on the AGE worksheet to the space provided in

Q5— Section header —

5.4Format the EPIDEMY workbook as indicated below.

5.4.1(a\ (b\ (c\ Open the EPIDEMY workbook and select the CHA RT worksheet. Protect the

Q5— Section header —

5.4.2Encrypt the EPIDEMY wor kbook with the password ODPL44 and confirm it (3

5.4Create print screen image of the Encrypt Document and Confirm Password dialog box es

Q5— Section header —

5.4.4Delete the CURVE worksheet. (1\

5.4.5Create a print screen image of the workbook to show the available worksheets in the workbook. (1\

Q5— Section header —

Q6— Section header —

6.1Open Microsoft Outlook.

Q6— Section header —

6.1.1Create contact below in the Address Book: (a\ (b\ (c\ (d\

6.1.2Insert a contact picture using the i mage named CHAIRPERSON in the STUDENT FILES folder (2\

6.1.3Create a print screen image to display the contact in the Address Book. Paste the im age in the

Q6— Section header —

6.2Create an e mail message as indicated below:

6.2.1(a\ (b\ Create the signature below using a font of your choic e, which will be automatically inserted in all e mails. Buthle Ngamso SECRETARY

Q6— Section header —

6.2.2Create the mail message below. TO: staff@youshouldknow.com campaigngroup@info.com CC: Insert the contact created in 6.1.1

6.2.3Subject: LISTERIOSIS INFORMATION DAY (1\

6.2.4Dear All Please find attached the program for th e information day which will take place at th e Civic Centre in

6.2.5Attach the document ADVERT from the STUDENT FILES folder to the mail. (2\

6.2.6Insert the signature created in 6.2. 1 in the message. (2\

6.2.7Create a print screen image of this e mail message and paste in

Q6— Section header —

6.2.8Insert your E XAMINATION NUMBER in the header of QUESTION 6 and print the document. [30] (3061024\30

Q7— Section header —

Topics Identified

Forms of OwnershipBusiness Plan

Mark Allocation

Sections20 + 60 + 30 + 30 = 140 marks

Key Information

Contact Number011 564 9874 · 011 123 4561

Email Addresschairperson@youshouldknow.com · b.ngamso@youshouldknow.com

Websitewww.youshouldknow.com

Paper information

TitleDocument

SubjectOffice Data Processing

LevelNCV Level 4

Document typeQuestion paper

Year2019

MonthNovember

Pages18

Downloads5

Examination context

Decade2010s

Years ago7y

SeasonSpring (SH)

Start dayFriday

Exam periodNovember 2019

Days since exam2,534

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 size587.4 KB

Pages18

Archived on8 September 2026

File age45d

ContributorFreeMode

FingerprintE9B5B96E6821

Questions and learner discussion

No questions or discussions have been posted yet.