This module is designed to develop an appreciation of the importance of information systems within the business environment and to develop students practical skills in the areas of system development and academic research. The key module aims are to : - To provide a broad understanding of the importance of Information Management Systems to modern organisations - To develop the learner’s analytical skills in the development and design of solutions to business IT problems - To provide learners with the skills to plan, design and develop IT solutions using advanced spreadsheet techniques - To develop the learner’s ability to develop a minor IT research project using specified referencing techniques and style guides
Information Management and Business Processes
The potential of Information Management for radical business transformation Approaches to process innovation using IS How Information Management can support Process Change
The Ethical Implications of Information Management
In the context of Information Management this content will address the following: Responsibility, Accountability and Liability Unethical versus Illegal Categories of Ethical Issues
Information Security
Threats to Information Security Vulnerabilities Protecting information resources Risk Management Controls
Introduction to Strategic IT Issues
IT Planning IT Governance
Advanced Electronic Spreadsheets
Revision of Workbook Basics Revision of standard spreadsheet functions and operations Spreadsheet Database Features Creating spreadsheet databases, Fields, Sorting, Calculated Fields, Data Forms, Validation, Sub-Totalling, Auto Filter, Advanced Filter, Extracting database records, Database Functions, Data Tables Creating One-variable tables, Two-variable tables, Horizontal & Vertical Lookup Tables Pivot Tables Creating and deleting Pivot Tables, Changing the layout and format. Summarizing with totals, formulas and charts. Working with external data. Summarizing Data Inserting summary totals in a list. Outlining a worksheet. Consolidating data from multiple tables Analysis tools Goal Seek, Scenarios, and Solver. Excel Functions Function types, Using functions, Trend and Forecast functions, Complex IF functions Multiple Workbooks Linked Workbooks, Templates, Handling multiple workbooks, Linking formulae, Comments and hyperlinks, Workbook Protection & Auditing Workbook protection, Auditing worksheet data, Data validation in worksheets
Advanced Word Processing
Introduction to the Departmental Written Submission standard. Use of Styles, generating a Table of Contents and Tables of Figures/Tables, Generating large documents using Section breaks, Header and Footers in sections, Page numbering in sections. Introduction to academic writing, using the Departmental Referencing Guide, basic research techniques, paraphrasing, avoiding plagiarism, referencing.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |