WSC-7 | Course Chemometrics in Excel

Course Chemometrics in Excel (3–5 ECTS credits)

February 14, 2010, St. Petersburg, Russia, WSC-7 preconference course
Contact person: Oxana Rodionova (rcs@chph.ras.ru)

Last Updates

Course materials are ready now. They are published at web page Tutorials.
The following manuals (with accompanying materials) — Matrix calculations in Excel, Projection methods in Excel will be considered in the course and it is highly recommended to study them carefully.

The course participants are advised to refresh their Excel skills and to carry out exercises given in file Tasks.xls. Other tutorials are presented in Russian for special Russian Educational Project. Free Demo version of Chemometrics Add-In can be used with the tutorials and supplementary Excel files.

The registered attendees will receive individual license for the full scale Add-In via personal communication.

Several vacancies in the course are still available, so you are welcome to apply.

Register on-line

Course description

The aim of the course is to provide the participants with simple and powerful tool for basic multivariate analysis. The core functions for projection methods are presented as worksheet functions in Excel, a most widely-spread data handling environment. All calculations are carried out in Excel books, and all regular Excel capacities can be applied for additional calculations: charts, data export and import, templates, etc. During the course attendees will have a wide opportunity for the hands-on data analysis.

Audience and language

Students (including postgraduates), specialists, scientists with a basic knowledge in chemometrics and Excel. The course language is English. Participants are encouraged to use their own laptops with Excel 2007 and Chemometrics Add-In installed.

Instructors

DSc. Alexey Pomerantsev (ICP RAS, Moscow)
DSc. Satu-Pia Reinikainen (LUT, Lappeenranta)
DSc. Oxana Rodionova (ICP RAS, Moscow)

Course materials

Course materials, including:

Projection methods in Excel (web tutorial)
Matrix calculations in Excel (web tutorial)
Supplementary xls-files
Chemometrics Add-In software

will be provided for the participants on January 15, 2010. To refresh the Excel skills it is highly recommended to read the tutorials and to carry out exercises.

Course Outline

Introduction (Brief reminders)

Basic projection methods PCA, PLS
Matrix calculations in Excel
Main features of Chemometrics.Add-In

Computer exercises

Explorative (one-block) data analysis: PCA and classification
Multivariate calibration

ECTS points

3 ECTS cr. are appointed by LUT to participants who carry out a final assignment provided at the end of the course and attend WSC-7 with a presentation. Two additional consultations will be given during WSC-7.

+ 2 ECTS cr. are appointed for the participants whose manuscripts will be accepted for the special WSC-7 issue of the Journal of Chemometrics.

Fee and deadlines

Fee includes full individual license for Chemometrics Add-In software

Early registration, till December 15, 2009 — 200 EUR
Registration after December 15, 2009 — 250 EUR

Deadline — January 30, 2010

Upon cancellation until twenty days before the start of the course, half of the course fee is due. Cancellations made less than twenty days before the start date of the course will not be refunded. In case you cannot attend, you can let someone else take your place without additional cost. Course organizers have the right to cancel a course until twenty days before the start of the course, in which case a complete refund will be provided. Course organizers also have the right to reject the application of course candidates without further motivation.

Program