CAPP06038 2016 Advanced Business Technology

General Details

Full Title
Advanced Business Technology
Transcript Title
Advanced Business Technology
100 %
Subject Area
CAPP - Computer Applications
BUS - Business
06 - NFQ Level 6
05 - 05 Credits
Start Term
2016 - Full Academic Year 2016-17
End Term
2019 - Full Academic Year 2019-20
David O'Halloran, Siobhain O'Connor, Carmel Sheehan, Diolinda Coyle
Programme Membership
SG_BEMBE_G06 201600 Higher Certificate in Business in Embedded award of BB Ab-initio L8 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

This module enables the student to construct a problem-based spreadsheet and develop a business web site

Learning Outcomes

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


implement a complex spreadsheet from a text-based scenario


develop a web site that incorporates various forms of media


acquire an understanding of the theoretical aspects of the business environment

Teaching and Learning Strategies

Practical demonstrations, lectures, class discussions, case studies and audio/video clips will be used to facilitate the learning process

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

Students are required to achieve at least a passing grade (40%) in the continuous assessment component of this module and minimum grade of 30% in the final theory examination, while achieving a passing grade overall

Repeat Assessments

Students may be required to repeat all components of the module or just the component they have failed. The Examination Board (under the guidance of the lecturer) will determine the Repeat Requirements for each student

Indicative Syllabus


Spreadsheet Applications Development

  • using problem-based learning to build a spreadsheet solution
  • structuring a spreadsheet - design, layout, presentation
  • dealing with risk and uncertainty - sensitivity analysis, goal seek, scenarios
  • utilising functions - financial, date & time, statistical, lookup & reference, text, logical, information, sub-totals
  • manipulating data - sort, filter, pivot tables
  • developing dashboards
  • building data validation into a spreadsheet
  • integrating with other software - importing and exporting data

 Web Development

  • using web development tools - online tools/CMS (eg WordPress) versus locally installed software (eg Adobe Dreamweaver)
  • adding content - text, images, video, audio, hyperlinks
  • organising content - tables, columns, menus
  • creating/modifying images using various tools - eg Photoshop, PicMonkey, Picasa, Pixlr, Paint


  • design guidelines for creating a web site
  • domain names, SEO, hosting (requirements, costing)
  • eCommerce - definition, types, advantages, disadvantages, payment systems (eg paypal, gateway systems)
  • digital marketing
  • data analytics
  • legal issues - copyright, patents, consumer rights, accessibility, social media, etc
  • introduction to project management


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 Practical - creating a spreadsheet Continuous Assessment Assessment 40 % Week 7 1
2 Practical - building a website Continuous Assessment Assessment 20 % Week 12 2

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Final Exam - 2 hour written examination Final Exam Closed Book Exam 40 % End of Term 3

Full Time Mode Workload

Type Location Description Hours Frequency Avg Workload
Laboratory Practical Computer Laboratory Problem-based learning 2 Weekly 2.00
Lecture Tiered Classroom Theoretical aspects of module 1 Weekly 1.00
Independent Learning Not Specified Self Study 2 Weekly 2.00
Total Full Time Average Weekly Learner Contact Time 3.00 Hours

Module Resources

Non ISBN Literary Resources


Frye, C. (2016) Microsoft Excel 2016 (Step by Step). Microsoft.

McNeil, P. (2014) Web Designer's Idea Book, Volume 4: Inspiration from the best web design trends, themes and styles. HOW Books.

Rainer, K., Prince, B., Watson, H. (2015) Management Information Systems. Wiley.