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
Autonomous Student Learning

49

Computer Aided Lab

16

Total

65

Requirements, Exclusions and Recommendations

Not applicable to this module.


Module Requisites and Incompatibles
Not applicable to this module.
 
Assessment Strategy  
Description Timing Open Book Exam Component Scale Must Pass Component % 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
 
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

Autumn
     
Lecture Offering 1 Week(s) - 11 Tues 11:30 - 13:20
Lecture Offering 1 Week(s) - 3, 5, 6, 7, 8, 9, 12 Tues 14:30 - 16:20
Autumn
     

Discover our Rankings and Accreditations