COMP06171 2019 Information Technology 2

General Details

Full Title
Information Technology 2
Transcript Title
Information Technology 2
Code
COMP06171
Attendance
75 %
Subject Area
COMP - 0613 Computer Science
Department
LIFE - Life Sciences
Level
06 - Level 6
Credit
05 - 05 Credits
Duration
Semester
Fee
Start Term
2019 - Full Academic Year 2019-20
End Term
9999 - The End of Time
Author(s)
Padraig McGourty, Akinlolu Akande
Programme Membership
SG_SFORE_G07 201900 Bachelor of Science in Science in Forensic Invest and Analys(Emb) SG_SAGRI_B07 201900 Bachelor of Science in Agri-Food Science SG_SHEAL_B07 201900 Bachelor of Science in Health Science and Physiology SG_SBIOM_B07 201900 Bachelor of Science in Biomedical Science SG_SMEDI_H08 201900 Bachelor of Science (Honours) in Medical Biotechnology SG_SPHAR_B07 201900 Bachelor of Science in Pharmaceutical Science with Drug Development SG_SSUST_C06 201900 Higher Certificate in Science in Sustainable Food Production SG_SHUMA_H08 201900 Bachelor of Science (Honours) in Human Nutrition SG_SHEAL_H08 201900 Bachelor of Science (Honours) in Health Science and Physical Activity SG_SHEAL_C06 201900 Higher Certificate in Science in Health and Exercise Science SG_SHUMA_B07 201900 Bachelor of Science in Human Nutrition SG_SPHAR_H08 201900 Bachelor of Science (Honours) in Pharmaceutical Science with Drug Development SG_SAGRI_H08 201900 Bachelor of Science (Honours) in Science in Agri-Food Science SG_SSCIE_B07 201900 Bachelor of Science in Science SG_SFORE_H08 201900 Bachelor of Science (Honours) in Forensic Investigation and Analysis SG_SFORE_B07 201900 Bachelor of Science in Science in Forensic Investigation and Analysis SG_SSCIE_H08 201900 Bachelor of Science (Honours) in Science SG_SSCIE_C06 201900 Higher Certificate in Science SG_SAGRI_H08 202000 Bachelor of Science (Honours) in Agri-Food Science SG_SBIOM_C06 202100 Higher Certificate in Science in Biomedical Science SG_SPHAR_C06 202100 Higher Certificate in Science in Pharmaceutical Science SG_SHUMA_H08 202200 Bachelor of Science (Honours) in Human Nutrition SG_SHUMA_B07 202200 Bachelor of Science in Human Nutrition SG_SBIOS_H08 202300 Bachelor of Science (Honours) in Biomedical Science SG_SHUMA_H08 202400 Bachelor of Science (Honours) in Human Nutrition SG_SSUST_C06 202400 Higher Certificate in Science in Sustainable Food Production SG_SAGRI_H08 202400 Bachelor of Science (Honours) in Agri-Food Science SG_SAGRI_B07 202400 Bachelor of Science in Agri-Food Science SG_SHUMA_B07 202400 Bachelor of Science in Human Nutrition
Description

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;

1.

Model problems using advanced features of Excel and build on concepts learned in Information Technology 1

2.

Create a poster to illustrate the results of a scientific project using an appropriate software package.

3.

Create brochures and information leaflets using an appropriate software

4.

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 & Continuous Assessment
100 %

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
Total Full Time Average Weekly Learner Contact Time 2.00 Hours

Required & Recommended Book List

Required Reading
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

Non ISBN Literary Resources

N/A

Journal Resources

N/A

URL Resources

N/A

Other Resources

N/A

 

Additional Information

N/A