CAPP06037 2022 Intermediate Business Technology

Design a fundamental spreadsheet with formulae, standard functions and charting capabilities.

Manipulate a database that contains tables, forms, reports and queries.

Theoretical Investigation into Modern Computing - Cyber Security, Information Systems, Business Ethics and Legal Issues

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.

Students will be required to partake in two practical assessments, to demonstrate proficiency in the practical components of the module.  Theory knowledge will be assessed using either online or offline MCQs.

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.

Spreadsheet (LO1):

• Enter, edit and format data,
• Create structured layouts,
• Insert, modify and delete columns and rows,
• Perform calculations using standard formulae and functions,
• Incorporate different types of cell references,
• Represent data visually,
• Protect important information.

Database (LO2):

• Examine existing relational database designs,
• Create forms and reports,
• Manipulate data using queries,
• Add and amend relationships and tables,
• Enter data via forms and tables.

Computer Theory (LO3):

• Cyber Security - Purpose. Intentional/unintentional threats. Difficulties in protecting systems. Cyber security controls. Social engineering, phishing, ransomware;
• Information Systems – What is data/information/knowledge? What is a computer-based information system? Capabilities of Information Systems. How does IT impact Organisations (reduction of middle managers and the way they do their job. ergonomic products, enabling people with disabilities to work with computers)?. Importance of Information Systems to Society (IT affects our quality of life, Robot Revolution, Improvements in Healthcare);
• Business Ethics - Definitions. What is a code of ethics?. Fundamental tenets of ethics. Four categories of ethical issues involving IT Applications (Privacy, Accuracy Property, Accessibility). What is privacy? Threats to privacy. Ethical analysis using case studies. Acceptable usage policy - IT Sligo;
• Legal Issues - Data protection act, GDPR. Freedom of information act. Intellectual property rights (patent, copyright, trademark). Social networking and the acts that govern the use of these sites.