CAPP06037 2016 Intermediate Business Technology
Full Title
Intermediate Business Technology
Transcript Title
Intermediate Bus Tech
Code
CAPP06037
Attendance
100 %
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_BACCO_C06 201600 Higher Certificate in Business in Accounting L6
SG_BOFFI_C06 201600 Higher Certificate in Business in Office Administration
SG_BADMN_B07 201600 Bachelor of Business in Business Administration L7
SG_BBUSI_C06 201600 Higher Certificate in Business
SG_BBUSS_B07 201600 Bachelor of Business in Business L7
SG_BEMBE_G07 201600 Bachelor of Business in Embedded award of BB Ab-initio L8
SG_BEMBE_G06 201600 Higher Certificate in Business in Embedded award of BB Ab-initio L8
SG_BTOUR_C06 201600 Higher Certificate in Business in Tourism
SG_BAPPL_C06 201600 Higher Certificate in Business in Applied Sport
SG_BTOUR_H08 201900 Bachelor of Business (Honours) in Business in Tourism with Event Management
SG_BTOUR_B07 201900 Bachelor of Business in Business in Tourism with Event Management
SG_BDIGI_B07 201900 Bachelor of Business in Digital Marketing
SG_BBUSI_H08 201900 Bachelor of Business (Honours) in Business L8 (Ab-initio)
SG_BAPPL_B07 201900 Bachelor of Business in Applied Sport with Business
SG_BSPOR_H08 201900 Bachelor of Business (Honours) in Sport with Business
SG_BACCO_C06 201900 Higher Certificate in Business in Accounting L6
SG_BBUSI_C06 201900 Higher Certificate in Business
SG_BOFFI_C06 201900 Higher Certificate in Business in Office Administration
SG_BADMN_B07 201900 Bachelor of Business in Business Administration L7
SG_BBUSS_B07 201900 Bachelor of Business in Business L7
Description
The aim of this module is to provide the learner with the skills to create a spreadsheet & manipulate a database effectively
Learning Outcomes
On completion of this module the learner will/should be able to;
1.
Create a Spreadsheet - data input, formatting, manipulation & reporting
2.
Use a Database - creating forms, queries & reports
3.
Theoretical Investigation into Modern Computing - IT Security, Information Systems, Business Ethics, Legal Issues and Traditional/Modern Marketing.
Teaching and Learning Strategies
Participative teaching, class discussion, case studies, powerpoint slides, lab demonstrations
Module Assessment Strategies
On-going theory assessments.
On-going computer lab assessments.
Repeat Assessments
Must pass module overall. If they fail overall module, they must repeat whatever elements they failed within the module.
Indicative Syllabus
1. Creating a Spreadsheet
- purpose, features, benefits & drawbacks
- different types of spreadsheets - MS Excel, Open Office, Google docs, MS 365 etc
- software environment
- data entry & editing
- copying & moving data
- formatting & conditional formatting
- spreadsheet structure/layout/views/quick access toolbar
- inserting/deleting/modifying columns/rows
- formulae - building ( , -, etc) & correct use of
- functions - SUM, AVERAGE, MIN, MAX, COUNT, IF, LOOKUP
- relative & absolute cell addressing
- range naming
- creating charts, sparklines
- freezing panes
- locking & protecting worksheets/workbooks
- inserting new worksheets
- working with multiple worksheets
- inserting headers & footers
- printing
2. 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, combo boxes, listboxes, formatting, etc
- creating queries to manipulate data - simple (single/multiple fields), criteria, parameter queries, wildcard queries, calculations, sort, filter
- creating reports for presentation & display
3. Computer Theory
- IT security - purpose, intentional/unintentional threats, difficulties in protecting systems, security controls, social engineering, phishing
- Information Systems – What is data/information/knowlege? What is a computer-based information system? A study of IS in the business world eg health, banking, education, robot technology, etc. and the identification of their components, procedures, benefits/drawbacks, costs, etc
- Business Ethics - definitions, approaches, what is privacy? threats to privacy, ethical analysis using case studies. Acceptable usage policy - IT Sligo
- Legal issues - data protection, freedom of information, intellectual property rights (patent, copyright, trademark), social networking, policy and procedures
- Introduction to digital / social media marketing – traditional versus modern marketing
(eg billboard versus Facebook), push/pull digital marketing
Coursework & Assessment Breakdown
Coursework & Continuous Assessment
100 %
Coursework Assessment
| Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
|---|---|---|---|---|---|---|
| 1 | Practical Evaluation Creating a Spreadsheet | Continuous Assessment | Practical Evaluation | 30 % | Week 6 | 1 |
| 2 | Practical Evaluation Using a Database | Continuous Assessment | Practical Evaluation | 30 % | Week 12 | 2 |
| 3 | Theory Assessment 1 | Continuous Assessment | Assessment | 20 % | Week 5 | 3 |
| 4 | Theory Assessment 2 | Continuous Assessment | Assessment | 20 % | Week 11 | 3 |
Full Time Mode Workload
| Type | Location | Description | Hours | Frequency | Avg Workload |
|---|---|---|---|---|---|
| Lecture | Not Specified | Formal Lecture | 1 | Weekly | 1.00 |
| Laboratory Practical | Computer Laboratory | Computer Based Class | 2 | Weekly | 2.00 |
| Independent Learning | Not Specified | Self Study | 2 | Weekly | 2.00 |
Total Full Time Average Weekly Learner Contact Time 3.00 Hours
Part Time Mode Workload
| Type | Location | Description | Hours | Frequency | Avg Workload |
|---|---|---|---|---|---|
| Lecture | Lecture Theatre | Lecture | 3 | Weekly | 3.00 |
Total Part Time Average Weekly Learner Contact Time 3.00 Hours
Module Resources
Non ISBN Literary Resources
Rainer, Prince, Cegielski. (2015) Introduction to Information Systems, Wiley. Fifth edition.
Harvey, G. (2010) Microsoft Excel 2010 for Dummies. Microsoft Press.
Laudon, K.C., Laudon, J.P. (2010) Management Information Systems: Managing the Digital Firm. Pearson. 11th edition.
Murray, K. (2010) Microsoft Word 2010 Inside Out. Microsoft Press.
Shoup, K. (2010) Teach Yourself Visually Microsoft Office 2010. Visual.
Turban, E., Volonino, L. (2010) Information Technology for Management: Transforming Organisations in the Digital Economy. Wiley. 7th edition.
Other Resources
Notes available via lecturer
Additional Information
None