Overview:
- Credits:
- 2.5
- Level:
- 4
- Semester:
- Autumn
- Subject:
- Accountancy
- School:
- Business
- Coordinator:
- Mr Michael Hackett
ACC40900 Accounting Analytics 1
Academic Year 2022/2023
This module provides students with an ability to build sophisticated financial models in Excel using advanced functions and techniques.Show/hide contentOpenClose All
Curricular information is subject to change
Learning Outcomes:
After completing this module students should be able to:
- construct, de-bug and analyse complex formulas in excel.
- use range names, scenarios and data tables.
- read/parse data from multiple sources.
- normalise data and perform share simulations
- sort, search, subtotal, group and use data validation.
- query data using multiple criteria.
- use Pivot tables and slicers.
- match data to other data sources and lookup tables.
- visualize data using appropriate graphs and graphics.
- use conditional formatting.
- construct VBA macros and activex controls.
- write user-defined functions.
- link and manage multiple spreadsheets.
- design dashboards and use camera.
- protect cells, files and share data in a secure way.
- use relationships between files and run PowerQueries.
- use Microsoft PowerBI.
- use Microsoft Access database
| Student Effort Type | Hours |
|---|---|
| Computer Aided Lab | 16 |
| Autonomous Student Learning | 49 |
| Total | 65 |
Requirements, Exclusions and Recommendations
Not applicable to this module.
Module Requisites and Incompatibles
Not applicable to this module.
Assessment Strategy
| Description | Timing | Component Scale | % of Final Grade | ||
|---|---|---|---|---|---|
| Class Test: Excel Core EC, Excel Expert EE and Microsoft Access AC MOS tests. 0.5 credits for EC or AC, 1.5 credits for EE. Bonus 0.5 for AC plus either EC or EE. Max possible 2.5. |
Throughout the Trimester | n/a | Alternative non-linear conversion grade scale 50% | No | 100 |
Carry forward of passed components
No
No
| Resit In | Terminal Exam |
|---|---|
| Summer | No |
Feedback Strategy/Strategies
• Feedback individually to students, post-assessment
How will my Feedback be Delivered?
Individual meetings and student reps forum
Discover our Rankings and Accreditations
