Faculty
: Faculty of Accountancy
Course Program
: Diploma in Accountancy
Course subject
: Computerized Accounting (AIS 280)
Semester
:
Resource person
: Mrs.Zuraini Yaakob
1.0 OBJECTIVE
This course is designed to enable learners to have exposure and experience on how to apply spreadsheet software in the area of Financial Accounting, Management
Accounting and Financial Management, to set up computerized accounting information system for businesses and provide basic knowledge on Accounting
Information System, the comparison between manual and computer based transaction processing, accounting records, risk exposures in Computer Based
Information System (CBIS), what are the Internal Control Structure (ICS), security measures in CBIS and data coding in computer-based systems.
2.0 ASSESMENT:
Continuous assessment
50%
Final examination
50%
Total
100%
3.0 SYLLABUS CONTENT
3.1 Introduction to Accounting Information System (AIS)
3.1.1
Overview of AIS
3.2 About MYOB
3.2.1
Creating a New Company File
3.2.2
The Banking Command Centre
3.2.3
Recording Journal
3.2.4
Setting up for Sales and Purchases
3.2.5
Managing Purchases
3.3 Managing Sales
3.4 Managing Inventory
3.5 Report and File Maintenance
3.6 Controlling the Computer Based Information Systems (CBIS)
3.6.1
Risk exposures
3.6.2
Internal Control
3.6.3
Security measures in CBIS
3.6.4
Data Coding in Computer-based systems
3.7 Overview of Microsoft Excel 2000 functions and keys applications
3.8 Excel Application in Financial Accounting
3.9 Automated Financial Statement
3.10 Financial Statement Analysis
3.11 Account Receivable Aging Report
3.12 Inventory Valuation
3.13 Advance Features of Microsoft Excel
3.14 Depreciation on Fixed Assets
3.15 Excel Application in Management Accounting
3.16 Excel Application in Financial Management