To provide students with a detailed understanding of business processes, the enterprise systems that
enable them and the data structures that underpin them.
Modules in semesters 3 and 4 will focus in on data extraction, preparation and reporting in addition to associate level spreadsheet skills.
Organisations, Business Processes, Information Systems and Enterprise Systems.
The modern global business environment; The Importance of Information Systems; Flows (physical, data, document, information) in Business Processes; The role of Enterprise Systems in Organisations; The financial impacts of process steps; Enterprise Systems and the types of data in them.
The procurement and production processes
Key concepts and assumptions; Basic procurement and production processes; Physical Flows, document and data flows, Information flows. The role of Enterprise Systems in these processes.
Business Process Management (BPM) and Change Management
Business Process Improvement; Business Process Reengineering; Business Process Design; Business Process Modelling; Defining and creating data requirements for operational BPM. Consideration of steps involved in managing Process/System Changes
Information Management
Data Extraction – Simple SELECT Statement, expressions and multiple columns, filtering data, sets (intersections, unions anddifferences), subquery expressions and filters, Aggregate functions (count, sum, avg, max, min), grouping data. Manageworksheets and workbooks - Import data into workbooks (.txt files, .csv files), Navigate within workbooks (Search for data, namedcells, ranges and workbook elements, hyperlinks), Format worksheets and workbooks (page setup, Adjust row height and columnwidth, headers and footers) Customise options and views(Quick Access toolbar, Display and modify workbook content in differentviews, Freeze worksheet rows and columns, Change window views, Modify basic workbook properties, Display formulas)Configure content for collaboration (Set a print area, Save workbooks in alternative file formats, Configure print settings, Inspectworkbooks for issues) Manage data cells and ranges - Manipulate data in worksheets (paste options, Auto Fill, Insert and deleteoptions) Format cells and ranges (Merge and unmerge, cell alignment, orientation, and indentation, Format Painter, Wrap text,number formats, cell styles) Define and reference named ranges (Define a named range, Name a table) Summarize data visually(Sparklines, built-in conditional formatting, conditional formatting)
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 | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |