Application of Excel Sheets in Chemistry
| Title | ΕΦΑΡΜΟΓΕΣ ΤΩΝ ΦΥΛΛΩΝ ΥΠΟΛΟΓΙΣΜΩΝ ΣΤΗ ΧΗΜΕΙΑ / Application of Excel Sheets in Chemistry |
| Code | Κ103 |
| Faculty | Sciences |
| School | Chemistry |
| Cycle / Level | 1st / Undergraduate |
| Teaching Period | Spring |
| Common | No |
| Status | Active |
| Course ID | 40002676 |
Programme of Study: PPS-Tmīma CΗīmeías (2016-sīmera)
Registered students: 0
| Orientation | Attendance Type | Semester | Year | ECTS |
|---|---|---|---|---|
| THEŌRĪTIKĪ CΗĪMEIA KAI CΗĪMIKĪ EKPAIDEUSĪ | Elective Course belonging to the selected specialization (Elective Specialization Course) | 8 | 4 | 5 |
| CΗĪMIKĪ ANALYSĪ-PERIVALLON-ĪLEKTROCΗĪMEIA | Optional Courses | 8 | 4 | 5 |
| CΗĪMIKĪ SYNTHESĪ-VIOCΗĪMEIA KAI VIOEFARMOGES | Optional Courses | 8 | 4 | 5 |
| CΗĪMIKĪ TECΗNOLOGIA KAI VIOMĪCΗANIKĪ CΗĪMEIA | Optional Courses | 8 | 4 | 5 |
| Academic Year | 2017 – 2018 |
| Class Period | Spring |
| Faculty Instructors | |
| Weekly Hours | 4 |
| Class ID | 600101679
|
Class Schedule
| Building | Χημείας (Παλαιό Α) |
| Floor | Όροφος 1 |
| Hall | ΑΙΘΟΥΣΑ 209 (292) |
| Calendar | Τετάρτη 11:00 έως 13:00 |
| Building | Χημείας (Παλαιό Α) |
| Floor | Όροφος 1 |
| Hall | ΑΙΘΟΥΣΑ 209 (292) |
| Calendar | Πέμπτη 11:00 έως 13:00 |
Course Type 2016-2020
- Background
Course Type 2011-2015
General Foundation
Mode of Delivery
- Face to face
Digital Course Content
- e-Study Guide https://qa.auth.gr/en/class/1/600101679
- At the Website of the School: http://www.chem.auth.gr/content/physical_lab/nikitas/Excel.pdf
Language of Instruction
- Greek (Instruction, Examination)
General Competences
- Retrieve, analyse and synthesise data and information, with the use of necessary technologies
Course Content (Syllabus)
Introduction to Computation Sheets (Excel).
Graphs.
Linear and nonlinear least squares.
Smoothing, differentiation and data integration.
Statistical analysis of data with worksheets.
Create complex data and application in breeding and study of physicochemical systems.
Introduction to macros.
Keywords
Computation Sheets (Excel);Linear and nonlinear least squares;Statistical analysis;macros
Educational Material Types
- Slide presentations
- Multimedia
- Book
Use of Information and Communication Technologies
Use of ICT
- Use of ICT in Course Teaching
- Use of ICT in Laboratory Teaching
- Use of ICT in Communication with Students
- Use of ICT in Student Assessment
Course Organization
| Activities | Workload | ECTS | Individual | Teamwork | Erasmus |
|---|---|---|---|---|---|
| Lectures | |||||
| Laboratory Work | |||||
| Tutorial | |||||
| Written assigments | |||||
| Total |
Student Assessment
Student Assessment methods
- Written Assignment (Formative, Summative)
- Report (Formative, Summative)
- Labortatory Assignment (Formative, Summative)
Bibliography
Course Bibliography (Eudoxus)
EXCEL ΕΙΣΑΓΩΓΗ ΚΑΙ ΕΦΑΡΜΟΓΕΣ, Π. I. Νικήτας, Θεσσαλονίκη 2008, ISBN 978-960-12-1775-8.
Additional bibliography for study
1. Άμεζη Βοήθεια ηος Excel και ηηρ Visual Basic for Applications. Ηλε-
κηπονική έκδοζη πος ζςνοδεύει ηο Microsoft Excel.
2. Microsoft Excel / User’s Guide, Microsoft Press, 1994.
3. Microsoft Excel / Visual Basic Programmer’s Guide, Microsoft Press,
1994.
4. Γ. Ζαπκάδαρ : Visual Basic for Applications (Ανάπηςξη βεληιζηοποιη-
μένος κώδικα για εθαπμογέρ ζηο Excel), Θεζζαλονίκη, 1998.
5. N. Καηζάνορ : Φςζικοσημεία, Αθήνα, 1993.
6. Π. Νικήηαρ : Μαθημαηική Ανάλςζη, Θεζζαλονίκη, 1997.
7. P. Atkins, Physical Chemistry, Oxford University Press, 1994.
8. R. de Levie : Quantitative Chemical Analysis, McGraw-Hill, New York,
1997.
9. R. de Levie : Advanced Excel for scientific data analysis, Oxford,
2008.
10. R. de Levie : How to Use Excel in Analytical Chemistry and in General
Scientific Data Analysis, Cambridge, 2001.
11. E.J. Billo, Excel for Chemists, Wiley-VCH, N.Y., 1997.
12. E.J. Billo, Excel for Scientists and Engineers, Wiley, 2007.
13. W. Press, B. Flannery, S. Teukolsky and W. Vetterling, Numerical
Recipes in Pascal, Cambridge University Press, 1986.
14. S. Chatterjee and B. Price, Regression Analysis by Example, John
Wiley & Sons, N.Y., 1977.
15. J.N. Miller and J.C. Miller, Statistics and Chemometrics for Analytical
Chemistry, Prentice Hall, 2000.
16. D.L. Massart et al., Handbook of Chemometrics and Qualimetrics:
Part A, Elsevier, 1997.
Last Update
14-10-2015
