SubjectsSubjects(version: 945)
Course, academic year 2023/2024
   Login via CAS
Applied Computer Technology - GAF131
Title: Applied Computer Technology
Guaranteed by: Department of Biophysics and Physical Chemistry (16-16110)
Faculty: Faculty of Pharmacy in Hradec Králové
Actual: from 2023
Semester: summer
Points: 0
E-Credits: 1
Examination process: summer s.:
Hours per week, examination: summer s.:0/21, C [HS]
Capacity: unknown / 66 (unknown)
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
Key competences:  
State of the course: taught
Language: English
Teaching methods: full-time
Teaching methods: full-time
Level:  
Explanation: (F 1.r.)
Note: deregister from the credit exam date if a requisite was not fulfilled
course can be enrolled in outside the study plan
enabled for web enrollment
Guarantor: doc. Dipl.-Math. Erik Jurjen Duintjer Tebbens, Ph.D.
Classification: Pharmacy >
Co-requisite : GAF105
Annotation -
Last update: doc. Dipl.-Math. Erik Jurjen Duintjer Tebbens, Ph.D. (11.10.2021)
The undergraduates get acquainted with the basic concepts and ideas of system theory and the principles of its application in regulation and control, in theory of information, computer technology and modelling. They get practice in the usage of personal computers, oriented mainly to text documents (MS Word) and experimental data processing (MS Excel).
Course completion requirements -
Last update: doc. Dipl.-Math. Erik Jurjen Duintjer Tebbens, Ph.D. (11.10.2021)

1. Active participation during all seminars – in the case of absence, a written

excuse by the physician must be handed over.

2. The student must pass the final test in which all tasks must be fulfilled in a

satisfactory way. Every student has at most 3 tries.

Literature -
Last update: doc. Dipl.-Math. Erik Jurjen Duintjer Tebbens, Ph.D. (11.10.2021)

Recommended:

  • Petr Klemera. Computer technology. Compendium for students of Pharmacy. Hradec Kralove: Farmaceuticka fakulta UK, , s. ISBN .

Syllabus -
Last update: doc. Dipl.-Math. Erik Jurjen Duintjer Tebbens, Ph.D. (11.10.2021)

Text editor Microsoft WORD

  • principles of documents creating, templates
  • formatting of fonts and paragraphs, page setup
  • handling of tables
  • equation editor
  • using of styles
  • references (captions, cross-references, citations, table of contents)

Spreadsheet Microsoft EXCEL

  • basic manipulation; formatting of cells
  • creating of formulas; the use of functions; matrix expressions
  • creating of graphs and theirs modification
  • data filtration; function Subtotal
  • Solver
Teaching methods -
Last update: doc. Dipl.-Math. Erik Jurjen Duintjer Tebbens, Ph.D. (11.10.2021)
Teachers conduct the seminars. Consultation may be based on a personal, telephone or email order.
Requirements to the exam -
Last update: doc. Dipl.-Math. Erik Jurjen Duintjer Tebbens, Ph.D. (11.10.2021)
There is no exam for this course.
 
Charles University | Information system of Charles University | http://www.cuni.cz/UKEN-329.html