147q1n2413 Nc2190 Office Data Processing Qp NCV Level 3 — Document

November 2024 — NCV Level 3 — 147q1n2413 Nc2190 Office Data Processing Qp

NCV Level 3 2024 NCV Business

↓ Download PDF 📄 730.7 KB

Preparing document

📋 Document Analysis

🎯 3 marks ⏱️ 3h 📄 19 pages 📝 181 items found 📚 3 topics 🔑 3 key info

See full analysis

Questions — A Preview of What to Expect in the Document

181

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 —

Q7— Section header —

Q1— Section header —

1.5or double line spacing A4 portrait 10 minutes 20 marks FONT TYPE: FONT SIZE: MARGINS: ALIG NMENT

1.1As a header, key in your EXAMINATION NUMBER and the QUESTION NUMBER against the left hand margin as follow

1.2The minimum speed requirement is 30 words per minute.

1.3This is a TIMED ACCURACY TEST for 10 minutes, which means candidates will start and stop on the invigilator instruction.

Q1— Section header —

Q2— Section header —

2.1Explain the diff erence between the internet and the web (4\

2.2List TWO search engines to be used when searching for information specific to South Africa. (2\

2.3Mention FOUR important ips for online searches. (4\

2.4Outline THREE basic tasks performe d by all search engines. (3\

2.5Write down FOUR steps on how to create a bookmark or favourite. (4\

2.6What is the shortcut key to open the avo rites window? (1\

2.7What do the following icons represent?

2.7.4

2.8Give THREE reasons why it is important to preview a web page before printing. (3\ [25] (3061023\ Copyright reserved25

Q3— Section header —

3.1Open the main folder, NSFAS, from the STUDENT FILES folder and change the view layo ut of all sub folders to Large Icon View. Make a screen print and paste it in the ANSWER SHEET. (3\

3.2Create a spreadsheet with file name PROOF OF ANNUAL HOUSEHOLD INCOME in the DOCUMENTS folder Make a screen print and paste it in the ANSWER SHE

3.3Move the APPLICATION FORM folder from the DOCUMENTS folder to the NSFAS folder Make screen print of both folders and paste

3.4Duplicate the Word file, Parents ID inside the DOCUMENTS sub folder Make a screen print and paste it in the ANSWER SHEET. (2\

3.5Delete the PowerPoint file PROOF OF MARITAL STATUS from the DOCUMENTS folder Make a screen print of the deleted file in the Recycle Bin

3.6Restore a PROOF OF MARITAL STATUS file Make a screen print after this action and paste it in the ANSWER SHEET. (2\

3.7Compress the STUDENT FILES folder and name the zipped folder ODP LEVEL 3. (1\

3.8Copy the compressed folder to the STUDENT FIL ES folder. (1\

3.9Make a screen print of the dialog box after copying the compressed file into the STUDENT FILES folder Paste the screen print in the ANSWER SHEET (1\

3.10Change the attributes of the NSFAS folder in the STUDENT FILES folder to a hidden file, make screen print and paste it in the ANSWER SHEET

Q4— Section header —

4.1Create a data source file using the following information and save it as UESTION 4A (10\ STUDENT ID STUDENT NAMES COURSE LEVEL

4.2If using MS Word, create a header with your EXAMINATION NUMBER and

Q4— Section header —

4.3Save and print th e data source file in A4 portrait rientation Place the PRINTOUT in your EXAMINATION FOLDER. (1\

Q4— Section header —

4.4Retrieve the document saved as NSFAS STATEMENT from the STUDENT FILES folder. (1\

4.4.1As a header, key in your EXAMINATION N UMBER left aligned and

Q4— Section header —

4.4.2Change the font and size of the entire document to Comic Sans, 12 pt. (2\

4.4.3Change the font size of the heading to Comic Sans, 14 pt. (1\

4.4.4Change the heading to upper c ase, underline and left aligned. (3\

4.4.5Find the word SARS and replace it with South African Revenue Services in bold. (2\ (3061023\

4.4.6Insert the following information below the last paragraph NSFAS reserves the right to make the co rrect funding decisions based on its financial eligibility verification processes. NSFAS Contact Centre is accessible on the below platforms from

4.4.7Change the single border around the paragraph to double. (1\

4.4.8Insert a can shape at the top right hand corner of the statement. (2\

4.4.9Copy the NSFAS image from the STUDENT FILES FOLDER, and resize the picture as follows: Height Width (2\

4.4.10Move and adjust the picture into the shape. (1\

4.4.11Format the picture effects to Subtle Effect Black, Dark 1. (1\

Q4— Section header —

4.4.13Format the merg e fields to talic and bold. (2\

4.4.14Print the primary document on ONE A4 ortrait page and save it as

Q4— Section header —

4.5Change the question number in the header to QUESTION 4C. (1\

4.6Merge the primary document with the data source to create a final document. (2\

4.7Print the final merged document displaying ONLY Motsamai B and Maseko YM. Place the PRINTOUTS in your EXAMINATION FOLDER. (2\ [50] (3061023\ 12 Copyright reserved50

5.1Retrieve the document saved as NSFAS STUDENT PORTAL from the STUDENT FILES folder. (1\

5.2As a header, key in your EXAMINATION NUMBER and the QUESTION NUMBER left align ed as follows:

5.3Edit the document as indicated in the instructions below:

5.3.1Change the font of the entire document to Century Gothic , 11 pt. (1\

5.3.2Move the logo from the bottom to the top above the heading centre aligned. (2\

5.3.3Format the heading to upper case, bold and double underline (3\

5.3.4Leave TWO line after the heading. (1\

5.3.5Apply numbering to all sub headings and indent appropriately. (2\

5.3.6Change the spacing of paragraph 2 to 1.5 line spacing and paragraph 3 to double line spacing. (2\

5.3.7Insert a page break after the last paragraph. (1\

5.3.8Change the o rientation of the first page to landscape orientation. (1\

5.3.9Use paragraph 1,2 and 3 on page 2 to cre ate THREE columns with a vertical line between the column (2\

5.3.10Insert column breaks to ensure that column headings are equal to one another. (1\

5.3.11Activate the automatic hyphenation function to provide equal right hand margin for the entire document. (1\

5.3.12WordArt Style, Hard Shadow Accent 1 and font size 28 pt to insert the following text as

5.3.13Create and edit the table as indicated below: (10\ PROCESS STEPS Step 1 Application submitted Step 2 Filtering Step 3 Validation

5.3.14Merge and centre the contents of row 1 across all columns. (1\

5.3.15(1\

5.3.16Bold the text in second column. (1\

5.3.17Split the table and import the NSFAS image from the ST UDENT FILES folder and place it between the words PROCESS and STEPS

5.3.18Change the design of the table to Grid Table 2. (1\

5.3.19Centre the text in column 2 vertically and horizontally. (1\

5.3.20Apply a 3 pt border style around the table. (1\

5.3.21Change the top and bottom margin of page 2 to cm (1\

5.3.22Insert a page break after the table (1\

5.3.23Use WordArt Style, Sharp Bevel and font size 36 pt to insert the following text as heading on page 3. NSFAS BURSARY COVERS (2\

5.3.24Insert the SmartArt Graphic Continues Cycle TWO lines after the heading on page 3. (7\ (3061023\ 14

5.3.25Format the colour of the SmartArt to Dark 1 Outline 1\

5.3.26Insert a page number at the bottom centre of the entire document. (2\

5.3.27Add the following footnote to the heading on page 3 and apply bold and italics. Unlock your future today! (4\

5.3.28Print the document and place the RINTOUT in the EXAMINATION FOLDER. (1\ [60] NSFAS BURSARY Tuition60

Q6— Section header —

6.1.1As a header, key in your E XAMINATION NUMBER left aligned and the QUESTION NUMBER right aligned.

6.1.2Change the font and font size of the entire spreadsheet to Century 11 pt. (2\

6.1.3Format the heading font to size 16 pt and centre across all columns in the work sheet. (2\

6.1.4Change the format of the sub heading in ow 3 to a long date, 14 pt and right aligned.

6.1.5Insert an open row in row 4. (1\

6.1.6Format the column heading to upper case, bold and centre aligned. (3\

6.1.7pply 15% shading to the column headings. (1\

6.1.8eft align the content of A5:A16 (1\

6.1.9Centre the worksheet vertically and horizontally across the page. (2\

6.1.10Apply single inside border and any thick border outside the table (2\

6.1.11Sort Column A with corresponding figures from largest to smallest. (1\

6.1.12Delete the Student Cell Phone Num ber column. (1\

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

6.1.14Save the spreadsheet rint the spreadsheet ONE landscape page with row and column headings and gridlines.

6.1.1Place the PRINTOUT in your EXAMINATION FOLDER (3061023\ 16 Copyright reserved Please turn over

Q6— Section header —

6.2Retrieve the spreadsheet saved a

Q6— Section header —

6.2.1Insert new columns with the following information: Column E TOTAL ALLOWANCES Column F: % OF TOTAL ALLOWANCES (2\

6.2.2Insert new rows in Column A as indicated below Ro w 17: Grand total Row 18: Average Accommodation Paid Row 19: Number of Students

6.2.3Calculate TOTAL in E6 by adding all the payments made. (1\

6.2.4Use the Autofill funct ion to copy the formulae from E6:E16. (1\

6.2.5Use AutoSum in B17 to calculate the GRAND TOTAL of all columns. (1\

6.2.6Use absolute cell referencing in cell F6 to calculate the % of TOTAL ALLOWANCES as a percentage of the TOTAL ALLOWANCES p aid to all students. (1\

6.2.7Use the AutoFill function to copy the formulae from F6:F16. (1\

6.2.8Use a function in cell C18 to determine the AVERAGE of accommodation paid. (1\

6.2.9Use function in B19 to calculate the number of st udents. (1\

6.2.10Use function in B20 to calculate the highest tuition paid. (1\

6.2.11Use function in C21 to calculate the lowest accommodation paid. (1\

6.2.12Display all values as urrency with 2 decimals except % OF TOTAL colum n and number of students. (2\

6.2.13Display values of the % OF TOTAL column as percentage with no decimal (2\

6.2.14Save and print the spreadsheet without gridlines Place the PRINTOUT in your EXAMINATION FOLDER. (1\ (3061023\

Q6— Section header —

6.3.1Display the formulae. (4\

6.3.2Adjust the column widths appropriately to fit all formulae. (1\

6.3.3Save and print the spreadsheet in landscape orientation with row and column headings Place the PRINTOUT in your EXAMINATION FOLDER. (2\

Q6— Section header —

6.4.1reate a PIE chart indicating Tuition Fee Paid to each student. (2\

6.4.2Insert the following chart title: TUITION FEE PAID EXAMINATION NUMBER

Q6— Section header —

6.4.3Display the data labels on the outside end for each segment. (2\

6.4.4Remove the legend. (1\

Q6— Section header —

Q7— Section header —

7.1Open MS PowerPoint create a new presentation and save it as

Q7— Section header —

7.2Slide 1 Title Slide (1\

7.2.1Insert the heading below in the title placeholder in font Bodoni MT Black, 72 pt and format to shadow Grey 50% effect. MyNSFAS status check (4\

7.2.2Insert the following sub title centre aligned in the placeholder using Broadway 40 pt

7.3Slide 2 Title and Conten (1\

7.3.1Key in the heading on the slide in upper case and underline d: What does awaiting academic results mean? (3\

7.3.2Key in the following text in the placeholder Awaiting academic results means that NSFAS will check your academic r esults and institution admission status to ensure you meet the requirement (4\

7.4Slide 3 Two Content Slide (1\

7.4.1Insert the following heading in the title placeholder in italics PROTECTING YOUR CREDENTIALS AND CRUCIAL INFORMATION

7.4.2Insert the following text in the placeholder on the left Applicants do not need to pay fee to apply Remember to not share your myNSFAS login details with anyone. NSFAS employees will never ask for your login details.

7.4.3Apply capital roman numbering. (1\

7.4.4Insert the image, NSFAS MASTER CARD from the STUDENT FILES folder on the right in the placeholder. (2\

7.4.5Adju st the image to fit the placeholder. (1\

7.5Make a screen print of Slide 3 and paste it in Microsoft Word Insert your (3\

7.6Import Slide 1 from the file named PRESENTATION, in the STUDENT FILES folder to become Slide 4. (2\

7.6.1Apply a 3 pt border to the Slide 4 heading and right align. (2\

7.6.2 Change the numbering to filled square bullets. (2\ (3061023\ 19 Copyright reserved

7.7Slide 5 Title Only (1\

7.7.1Key in the following as slide title in bold text TAKE NOTE THAT NSFAS APPLICATION FOR THE 2023 ACADEMIC YEAR IS NOW CLOSED. (2\

7.7.2Insert the Re ctangular Callout Shape in the centre of the slide. Fill the shape with the colour blue. (3\

7.7.3Insert the following text into the shape: A big THANK you to everyone who applied. (2\

7.7.4Format the shape text to ARIAL change to bold and font size 54 pt. (2\

7.7.5(2\

7.8Apply crop design/theme to the presentation. (2\

7.9Apply slide number to all the slides in the presentation. (1\

7.10As a footer, key in your

Q7— Section header —

7.11Save and print the presentation as handouts with TWO slides per page Place the PRINTOUTS in your EXAMINATION FOLDER. (2\ [60] TOTAL:60

Topics Identified

Business FunctionsLeadershipBusiness Plan

Mark Allocation

Total300 marks

Sections20 + 25 + 20 + 50 + 60 + 65 + 60 = 300 marks

Key Information

Contact Number0204040590 · 0410181008

Email Addressinfo@nsfas.org.za

Websitewww.nsfas.org.za

Paper information

TitleDocument

Subject147q1n2413 Nc2190 Office Data Processing Qp

LevelNCV Level 3

Document typeQuestion paper

Year2024

MonthNovember

Pages19

Downloads3

Examination context

Decade2020s

Years ago2y

SeasonSpring (SH)

Start dayFriday

Exam periodNovember 2024

Days since exam708

About 147q1n2413 Nc2190 Office Data Processing Qp 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 size730.7 KB

Pages19

Archived on8 September 2026

File age45d

ContributorFreeMode

Fingerprint1EB9D65E0583

Questions and learner discussion

No questions or discussions have been posted yet.