This module builds on the Enterprise Systems module and is intended to give the student a good understanding and practical use of Spreadsheet and Data Source tools that can be used to help monitor integrated business processes and select processes for improvement projects. It also introduces the student to advanced Spreadsheet and Data Source tools for the creation of Business Intelligence.
Modules in semesters 1 & 2 will focus of communication and presentation applications in addition to spreadsheet skills.
The Fulfilment Process
Key concepts and assumptions; The Basic Fulfillment Process; The roles of Enterprise Systems in the fulfillment process; Fundamentals of data for the fulfillment Process.
Integrating the procurement, fulfilment and production processes. The roles of Databases and Enterprise Systems in executing integrated processes.
Using ICT to Improve Processes
Using ICT to improve processes. IS as a hindrance to process improvement. How management improve processes.
Advanced Information Management
Manage tables and table data - Create and format tables (create from cell ranges, Apply table styles, Convert tables to cellranges) Modify tables (Add or remove table rows and columns, Configure table style options, Insert and configure total rows)Filter and sort table data (Filter records, Sort data by multiple columns) Perform operations by using formulas and functions -Insert references ( relative, absolute, and mixed references, use of named ranges and named tables in formulas), Calculate andtransform data (calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions, Count cells by using the COUNT(),COUNTA(), and COUNTBLANK() functions, conditional operations by using the IF() function) Format and modify text (use ofRIGHT(), LEFT(), and MID() functions, UPPER(), LOWER(), and LEN() functions, CONCAT() and TEXTJOIN() functions) Managecharts - Create charts (charts and chart sheets) Modify charts (Add data series to charts, Switch between rows and columns insource data, Add and modify chart elements) Format charts (chart layouts, chart styles, Add alternative text to charts foraccessibility)
Modules delivered in the Data Management and Business Intelligence pillar are designed to underpin and support the accountant. The skills gained in the modules are directly applicable to their future roles in the accounting profession. In assessing the skills levels we will test the students’ abilities to apply the skills and techniques learnt to real world scenarios relevant to the accounting profession. The pillar has been developed to ensure an IT presence through each semester and each module builds on the preceding ones. In delivery of this pillar we will use applied learning approaches to enable students have a professional level of expertise in the use and application of spreadsheet tools. The student experience in the computer laboratories will reflect, as close as possible, the range of tools, application packages and practices that they will experience in work environment. Joint assessment will be carried out in conjunction with modules from the Decision Making and Risk Analysis, Compliance (Law & Tax), Financial Accounting & Reporting and finally Economics & Finance pillars, where practical. A key tenet of the pillar is the transfer of skill sets developed in the Data Management pillar into all aspects of the student activities and study in other pillars. We will use productivity tools in support of professional communications in the work environment.
|Module Content & Assessment