COMP06172 2014 INFORMATION TECHNOLOGY 2 AND MOLECULAR GRAPHICS
This module deals with advanced practical applications of Information Technology. It covers the software packages for word processing, presentations and databases. It also covers a basic introduction to computer forensics.
The scientific applications will include drawing two-dimensional chemical structures, determining basic chemical parameters with software (i.e. determination of molecular weights, verifying chemical reactions, etc.) and using a spreadsheet to simulate titrations.
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;
Produce a poster which illustrates the results of a piece of research and all its constituent parts.
Communicate using Presentation Software in teams or individually.
Use a number of tools designed for collaboration on projects.
Use basic molecular graphics applications to create and study chemical structures.
Module Assessment Strategies
This module will be assessed by means of practical activities done in the computer laboratory during the weekly practical sessions, assignments in the desktop publishing and presentations section which will be completed durning the students independent learning. There will also be a computer laboratory based assessment during the module to ensure the student has met the learning outcomes and has taken on board the feedback given during the weekly practical sessions and the assignments already completed
Advanced processing of data using Excel
Process Control Charts
IF Statements/Nested IF Statements
Pivot Tables/Pivot Charts
Simulation of titrations with Microsoft Excel.
Processing of titrimetric data with a spreadsheets
Developing a poster in MS PowerPoint
Tools used for collaboration.
Use two dimensional structural drawing and evaluation software e.g. ISIS Draw.
Coursework & Assessment Breakdown
|Title||Type||Form||Percent||Week||Learning Outcomes Assessed|
|1||Practical Evaluation Advanced Excel Exam||Continuous Assessment||UNKNOWN||20 %||Week 4||3,5|
|2||Project Project using collaboration tools||Continuous Assessment||UNKNOWN||10 %||Week 6||2,3|
|3||Project Production of a scientific poster||Continuous Assessment||UNKNOWN||20 %||Week 8||1,2|
|4||Practical Evaluation Laboratory Practicals, Presentations, Mini Projects||Continuous Assessment||UNKNOWN||50 %||OnGoing||2,4,5|
Full Time Mode Workload
|Laboratory Practical||Computer Laboratory||Computer Laboratory Practical||3||Weekly||3.00|
|Independent Learning||UNKNOWN||Self Study||4||Weekly||4.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
Harris, Daniel C. Quantitative chemical Analysis, 7th Edition (2006), Publ. W.H. Freeman and Company (Chapters 3-5) (1)
Microsoft Office Support Site - http://office.microsoft.com/