Computer Technique - S342021
Title: Computer Technique
Guaranteed by: Department of Chemistry of Natural Compounds (342)
Faculty: Faculty of Food and Biochemical Technology
Actual: from 2011 to 2020
Semester: winter
Points: winter s.:2
E-Credits: winter s.:2
Examination process: winter s.:
Hours per week, examination: winter s.:1/1, C+Ex [HT]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
Language: English
Teaching methods: full-time
Teaching methods: full-time
Level:  
For type:  
Guarantor: Raich Ivan doc. Dr. Ing.
Examination dates   Schedule   
Syllabus - Czech
Last update: KNOBLOCL (17.01.2012)

. Creation of long and technical documents in Microsoft Word, creation and formatting of styles and templates.

2. Advanced formatting using styles and templates, outline, creation and formatting of tables.

3. Multilevel numbered and bulleted lists, tables of contents, indexes.

4. References, cross-references, numberings of pages and other items.

5. Absolute and relative addresses in Microsoft Excel, working with large tables and sheets, advanced and embedded functions, array formulae.

6. Conditional formatting, pivot tables, optimizations using Solver.

7. Advanced sorting and ranking values, filtering data, database functions.

8. Database objects in Microsoft Access: tables, fields, queries, indexes, forms and reports. Relational databases.

9. Creation of databases, entering data, queries.

10. Reporting from databases, SQL language.

11. Chemical structures editing in ChemSketch, finding related chemical information.

12. Searching for structural, chemical and biological data in commercial chemical databases.

13. Introduction to molecular modeling, visualization and creation of 3-D chemical structures.

14. Electronic laboratory notebook, managing spectral and literature data.