MODULE 1 MASTERING A SPREADSHEET PROGRAM
Starting point
Unit 1.1 Function of a spreadsheet
Unit 1.2 Use of a spreadsheet manual
Unit 1.3 The Help function
Unit 1.4 Application of spreadsheet commands and formulas
What you have learned and where to next
Revisiting learning outcomes
Assessment
MODULE 2 FINANCIAL ACCOUNTING APPLICATIONS ON A SPREADSHEET
Starting point
Unit 2.1 Stock keeping on a spreadsheet
Unit 2.2 Inventory valuation on a spreadsheet
What you have learned and where to next
Revisiting learning outcomes
Assessment
MODULE 3 FINANCIAL STATEMENTS APPLICATIONS ON A SPREADSHEET
Starting point
Unit 3.1 The Statement of Comprehensive Income (Income Statement)
Unit 3.2 The Statement of
Financial Position (Balance Sheet)
Unit 3.3 The Statement of Cash Flow
What you have learned and where to next
Revisiting learning outcomes
Assessment
MODULE 4 BASIC COST AND MANAGEMENT ACCOUNTING APPLICATIONS ON A SPREADSHEET
Starting point
Unit 4.1 Manufacturing Cost Statement with specific sections
Unit 4.2 Manufacturing Cost Statement with specific columns
Unit 4.3 Manufacturing Statement of Comprehensive Income
What you have learned and where to next
Revisiting learning outcomes
Assessment
MODULE 5 ANALYSIS AND INTERPRETATION OF FINANCIAL STATEMENTS ON A SPREADSHEET
Starting point
Unit 5.1 Financial statement interpretation
Unit 5.2 Use data from financial statements to calculate and interpret information
What you have learned and where to next
Revisiting learning outcomes
Assessment
MODULE 6 FINANCIAL REPORTS (REPORT WRITER) ON AN ACC PACKAGE (PASTEL PARTNER)
Starting point
Unit 6.1 The setting
of
the necessary computer parameters for opening a new set of accounts
Unit 6.2 The set-up of the General Journal and other journals with relevant codes and parameters
Unit 6.3 Creating General Ledger accounts with codes and parameters
Unit 6.4 Input of balances for General Ledger accounts
Unit 6.5 Process, print and update the General Journal
Unit 6.6 Standard parameters for the compilation of financial and management reports on a Gen Ledger
Unit 6.7 Preparation and presentation of computerised financial and management reports
Unit 6.8 Export (transfer) of Report Writer data from an accounting package to a spreadsheet
What you have learned and where to next
Revisiting learning outcomes
Assessment
MODULE 7 BUDGETS ON AN ACCOUNTING PACKAGE (PASTEL PARTNER)
Starting point
Unit 7.1 Set up parameters for a budget system
Unit 7.2 Input (enter) of budget items
Unit 7.3 Percentage adjustments and rounding on the budget
Unit 7.4
Compare a budget with actual figures
Unit 7.5 Export (transfer) of budgeted data from an accounting package to a spreadsheet
What you have learned and where to next
Revisiting learning outcomes
Assessment
Exemplar Examination
Glossary
Index