Course Details

ACCOUNTING SYSTEM ANALYSIS AND DESIGN

About this Course

This course covers the phases of systems development life cycle (SDLC) that includes systems planning, analysis, design, evaluation and selection, conversion and implementation, and system maintenance. This course also covers project management software and data analysis using spreadsheet together with basic programming language for data visualization.

Course Learning Outcomes

1) Explain theories related to Accounting Information System (AIS) for business organization
2) Display digital skills in tasks related to accounting systems and software
3) Demonstrate communication skills in tasks related to accounting systems analysis and design

Course Syllabus

+ Course Syllabus

1) Introduction to Systems Development & System Analysis
Introduction
System Development Life Cycle
System Planning
Feasibility Analysis
Behavioral Aspect of Change
Systems Analysis
Roles of accountant in SDLC

2) AIS Development Strategies
Introduction
Purchasing Software
In-House Development
Outsourcing the System
Business Process Management
Prototyping
Computer-Aided Software Engineering

3) Systems Design, Implementation and Operation Introduction
Conceptual Systems Design
Evaluate Design Alternatives
Physical Systems Design
Systems Implementation
Systems Conversion
Operation and Maintenance

4) Project Management Software
Introduction to Project Management Software
Using Project Management Software In System Planning

5) Data Management and Analysis
Accounting Data Analysis Using Spreadsheet Software
-Introduction to Spreadsheet Functions
-Advanced Functions and Formulas
-Lookups and Data Tables
-Presenting Data Using Charts
-Analyzing Data Using Pivot Tables, Pivot Charts and Filter
-Data Import, Export & Preparation
-Introduction to Macros & Mail Merge

Basic Programming Language for Interface, Data Automation & Manipulation
-Introduction to Programming Concept
-Understanding Variables, Conditions & Loops
-Using Cells, Ranges and Other Objects
-Automated Dashboard Creation

6) Current Issues in AIS
Fintech
XBRL
Green IT
Other current issues