Skip to main content

IB94W - Spreadsheet Modelling

  • Module code: IB94W
  • Module name: Spreadsheet Modelling
  • Department: Warwick Business School
  • Credit: 15

Content and teaching | Assessment | Availability

Module content and teaching

Principal aims

This module recognises the essential role that computing plays in Operational and Business Analysis projects, and the need for the students to develop hands on experience, good modelling and design skills and an understanding of the role of popular business computing tools. It includes both a top-down conceptual modelling/design and a bottom-up skills based course. The module demonstrates and develops both conceptual and practical understanding of the fundamental computing tool of spreadsheets and the problems they can address. There is an emphasis on OR applications such as simulation, stochastic and data management processes. The module aims to promote good analysis and design skills so that the student can build or specify applications that both meet the requirements and are usable and well documented. To this end the focus includes both methodological rigour and practical problem-solving techniques, and includes computer programming for control and usability of custom applications.

Principal learning outcomes

Subject Knowledge and Understanding: Understand the capabilities and contribution that computer-based spreadsheets can offer in operational and business analysis projects; Design a functional, well structured, documented and usable spreadsheet application.Key Skills: Implement a functional, well structured, documented and usable spreadsheet application; Work collaboratively towards application design. Cognitive Skills: Design and write simple computer programs.Subject Specific/Professional Skills: Know how to develop and use a spreadsheet for investigating a problem situation.

Timetabled teaching activities

Total contact hours: 30 hours. Lectures per week: 18 hours. Directed study: 14 hours. Laboratory sessions: 8 hours. Module duration (weeks, if applicable): 12 x half day sessions over 6 weeks.

Departmental link

https://my.wbs.ac.uk

Module assessment

Assessment group Assessment name Percentage
15 CATS (Module code: IB94W-15)
A (Assessed work only) Spreadsheet Design (group 1500 word report) 25%
  Spreadsheet Model and Report (2000 words) 75%

Module availability

This module is available on the following courses:

Core
  • Postgraduate Taught Business Analytics and Consulting (N1N2) - Year 2
  • Postgraduate Taught Business Analytics (N1N3) - Year 2
Optional Core

N/A

Optional
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G300) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G300) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30A) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30A) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30A) - Year 5
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30B) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30B) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30B) - Year 5
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30C) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30C) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30C) - Year 5
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30D) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30D) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (G30D) - Year 5
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30E) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30E) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30E) - Year 5
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30F) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30F) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30F) - Year 5
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30G) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30G) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30G) - Year 5
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30H) - Year 3
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30H) - Year 4
  • Undergraduate Master of Mathematics,Operational Research,Statistics and Economics (with Intercalated (G30H) - Year 5