DCU Home | Our Courses | Loop | Registry | Library | Search DCU

Registry

Module Specifications

Archived Version 2011 - 2012

Module Title Organisation, Visualisation, Validation and Presentation of Laboratory Data
Module Code CS207
School School of Chemical Sciences

Online Module Resources

Module Co-ordinatorProf. Robert ForsterOffice NumberX110
NFQ level 8 Credit Rating 5
Pre-requisite None
Co-requisite None
Compatibles None
Incompatibles None
Description

The purpose of this module is to develop skills in the us of spreadsheets for the visualisation, analysis and presentation of chemical data. In this module, students will develop knowledge and skills in descriptive statistics and the importance of statistical data for validating results. Students are expected to attend lectures a well as hands-on practical PC sessions and to contribute to discussions.

Learning Outcomes

1. Apply descriptive statistical methods to quantitatively summarize a chemical data set.
2. Present and compare data in graphical form.
3. Perform linear regression analysis on chemical data sets.
4. Apply theoretical models so as to linearise data sets.
5. Process data, e.g., by using numerical differentiation, so as to maximise information conent.
6. Use gradient search methods to fit non-linear theoretical models to experimental data.



Workload Full-time hours per semester
Type Hours Description
Lecture12Real world and theoretical chemical problems in data analysis, visualisation and presentation are presented and discussed.
Laboratory24Students quantitatively analyse a spreadsheet containing data, fit models and produce presentations of their conclusions.
Independent Study89Students conduct background reading and practice preparing spreadsheets, documents and presentation skills. Students also revise key chemistry topics covered in course.
Total Workload: 125

All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml

Indicative Content and Learning Activities

Descriptive Statistics
Students will use Excel to calculate quantitative descriptive statistics for data sets including mean, standard deviation, standard, relative and absolute errors, perform one-tailed & two-tailed tests and F-tests.

Modelling Kinetic Data
Students will linearise first and second order kinetic models, apply these models to experimental data and apply linear regression analysis to determine the rate constants.

Modelling and Visualising Equilibria
Experimental monoprotic titration data will be analysed using theoretical models and plotted and analysed.

Importing instrumental data
Students will learn how to import, frmt, analyse and present data generated by a range of instruments.

Multi-Step Reactions
Students will use theoretical formation constants to construct and visualise the concnetrations of individua components in a multi-step Metal – Ligand Complexation reaction.

Gradient Search Methods
Students will use gradient search methods to fit non-linear models such as kinetics, equilibria etc, to experimental data.

Assessment Breakdown
Continuous Assessment100% Examination Weight0%
Course Work Breakdown
TypeDescription% of totalAssessment Date
Reassessment Requirement
Resit arrangements are explained by the following categories;
1 = A resit is available for all components of the module
2 = No resit is available for 100% continuous assessment module
3 = No resit is available for the continuous assessment component
Unavailable
Indicative Reading List

  • Diamond, D. and Hanratty, V.C.A.: 1997, Spreadsheet Applications in Chemistry,, Wiley Interscience, ISBN 0471149872
  • E. Joseph Billo: 1997, Excel for Chemists, Wiley-VCH, 0-471-18896-4
Other Resources

None
Programme or List of Programmes
ACBSc in Chemical and Pharmaceutical Sc.
ASBSc in Analytical Science
BSSAStudy Abroad (DCU Business School)
BSSAOStudy Abroad (DCU Business School)
ECSAStudy Abroad (Engineering & Computing)
ECSAOStudy Abroad (Engineering & Computing)
ESHBSc Environmental Science & Tech
ESTBSc in Environmental Science & Tech
HMSAStudy Abroad (Humanities & Soc Science)
HMSAOStudy Abroad (Humanities & Soc Science)
IESAStudy Abroad (Institute of Education)
IESAOStudy Abroad (Institute of Education)
SHSAStudy Abroad (Science & Health)
SHSAOStudy Abroad (Science & Health)
Archives: