CAPP06040 2016 Advanced Business Technology for Accountants (BA (Hons) Accounting Year 1, S2)

General Details

Full Title
Advanced Business Technology for Accountants (BA (Hons) Accounting Year 1, S2)
Transcript Title
Adv Bus Tech for Accountants
N/A %
Subject Area
CAPP - Computer Applications
BUS - Business
06 - NFQ Level 6
05 - 05 Credits
Start Term
2016 - Full Academic Year 2016-17
End Term
9999 - The End of Time
Carmel Sheehan
Programme Membership
SG_BEMBE_G07 201600 Bachelor of Business Embedded Award BB L7 in Finance and Investment SG_BEMBE_G06 201600 Higher Certificate in Business in Embedded Award BB(Hons) Finance and Investment SG_BACCO_H08 202100 Bachelor of Arts (Honours) in Business in Accounting L8 SG_BFINA_H08 202100 Bachelor of Business (Honours) in Business in Finance and Investment

The student will be able to model real world problems using spreadsheets and manipulate a database effectively.

Learning Outcomes

On completion of this module the learner will/should be able to;


Use a wide range of spreadsheet functions used in a business environment


Design and implement spreadsheet models based on real world scenarios


Using a database - create tables, forms, queries and reports


Theoretical investigation into IT security, outsourcing, Ecommerce, legal issues, digital marketing and project management

Teaching and Learning Strategies

In-class discussion, case studies, powerpoint slides, practical classes

Module Assessment Strategies

 Learning outcomes will be assessed through the creation of applications which address practical real-world problems.  Assessments will incorporate both design and implementation elements.

All topics are to be taught using problem based learning.


Repeat Assessments

If the students do not pass the module in full, they  must repeat whatever element they have failed.

Indicative Syllabus

Spreadsheet Applications Development

  • How to take text based problem and build it in excel
  • Structuring a spreadsheet - design, layout, presentation
  • Model real world problems. This should reinforce Problem Based Learning
  • Dealing with Risk and Uncertainty: sensitivity analysis, goal seek, scenarios
  • Functions - Financial, Date & Time, Statistical, Lookup & Reference, Text, Logical, Information, Sub-totals
  • Manipulate data - sort, filter, validation, pivot tables
  • Integration of EXCEL with other packages eg ACCESS, SAGE - Importing and exporting data
  • Presenting and interpreting of information - Charts(selection, formatting, time series vs cross sectional) and report generation

 Using a Database
(the purpose of this topic is primarily database query & report generation - NOT database design & development)

  • purpose, features, benefits & drawbacks
  • different types of databases - MS Access, Open Office, Google docs, etc
  • software environment
  • examining existing relational database designs - table setup (fields, primary/foreign keys, data types, validation rules, input masks, formats, etc), relationships
  • adding a simple table to an existing database
  • creating forms for inserting/editing data - labels, textboxes, command buttons, formatting, etc
  • creating queries to manipulate data - simple (single/multiple fields), criteria, user-specified, calculations, sort, filter
  • creating reports for presentation & display


  • IT security - purpose, threats, prevention, social engineering
  • Outsourcing
  • Ecommerce, Definition, role, advantages pillars, Payment systems - paypall, gateway systems
  • Legal issues - data protection, freedom of information, intellectual property rights, social networking
  • Intro to Project management
  • Digital marketing



Coursework & Assessment Breakdown

Coursework & Continuous Assessment
70 %
End of Semester / Year Formal Exam
30 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Practical Evaluation Spreadsheet assessment Continuous Assessment Practical Evaluation 40 % Week 7 1,2
2 Practical Evaluation Using a Database Continuous Assessment Practical Evaluation 30 % Week 13 3

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Final Exam 2 Hour written exam Final Exam Closed Book Exam 30 % End of Term 1,2,3,4

Full Time Mode Workload

Type Location Description Hours Frequency Avg Workload
Laboratory Practical Computer Laboratory Problem based learning 2 Weekly 2.00
Lecture Tiered Classroom Theoretical aspects of course 1 Weekly 1.00
Total Full Time Average Weekly Learner Contact Time 3.00 Hours

Module Resources

Non ISBN Literary Resources

Microsoft Office Excel 2010: Database Analysis and Business Modelling

  • Author: Wayne L. Winston
  • Publisher: Microsoft Press 2010

Shoup, K. (2010) Teach yourself visually Microsoft Office 2010. Visual.

Rainer. Watson. (2012) Management Information Systems: Moving Business Forward. Wiley

Other Resources


Additional Information