CAPP07031 2016 Information and Communications Technology in Accounting 2
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 Business in Accounting (Add-on)
SG_BACCO_H08 201600 Bachelor of Arts (Honours) in Accounting L8
SG_BACCO_H08 201800 Bachelor of Arts (Honours) in Business in Accounting L8
SG_BACCO_H08 202100 Bachelor of Arts (Honours) in Business in Accounting L8
SG_BACCO_J07 202100 Bachelor of Business in Accounting L7
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 | Coursework Assessment | Practical Evaluation | 30 % | Week 6 | 1,2,3 |
| 2 | Practical Evaluation Excel Assignment | Coursework Assessment | Practical Evaluation | 30 % | Week 10 | 1,4 |
| 3 | Multiple Choice Quiz | Coursework Assessment | Multiple Choice/Short Answer Test | 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 |
|---|---|---|---|---|---|
| Practical / Laboratory | 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
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
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
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
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