General Details

Full Title
Transcript Title
N/A %
Subject Area
COMP - Computing
LIFE - Life Sciences
06 - NFQ Level 6
05 - 05 Credits
Start Term
2014 - Full Academic Year 2014-15
End Term
2019 - Full Academic Year 2019-20
Ian McLoughlin, Eoin Gillespie, Cian Taylor, Akinlolu Akande, Padraig McGourty
Programme Membership
SG_JSCIE_X06 201400 Certificate SG_SAGRI_G06 000000 Higher Certificate in Science in Agri-Food Science SG_SHEAL_H08 201600 Bachelor of Science (Honours) in Science in Health Science and Physical Activity SG_SSCIE_H08 201600 Bachelor of Science (Honours) SG_SSCIE_C06 201600 Higher Certificate in Science SG_SSCIE_H08 201700 Bachelor of Science (Honours) SG_SHUMA_H08 201700 Bachelor of Science (Honours) in Human Nutrition SG_SHUMA_B07 201700 Bachelor of Science in Human Nutrition SG_SSCIE_C06 201700 Higher Certificate in Science SG_SHUMA_B07 201800 Bachelor of Science in Science in Human Nutrition SG_SAGRI_B07 201800 Bachelor of Science in Science in Agri-Food Science SG_SAGRI_H08 201800 Bachelor of Science (Honours) in Science in Agri-Food Science

This module deals with advanced practical applications of Information Technology. It covers the software packages for spreadsheets, posters, brochures and databases.

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 the appropriate software package


Create brochures and information leaflets using desktop publishing software


Explain the theory of database technology and the basics of data storage technologies


Design and create a simple website using an appropriate web page editor or online service


Use various web based tools which will aid with collaboration on group projects.

Module Assessment Strategies

As part of the summative assessment the learner will complete assignments in the desktop publishing and website development section which will be completed durning the students independent learning.

There will also be two computer laboratory based assessments which will assess the students practical application of skills used during the Advanced Excel and Database sections of the course as well as their knowledge of collaboration tools.

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 assisstance and feedback during the completion of these activities which they can then put into practice when undertaking the summative assessment.

Module Dependencies


Indicative Syllabus

Advanced Excel

IF statements/Nested IF statements

Lookup Functions

Advanced Charts

Pivot Tables/Pivot Charts

Desktop Publishing

Creating scientific posters using MS PowerPoint

Brochures and Information leaflets in MS Publisher

Databases and Data Storage

Introduction to Database terminology

Database Architectures

Data storage technologies

Website Development

Introduction to basic HTML

Introduction to basic CSS

Use of an appropriate tool to develop a simple website

Collaboration Tools

Online productivity tools (Google Docs, Office Live, Dropbox etc.)

Tools for conducting online surveys


Coursework & Assessment Breakdown

End of Semester / Year Formal Exam
100 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Practical Evaluation Weekly Class Activities Formative UNKNOWN - % OnGoing 1,2,3,4,5,6
2 Continuous Assessment Lab Based Excel Assessment Continuous Assessment UNKNOWN 30 % Week 4 1
3 Project Desktop Publishing Assignment Continuous Assessment UNKNOWN 25 % Week 8 2,3
4 Project Simple Website Development Continuous Assessment UNKNOWN 20 % Week 11 5
5 Practical Evaluation End of Module Assessment on Databases and collaboration tools Continuous Assessment UNKNOWN 25 % Week 13 4,6

Full Time Mode Workload

Type Location Description Hours Frequency Avg Workload
Laboratory Practical 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

Module Resources

Non ISBN Literary Resources

Bucki, L. (2013). Office 2013 Library, Wiley, U.S.A

Marmel, E. (2013). Office 2013 Simplified, Wiley, U.S.A

Liengme, B. (2007). A Guide to Microsoft Excel 2007 for Scientists and Engineers, Elsevier, Canada

URL Resources
Other Resources



Additional Information