COMP06171 2014 INFORMATION TECHNOLOGY 2
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.
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.
IF statements/Nested IF statements
Pivot Tables/Pivot Charts
Creating scientific posters using MS PowerPoint
Brochures and Information leaflets in MS Publisher
Databases and Data Storage
Introduction to Database terminology
Data storage technologies
Introduction to basic HTML
Introduction to basic CSS
Use of an appropriate tool to develop a simple website
Online productivity tools (Google Docs, Office Live, Dropbox etc.)
Tools for conducting online surveys
Coursework & Assessment Breakdown
|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
|Laboratory Practical||Computer Laboratory||Practical||2||Weekly||2.00|
|Independent Learning||UNKNOWN||Self Study||5||Weekly||5.00|
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