CAPP06038 2022 Advanced Business Technology

General Details

Full Title
Advanced Business Technology
Transcript Title
Advanced Business Technology
75 %
Subject Area
CAPP - Computer Applications
BUS - Business
06 - NFQ Level 6
05 - 05 Credits
Start Term
2022 - Full Academic Year 2022-23
End Term
9999 - The End of Time
Siobhain O'Connor, Diolinda Coyle, Kerry Dolan, Carmel Sheehan
Programme Membership
SG_BBUSI_C06 202200 Higher Certificate in Business in Business Studies SG_BBUSI_H08 202200 Bachelor of Business (Honours) in Business SG_BBUSS_B07 202200 Bachelor of Business in General Business SG_BADMN_B07 202200 Bachelor of Business in Business Administration SG_BBUSJ_B07 202200 Bachelor of Business in Business SG_BBUSI_C06 202200 Higher Certificate in Business in Business SG_BBUSL_C06 202200 Higher Certificate in Business in Business Administration SG_BBUSM_C06 202200 Higher Certificate in Business in Business Studies SG_BBUSB_H08 202200 Bachelor of Business (Honours) in Business SG_BBUSI_H08 202200 Bachelor of Business (Honours) in Business SG_BBUSG_B07 202300 Bachelor of Business in General Business SG_BADMN_C06 202200 Higher Certificate in Business in Business Administration SG_BBUSI_C06 202300 Higher Certificate in Business in Business (exit) SG_BBUSJ_B07 202300 Bachelor of Business in Business (exit)

The aim of this module is to provide the learner with the advanced technology skills required to work in a business environment.  Practically, the student will learn how to construct a problem-based spreadsheet and create an informational web site. The student will acquire an understanding of the theoretical aspects of the business environment.

Learning Outcomes

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


Implement a complex spreadsheet from a text-based scenario.


Produce a web site that incorporates various forms of media.


Acquire a knowledge of the theoretical aspects of the business environment.

Teaching and Learning Strategies

The learner will be provided with direct instruction in a computer lab, to facilitate active and experiential learning.  Various strategies will be used to improve student learning via lectures, class discussions, case studies, PowerPoint slides, audio and video clips.

Module Assessment Strategies

Learning outcomes will be assessed through the creation of applications which address practical real-world problems. Assessments will incorporate design and implementation elements.  All topics are to be taught using Problem-Based Learning Techniques.

Repeat Assessments

If the student fails the module overall, he/she will be required to repeat the failed component(s) only, by means of examination(s) during the Autumn examination session.

Indicative Syllabus

Spreadsheet Application Development (LO1):

  • Design and develop an advanced spreadsheet using problem-based learning techniques,
  • Incorporate various complex calculations using advanced formulae and functions,
    (financial, logical, text, date and time, lookup and reference, mathematical, statistical, information),
  • Organise, validate, manipulate, summarise, predict and analyse data,
  • Display information in charts, pivot tables, pivot charts and dashboards.

Web Creation (LO2):

  • Create an informational web site using web development or web-based tools,
  • Incorporate and modify text, images, buttons, hyperlinks, forms, maps, audio and video,
  • Organise content in a variety of different ways,
  • Preview and publish.

Theory (LO3):

  • Design guidelines for creating a web site,
  • Domain names, SEO, hosting (requirements, costing),
  • E-commerce & E-business - definition, types of e-commerce, e-commerce business models, benefits of e-commerce, limitations of e-commerce. payment systems (e.g., e-cheques, electronic credit cards, virtual credit cards, purchasing cards, electronic cash, person to person payments (PayPal) ), How an electronic credit card works, 
  • Traditional versus modern marketing; digital/social media marketing,
  • Data analytics - what is it?, what does it do?, business advantages, types of data analytics applications & their uses,
  • Outsourcing,
  • Introduction to project management.

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
100 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Advanced Spreadsheet Design/Development Coursework Assessment Practical Evaluation 40 % Week 12 1
2 Web Site Creation Coursework Assessment Practical Evaluation 20 % Week 4 2
3 Theory Assessment Coursework Assessment Assessment 40 % Week 11 3

Full Time Mode Workload

Type Location Description Hours Frequency Avg Workload
Supervision Computer Laboratory Problem-Based Learning 2 Weekly 2.00
Lecture Classroom Fixed Seating Theoretical Aspects of Module 1 Weekly 1.00
Independent Learning Not Specified Self-Study 4 Weekly 4.00
Total Full Time Average Weekly Learner Contact Time 3.00 Hours

Required & Recommended Book List

Recommended Reading
Excel 2016 Bible John Wiley & Sons

Recommended Reading
2020 Confident Web Design: Master the Fundamentals of Website Creation and Supercharge Your Career (Confident Series) Kogan Page

Recommended Reading
2019 Information Technology Essentials Volume 1: Introduction to Information Systems Independently Published

Recommended Reading
2019 Management Information Systems Wiley
ISBN 1119588618 ISBN-13 9781119588610
Recommended Reading
Excel 2019 Bible John Wiley & Sons
ISBN 9781119514787 ISBN-13 1119514789

Module Resources

Non ISBN Literary Resources

McFedries, P. (2019) Microsoft Excel 2019 Formulas & Functions. Microsoft Press 2019.

Journal Resources
URL Resources
Other Resources

Support material prepared by lecturers and available to students on the college network or via Moodle.

Additional Information