AERD30010
Source: https://hub.ucd.ie/usis/!W_HU_MENU.P_PUBLISH?p_tag=MODULE&MODULE=AERD30010&TERMCODE=202500&ACYR=2026 Parent: https://hub.ucd.ie/usis/!W_HU_MENU.P_PUBLISH?p_tag=COURSE&MAJR=FAS1&AUDIENCE=
Academic Year 2025/2026
Spreadsheet Modelling and Business Applications (AERD30010)
Subject: : Agribus Extension & Rural Dev
College: : Health & Agricultural Sciences
School: : Agriculture & Food Science
Level: : 3 (Degree)
Credits: : 5
Module Coordinator: : Professor Michael Wallace
Trimester: : Autumn
Mode of Delivery: : On Campus
Internship Module: : No
How will I be graded? : Letter grades
Curricular information is subject to change.
This is an intermediate level module that focuses on spreadsheet modelling techniques in the context of managerial decision making within commercial organisations. The module aims to facilitate students in gaining key computing skills applicable to the business environment. Lectures and practical exercises focus on spreadsheet applications in data analysis and simulation modelling of business decisions. Theory and practice are illustrated with example models in financial analysis and planning, investment appraisal, inventory management and risk analysis.
About this Module
Open All Close All
What will I learn?
Learning Outcomes:
On completion of the module students should be able to: \ Explain the potential roles of spreadsheet modelling in decision support within an organisation; Discuss the structure, conceptual basis and utility of specific models used to support business decision making; Use spreadsheets in key business applications including data analysis and simulation modelling.
Indicative Module Content:
The module includes the following topics:\ (1) Decision support systems and the role of spreadsheet applications\ (2) Introductory concepts in modelling with Microsoft Excel\ (3) Use of functions: mathematical, financial, logical and statistical\ (4) Cost-Volume-Profit model\ (5) Analysis of financial data\ (6) Investment appraisal model\ (7) Inventory management model\ (8) Simulation modelling: validation and verification strategies\ (9) Stochastic simulation models.\
How will I learn?
Student Effort Hours:
| Student Effort Type | Hours |
|---|---|
| Specified Learning Activities | 20 |
| Autonomous Student Learning | 44 |
| Lectures | 12 |
| Practical | 24 |
| --- | --- |
| Total | 100 |
\
Approaches to Teaching and Learning:
The module comprises a mixture of lectures and computer-based practical classes. The practical classes use problem-based learning techniques where students gain the opportunity to apply and practice concepts that have been discussed in lecture classes.
Am I eligible to take this module?
Requirements, Exclusions and Recommendations
Learning Requirements:\
AERD20030 - Business Management (or equivalent)
\
Module Requisites and Incompatibles
Not applicable to this module. \ \
How will I be assessed?
Assessment Strategy
| Description | Timing | Component Scale | Must Pass Component | % of Final Grade | In Module Component Repeat Offered |
|---|---|---|---|---|---|
| Exam (In-person): Theory examination | End of trimester Duration: 1 hr(s) | Graded | No | 40 | No |
| Practical Skills Assessment: Practical Excel Test | Week 12 | Graded | No | 35 | No |
| Quizzes/Short Exercises: Practical exercises | Week 2, Week 3, Week 4, Week 5, Week 6, Week 7, Week 8, Week 9, Week 10 | Graded | No | 25 | No |
\
Carry forward of passed components
Yes
\
What happens if I fail?
| Resit In | Terminal Exam |
|---|---|
| Spring | Yes - 1 Hour |
Please see Student Jargon Buster for more information about remediation types and timing. \
Assessment feedback
Feedback Strategy/Strategies
• Feedback individually to students, post-assessment\
How will my Feedback be Delivered?
Assessment for this module comprises 3 components: in-class exercises (25%); practical exam (35%), and a theory exam (40%). In-class exercises are completed throughout the trimester and students will receive prompt feedback on their performance. This formative feedback supports students' preparation for a practical exam in Week 12. Students will receive feedback on their practical test within a target time of 2 weeks after completion. The end-of-trimester written examination is a summative assessment with each student receiving a grade for their exam and overall module performance. Students can receive feedback on their exam by appointment with the lecturer.
When is this module offered?
Timetabling information is displayed only for guidance purposes, relates to the current Academic Year only and is subject to change.
| Autumn | Lecture | Offering 1 | Week(s) - Autumn: All Weeks | Mon 15:00 - 15:50 |
| Autumn | Computer Aided Lab | Offering 1 | Week(s) - Autumn: All Weeks | Mon 16:00 - 17:50 |