COMP06171 2019 Information Technology 2
This module deals with advanced practical applications of Information Technology. It covers the software packages for spreadsheets, desktop publishing, electronic notebooks and data management.
The teaching methods used will be a combination of lectures, self-study, labs, tutorials, and any combination of discussion, case study, problem-solving exercises and computer-based learning.
Learning Outcomes
On completion of this module the learner will/should be able to;
Model problems using advanced features of Excel and build on concepts learned in Information Technology 1
Create a poster to illustrate the results of a scientific project using an appropriate software package.
Create brochures and information leaflets using an appropriate software
Use online cloud tools and other software packages for data management and collaboration.
Teaching and Learning Strategies
The teaching methods used will be a combination of lectures, self-study, labs, tutorials, and any combination of discussion, case study, problem-solving exercises and computer-based learning.
Module Assessment Strategies
As part of the summative assessment, the learner will complete assignments in desktop publishing and use of digital notebooks which will be completed during the students independent learning. There will also be computer laboratory-based assessments which will assess the students' practical application of skills in relation to using advanced spreadsheet functionality and data management techniques.
The learner will also undergo formative assessment by means of practical activities done in the computer laboratory during the weekly practical sessions. They will be given assistance and feedback during the completion of these activities which they can then put into practice when undertaking the summative assessment.
Repeat Assessments
Where the module mark is below 40% and attendance is below the 75% requirement, the student must repeat attend the module.
Where the deficit is only in the module mark, the student will be asked to attend a practical assessment.
Indicative Syllabus
Advanced Spreadsheets
- Advanced Charting
- Logical Functions
- Working with large datasets
Desktop Publishing
- Creating an academic poster
- Creating brochures/leaflets for information dissemination.
Digital Notebooks
- OneNote
- Electronic Lab Notebooks
Data Management
- Cloud Infrastructure: Online Collaborative tools
- Databases
Coursework & Assessment Breakdown
Coursework Assessment
Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
---|---|---|---|---|---|---|
1 | Advanced Excel Assessment | Coursework Assessment | Practical Evaluation | 25 % | Week 4 | 1 |
2 | Desktop Publishing Assignment | Coursework Assessment | Assignment | 25 % | Week 7 | 2,3 |
3 | Data Management Assessment | Project | Assignment | 20 % | Week 10 | 4 |
4 | End of Module Assessment | Coursework Assessment | Practical Evaluation | 30 % | Week 13 | 1,2,3,4 |
Full Time Mode Workload
Type | Location | Description | Hours | Frequency | Avg Workload |
---|---|---|---|---|---|
Practical / Laboratory | Computer Laboratory | Practical | 2 | Weekly | 2.00 |
Independent Learning | UNKNOWN | Self Study | 5 | Weekly | 5.00 |
Required & Recommended Book List
2015-11-02 Office 2016 Simplified John Wiley & Sons
ISBN 9781119074748 ISBN-13 1119074746
Explains how to effectively utilize the latest version of the integrated software package, covering Word, Excel, PowerPoint, Outlook, Publisher, OneNote, and Access.
Module Resources
N/A
N/A
N/A
N/A
N/A