CAPP06042 2022 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 - NFQ Level 6
Credit
10 - 10 Credits
Duration
Semester
Fee
€
Start Term
2022 - Full Academic Year 2022-23
End Term
9999 - The End of Time
Author(s)
Kerry Dolan, Aileen Brennan, Fergal Keane
Programme Membership
SG_BBUSO_C06 202200 Higher Certificate in Business in Business Studies (Online)
SG_BBISO_C06 202300 Higher Certificate in Business in Business Studies (Online)
Description
In this module learner will encounter some theoretical concepts behind the use of computing technology in business and personal contexts, will create a model of a real world problem using spreadsheets and will construct an information website for an organisation.
Learning Outcomes
On completion of this module the learner will/should be able to;
1.
Identify a range of spreadsheet functions relevant to solving business problems.
2.
Design and implement spreadsheet models based on real a world scenario
3.
Describe the relevant considerations when creating and maintaining web sites
4.
Design and construct a brochure web site
5.
Summarise concepts relevant to Information Systems - Types and uses, Cyber Security, Business Ethics and Legal Issues.
Teaching and Learning Strategies
The module will be delivered in weekly online sessions. Both practical and theoretical concepts will be addressed in these classes. Independent practice outside of class time will also be assigned to learners, in order to improve their technical proficiency using software applications
Module Assessment Strategies
The is will be 60% continuous assessment with 40% final exam. The 60% will primarily assess the the practical component of the course while the 40% will address the theoretical elements.
Repeat Assessments
Repeat exams and practical assessments will be made available when required
Indicative Syllabus
Spreadsheet Applications Development:
- 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 - Importing and exporting data;
- Structuring a spreadsheet - design, layout, presentation;
- Model real world problems- how to take text based problem and build a solution in Excel;
- Dealing with Risk and Uncertainty: sensitivity analysis, goal seek, scenarios;
- Presenting and interpreting of information - Charts(selection, formatting, time series vs cross sectional) and report generation.
Web Development:
- Guidelines for creating a website;
- HCI design guidelines;
- Web Based Development tools – free online development tools versus locally installed development tools;
- 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:
- IT security − purpose, threats, prevention, social engineering;
- Information Systems – a brief overview of IS in the business world;
- Business Ethics − definitions, approaches, ethical analysis using case studies;
- Legal issues − data protection, freedom of information, intellectual property rights, social networking, policy and procedures;
- Introduction to digital / social media marketing – traditional versus modern marketing (eg billboard versus Facebook);
- E commerce - definition, role, advantages, pillars, payment systems - PayPal, gateway system.
Coursework & Assessment Breakdown
Coursework & Continuous Assessment
100 %
Coursework Assessment
| Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
|---|---|---|---|---|---|---|
| 1 | Excel | Project | Assessment | 30 % | Week 7 | 1,2 |
| 2 | Web Project | Project | Practical Evaluation | 30 % | Week 12 | 3,4 |
| 3 | Intermediate and End of Semester Assessment | Coursework Assessment | Assessment | 40 % | OnGoing | 1,3,5 |
Online Learning 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 |
| Independent Learning | Not Specified | Independent Learning | 3 | Weekly | 3.00 |
Total Online Learning Average Weekly Learner Contact Time 2.50 Hours
Required & Recommended Book List
Recommended Reading
2022-03-13 Microsoft Office 365 Step by Step Microsoft Press
ISBN 0137544766 ISBN-13 9780137544769
2022-03-13 Microsoft Office 365 Step by Step Microsoft Press
ISBN 0137544766 ISBN-13 9780137544769
This is learning made easy. Get more done quickly with Office 365. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint, and Outlook Format Word documents for maximum visual impact Build powerful, reliable Excel workbooks for analysis and reporting Prepare highly effective PowerPoint presentations Use Outlook to organize your email, calendar, and contacts Includes downloadable practice files
Recommended Reading
2021-06-22 Hello Web Design No Starch Press
ISBN 9781718501386 ISBN-13 1718501382
2021-06-22 Hello Web Design No Starch Press
ISBN 9781718501386 ISBN-13 1718501382
This book democratizes web development for everyone. It's a fun, clever guide that covers all of the key design principles, best practices, useful shortcuts, pro tips, real-world examples, and basic coding tutorials needed to produce a beautiful website that you'll feel confident sharing with the world. Because you, too, can design for the web! Hello Web Design contains everything you need to feel comfortable doing your own web development, including an abundance of real-life website examples that will inspire and motivate you. No need to spend time and money hiring an expensive graphic designer; this book will walk you through the fundamentals - and shortcuts - you need to do it all yourself, right now.
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.
URL Resources