CAPP07018 2016 Business Computer Applications
Full Title
Business Computer Applications
Transcript Title
Business Computer Apps
Code
CAPP07018
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)
David O'Halloran, Aiden Bell
Programme Membership
SG_BADMN_J07 201600 Bachelor of Business in Business Administration L7
SG_BADDO_J07 201600 Bachelor of Business
SG_BBUSS_B07 201600 Bachelor of Business in Business L7
SG_B(ADD_J07 201600 Bachelor of Business in (Add On) L7
SG_BADMN_B07 201900 Bachelor of Business in Business Administration L7
SG_BBUSS_B07 201900 Bachelor of Business in Business L7
Description
This module builds on students' knowledge of computer applications (such as spreadsheets and databases) with an emphasis on solving business problems and capturing and analysing business data.
Learning Outcomes
On completion of this module the learner will/should be able to;
1.
Select and use the appropriate tools to manage, analyse and report on business data, based on a range of detailed business scenarios (eg. databases and spreadsheets)
2.
Discuss the advantages and disadvantages of end-user development.
3.
Explain how business intelligence can be used to improve decision making within an organisation.
Module Assessment Strategies
Students knowledge is tested at every step by means of on-line quizzes.
Students will be required to work on projects to produce a database and a number of spreadsheets for business use. Both the database and spreadsheet projects will incorporate elements of end-user computing and business intelligence.
Module Dependencies
Prerequisites
Students must have a basic knowledge of Spreadsheets and of using a DBMS.
Indicative Syllabus
1. End-user computing Describe end-user computing, highlighting the advantages and risks involved. Compare and contrast end-user computing with typical SDLC.
2. Data Management
Identify what data a business should save in a database for a given business problem (eg Stock Control, Sales Management, Customer Profiles, Supplier Details, Questionnaire Analysis) and possible sources for this data.
Interpret entity relationship diagrams that model this data.
Design, create and maintain database tables using both a simple ERDs and data from spreadsheets.
Identify the best tool/combination of tools for facilitating information storage and extraction in given business scenarios.
Produce simple databases, forms, queries, reports and macros.
3. Business Analysis using Spreadsheets
Produce spreadsheet models which can be used to analyse business situations (eg Projected Cash Flow, Sales Forecasting).
Perform "what if" analysis, sensitivity analysis and goal seeking.
Import data from databases and do pivot table analysis.
Produce reports from spreadsheets.
4. Introduction to business intelligence
Identify how companies can use operational and other data to make business decisions.
Discuss data quality issues.
Describe how information systems can be used for both operational and analytical purposes.
Explain how web analytics is carried out.
Coursework & Assessment Breakdown
Coursework & Continuous Assessment
60 %
End of Semester / Year Formal Exam
40 %
Coursework Assessment
| Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
|---|---|---|---|---|---|---|
| 1 | Project Produce a set of spreadsheets | Continuous Assessment | UNKNOWN | 25 % | Week 1 | 1,2 |
| 2 | Project Produce a database solution for a business problem | Continuous Assessment | UNKNOWN | 25 % | Week 7 | 1,2 |
| 3 | Multiple Choice Ongoing quizzes | Continuous Assessment | UNKNOWN | 10 % | OnGoing | 1,2,3 |
End of Semester / Year Assessment
| Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
|---|---|---|---|---|---|---|
| 1 | Final Exam 2 hour written exam | Final Exam | UNKNOWN | 40 % | End of Term | 1,2,3 |
Full Time Mode Workload
| Type | Location | Description | Hours | Frequency | Avg Workload |
|---|---|---|---|---|---|
| Lecture | Lecture Theatre | Theory and class discussions | 1 | Weekly | 1.00 |
| Laboratory Practical | Computer Laboratory | Computer practical work | 2 | Weekly | 2.00 |
| Independent Learning | UNKNOWN | Project Work | 4 | Weekly | 4.00 |
Total Full Time Average Weekly Learner Contact Time 3.00 Hours
Module Resources
Non ISBN Literary Resources
Microsoft and Office Excel 2007 : data analysis and business modeling Microsoft Press, 2007, by Winston, Wayne
Excel for small business owner Holy Macro! Books, 2008, by Hari, P. K.
Databases a beginner's guide McGraw-Hill Professional Publishing, 2009, by Oppel Andy
Multichannel marketing : metrics and methods for on and offline success Sybex, 2008, by Arikan Akin
Other Resources
None
Additional Information
None