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
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
2016 - Full Academic Year 2016-17
End Term
9999 - The End of Time
Author(s)
Carmel Sheehan
Programme Membership
SG_BFINA_H08 201600 Bachelor of Business (Honours) in Finance and Investment 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 201800 Bachelor of Arts (Honours) in Business in Accounting L8
Description

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;

1.

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

2.

Design and implement spreadsheet models based on real world scenarios

3.

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

4.

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

Theory

  • 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

None

Additional Information

None