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.
Learning Outcomes
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
Module Dependencies
Indicative Syllabus
Advanced processing of data using Excel
Process Control Charts
IF Statements/Nested IF Statements
Lookup Functions
Pivot Tables/Pivot Charts
Simulation of titrations with Microsoft Excel.
Processing of titrimetric data with a spreadsheets
Desktop Publishing
MS Publisher
Developing a poster in MS PowerPoint
Tools used for collaboration.
Google Docs
Office Live
Dropbox
Presentation Software
Prezi
Molecular Grapics
Use two dimensional structural drawing and evaluation software e.g. ISIS Draw.
Coursework & Assessment Breakdown
Coursework Assessment
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
Type | Location | Description | Hours | Frequency | Avg Workload |
---|---|---|---|---|---|
Laboratory Practical | Computer Laboratory | Computer Laboratory Practical | 3 | Weekly | 3.00 |
Independent Learning | UNKNOWN | Self Study | 4 | Weekly | 4.00 |
Module 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
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/
None