Course Information
TitleΕΦΑΡΜΟΓΕΣ ΤΩΝ ΦΥΛΛΩΝ ΥΠΟΛΟΓΙΣΜΩΝ ΣΤΗ ΧΗΜΕΙΑ / Application of Excel Sheets in Chemistry
CodeΚ103
FacultySciences
SchoolChemistry
Cycle / Level1st / Undergraduate
Teaching PeriodSpring
CommonNo
StatusActive
Course ID40002676

Programme of Study: PPS-Tmīma CΗīmeías (2016-sīmera)

Registered students: 6
OrientationAttendance TypeSemesterYearECTS
THEŌRĪTIKĪ CΗĪMEIA KAI CΗĪMIKĪ EKPAIDEUSĪElective Course belonging to the selected specialization (Elective Specialization Course)845
CΗĪMIKĪ ANALYSĪ-PERIVALLON-ĪLEKTROCΗĪMEIAOptional Courses845
CΗĪMIKĪ SYNTHESĪ-VIOCΗĪMEIA KAI VIOEFARMOGESOptional Courses845
CΗĪMIKĪ TECΗNOLOGIA KAI VIOMĪCΗANIKĪ CΗĪMEIAOptional Courses845

Class Information
Academic Year2019 – 2020
Class PeriodSpring
Faculty Instructors
Weekly Hours4
Total Hours52
Class ID
600145941
Type of the Course
  • Background
Course Category
General Foundation
Mode of Delivery
  • Face to face
Digital Course Content
Language of Instruction
  • Greek (Instruction, Examination)
Learning Outcomes
Upon successful completion of the course the student is expected to: - Be able to import and format experimental data on Microsoft Excel spreadsheets with the ability to edit and present them in graphs - Be familiar with the application of Excel in data analysis and evaluation (price confidence intervals, error estimation, data correlation) - Implement statistical case controls - Understand the theory of least squares and apply linear and non-linear curve adjustment (regression) to experimental data
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
ActivitiesWorkloadECTSIndividualTeamworkErasmus
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
26-04-2020