CAPP06042 2016 Computer Application 2
Full Title
Computer Application 2
Transcript Title
Computer Application 2
Code
CAPP06042
Attendance
N/A %
Subject Area
CAPP - Computer Applications
Department
BUS - Business
Level
06 - Level 6
Credit
10 - 10 Credits
Duration
Semester
Fee
€
Start Term
2016 - Full Academic Year 2016-17
End Term
2022 - Full Academic Year 2022-23
Author(s)
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
Description
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;
1.
Use a wide range of spreadsheet functions to solve business problems
2.
Design and implement spreasheet models based on real world scenarios
3.
Design and construct a web site modeling a real world scenario
4.
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
Theory
- 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 | Coursework 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 |
ACCS Mode Workload
| Type | Location | Description | Hours | Frequency | Avg Workload |
|---|---|---|---|---|---|
| Lecture | Computer Laboratory | Lecture | 1 | Weekly | 1.00 |
| Practical / Laboratory | Computer Laboratory | Practical | 1.5 | Weekly | 1.50 |
Total ACCS Average Weekly Learner Contact Time 2.50 Hours
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