Module Descriptors
BUSINESS INFORMATION SYSTEMS IN ORGANISATIONS
COIS41163
Key Facts
Digital, Technology, Innovation and Business
Level 4
30 credits
Contact
Leader: Euan Wilson
Hours of Study
Scheduled Learning and Teaching Activities: 84
Independent Study Hours: 216
Total Learning Hours: 300
Assessment
  • 2500 WORD REPORT weighted at 50%
  • TEST weighted at 50%
Module Details
INDICATIVE CONTENT
Introduction to information systems (IS)
Use of IS for strategic, tactical and operational decision making
Business functions and supply chains. Supply chain management
Managers and their information needs
Business intelligence and knowledge management
Introduction to collaborative systems (e.g.MS Sharepoint)
The web enabled enterprise
Global information systems
Choices in systems acquisition
Risks, security and disaster recovery
Green IT
Ethical issues in IT

The second half of the module will utilise some of the advanced spreadsheet functions and features available to aid modelling/analysis/decision making for quantity based problems. Those met will include amongst others: a range of functions to aid modelling, lookup functions for value selection, array formulae for criteria based analysis, customising worksheet interfaces, solver for problem optimisation, sensitivity analysis using scenarios and data tables, and pivot tables for cross tabulations.
Students will also be introduced to VBA macros together with some basic tools of programming enabling the automation of processes within a spreadsheet. Principles met will include: recording macros, editing macros, use of message boxes and input boxes to allow interaction with the user, if statements, for each and do loops, an introduction to forms, and the development of personalised functions.

ADDITIONAL ASSESSMENT DETAILS
1 – 50% 2,500 word report that analyses the strategic, tactical and operation decision making in a business and proposes solutions. The report will contain prototype interfaces showing what the system would deliver. The assignment does not require the development of working systems but a clear explanation of the proposed navigation, intended user covering learning outcomes 1 to 3.

2 - 50% test comprising two one-hour 15 minute tests assessing Learning Outcomes 4 & 5.

The test is the final assessment point.

PLEASE NOTE ALTERNATIVE ASSESSMENTS FOR Semester 1 2020/21 DUE TO COVID-19 AS FOLLOWS: 2500 word report (50%), Coursework 1 (25%), Coursework 2 (25%)
REFERRING TO TEXTS
Laudon, L. a., 2012. Management information Systems : Managing the Digital Firm. 12th ed. s.l.:Pearson. ISBN: 978-0-27-375453-4

Walkenbach, J., 2013. Excel 2013 Bible. s.l.:Wiley. ISBN: 978-0470474877
ACCESSING RESOURCES
MS Sharepoint.
SPECIAL ADMISSIONS REQUIREMENTS
None.
LEARNING OUTCOMES
1) APPLY KNOWLEDGE OF DIFFERENT TYPES OF INFORMATION SYSTEM IN SUPPORT OF STRATEGIC PLANNING WITHIN AN ORGANISATION.
Application, Knowledge & Understanding

2) DEMONSTRATE AN UNDERSTANDING OF THE INFORMATION REQUIREMENTS AND SOCIAL, LEGAL AND ETHICAL ISSUES FOR MANAGEMENT DECISION MAKING IN ORGANISATIONS.
Knowledge & Understanding, Learning

3) ANALYSE A BUSINESS SCENARIO AND DEVELOP A PROTOTYPE INFORMATION SYSTEM
Analysis, Problem Solving

4) APPLY UNDERSTANDING OF SPREADSHEET MODELLING TO ENABLE THE ANALYSIS OF QUANTITATIVE BASED PROBLEMS.
Analysis, Application, Knowledge & Understanding, Problem Solving

5) DEVELOP SIMPLE VBA MACROS TO AUTOMATE SPREADSHEET OPERATIONS.
Analysis, Application, Knowledge & Understanding, Problem Solving

Module Learning Strategies
"In semester 1 students will be provided with a broad overview of the indicative content and demonstrations of good practice in a variety of topics. Learning support material will be provided. The practical nature of the module is covered by practical tutorials. Weekly formative assessments will support the learning (13 lectures and 36 tutorials).

In Semester 2, students will experience 26 hours of computer based in-class practical sessions (2 hours per week). There will be a further 13 hour of class contact (1 hour per week) with the whole group some weeks of a lecture and other weeks of additional practical time.
Independent study time will be spent completing the worksheets, further practising the methods met in class, and preparing for assessments.
"