Computerised Financial Systems N6 — Document

November 2019 — N6 — Computerised Financial Systems

N6 2019 Nated Business

↓ Download PDF 📄 399.4 KB

Preparing document

📋 Document Analysis

🎯 2 marks ⏱️ 3h 📄 6 pages 📝 98 items found 📚 2 topics

See full analysis

Questions — A Preview of What to Expect in the Document

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.1ou are the new accountant of AL who wants to computerise their books on the Pastel program.

1.1.1Create a new set of accounts named ALI. NOT use the setup assistant. Select File, New New Company Name

1.1.2Use the given account nu mbers to create the following general ledger accounts. Link each account to the correct eport riter category. ACC

1.1.3Use Receipt as a description in the cash receipt j ournal and Payment as a description in the cash payment j

1.1.4Do NOT print the ash journal b atch listings

1.1.5Post (update\e cash journals to the general l edger.

1.1.6Print the entry type details of the cash receipt journal and the cash payment j ournal for June 2019, period 12 on

1.2.1Use the b udge t assistant to enter the following budgeted amounts for the incomes and expenses for June 2019: Current income: Services r endered 140 000 Commission received

1.2.2NOT print this budget.

1.2.3Export one trial balance on 30 June 2019 from Pastel to Excel to show the account balances as well as the budgeted amounts. Print zero it ems

1.2.4NOT print the trial balance yet

1.2.5Do the following in Excel before you print the trial balance (a\ (b\ (c

1.2.6NOT make any other changes to the trial balance.

1.2.7Save the spreadsheet as Trial B alance

1.2.8rint on ONE landscape oriented page. (28\ 6030186

1.3.1Use the Report Writer to create the following financial report from scratch by using the following report format: Report headings: Line

1.3.2Use the Report Writer Assistant to make a Pastel PRINTOUT of the financial report , with Index Description MY SUMMARY (created

Q1— Section header —

1.3.3ote that this report mus t NOT be exported to Excel before printing.

1.3.4Make sure that you have printed your own report, as NO marks will be awarded if you print and hand in ONE f the existing Pastel reports. (19\

1.4.1Use t he Report Writer Assistant again to make a Pastel PRINTOUT of the report format of the financial report with Index

Q1— Section header —

1.4.2Note that this re port must NOT be exported to Excel before printing.

1.4.3Make sure that you have printed your own report format, as NO marks will be awarded if you print and hand in the format of ONE of the existing Pastel reports. 11\ [77]77

Q2— Section header —

2.1Cash b udget: The bookkeeper of Nina's Shebeen got very sick and you are appointed as the temporary bookkeeper for three months. On investigation of her work, you discovered that

2.1.1Use the given information to do the calculation of the receipts from debtors during April 2019.

2.1.2Show ALL calculations clearly as NO marks will be awarded for a single answ er only

2.1.3Do NOT draft the cash b udget of Nina's Shebeen for April 2019.

2.1.4Clearly indicate the final answer by typing 'Received during April 2019' next to it.

2.1.5Display ALL amounts as integers.

2.1.6Insert as a header: our EXAMINATION NUMBER (left\and PRINTOUT 5 (right\

2.1.7Save the document as Cash

2.1.8rint on ONE landscape oriented page. (13

2.2Contracts The following information was extracte d from the financial records of Jozi Building Contra ctors for the year ending 30 June 2019: Contract price

2.2.1Jozi Building Contractors supplied their previous contract cost tatement to you to use as a n e xample. Type this example exactly as given: Contract cost s tatement for the year ended:

2.2.2Remember to change the date of the old example to the current year and ensure that this date appears in bold and in exactly the same format a the example.

2.2.3Since Jozi Building Contractors did not use any subcontractors during last year, you have to add subcontractors to the statement for this year. Display ALL amounts as integers with a thousand separator.

2.2.4Insert your EXAMINATION NUMBER as a left header and PRINTOUT 6 as a right header.

2.2.5Save the document as C ontract

2.2.6rint on ONE portrait oriented age. (23\ [36]36

Q3— Section header —

3.1Ad vanced Excel You work for the City of Cape Town and were asked to prepare a s chedule to investigate load shedding during July

3.1.1Type the following schedule exactly as given. Do NOT typ e the column (A, B, C, etc.\ and the row (1, 2, 3, etc. \headings in the shaded areas. It is only an indication of the columns and rows to be used.

3.1.2Centre the main heading in row 1 over the width of the spreadsheet. Display this heading in bold and font size 16 pt

3.1.3Centre the heading in row 2 over columns D, E and F (as shown\

3.1.4Centre and wrap the column headings in row 3.

3.1.5Sort the su burbs (in ONE step \in ascendi ng order according to the phase and then chronologically (Mon

3.1.6The following table shows how long the power will be off during each phase. Type the relevant times (as determined by the phase, in time format\in the DURATION OFF column, where question marks appear.

3.1.7EXPECTED TIME ON is the time that the power is expected to be switched back on after the load shedding. Use cell references to calculate the

3.1.8Add the following TWO columns to the schedule (in row 3\ COST PER HOUR TOTAL COST

3.1.9The following table shows the cost to businesses per hour that the power is off. Type the relevant cost (as determined by the day of the week\ in the COST PER HOUR column ( column G\ DAY COST PER HOUR

3.1.10Use cell references to calcul ate the TOTAL COST in column H. TOTAL COST is the number of hou rs (in DURATION OFF\

3.1.11Display the amounts in column G and H with the South African currency and TWO decimals.

3.1.12Insert any neat horizontal and vertical lines. Do NOT print the row and c olumn headings.

3.1.13Insert your EXAMINATION NUMBER as a left header and PRINTOUT 7 as a right header.

3.1.14Save the spreadsheet as A dvanced

3.1.15rint the spreadsheet on ONE landscape oriented page (24\

3.2Formulae

Q3— Section header —

3.2.2Adjust column widths to fit the spreadsheet on ONE landscape oriented page. Ensure that ALL information is still visible.

3.2.3Hide column D (TIME CUT\d COLUMN E (DURATION OFF\. 6030186 14 Copyright reserved

3.2.4Use the filter function to display only the suburbs that experience load shedding on a Tuesday and a Thursday.

3.2.5Do NOT use the fit to one page option, as NO marks will be awarded for printing smal ler than 100% Arial or Calibri 10 pt or

3.2.6Save the changed document as F ormulae

3.2.7rint (with row and column headings\ on ONE landscape oriented pa ge. (11\

Q4— Section header —

4.1Breakeven table The following information was extracted from the books of Ramaphosa Designs: Number of units sold 000 units Total sales R400

4.1.1raw a table with the following columns: UNITS FIXED COST TOTAL COST SALES

4.1.2Show the following number of units in the table: 000, 2 000, 3 000, 4 000 , 5 000, 6 000, 7

4.1.3Insert any neat horizontal and vertical lines to enhance the appearance of the table.

4.1.4Display AL L amounts as integers with the r and currency sign.

4.1.5Insert your EXAMINATION NUMBER as a left header and PRINTOUT 9 as a right header.

4.1.6Save the docume nt as Table

4.1.7rint on ONE portrait oriented age. (15\

4.2Graph

Q4— Section header —

4.2.2Show the number of units on the axis of the graph and the other THREE columns of the table as lines on the line graph

4.2.3Insert the following headings above the graph over TWO lines as indicated below RAMAPHOSA DESIG NS BREAKEVEN ANALYSIS

4.2.4Insert app ropriate titles for the and axi s.

4.2.5Remove the legend of the graph.

4.2.6Insert a text box next to each line on the line graph and type in these text boxes what each line represents.

4.2Insert ONE arrow on the graph that points directly at the breake ven point.

4.2.8Insert your EXAMINATION NUMBER and PRINTOUT 10 as a centred footer.

4.2.9Sa ve the graph as G raph

4.2.10Print the graph on a separate landscape oriented sheet. (16\ [31] 603018631

Q5— Section header —

5.1Use the given example to complete the w age journal for the week ended 28 October 2019:

5.2Centre the heading over the width of the journal.

5.3Wrap and centre the column headings as shown.

5.4Display the percentages for the deductions exa ctly as shown.

5.5Use formulae and cell references to complete the wage journal. Use the percentages given in the journal.

5.6Display ALL amounts with TWO decimals in South African currency.

5.7Insert any neat horizontal and vertical lines.

5.8Insert your EXAMINATION NUMBER (left\and PRINTOUT 11 (right\as a header.

5.9Save the document as W age

5.10Print on ONE landscape p age. [21] TOTAL: 200 Wage journal for the week ended 28 October 2019 Gross wage Deductions21

Topics Identified

Forms of OwnershipBusiness Plan

Mark Allocation

Total200 marks

Sections77 + 36 + 35 + 31 + 21 = 200 marks

Paper information

TitleDocument

SubjectComputerised Financial Systems

LevelN6

Document typeQuestion paper

Year2019

MonthNovember

Pages16

Downloads5

Examination context

Decade2010s

Years ago7y

SeasonSpring (SH)

Start dayFriday

Exam periodNovember 2019

Days since exam2,535

About Computerised Financial Systems 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 size399.4 KB

Pages16

Archived on8 September 2026

File age45d

ContributorFreeMode

FingerprintD26F983A934F

Questions and learner discussion

No questions or discussions have been posted yet.