Office Data Processing NCV Level 3 — Document

November 2018 — NCV Level 3 — Office Data Processing

NCV Level 3 2018 NCV Business

↓ Download PDF 📄 501.1 KB

Preparing document

📋 Document Analysis

🎯 300 marks ⏱️ 3h 📄 9 pages 📝 141 items found 📚 2 topics 🔑 2 key info

See full analysis

Questions — A Preview of What to Expect in the Document

141

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 —

1.1Insert your EXAMINATION NUMBER AND QUESTION NUMBER as a header against the left margin as follow: EXAMINATION NUMBER

Q1— Section header —

1.2The minimum speed require ment is 30 words per minute.

1.3This is a timed accuracy test for 10 minutes, which means candidates will start and stop on instruction from invigilator.

Q1— Section header —

Q2— Section header —

2.1Create a data source file using the follo wing information and save the file as

Q2— Section header —

2.3Save and print the dat a source file. (1\

Q2— Section header —

2.4.2 Insert the headings as follows: uppercase, bold, centre and font size 18 pt. SUPPORTING A YOUNG PARENT START RIGHT: TEEN PREGNANCY PROGRAM (4\ 2. .3

2.4.5Change the sub bold. (2\ 2. Apply any bullet with

Q2— Section header —

2.4.1Change the question number in the head

Q2— Section header —

2.4.14Print only document 1 and 3 of the final/merged documents. (1\ 60

Q3— Section header —

3.2Insert your EXAMINATION NUMBER and QUESTION NUMBER as a header left as follows: EXAMINATION NUMBER

Q3— Section header —

3.3.2Change the entire document to single line spacing. (1\ 3. 3. Change the main heading to font size 36pt, uppercase and use any outline effect. (3\

3.3.12Change the heading and paragraph of Goal 1 3 to 3 equal columns with a vertical line between columns. (3\

3.3.13Apply full justification and hyphenation to the columns. (2\

3.3.14Find the word communities and replace with COMMUNITIES in uppercase, bold and italics. (2\ (3061023\ 13 NC2190 (E\

3.3.15Insert the picture CONTRACEPTIVES two lines below the Goal 4 paragraph and change the height and width of the picture to 10 cm and 16,43 cm.

3.3.16Apply any picture style to the picture.

3.3.17Insert a page break before the heading ' Conclusi on

3.3.18Open the file teen challenges and copy the file two lines after the last paragraph of conclusion.

3.3.19Change the row height of the table to 1,5 cm. (1\

3.3.20Change the font and font size of the table to CALISTO M T 12pt. (2\

3.3.21Apply any table style to the table. (1\

3.3.22Change the column headings to bold, uppercase and centre. (2\

3.3.23Apply a double outside border to the table. (1\

3.3.24Delete the row 'bullied on school propert y'. (1\

3.3.25Centre the table across the page. (1\

3.3.26Centre text vertically and left align in table accept column headings. (2\

3.3.27Print the document (only 3 pages\ (2\ [60] (3061023\ 14 NC2190 (E\60

Q4— Section header —

4.1Retrieve the document saved as AVOID PREGNANCY from your student file folder. (1\

4.2Insert a new TITLE SLIDE as SLIDE 1. (2\

4.3Edit slide 1:

4.3.1Insert the heading AVOID TEENAGE PREGNANCY in uppercase, bold, 65pt in the title placeholder. (4\

4.3.2Insert the sub heading By WikiHow in font colour black, right align in the second placeholder. (3\

4.4Edit Slide 2:

4.4.1Change the h eading to shadow effect and font size 60pt. (2\

4.4.2Use a spell check function to correct all typing errors. (2\

4.4.3Change the bullets to numbering. (2\

4.5Insert a new TITLE AND CONTENT SLIDE as SLIDE 3 as follows. (10\ uppercase, bold, font size 40pt Unprotected vaginal sex has the h ighest likelihood of resulting in pregnancy. Pulling out carries some risk of pregnancy.

4.6Edit Slide 4: Create a 3D PIE Graph with the following information: Contraceptive Unintended pregnancy % Implant 0,05% Injectable 6%

Q4— Section header —

4.7Edit Slide 5:

4.7.1Change the heading to TYPES OF CONTRACEPTIVES in uppercase, bold and underline. (4\

4.7.2Open the file TYPES from your student file. Copy and paste to Slide 5 and insert the following information in column 3 and 4. The Diaphragm Placed inside the vagina to prevent sperm into uterus. The Intrauterine

4.7.3Apply 50% shading to column 3 and bold the text. (3\

4.8Import the file SLIDE 6 from your student file folder and edit slide as follows: Change the layout to TITLE with TWO CONTENT and move the second bullet to the right column in slide 6. (1\ (3\

4.9bold and right align in slide 7. (2 (3061023\ 16 NC2190 (E\

4.10Edit slide 8:

4.10.1Apply a border to the body placeholder and change the placeholder to any AutoShape. All text must be visible. (2\

4.10.2Change the AutoShape to 3D contrasting left. (2\

4.11Change the font of prese ntation to font BASKERVILLE and apply any design/theme to presentation. (Use an appropriate design where everything is visible.\

4.12Insert a FOOTER aligned as follows on handout page: EXAMINATION NUMBER

Q4— Section header —

4.13Save and pri nt the presentation as handouts with 4 slides per page. (1\ [60]60

Q5— Section header —

5.1Open/retrieve the document saved

Q5— Section header —

5.1.1Insert your EXAMINATION NUMBER and QUESTION NUMBER as a header left aligned of the spreadsheet as follows: EXAMINATION NUMBER

Q5— Section header —

5.1.2Change the font of the entire spreadsheet to COMIC SANS 12pt. (1\

5.1.3Change the heading to bold, underline and 20pt. (2\

5.1.4Insert 3 open rows after the heading. (1\

5.1.5Change the row height of rows to 19.5 (26 p ixels\. (1\

5.1.6Insert the following text: Total Teenage Mothers (Survey\ 1407 Total Service Providers (Survey\ 704 Total Focus Groups (Teenage Boys and Girls\ 90 (3\ (3061023\

5.1.7Merge and centre the cells B5:E5. (1\

5.1.8Insert the t ext PROVINCES in uppercase and italics. (2\

5.1.9Insert borders with function you familiar with as follows: Double outside border A6:F15 Single inside border A8:F15 (2\

5.1.10Display values as number with 1 decimal. (1\

5.1.11Centre a lign column A. (1\

5.1.12Change the column headings to centre, bold and 14pt and apply a dark colour shade. (3\

5.1.13Insert the image saved as TEEN FACT from your STUDENT FILES folder on which ever drive is used and paste it in cell C2:E4.Ad just picture to fit. (3\

5.1.14Apply a suitable border or any picture style to the image. (1\

5.1.15Adjust column widths where necessary to ensure that all data is clearly displayed. Save and print the spreadsheet on landscape orientation. (2\

Q5— Section header —

5.2.2Find the word GRATIFICATION and replace with SATISFACTION Sentence case. (1\

5.2.3Sort column A in ascending order according to factors. (1

5.2.4Use the formula to calculate the total factors for provinces in F8. (2\

5.2.5Use the AutoFill handle to copy the formulas from F9:F15. (1\

5.2.6Use a function in B16 to calculate the total of factors per province. (1\

5.2.7se the AutoFill handle to copy the formulas from C16:F16. (1\ (3061023\ 18 NC2190 (E\

5.2.8Use a formula in B17 to determine the HIGHEST number in the Eastern Cape. (1\

5.2.9Use a formula in E18 to determine the AVERAGE number in Limpopo. (1\

5.2.10Ca lculate the % of TOTAL per province as follows in D19 and E19. Use absolute cell reference. (2\

5.2.11Display numbers as number with 1decimal and percentage of Total as percentage with no decimal. (1\

5.2.12Adjust column widths so that all data is clearly displayed. Save and print this spreadsheet on orientation landscape. (2\

Q5— Section header —

5.3.1Display the formulae. (2\

5.3.2Adjust the column widths so that ALL the formulae are legible. (1\

Q5— Section header —

5.3.4Save and print the document with row/column headi ngs. (1\ [5 0]

Q6— Section header —

6.2You want to change the standard view of the internet to full screen mode. Explain in steps how you would change this screen to full screen mode. (3\

6.3Icons can be added or removed from the command bar. Demo nstrate how you would add or remove icons by making use of a print screen to indicate the steps and paste into the ANSWER SHEET. (5\

6.4You need to save images displayed on a web page. Explain in steps how you would save the image. (6\ (3061 023\ 19 NC2190

6.5Study the following image:

6.5.1Identify the internet term that changes the mouse pointer to a hand that indicates this particular piece of text or image. (2\

Q6— Section header —

6.6Print t he document. (1\ [20]20

Q7— Section header —

7.2When creating a PDF file you can set various security options.

Q7— Section header —

7.3Locate the student file folder and compress the files into a folder and save it as ODP L3. Make a print screen image. (4\

7.4Use the Help and Support function to s earch for information on how to back up your files. Copy and paste the information. (4\

7.5Create a new folder called PREVENTION TEEN PREGNANCY. (4\

7.6Copy the files from the student file folder. (2\

7.7Create a text document called PR EVENTION in the PREVENTION TEEN PREGNANCY folder. Make a print screen image. (4\

7.8Delete the folder PREVENTION TEEN PREGNANCY and make a print screen image of the recycle bin displaying the deleted folder. (3\

7.9Print the document. 1\ [30] TOTAL: 0030

Topics Identified

LeadershipBusiness Plan

Mark Allocation

Total300 marks

Sections60 + 60 + 20 + 30 = 170 marks

Key Information

Contact Number086 123 0042 · 086 123 0044

Email Addressmsayala@icare.com · ancayo@icare.com

Paper information

TitleDocument

SubjectOffice Data Processing

LevelNCV Level 3

Document typeQuestion paper

Year2018

MonthNovember

Pages19

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 size501.1 KB

Pages19

Archived on8 September 2026

File age45d

ContributorFreeMode

Fingerprint042533DA2AF5

Questions and learner discussion

No questions or discussions have been posted yet.