Office Data Processing Supplementary NCV Level 3 — Document

March 2018 — NCV Level 3 — Office Data Processing Supplementary

NCV Level 3 2018 NCV Business

↓ Download PDF 📄 460.2 KB

Preparing document

📋 Document Analysis

🎯 30 marks ⏱️ 3h 📄 8 pages 📝 126 items found 📚 4 topics 🔑 1 key info

See full analysis

Questions — A Preview of What to Expect in the Document

126

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 —

1.1Inse rt your EXAMINATION NUMBER at the left hand margin and the QUESTION NUMBER at the right hand margin as a header.

1.2The minimum speed required to complete this question is 30 words per minute.

1.3This is a timed accuracy te st for 10 minutes, which means candidates wil start and stop on instruction the invigilator.

Q1— Section header —

1.5Print the document and place the PRINTOUT in the STUDENT FILES FOLDER. (3061023\ NC2200 (E\

Q2— Section header —

2.1As the personal assistant to the HOD Mr Preggy Naidoo in the faculty Business Studies at Computer College you need to send the letters below to the c ollege management who request ed information regarding teenage

2.2Save the document as RESEARCH LIST and make a PRINTOUT. (1\

Q2— Section header —

2.3.1Insert your EXAMINATION NUMBER as header on the left hand si

Q2— Section header —

2.3.2Change the document to single line spacing and use hyphenation to ensure that all margins are equal. (2\

2.3.3Change the font of the document except the logo to Arial 1 pt. (2\

2.3.4Insert today' s date TWO lines below the college logo and leave TWO line spaces. (2\

2.3.5Replace the existing text as shown below with the actual merge fields: <<MANAGER>> <<NAME>> <<DEPARTMENT>> <<OFFICE>> <<EXTENSION>> (5\

2.3.6Insert the subject heading TEENAGE PREGNA NCY centre aligned, bold and underlined eave TWO

2.3.7Insert the following text exactly as given, four lines after the last parag raph: Mr P Naidoo HOD: BUSINESS STUDIES (3\ (3061023\ 10

2.3.8Insert the following footer in bold, font size 8 and centred: TEENAGE PREGNANCY IS OUR RESPONSIBILITY!!! (5\

2.3.9Save the document

Q2— Section header —

2.4.1Merge this document with the data source RESEARCH LIST to create THREE letters. (2\

Q2— Section header —

2.4.3Save the final merge d documents

Q2— Section header —

Q3— Section header —

3.1Retrieve the document saved as TEENAGE PREGNANCY SUPPORT from the STUDENT FILES FOLDER (1\

3.2Insert your EXAMINATION NUMBER as a footer against the left hand margin and the QUESTION NUMBER against

3.3Edit the document as indicated in the instructions below:

3.3.1Change the font of the entire document to Segoe UI 12 pt. (2\

3.3.2Fully justify the entire document and use the hyphenation function to create equal margins through out the document. (2\

3.3.3Edit the heading TEENAGE PREGNANCY SUPPORT to a WordArt of your choice and leave TWO line spaces after the heading. (3\

3.3.4Change the font of the WordArt to size 28. (1\

3.3.5Leave TWO line spaces after the second line of the first paragraph (1\

3.3.6Leave TWO line spaces before and after the paragraph heading IF YOU ARE SINGLE AND PREGNANT (2\ (3061023\ 11

3.3.7Change the paragraph heading to bold, centre and underlined (3\

3.3.8Insert the image saved as SINGLE PARENT from your STUDENT FILES FOLDER (2\

3.3.9Centre the picture and insert double frame border of your choice around the picture. (2\

3.3.10Leave ONE line space below the image (1\

3.3.11Leave TWO line spaces below the first sentence after the picture hange this sentence to underline and upper

3.3.12Do uble underline the words 'Ask Brook' be low the heading in

Q3— Section header —

3.3.13Insert page break after the third paragraph BROOK if you are Ask Brook

3.3.14Change the paragraph heading THE YOUNG WOMAN'S GUIDE TO PREGNANCY to bold and italics. (2\

3.3.15Leave TWO line spaces before and after the paragraph heading CARRYING ON WITH YOUR EDUCATION WHILE YOU ARE PREGNANT and change this heading to bold and italics. (2\

3.3.16Leave TWO line spaces before a nd after the paragraph heading FINDING SOMEWHERE TO LIVE WHEN YOU ARE PREGNANT and change this heading to bold and italics. (2\

3.3.17Highlight the last three par agraphs starting with THE YOU NG WOM 'S THREE

3.3.18Creat e the following table TWO lines after the columns on page 2: PROVINCE PERCENTAGE AGE

3.3.19Apply any TABLE DESIGN/STYLE to the table. (2\

3.3.20Insert the 8 point st ar AutoShape from Stars and Banners TWO lines after the table. (2\ (3061023\

4.4Insert title and two content slide as slide 3 with the following text:

4.4.1Title place holder ype BIRTH CONTROL IMPLANT in bold and underlined (3\

4.4.2lace holder 1: Type the text exactly as given: HOW DOES A BIRTH CONTROL IMPLANT WORK? The implant releases progestogen into the bloodstream challenging the path of the sperm through the cervix to reach the

4.4.3Format the heading in place holder 1 to old, underlined and centre (3

4.4.4In place holder 2: Insert the image saved as TEEN PREGNANCY and adjust the picture to fit the placeholder (3\

4.4.5Insert speaker not e in slide 3: Contraceptive Implant an Effective Method to Prevent Pregnancy (5\

4.4.6Make a print screen image showing slide 3 with the speaker note. Open a blank Ms Word document and paste the image in the document. Insert your EXAMINATION NUMBER and the QUESTION NUMBER as a header against the left margin as

Q4— Section header —

4.5Insert a blank slide as slide 4 to create the shaded AutoShape Horizontal Scroll below with the text i n the centre of the slide. (5

4.6Import slide 2 from the presentation named TEENAGE PREGNANCY AWARENESS in the STUDENT FILES FOLDER to become lide 5 in the presentation. (2\

4.7Format the design for the whole presentation to SO LSTICE (3 PREVENTION FOR UNPREPARED PREGNANCY

4.8Insert a slide number to all slides (2\

4.9Insert a header as indicated below and print the presentation as handout with 6 slides horizontally.

Q4— Section header —

Q5— Section header —

5.1Create the spreadsheet as set out below: (11\ PROVINCIAL STATISTICS ON TEENAGE PREGNANCY TEEN PREGNANCY WORLDWIDE

5.1.1Insert the following header:

Q5— Section header —

5.1.2Adjust column widths where necessary to ensure that all data is clearly displayed. (1\

5.1.3Save and print the spreadsheet with row and column headings. (1\ (3061023\ 15 NC2200 (E\

Q5— Section header —

5.2.1Format the font of the heading in row 1 to Baskerville Old Face and bold. (2\

5.2.2Merge and centre the heading in cell A1 across the range A1:E1. (1\

5.2.3Insert TWO open rows below the heading PROVIN CIAL STATISTICS ON TEENAGE PREGNANCY (1\

5.2.4Change the height of ow 3 to 102.75/137 pixels and merge and centre cell :C 3.

5.2.5Insert the image named SEX CONSEQUENCES from the STUDENT FILES FOLDER in cell B3 to C3 . Resize the pi cture to fit into these cells. (2\

5.2.6Format th e text in row 4 to become bold EEN PREGNANCY WORLDWIDE and insert ONE open line

5.2.7Insert a new column after PREGNANT TEENAGERS and insert the following text in the new c olumn: NON PREGNANT TEENAGERS (2\

5.2.8Insert a new column after NON PREGNANT TEENAGERS and insert the following text in the new column: % PREGNANT (1\

5.2.9In the last row of the spreadsheet below Western Cape in cell A17, key in the w ord TOTAL in upper case. (2\

5.2.10In the last row of the spreadsheet below the inserted word TOTAL in cell A18, key in the word AVERAGE in upper case. (2\

5.2.11In the last row of the spreadsheet below the inserted word AVERAGE in cell A19 , key in the word COUNT in upper case. (2\

5.2.12Change ALL column headings to bold and centre. (2\

5.2.13Calculate the NON PREGNANT TEENAGERS AS FOLLOWS: OVERALL TEENAGERS minus PREGNANT TEENAGERS (2\ (3061023\ 16

5.2.14Use the AutoFill handle to copy the formulae from cells D8:D16. (1

5.2.15Calculate the % PREGNANT as follows: PREGNANT TEENAGERS divided by OVERALL TEENAGERS (2

5.2.16Use the AutoFill handle to copy the formulae from cells E8:F16. (1\

5.2.17Calcu late the TOTAL of each column. (2\

5.2.18Use the AutoFill handle to copy the formulae from cells B17:D17. (1\

5.2.19Calculate the AVERAGE of % PREGNANT in cell E18. (2\

5.2.20Calculate the NUMBER of PROVINCES in cell E19 (2\

5.2.21 Display % PREGNANT and AVERAGE of % PREGNANT as a percentage with NO decimal and ALL other figures as integers.

5.2.22Adjust column widths to fit the spreadsheet on ONE page. Save and print the spreadsheet in landscape orientation with row and column headings and gridlines.

Q5— Section header —

5.3.2Display the formulae

5.3.3Adjust the column widths so that ALL formulae are visible.

5.3.4Save and print the document with row and column headings and gridlines. (1 [60] (3061023\60

Q6— Section header —

6.1FROM: TO: CC: BCC: SUBJECT: MESSAGE: manager@msunduzimunicipality.gov.za msimang@msunduzicollege.co.za vanwyk@coastalcollege.co.za

6.2Change the font of the message to Arial 12 pt and bold. (2

6.3Set this e mail as high priority. (2\

6.4Make a print screen image of the message and paste it in the space provided in your ANSWER FILE. (2\ [30] (3061023\ 1830

Q7— Section header —

7.1Open the content of the main folder, PROVINCES, make a print screen image and paste it in the ANSWER FILE. (2\

7.2Create the subfolder PIETERMARITZBURG in the KWAZULU NATAL folder. (2\

7.3Open a blank MS WORD document and save it as Msunduzi Municipality in the PIET ERMARITZBURG subfolder. (2

7.4Copy the file Msunduzi Municipality from the PIETERMARITZBURG subfolder and paste it in the KWAZULU NATAL folder. (2\

7.5Open the contents of the PIETERMARITZBURG subfolder. Make a print screen image and paste in the ANSWER FILE. (1

7.6Open the FREE STATE folder and create a subfolder SASOLBURG (2

7.7Open the contents of the FREE STATE folder and make a print screen image and paste it in the ANSWER FILE. (1\ [20] TOTAL: 30020

Topics Identified

Business EnvironmentsBusiness FunctionsLeadershipBusiness Plan

Mark Allocation

Total300 marks

Sections20 + 50 + 60 + 60 + 30 + 20 = 240 marks

Key Information

Email Addressmanager@msunduzimunicipality.gov.za · msimang@msunduzicollege.co.za

Paper information

TitleDocument

SubjectOffice Data Processing Supplementary

LevelNCV Level 3

Document typeMemorandum

Year2018

MonthMarch

Pages18

Downloads5

Examination context

Decade2010s

Years ago8y

SeasonAutumn (SH)

Start dayThursday

Exam periodMarch 2018

Days since exam3,146

About Office Data Processing Supplementary 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 size460.2 KB

Pages18

Archived on8 September 2026

File age47d

ContributorFreeMode

Fingerprint8265ECC77640

Questions and learner discussion

No questions or discussions have been posted yet.