CAPP06042 2016 Computer Application 2

General Details

Full Title
Computer Application 2
Transcript Title
Computer Application 2
N/A %
Subject Area
CAPP - Computer Applications
BUS - Business
06 - NFQ Level 6
10 - 10 Credits
Start Term
2016 - Full Academic Year 2016-17
End Term
9999 - The End of Time
David O'Halloran
Programme Membership
SG_BBUSO_C06 201600 Higher Certificate in Business in Business in Business SG_BBSOL_C06 202000 Higher Certificate in Business

The student will be able to model real world problems using spreadsheets and construct a business website.

Learning Outcomes

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


Use a wide range of spreadsheet functions to solve business problems


Design and implement spreasheet models based on real world scenarios


Design and construct a web site modeling a real world scenario


Teach theoretical computing to support practical components

Teaching and Learning Strategies

The class will be a combination of a 2.5 hour slot at night. Both Practical and theory will be taught.

Module Assessment Strategies

The is will be 60% continuous assessment with 40% final exam. The 60% will primarily asssess the the practical component of the course while the 40% will address the theoretical elements

Indicative Syllabus

Spreadsheet Applications Development

  • How to take text based problem and build it in Excel
  • Structuring a spreadsheet - design, layout, presentation
  • Model real world problems. This should reinforce Problem Based Learning.
  • Developing a structured solution
  • Encorporating standard accounting procedures – cash-flow, cost/benefit analysis, financial calculations, TCO
  • Dealing with Risk and Uncertainty: sensitivity analysis, goal seek, scenarios
  • Functions - Financial, Date & Time, Statistical, Lookup & Reference, Text, Logical, Information, Sub-totals
  • Manipulate data - sort, filter, validation, pivot tables
  • Integration of EXCEL with other packages eg ACCESS, SAGE - Importing and exporting data
  • Presenting and interpreting of information - Charts(selection, formatting, time series vs cross sectional) and report generation

Web Development

  • Guidelines for creating a website
  • Web Based Development tools – free online development tools (WEBS, WEEBLY, GOOGLE SITES, DOODLE KIT) versus locally installed development tools (MS Expression Web)
  • Content, Text. images, video, tables etc
  • Domain names, hosting (requirements, costing)
  • Image creation versus acquiring using various tools – Google Images, Photoshop, Picasa, Pixlr, Paint, etc
  • Digital marketing - search engine optimisation


  • HCI design guidelines
  • Hosting options
  • Outsourcing
  • Ecommerce - definition, role, advantages, pillars, payment systems - PayPal, gateway systems
  • Law pertaining to Web, copyright, patent, consumer rights, etc
  • Digital marketing



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 Excel Continuous Assessment Assessment 40 % Week 8 1,2
2 Web Project Project Practical Evaluation 20 % Week 12 3

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Final Exam Final Exam Assessment 40 % Week 13 4

Module Resources

Non ISBN Literary Resources

Microsoft Office Excel 2010: Database Analysis and Business Modelling

  • Author: Wayne L. Winston
  • Publisher: Microsoft Press 2007

The Web Designer's Idea Book: The Ultimate Guide To Themes, Trends & Styles In Website Design: The Ultimate Guide to Themes, Trends and Styles in Website ... Themes, Trends & Styles in Website Design)

  • Author: Patrick Mcneil
  • Publisher: How Books

Date: Oct 2010