Module Overview

Information Management

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

Module Code

BSST H2036

ECTS Credits

5

*Curricular information is subject to change

Information Management and Business Processes

The potential of Information Management for radical business transformationApproaches to process innovation using ISHow 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 LiabilityUnethical versus IllegalCategories of Ethical Issues

Information Security

Threats to Information SecurityVulnerabilitiesProtecting information resourcesRisk ManagementControls

Introduction to Strategic IT Issues

IT PlanningIT Governance

Advanced Electronic Spreadsheets

Revision of Workbook BasicsRevision of standard spreadsheet functions and operationsSpreadsheet Database FeaturesCreating spreadsheet databases, Fields, Sorting, Calculated Fields, Data Forms, Validation, Sub-Totalling, Auto Filter, Advanced Filter, Extracting database records, Database Functions, Data TablesCreating One-variable tables, Two-variable tables, Horizontal & Vertical Lookup TablesPivot TablesCreating and deleting Pivot Tables, Changing the layout and format. Summarizing with totals, formulas and charts. Working with external data.Summarizing DataInserting summary totals in a list. Outlining a worksheet. Consolidating data from multiple tablesAnalysis toolsGoal Seek, Scenarios, and Solver.Excel FunctionsFunction types, Using functions, Trend and Forecast functions, Complex IF functionsMultiple WorkbooksLinked Workbooks, Templates, Handling multiple workbooks, Linking formulae, Comments and hyperlinks, Workbook Protection & AuditingWorkbook 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