CAPP06037 2016 Intermediate Business Technology
The aim of this module is to provide the learner with the skills to create a spreadsheet & manipulate a database effectively
Learning Outcomes
On completion of this module the learner will/should be able to;
Create a Spreadsheet - data input, formatting, manipulation & reporting
Use a Database - creating forms, queries & reports
Theoretical Investigation into Modern Computing - IT Security, Information Systems, Business Ethics, Legal Issues and Traditional/Modern Marketing.
Teaching and Learning Strategies
Participative teaching, class discussion, case studies, powerpoint slides, lab demonstrations
Module Assessment Strategies
On-going theory assessments.
On-going computer lab assessments.
Repeat Assessments
Must pass module overall. If they fail overall module, they must repeat whatever elements they failed within the module.
Indicative Syllabus
1. Creating a Spreadsheet
- purpose, features, benefits & drawbacks
- different types of spreadsheets - MS Excel, Open Office, Google docs, MS 365 etc
- software environment
- data entry & editing
- copying & moving data
- formatting & conditional formatting
- spreadsheet structure/layout/views/quick access toolbar
- inserting/deleting/modifying columns/rows
- formulae - building ( , -, etc) & correct use of
- functions - SUM, AVERAGE, MIN, MAX, COUNT, IF, LOOKUP
- relative & absolute cell addressing
- range naming
- creating charts, sparklines
- freezing panes
- locking & protecting worksheets/workbooks
- inserting new worksheets
- working with multiple worksheets
- inserting headers & footers
- printing
2. Using a Database
(the purpose of this topic is primarily database query & report generation - NOT database design & development)
- purpose, features, benefits & drawbacks
- different types of databases - MS Access, Open Office, Google docs, etc
- software environment
- examining existing relational database designs - table setup (fields, primary/foreign keys, data types, validation rules, input masks, formats, etc), relationships
- adding a simple table to an existing database
- creating forms for inserting/editing data - labels, textboxes, command buttons, combo boxes, listboxes, formatting, etc
- creating queries to manipulate data - simple (single/multiple fields), criteria, parameter queries, wildcard queries, calculations, sort, filter
- creating reports for presentation & display
3. Computer Theory
- IT security - purpose, intentional/unintentional threats, difficulties in protecting systems, security controls, social engineering, phishing
- Information Systems – What is data/information/knowlege? What is a computer-based information system? A study of IS in the business world eg health, banking, education, robot technology, etc. and the identification of their components, procedures, benefits/drawbacks, costs, etc
- Business Ethics - definitions, approaches, what is privacy? threats to privacy, ethical analysis using case studies. Acceptable usage policy - IT Sligo
- Legal issues - data protection, freedom of information, intellectual property rights (patent, copyright, trademark), social networking, policy and procedures
- Introduction to digital / social media marketing – traditional versus modern marketing
(eg billboard versus Facebook), push/pull digital marketing
Coursework & Assessment Breakdown
Coursework Assessment
Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
---|---|---|---|---|---|---|
1 | Practical Evaluation Creating a Spreadsheet | Continuous Assessment | Practical Evaluation | 30 % | Week 6 | 1 |
2 | Practical Evaluation Using a Database | Continuous Assessment | Practical Evaluation | 30 % | Week 12 | 2 |
3 | Theory Assessment 1 | Continuous Assessment | Assessment | 20 % | Week 5 | 3 |
4 | Theory Assessment 2 | Continuous Assessment | Assessment | 20 % | Week 11 | 3 |
Full Time Mode Workload
Type | Location | Description | Hours | Frequency | Avg Workload |
---|---|---|---|---|---|
Lecture | Not Specified | Formal Lecture | 1 | Weekly | 1.00 |
Laboratory Practical | Computer Laboratory | Computer Based Class | 2 | Weekly | 2.00 |
Independent Learning | Not Specified | Self Study | 2 | Weekly | 2.00 |
Part Time Mode Workload
Type | Location | Description | Hours | Frequency | Avg Workload |
---|---|---|---|---|---|
Lecture | Lecture Theatre | Lecture | 3 | Weekly | 3.00 |
Module Resources
Rainer, Prince, Cegielski. (2015) Introduction to Information Systems, Wiley. Fifth edition.
Harvey, G. (2010) Microsoft Excel 2010 for Dummies. Microsoft Press.
Laudon, K.C., Laudon, J.P. (2010) Management Information Systems: Managing the Digital Firm. Pearson. 11th edition.
Murray, K. (2010) Microsoft Word 2010 Inside Out. Microsoft Press.
Shoup, K. (2010) Teach Yourself Visually Microsoft Office 2010. Visual.
Turban, E., Volonino, L. (2010) Information Technology for Management: Transforming Organisations in the Digital Economy. Wiley. 7th edition.
Notes available via lecturer
None