Office Data Processing NCV Level 3 — Memo

February 2020 — NCV Level 3 — Office Data Processing

NCV Level 3 2020 NCV Business

↓ Download PDF 📄 1.23 MB

Preparing document

📋 Document Analysis

📄 31 pages 📝 174 items found 📚 2 topics 🔑 1 key info

See full analysis

Questions — A Preview of What to Expect in the Document

174

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.

1.3Accuracy: Use a red tick to indicate all accuracy marks Use a red to indicate

1.4XX\ Timed accuracy t est: The timed accuracy test will be marked according to the given s che ule for QUE

Q1— Section header —

Q2— Section header —

2.1Format ted Slide 1 as a Title Slide

2.1.1Inserted the headin g in the Title placeholder in uppercase, size 44 pt, bold and shado w effect. (5\

2.1.2Insert ed the subheading in black font and italics in the subtitle placeholder (4\

2.2Inserted a new Two Content slide as Slide 2 and edit it as follows: (1\

2.2.1Insert the text in uppercase in the title placeholder. (2\

2.2.2Insert ed the text in the body placeholder on the left: (3\

2.2.3Inserted the image named PARENTING and applied any picture style. (4\

2.3Insert a new itle and Content slide as Slide 3 and edit it as follows: (1\

2.3.1Insert the text in uppercase in the title placeholder. (2\

2.3.2Create the table in the body placeholder: (8\

2.4Import the slide MISBEHAVIOUR as Slide 4 and edit it as follows: (1\

2.4.1Insert the text below in uppercase in the title placeholder. WHY DO CHILDREN MISBEHAVE? (2\

2.4.2Use the spell check function to correct spelling errors. (2\

2.4.3Edit the text in the body placeholder (5\

2.5Insert a new Title and Content slide as Slide 5 and edit it as follows: (1\

2.5.1Insert the text in uppercase in the title placeholder. (3\

2.5.2Create a 3D pie chart using the information given and insert data labels on the outside of each segment: (5\

2.6Insert a new Title and Content slide as Slide 6 and edit it as follows: (1\

2.6.1Insert the heading SOLUTIONS in the title placeholder in uppe case and bold. (3\

2.6.2Insert the SmartA rt Graphic Horizontal Bullet List (2\

2.6.3Copied and pasted the text below the headings from the file saved as SOLUTIONS in the STUDENT FILES folder. (1\

2.6.4Applied any SmartArt style to the graphic. (1\

2.7Applied slide number s to all slides in the presentation. (1\

2.8Inserted a header aligned as follows on the handout page:

Q2— Section header —

2.9Printed the presentation as handouts with THREE slides per page. (1\ [60]60

Q2— Section header —

2.8header

2.9handout, 3 slides per page SLIDE 2

2.2Two Content slide SLIDE 3

2.3

2.4Import slide MISBEHA IOUR SLIDE 5 Title and Content slide SLIDE 6

2.6Title and Content slide 3rrr/_FJF_FJ/oj3]rFs3Fs3%]r;koFs3!kt_tl/s3]r!kt_tl/s3oFJF_FJ/oj3J/r]rtl/s3!kt_]r]r]r/t_Jkr!kt_/t_Fs3%ttKbCJ]p!klFok_bCJkp!;kb.tK]o!k_Zb]`Fok_tb3]b]`]`]`kb.tKbCJZl]`k_]`bCJs3kok_k_k`kp!;Zb]`CtoFtm.tr!]tK'

Q3— Section header —

3.5marked in merged document

3.5.12 marks lost for the header NOT inserted/incorrect

3.5.14mus t be marked in the mer ged letter

3.5.171 mark lost for NOT printing primary/main document If no PRINTOUT of the p rimary document is included:

3.5.152 mark lost dence of documents being linked

3.5.167 marks lost dence of merge fields being inser ted

3.5.171 mark PRINTOUT of the primary d ocument PRINTOUT of merged d ocuments If no PRINTOUT of the merged documents is included, marks for 3.5.18 to 3.5.20 are lost

Q3— Section header —

3.1Case Accuracy Column width (12\

Q3— Section header —

3.4Retrieved the document. (1\ Inserted EXAMINATION NUMBER and QUESTION NUMBER Header right

3.4Changed the font size of the enti re document to Comic Sans 12 pt

3.4Changed line spacing to single Changed spacing before and after

3.4Changed heading to 14 Centre Bold

3.4Applied nu mbering Correct paragraph Indentation

3.4Inserted symbol TWO lines be fore heading Applied dashed line Centre aligned heading ORDER FORM (1\

3.4Chan ged the row height to 1 cm/0.39" (1\ Changed table headings to bold and italics Applied 50% shading to table headings Correct headings

3.4.10 Centre aligned text in cells vertically (1\ .11 Merged row 1 from column 2 to 4 Merged row 2 from column 2 to 4

3.4.12 AutoF it table to contents (1\ 12

Q3— Section header —

3.5.1Merged TECHNIQUES with PARENTLIST (1\

Q3— Section header —

3.5.3Printed pages 1 and 2 of the document only (2\ [60] EXAMINATION NUMBER60

Q3— Section header —

3.2header/file name (MS Access\

3.1upper/lower case PARENTS PO BOX TOWN CODE CONTACT NUMBER Mr & Mrs Ngcobo PO BOX 54 GRAAFF REINET

Q3— Section header —

3.4

3.4.11 merge cells

4.15merge field .13 insert cells

3.4.14 margins (top, bottom\ 14

Q3— Section header —

3.5.1merge Use grounding 15

Q3— Section header —

3.5.3print page 2 Use grounding 16

Q4— Section header —

4.1Insert ed the EXAMINATION NUMBER and QUESTION NUMBER as a header in the centre as follows: EXAMINATION NUMBER

Q4— Section header —

4.2Edit the document as indicated in the instructions below:

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

4.2.2Applied the Subtitle style, bold and font size 16 pt to the following headings: Authoritative Permissive Authorit arian

4.2.12Delete paragraphs 5 and 6. (1\

4.2.13

4.2.15Change the top and bot tom margins of page 2 to 1.5 cm/0.59". Find the word NEGLECTFUL and replace with UNINVOLVED in uppercase, bold and italics. (1\

4.2.16Insert the SmartArt Graphic Equation with text, TWO lines below the UNINVOLVED paragraph. (6\

4.2.17 Applied any SmartArt style to the graphic. (1\

4.2.18Insert on page 2 an additional footnote after the word 'Uni volved parenting' below the heading UNINVOLVED PARENTING as follows: Also known as neglectful parenting. (2\

4.2.19Insert a section break for the next page after the SmartArt graphic on page 2. (1\

4.2.20Change the subheadings on page 3 below the heading 'How to recognise which parent you are', to bold, italics and cent red. (2\

4.2.21Change the font size of the parag raphs on page 3 to 10 pt (do not include subheadings\. (2\

4.2.22Change the orientation of page 3 to landscape. (1\

4.2.23Create FOUR equal columns with a parenting style (subheading\ in each column. (2\

4.2.24Inse a footer aligned on the right using italics and font size 9 pt as indicated below: By Emily Heughes (3\

4.2.25Inserted page numbers in the top right of the document as follows: (2\

4.2.26Print the document. (1\ [50] 1850

4.1header in centre EXAMI NATION NUMBER

Q4— Section header —

4.2.5insert 2 lines How to Identify Yours

4.2.7any border In psychology today, there are four major recogn ized parenting styles: authoritative, neglectful, permissive, and authoritarian. Each one carries different characte istics and brings about different reactions in the children which they are used on. It is i

4.2.1Centur y Gothic 11pt (entire document\ Authoritative

4.2subtitle style Authoritative pa r- enting is widely r garded as the most effective and ben ficial pa

4.2.8insert image Permissive

4.2.11place footnote co rect Permissive parenting , is another potentially harmful style of parenting. These pa ents are responsive but not demanding. These parents tend to be lenient while trying to avoid co

4.2.3Automatic h yphenation 1 Also known as indulgent parenting.

4.2.12delete paragraphs 5 & 6

4.2.13insert page break 19

4.2.14

Q4— Section header —

4.2.15

4.2.16 I nsert SmartArt Equation

4.2.19nsert sect ion break for next page

4.2.18ootnote placed correctly 2 Also known as neglectful parenting 20

4.2.20

4.2.21paragraph font size 10pt (pg 3 only\ Recognizing your authoritar an style: Do you have very strict rules that you believe should be followed no ma t-

4.2

4.2footer By Emily Heughes 22

Q5— Section header —

5.2.2Calculated formula D6

5.2.3Calculated formula E6 (2\

5.2.4Calculated formula E18 (2\

5.2.5Calculated formula F6

5.2.6AutoFill used to copy formulas in column D to F (2\

5.2.7Calculated average in B19

5.2.8Calculated maximum in C20

5.2.9Calculated count in B21

5.2.10Displayed n umbers as integers Displayed % total as percentage with NO decimal (2\

5.2.11Column width Portrait printed row and column headings (2\ [23]23

Q5— Section header —

5.3.1Displayed formulae and adjusted column widths (3\

5.3.2Changed QUESTION NUMBER to 5C (1\

5.3.3Printed with row and column headings and gridlines (2\ 23

Q5— Section header —

5.1accuracy upper/lower case NO bold/italics

5.1.1header in centre

5.1.7merge & centre A1:F1

5.1.2AutoFill months

5.1.2AutoFill months 24

Q5— Section header —

5.2.11print

5.2.2calculate 2019 absolute cell reference 25

Q5— Section header —

Q6— Section header —

6.2Created a print screen image of the steps to follow when you want to d lete or clear the history of temporar nternet a nd website files and pasted the image in the space provide in the answer file. (5\

6.3Used the Help and Support function to search for information on how to change your current webpage as the homepage. Copied and pasted the information in the space provided in the answer file. (5\

Q6— Section header —

6.5Differentiated between a webpage and a website. (2\

6.6Named three examples of a search engine. (3\

6.7Printed the document. (1\ [20] 2720

Q6— Section header —

6.3Start Help and Support Correct information Click to open Internet Explorer. Navigate to the webpage you would like to set as the home page. Click the arrow to the right of the Home button, and then click Add or Change Home Page.

Q6— Section header —

6.5A website is where content is displayed. A place connected to the Internet, where a company or an organization, or an individual person, puts inf ormation. A web page is the content that is displayed on the website.

6.6Google Ananzi Yahoo Bing Google Scholar Aardvark (Any THREE (3\

6.7Print (1\ 29

Q7— Section header —

7.1Opened document/I nserted EXAMINATION NUMBER (1\

7.2Created tree structure and displayed Main folder DISCIPLINE Subfolder PARENTING Subfolder TYPES Subfolder GUIDELINES

7.5Opened file Styles File Save as Save as file type PDF Student files folder Statistics

Q7— Section header —

7.2print screen

7.2Main folder DISCIPLINE

7.3correct folder 31

Q7— Section header —

7.6

Topics Identified

Forms of OwnershipBusiness Plan

Mark Allocation

Sections20 + 60 + 60 + 50 + 23 + 20 + 30 = 263 marks

Key Information

Contact Number000 933 4555 · 049 922 2545

Paper information

TitleMemo

SubjectOffice Data Processing

LevelNCV Level 3

Document typeNCV Business

Year2020

MonthFebruary

Pages31

Downloads3

Examination context

Decade2020s

Years ago6y

SeasonSummer (SH)

Start daySaturday

Exam periodFebruary 2020

Days since exam2,443

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 size1.23 MB

Pages31

Archived on8 September 2026

File age46d

ContributorFreeMode

Fingerprint6BF39898D817

Questions and learner discussion

No questions or discussions have been posted yet.