CAPP06040 2022 Advanced Business Technology for Accountants
Full Title
Advanced Business Technology for Accountants
Transcript Title
Adv Bus Tech for Accountants
Code
CAPP06040
Attendance
N/A %
Subject Area
CAPP - Computer Applications
Department
BUS - Business
Level
06 - NFQ Level 6
Credit
05 - 05 Credits
Duration
Semester
Fee
€
Start Term
2022 - Full Academic Year 2022-23
End Term
9999 - The End of Time
Author(s)
Kerry Dolan, Carmel Sheehan
Programme Membership
SG_BACCO_H08 202200 Bachelor of Arts (Honours) in Accounting
SG_BFINA_H08 202200 Bachelor of Business (Honours) in Finance and Investment
SG_BACOO_H08 202300 Bachelor of Arts (Honours) in Accounting
SG_BFINA_B07 202200 Bachelor of Business in Finance and Investment
SG_BFINA_B07 202200 Bachelor of Business in Finance and Investment
Description
This module provides students with an understanding of and practical experience in the use of Excel and Access applications. The student will be able to model real world problems using spreadsheets and will also learn how to manipulate a database effectively. The student will acquire an understanding of the theoretical aspects of the business environment.
Learning Outcomes
On completion of this module the learner will/should be able to;
1.
Design and implement spreadsheet models based on real world scenarios
2.
Use a wide range of spreadsheet functions used in a business environment
3.
Using a database - create tables, forms, queries and reports
4.
Acquire a knowledge of the theoretical aspects of the business environment.
Teaching and Learning Strategies
- Practical demonstrations
- Lectures
- Class discussions
- Case studies
- Audio/video clips will be used to facilitate the learning process
Module Assessment Strategies
- Practical in-class assessments
- Multiple choice assessments
Repeat Assessments
If the students do not pass the module in full, they must repeat whatever element they have failed.
Indicative Syllabus
LO1 - Design and implement spreadsheet models based on real world scenarios
- Taking a text based problem and building it in excel
- Structuring a spreadsheet - design, layout, presentation
- Model real world problems. This should reinforce problem based learning
LO2 - Use a wide range of spreadsheet functions used in a business environment
- Dealing with risk and uncertainty: sensitivity analysis, goal seek, scenarios, data tables
- Functions - financial, date & time, statistical, lookup & reference, text, logical
- Absolute and relative cell referencing
- Manipulating data - sort, filter, validation, pivot tables
- Presentation and interpretation of information - charts (selection, formatting, labelling, etc.)
LO3 - Using a database - create tables, forms, queries and reports
- Examining existing relational database designs
- Adding a simple table to an existing database
- Creating forms for inserting/editing data
- Creating queries to manipulate data
- Creating reports for presentation & display
LO4 - Acquire a knowledge of the theoretical aspects of the business environment.
- Cyber Security - Purpose. Intentional/unintentional threats. Difficulties in protecting information systems. Cyber security controls. Social engineering, phishing, ransomware
- Outsourcing
- E-commerce, E-business, types of E-commerce, E-commerce business models, electronic payment systems, benefits/limitations of E-commerce
- Legal Issues - data protection, GDPR, freedom of information, intellectual property rights, social networking
- Introduction to project management
- Digital marketing
Coursework & Assessment Breakdown
Coursework & Continuous Assessment
100 %
Coursework Assessment
| Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
|---|---|---|---|---|---|---|
| 1 | Practical Evaluation Spreadsheet Assessment | Coursework Assessment | Practical Evaluation | 40 % | Week 7 | 1,2 |
| 2 | Practical Evaluation Database Assessment | Coursework Assessment | Practical Evaluation | 30 % | Week 13 | 3 |
| 3 | Moodle Theory Assessment | Coursework Assessment | Assessment | 30 % | Week 12 | 4 |
Full Time Mode Workload
| Type | Location | Description | Hours | Frequency | Avg Workload |
|---|---|---|---|---|---|
| Practical / Laboratory | Computer Laboratory | Computer Based Class | 2 | Weekly | 2.00 |
| Lecture | Tiered Classroom | Theoretical aspects of course | 1 | Weekly | 1.00 |
| Independent Learning | Not Specified | Self Study | 3 | Weekly | 3.00 |
Total Full Time Average Weekly Learner Contact Time 3.00 Hours
Required & Recommended Book List
Recommended Reading
2019 Management Information Systems Wiley
ISBN 1119588618 ISBN-13 9781119588610
2019 Management Information Systems Wiley
ISBN 1119588618 ISBN-13 9781119588610
Recommended Reading
Excel 2019 Bible John Wiley & Sons
ISBN 9781119514787 ISBN-13 1119514789
Excel 2019 Bible John Wiley & Sons
ISBN 9781119514787 ISBN-13 1119514789
Recommended Reading
MICROSOFT ACCESS 2021: The Concise Microsoft Access A-Z Mastery Guide for All Users Independently published
MICROSOFT ACCESS 2021: The Concise Microsoft Access A-Z Mastery Guide for All Users Independently published
Module Resources
Non ISBN Literary Resources
McFedries, P. (2019) Microsoft Excel 2019 Formulas & Functions. Microsoft Press 2019.
Journal Resources
URL Resources
- https://trumpexcel.com/learn-excel/
- https://support.microsoft.com/en-us/office/access-video-training-a5ffb1ef-4cc4-4d79-a862-e2dda6ef38e6
Other Resources
Lecture notes available via in-class handouts and Moodle
Additional Information
None