CAPP07031 2016 Information and Communications Technology in Accounting 2

General Details

Full Title
Information and Communications Technology in Accounting 2
Transcript Title
ICT in Accounting 2
Code
CAPP07031
Attendance
N/A %
Subject Area
CAPP - Computer Applications
Department
BUS - Business
Level
07 - NFQ Level 7
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, Helen Grady
Programme Membership
SG_BACCT_J07 201600 Bachelor of Business in Accounting L7 SG_BACCO_H08 201800 Bachelor of Arts (Honours) in Business in Accounting L8
Description

This module will focus on developing the students ability to identify, source and utilise the most appropriate technology resources available to add value to an organisation.  It also aims to develop the students awareness of how to effectively and efficiently utilise information technology resources together with traditional accounting controls and methods to provide users with the financial information necessary to manage an organisation.  It also demonstrates the use of an accounting and payroll package.

Learning Outcomes

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

1.

Understand the role and application of Information Systems and Information Technology in the management and control of organisations

2.

Use a computerisied accounts package to generate a set of financial statements

3.

Use a computerised payroll package to calculate employees pay and generate reports

4.

Demonstrate the benefits derived by employing advanced spreadsheet functions as management accounting tools for short and long term decision making

5.

Discuss significant business information technology trends

Teaching and Learning Strategies

Lecture Strategy used to introduce each topic to students. It is used as a means of conveying information on a new topic to students.

Active Learning - students participate in projects where they are provided with transactions that they have to capture with software. The projects simulate transactions encountered in a workplace situation and provide students with the opportunity to gain experience and confidence on software used in the workplace. This aims to improve students' understanding and retention of information and can be very effective in developing higher order cognitive skills such as problem solving and critical thinking.

Discussion Strategies where students are engaged in discussion to deepen their learning and motivation by propelling them to develop their own views and hear their own voices. It provides a good environment for interaction and is the first step in encouraging students to talk.

Module Assessment Strategies

Practical assessment, projects and MCQ's 

Repeat Assessments

Practical assessment, projects and MCQ's

Indicative Syllabus

1. Understand the role and application of Information Systems and Information Technology in the management and control of organisations

  • The digital firm
  • Types of information systems in business
  • Functions of information systems
  • The System Development Life Cycle
  • Information Technology
  • Organisational Support Systems
  • Information System Development
  • Feasability Study and Business Value of Systems

2. Use a computerisied accounts package to generate a set of financial statements

  • Process the transactions for a company for one month, extract a set of financial statements and reports for the period using accounting software
  • Analyse the periodic reports

 3. Use a computerised payroll package to calculate employees pay and generate reports

  • Prepare manual payroll calculations
  • Set up employees details
  • Identify the requirements necessary to calculate and fully process an individuals pay
  • Generatation of payroll reports 

4. Demonstrate the benefits derived by employing advanced spreadsheet functions as management accounting tools for short and long term decision making.

  • Create an excel template as a decision support tool for a management accounting group project     

5. Discuss significant business information technology trends

  • Mobile computing
  • Mix of in-house and outsourced services
  • Enterprise application software migrating to the cloud
  • Formalising the software lifecycle management to reduce costs
  • Business Intelligence, the Dashboard, Key Performance Indicators, XBRL, Integrated Reproting and Big Data

 

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 Computerised Accounts and Payroll Continuous Assessment Practical Evaluation 30 % Week 6 1,2,3
2 Practical Evaluation Excel Assignment Continuous Assessment Practical Evaluation 30 % Week 10 1,4
3 Multiple Choice Quiz Continuous Assessment Multiple Choice 10 % Week 11 1,2,3,4,5

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Final Exam Theory Final Exam Closed Book Exam 30 % Week 15 1,2,3,4,5
             
             

Full Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Laboratory Practical Computer Laboratory Computer Based Class 3 Weekly 3.00
Independent Learning UNKNOWN Self Study 4 Weekly 4.00
Total Full Time Average Weekly Learner Contact Time 3.00 Hours

Required & Recommended Book List

Recommended Reading
Accounting Information Systems: The Crossroads of Accounting and IT Pearson Education Limited
ISBN 1292023376 ISBN-13 9781292023373
Recommended Reading
2014-04-03 Business Information Systems for Accounting Students Pearson Education Limited
ISBN 0273773526 ISBN-13 9780273773528

Business Information Systems for Accounting Students offers a more practical approach than the typical accounting information systems textbook. The text covers the technical foundations of the topic, and provides a unique insight into what information systems and technology mean for accountants in today's business environment. Providing a contemporary education for undergraduate accounting students, Quinn and Kristandl offer a fresh perspective that is relevant to both UK and international students of computerised accounting, accounting information systems or accounting technology. Key features of the text include: * Real life examples with QR codes for easy access on smart devices . Examples are drawn from leading organizations such as Ryanair, Marks and Spencer, SAP and The World Bank. * Coverage of the features of selected office, accounting and business software * Mini-cases to show how technology benefits business "Tracking the relationship between accounting and technology in an ever changing world is no mean feat. Now, this book offers a comprehensive overview of technology- using many real-life examples - to introduce why and how technology matters for today's accountant" Professor Niels Dechow, EBS Business School, Wiesbaden.

Recommended Reading
2014-04-17 Learn Excel 2013 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques The Smart Method, Limited
ISBN 1909253073 ISBN-13 9781909253070

This Excel 2013 book is for users who want to upgrade their basic Excel 2013 skills to true expert level. It will teach you to master all of the Excel 2013 advanced features. If you are an absolute beginner you need our Excel 2013 Essential Skills book.

The book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to master advanced Excel 2013 features. Heres just four of the many ways in which the book is unique:

  • This book wont waste your time by teaching basic Excel 2013 skills that you already know. All of that material is covered already in our beginners Excel 2013 Essential Skills book. By assuming that you are already able to use the Excel 2013 basic features, far more ground can be covered.
  • Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses.
  • Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).
  • Each lesson has a sample file that models a real-world business problem. Youll immediately appreciate the value and relevance of each skill you learn.

Advanced concepts are explained without needless technical jargon.  Everything is concisely described in a simple, no-nonsense way.  No matter what your background is, this book will enable you to master Excel 2013s most advanced features.

Amongst other things you'll learn how to:

  • Use Excel 2013s new data model feature to create table relationships
  • Master dynamic tables and structured table references
  • Completely understand Excel 2013s new ability to create OLAP cubes
  • Use Excel 2013s new OLAP Pivot Tables to present OLAP cube data
  • Perform What-If analysis to model and compare business scenarios
  • Record macros and then execute them from button controls
  • Create intuitive user interfaces using form controls
  • Enforce complex business rules using function-driven custom validations
  • Use advanced functions to solve real-world business problems
  • Understand and use all of Excels security features
  • Use Excel 2013s new timeline slicers to quickly filter date ranges
  • Create and use dynamic and table-based range names

Companies who have taken Smart Method courses include:

AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco,  Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence,  Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS,  The British Museum, The National Gallery,  Pokerstars, Marks & Spencer, Virgin, O2, BMW... and many, many others.

Recommended Reading
2015-07-13 Management Information Systems Wiley
ISBN 111889538X ISBN-13 9781118895382

The 3rd Edition of Management Information Systems promotes active learning like no other text in the market. Each chapter is comprised of tightly coupled concepts and section-level student activities that transport your students from passively learning about IS to doing IS in a realistic context.

The integration of Microsoft Excel and Access exercises at the end of every chapter enables students to practice their Microsoft application skills in the context of the chapter material.

Module Resources

URL Resources

http://www.sage.ie/software-and-services/accounting-and-finance

http://www.sage.ie/software-and-services/payroll

http://www.revenue.ie/en/online/

http://www.gcflearnfree.org/excel2016

Other Resources

Lecturer Notes available via Moodle

Additional Information

None