Spreadsheet Assessments 40%
Accounting Assessments 60%

Spreadsheet Assessments

Practical Assessments 30%
Theory Assessment 10%

Accounting Assessments

Completion of Workbook Exercises 40%
Completion of Assignments 20%

Spreadsheet Component

Theory Paper comprising twenty objective
questions (completion, true/false, mix and match, or
multiple choice) based on the applications and
operations associated with spreadsheets generally -
of 10 minute duration (worth 10 marks).

Practical Assessment to consist of THREE
separate assessments of 30 minute duration (each
worth 10 marks) to include topics listed below:

- Invoices totalled (twenty maximum) to include Data,
Invoice No, Client Name, Amount; to test listing, adding, sorting,
formatting/alignment.

- Payroll (maximum number of employees eight) to test
sorting, adding, multiplication, percentages, subtraction, sorting,
formatting/alignment, ruling of lines and editing of same.

- Petty Cash using the Imprest System (maximum of extended
columns five) with a minimum number of voucher entries of twelve, to test
formulas, adding, subtracting, formatting/alignment, ruling of lines - to be
extended, totalled, balanced and Reimbursement Cheque inserted, and editing of
same.

Accounting Software Component

Assessment for the Practical to be based on the
SEVEN exercises in Workbook:

- Lesson 1 and 2 10 marks
- Lesson 3 10 marks
- Lesson 4 10 marks
- Lesson 5 10 marks
- Lesson 6 10 marks
- Lesson 7 10 marks 60 marks scaled to 40%

PLUS a number of separate assessments (minimum two)
based on Accounting 1A concepts to include any of
the following:

INVOICES
goods purchased for cash
goods purchased on credit
goods sold for cash
goods sold on credit

CREDIT NOTES
goods returned - previously purchased for cash
goods returned - previously purchased on credit
goods returned - previously sold for cash
goods returned - previously sold on credit

RECEIPTS
general including receipt of additional Capital

PAYMENTS
general setting up of Petty Cash Imprest System payment of reimbursement of
Petty Cash payment of work-related expenses purchase of Asset for cash

JOURNAL ENTRIES
purchase of Asset on credit
journal entries emanating from a Payroll