CAPP06037 2016 Intermediate Business Technology

General Details

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
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