Computer Practice N6 — Document
November 2019 — N6 — Computer Practice
N6
2019
Nated Business
Preparing document
📋 Document Analysis
See full analysis
Questions — A Preview of What to Expect in the Document
164
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 —
1.1Certain decisions must be made b efore buying a new computer One of them concerns the screen Name FIVE
1.2Name any THREE financing met hods to use when buy ing a computer. ive ONE advantage of each method.
Q2— Section header —
2.1Indicate whether the following statements are TRUE or FALSE Choose the answer and w rite only rue
2.1.1The Display option on the Control Pan el gives you options for changing the sc reen saver
2.1.2Backup is a system tool that saves data on computer s hard drive.
2.1.3The option Connect to a Wireless Network is via Control Panel: Network and Sharing Centre.
2.1.4Changes to t he display or sleep mode of a computer are done via the power options of the Control Panel.
2.1.5The System Defragmenter is used to display the information of the system. (6030196
2.1.6To uninstall programs on the system the option of Programs and Features on the Control Panel must be used
2.1.7Features l ike the Windows Watch, Calendar and Weather are installed via the option Desktop Gadgets on the Control Panel.
2.1.8Physical formatting is also called rela tive or high level formatting.
2.1.9Partitioning splits the hard drive into parts mak ing it appear as multiple drives.
2.1.10The RAM, ROM and cache memory are kn own as the housekeeping areas (10 1\ (10\ (6030196
2.2.1What is the name of this folder?
2.2.2When was this folder created?
2.2.3Where is this folder located on the computer?
2.2.4How many files and folders does this folder contain? (4 1\ (4\ [14] (603019614
Q3— Section header —
3.1.1 n the ANSWER SHEET COLUMN A
3.13rocess of converting information or data into a code, especially to prevent unauthoris ed access Software specifica lly designed to disrupt, damage or gain authoris
4.2Give the reason and/or possible solution of each of the following computer problems: .2.1 Computer has frozen and program s are not responding (2\
13.1.1PRICE = QUANTITY x UNIT PRICE
13.1.2SUBTOTAL = Sum of PRICE
13.1.3VAT @ 15% = 15% of PRICE
13.1.4TOTAL PAYABLE = SUBTOTAL + VAT 14. Insert the following footnote after the word PRICE in the second table (column heading\s indicated (use 1 as footnote number\: Per month for a 24 months contract period
Q7— Section header —
10.6Ensure that there is a page break at the end of the Table of Contents. 11. MANIPULATION OF THE SECOND PAGE: (This page starts with HISTORY.\
11.1The page number must start at 10.
11.2Centre this page vertically.
11.3Sort the paragraph as indicated.
11.4Update the Table of Contents, if necessary. 12. MANIPULATION OF THE LAST PAGE (INDEX\
12.1Change the text INDEX to 16 pt, capital letters, bold and centred. Insert text borders around the text (margin to margin\and apply light grey shading.
12.2Leave TWO line space after the heading INDEX and generate the index with the words below. Do NOT include references to the Table of Contents. Use only main entries. light; transmission; optical fibre; distance;
12.3Page n umbers must be right aligned with tab leader lines. Use TWO columns. 13. 14. Save the document as Q8 OPTIC
Q9— Section header —
9.1Retrieve the spreadsheet FIBRE CONTRACTS that is saved in the COMPUTER PRACTICE N6 STUDENT FILES folder.
9.2Change the font of the spreadsheet to Arial 10 pt, unless instructed otherwise.
9.3Insert your EXAMINATION NUMBER/COMPUTER NUMBER and the QUESTION NUMBER as indicated in the instructions.
9.4Change the page layout to landscape orientation.
9.5Follow the instructions below and on the screenshot. Take ALL the proofreading signs into consideration. Insert ALL text as indicated.
9.6Insert 6 open rows at the top of the spreadsheet.
9.7Format the first row as follows:
9.7.1Merge and centre cells A1 to H1.
9.7.2Set the row height to 3,5 cm/ 1,38
9.7.3Insert the text Fibre Optics Services in Arial 14 pt and align text at the bottom centred.
9.7Insert the text Khawuleza as a WordArt object (Style: Reflection\ in the open space above Fibre Optics Services. If your program version does not have the reflection style available, you may use any shadow effect.
9.7Change the font of the WordArt to Agency FB 40 pt and bold.
9.7.6Ensure the WordArt object does not overlap any current text.
9.7.7Format the cell/row to have a Fill Effect of two colours, vertical shading style (dark to light\
9.8Insert the picture FIBRE LOGO that is saved in the COMPUTER PRACTICE N6 STUDENT FILES folder in row 1 and format as follows:
9.8.1Set th e picture height and width to 2, 54 cm/1''.
9.8.2Align the picture with the right border of column H. (6030196 27 Copyright reserved Please turn over
9.8.3Format the picture to the style Drop Shadow Rectangle.
9.9Insert the text in rows . Use the correct Wingding ymbols.
9.10Use a function to insert the current date and time in cell H3. Display the date and time as indicated in the screenshot. The date and time must update the system date each time the spreadsheet is opened.
9.11Format row 7 as follows:
9.11.1Merge and centre cells A7 to H7.
9.11.2Use a spreadsheet functi on to change the text in row 7 DOWNLOAD 20 UPLOAD 2 MBPS UNCAPPED CONTRACTS\to capital letters
9.11.3Bold row 7.
9.12Format row 8 as follows:
9.12.1Insert the text of the new column headings.
9.12.2Apply text wrap to all headings as indicated in the screenshot.
9.12.3Change all headings to bold.
9.12.4Centre all headings.
9.13Bold all text in rows 16 to 19.
9.14Insert the formulae/functions where letters of the alphabet appear to do the following calculations: The Product price is a monthly fee that the client pays for data services. Assign the range name PRODUCT to the reference table A22:C26.
9.15Copy the formulae/functions to other cells as indicated.
9.16Sort the P roduct code and the corresponding data in ascending order.
9.17Display the Product price, Router price, Router price per month, Estimated yearly fees, T otal, Average product price and H ighest estimated yearly fees as currency with TWO decimals.
9.18Display the N umber of clients as an integer.
9.19Apply all vertical and horizontal borders as indicated.
9.20Adjust the column widths and row heights to display all data correctly (as indicated on the screenshot\ou may adjust the margins if necessary.
9.21Save
Q9— Section header —
9.22Print the spreadsheet without row and column headings in landscape orientation on ONE page. Place the PRINTOUT in your EXAMINATION FOLDER. (6030196 29 Copyright reserved
Q9— Section header —
9.1Retrieve the spreadsheet
Q9— Section header —
9.2Change the question number in the header to 9B.
9.3Display row and column headings.
9.4Delete the picture.
9.5Hide the reference tables in rows 21 to 29.
9.6Hide columns A to D.
9.7Display the formulae.
9.8Change the column widths and row heights so that ALL formulae are legible.
9.9You may adjust the margins, if necessary, to fit the spreadsheet one landscape page.
9.10Save the spreadsheet as QUESTION 9B FIBRE CONTRACTS.
9.11Insert the file name of the spreadsheet at the bottom centre of the footer.
9.12Centre the spreadsheet horizontally and vertically on the page.
9.13Print the spreadsheet with row and column headings and centred on ONE landscape page. Place the PRINTOUT in your EXAMINATION FOLDER. (28\ [70]70
Q10— Section header —
10.1Create the spreadsheet by following the instructions below and on the screenshot. Take all proofreading signs into consideration.
10.2Use Arial 10 pt, unless instructed otherwise.
10.3Insert your EXAMINATION NUMBER/COMPUTER NUMBER and the QUESTION NUMBER as indicated in the instructions.
10.4Change the page layout to landscape orientation.
10.5Insert the text as indicated on the screenshot. (6030196 31 Copyright reserved Please turn over
10.6Insert the company name, Khawuleza Fibre Optic Services, in bold in A1 using Agency FB 40 pt.
10.7Insert the text FINANCIAL PLANNING in A3 in Arial 14 pt and bold.
10.8Merge and centre the following cells: A5:B5 D5:E5 A14:B14 D14:E14. Insert the text in capital letters as indicated on the screenshot. Format these
10.9Insert the rest of the text in rows 6 20.
10.10Insert the column headings in row 22 in capital letters , bold and italics. Centre all these headings.
10.11Copy the names of the clients from the file FIBRE CONTRACTS that is saved in the COMPUTER PRACTICE N6 STUDENT FILES folder . Paste these names
10.12Insert the text in cell A30 in bold and italics as indicated on the screenshot.
10.13Insert the values of DISTANCE TO HOUSE (M\n cells B24 B29 as integers.
10.14Insert formulae/functions where letters of the alphabet appear to do the calculations below. Use absolute cell reference where applicable when referring to values. Use the values in B6 to B8 and the appropriate spreadsheet function to
10.15Copy the formulae/functions to the other cells as indicated.
10.16Display all monetary values as currency with TWO decimals.
10.17Display ANNUAL INTEREST RATE values as percentage with ONE decimal.
10.18Display TERM OF LOAN (YEARS\TERM OF INVESTMENT (YEARS\ CONTRACT TERM (YEARS\nd DISTANCE TO HOUSE (M\s integers.
10.19Display all borders as indicated on the screenshot.
10.20Adjust the column widths and row heights to display all data correctly as in dicated on the screenshot. You may adjust the margins if necessary.
Q10— Section header —
10.22Print the spreadsheet without row and column headings in landscape orientation on ONE page. Place the PRINTOUT in your EXAMINATION FOLDER. (6030196 33
Q10— Section header —
10.1Retrieve the spreadsheet QUESTION 10A FINANCE.
10.2Change the question number in the header to 10B.
10.3Display row and column headings.
10.4Display gridlines.
10.5Hide column A.
10.6Hide rows 1 4.
10.7Display the formulae.
10.8Change the column widths and row heights so that ALL formulae are legible.
10.9Save the spreadsheet as QUESTION 10B FINANCE.
10.10Print the spreadsheet with row and column headings and gridlines in landscape orientation on ONE page. Place the PRINTOUT in your EXAMINATION FOLDER. (30\ [65]65
Q11— Section header —
11.1Retrieve the spreadsheet ISP SURVEY that is saved in the COMPUTER PRACTICE N6 STUDENT FILES folder. The table provides an overview of the results of a customer survey with scores out of 10. Only ISPs which received a
11.2Create a MIXED/COMBO CHART to display the alue for money, etwork quality, upport and billing and
11.3Display the verage as a line chart and alue for money, etwork quality, upport and billing
11.4Use a spreadsheet instruction to move the chart to a new sheet.
11.5Insert your EXAMINATION NUMBER/COMPUTER NUMBER and the QUESTION NUMBER as indicated in the instructions. (6030196 35 Copyright reserved
11.6Insert the following chart title in 2 rows as indicated:
11.6.1TOP FIVE ADSL AND FIBRE ISPs IN SOUTH AFRICA Survey by: MyBroadband
11.6.2he 1 st line of the title must be in Agency FB 18 pt and bold.
11.6.3he 2 nd line of the title must be in Century Gothic 10 pt.
11.7Insert the following axis titles:
11.7.1Vertically rotated title: RATING
11.7.2Horizontal title: SA INTERNET SERVICE PROVIDERS
11.8Display the data labels as follows:
11.8.1Display labels for the alue for money series as data callouts above the chart. Display only the values.
11.8.2Show labels for the line chart below the line.
11.9Display the legend as follows:
11.9.1Place the legend above the chart plot area without overlapping the plot area.
11.9.2Ensure the legend display the series correctly: Value for oney, Network uality, Support and illing
Q11— Section header —
11.11Print the chart as a new sheet in landscape orientation. Place the PRINTOUT in your EXAMINATION FOLDER. [15] TOTAL SECTION C: 150 GRAND TOTAL: 20015
Q1— Section header —
Q2— Section header —
Q3— Section header —
Q4— Section header —
Q1— Section header —
1.1(5 1\ (5\
1.2Method Advantage Method Advantage (6030196\
Q2— Section header —
2.1.10
2.2.414
Q3— Section header —
3.113. 12
3.1
4.1.2(2 2\ (4\
4.2.1(2\ (6030196\ Copyright reserved ANSWER SHEET EXAMINATION NUMBER:
4.2.2(3\
4.2.312
Topics Identified
4
Business EnvironmentsForms of OwnershipBusiness FunctionsBusiness Plan
Mark Allocation
Total200 marks
Sections11 + 14 + 13 + 12 + 32 + 31 + 27 + 70 + 65 + 15 + 14 + 12 = 316 marks
Key Information
Email Addressinfo@khawulezafibre.com
Websitewww.khawulezafibre.com
Paper information
TitleDocument
SubjectComputer Practice
LevelN6
Document typeQuestion paper
Year2019
MonthNovember
Pages39
Downloads5
Examination context
Decade2010s
Years ago7y
SeasonSpring (SH)
Start dayFriday
Exam periodNovember 2019
Days since exam2,536
About Computer Practice examination preparation
Computer Practice tests practical proficiency with productivity software and basic computer literacy. The examination combines theoretical knowledge with practical application.
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.
software proficiency
interpreting computer instructions
accurate output reproduction
file management
applying computer theory
A practical revision approach
Practice using the software features that appear in the examination. The memorandum rewards correct feature identification, accurate output, and proper file management techniques.
File details
File size1.27 MB
Pages39
Archived on8 September 2026
File age47d
ContributorFreeMode
Fingerprint2DAFC02C121C
Questions and learner discussion
Log in to ask a question or leave a review.
No questions or discussions have been posted yet.