SubjectsSubjects(version: 963)
Course, academic year 2020/2021
  
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
State of the course: taught
Language: English
Teaching methods: full-time
Teaching methods: full-time
Level:  
Guarantor: Raich Ivan doc. Dr. Ing.
Examination dates   Schedule   
Syllabus - Czech

. 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.

Last update: KNOBLOCL (17.01.2012)
 
VŠCHT Praha