Module Details
Module Code: |
INFO6037 |
Title: |
Business IT Applications
|
Long Title:
|
Business IT Applications
|
NFQ Level: |
Fundamental |
Valid From: |
Semester 1 - 2023/24 ( September 2023 ) |
Field of Study: |
4820 - Information Systems
|
Module Description: |
This module will help students develop the PC skills they need to be successful in study and beyond. It will show students how to combine features from multiple applications to produce professional business documents and reports.
|
Learning Outcomes |
On successful completion of this module the learner will be able to: |
# |
Learning Outcome Description |
LO1 |
Produce professional business documents and reports using a wordprocessor |
LO2 |
Organise, analyse and report business information using a spreadsheet tool. |
LO3 |
Communicate and share business information using a presentation tool |
LO4 |
Integrate and analyse data from multiple tables within a spreadsheet environment. |
LO5 |
Combine elements of PC applications to produce a professional business report. |
Dependencies |
Module Recommendations
This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named MTU module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
|
|
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module. You may not earn additional credit for the same learning and therefore you may not enrol in this module if you have successfully completed any modules in the incompatible list.
|
No incompatible modules listed |
Co-requisite Modules
|
No Co-requisite modules listed |
Requirements
This is prior learning (or a practical skill) that is mandatory before enrolment in this module is allowed. You may not enrol on this module if you have not acquired the learning specified in this section.
|
No requirements listed |
Indicative Content |
Wordprocessing
Text formatting, page margins, line spacing, indenting, paragraphing, headings, document layout, headers/footers, bullets and numbering, tables, borders and shading, Table of Contents, Mail Merge, Word Styles, Word Templates. Inserting and formatting graphical pictures and objects; printing, saving and sharing. Importing, embedding and formatting content from other applications
|
Spreadsheets
Formatting data, viewing, printing and sharing workbooks. Basic calculations & functions (sum, average, min, max, count, simple if); Absolute cell and mixed referencing, tables, charts, conditional formatting, Lookup functions; Pivot Tables; worksheet linking and data consolidation. Lookup and retrieval functions, text functions, logical functions, Pivot tables, Pivot charts, dashboards and data visualisation. Exporting data to Word and Powerpoint for presentation.
|
Presentation Tool
Creating slides, formatting text, slide numbering, footers, inserting graphics, pictures; use of SmartArt tools. Slide view navigation(outline; normal; slide sorter; slide show). Use of design themes, master slides, slide transitions and custom animation. Sharing presentations. Importing content from other applications.
|
Database Tool
Introduction to database concepts such as primary and foreign keys, referential integrity, data types and relationships. Planning and designing databases; creating tables, queries, forms and reports. Exporting data to Excel and other applications.
|
Module Content & Assessment
|
Assessment Breakdown | % |
Coursework | 100.00% |
Assessments
No End of Module Formal Examination |
Reassessment Requirement |
Coursework Only
This module is reassessed solely on the basis of re-submitted coursework. There is no repeat written examination.
|
The University reserves the right to alter the nature and timings of assessment
Module Workload
Workload: Full Time |
Workload Type |
Contact Type |
Workload Description |
Frequency |
Average Weekly Learner Workload |
Hours |
Lab |
Contact |
Computer lab practical |
Every Week |
4.00 |
4 |
Independent & Directed Learning (Non-contact) |
Non Contact |
Self directed student learning |
Every Week |
3.00 |
3 |
Total Hours |
7.00 |
Total Weekly Learner Workload |
7.00 |
Total Weekly Contact Hours |
4.00 |
Workload: Part Time |
Workload Type |
Contact Type |
Workload Description |
Frequency |
Average Weekly Learner Workload |
Hours |
Lab |
Contact |
Computer lab practical |
Every Week |
2.00 |
2 |
Independent & Directed Learning (Non-contact) |
Non Contact |
Self directed student learning |
Every Week |
5.00 |
5 |
Total Hours |
7.00 |
Total Weekly Learner Workload |
7.00 |
Total Weekly Contact Hours |
2.00 |
Module Resources
|
Recommended Book Resources |
---|
-
Joan Lambert and Curtis Frye. (2015), Microsoft Office 2016 Step by Step, 1st. Microsoft Press, [ISBN: 9788120352049].
| Supplementary Book Resources |
---|
-
Noel Kantaris. (2016), Microsoft Office 2016 Explained, 1st. Bernard Babani Publishing, [ISBN: 9780859347624].
| This module does not have any article/paper resources |
---|
Other Resources |
---|
-
Website, GCF Global. MS Office Tutorials,
-
Website, Microsoft. Microsoft 365 Training,
-
Website, Highline. Excel tutorials,
|
|