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 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 |