SubjectsSubjects(version: 964)
Course, academic year 2024/2025
   Login via CAS
Applied Computer Technology - GB224
Title: Aplikovaná výpočetní technika
Guaranteed by: Department of Biophysics and Physical Chemistry (16-16110)
Faculty: Faculty of Pharmacy in Hradec Králové
Actual: from 2024
Semester: summer
Points: 0
E-Credits: 2
Examination process: summer s.:
Hours per week, examination: summer s.:0/8, C [HS]
Capacity: unknown / 25 (unknown)
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
Key competences:  
State of the course: taught
Language: Czech
Teaching methods: combined
Level:  
Explanation: (ZBK 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: Mgr. Veronika Bernhauerová, Ph.D.
Comes under: 2.ročník 2024/25 LDZ kombinovaná
Co-requisite : GB106
Annotation -
Lessons are held on a PC with Windows operating system. Students will become familiar with the text editor WORD and the table processor EXCEL.
Last update: Bernhauerová Veronika, Mgr., Ph.D. (14.02.2025)
Course completion requirements -

The following conditions must be met for credit to be awarded:

  1. Active participation in all exercises. Absence can be compensated by participation in the seminar at another time. Absences may be excused for medical reasons (illness, hospitalization) only upon presentation of a written certificate from the attending physician.
  2. Successful completion of the credit test. Satisfactory completion of all assigned instructions is required for successful completion of the test. Each student is entitled to 3 attempts.
Last update: Bernhauerová Veronika, Mgr., Ph.D. (14.02.2025)
Literature - Czech

Doporučená:

  • Petr Klemera. Výpočetní technika (PC, Windows, WORD, EXCEL). Hradec Kralove: Farmaceuticka fakulta, 2006, s. ISBN .

Last update: Bernhauerová Veronika, Mgr., Ph.D. (14.02.2025)
Teaching methods - Czech

Studenti pracují na PC pod vedením vyučujícího.

Konzultace možná na základě osobní nebo emailové žádosti .

Last update: Bernhauerová Veronika, Mgr., Ph.D. (14.02.2025)
Requirements to the exam - Czech

Předmět není ukončen zkouškou.

Last update: Bernhauerová Veronika, Mgr., Ph.D. (14.02.2025)
Syllabus -

Text editor Microsoft WORD

  • principles of document creation
  • font formatting, paragraphs, page layout
  • tables
  • mathematical expressions editor
  • using and creating styles; templates
  • references (titles, cross-references, citations, table of contents)


Tabular processor Microsoft EXCEL

  • basic cell manipulation; cell formatting
  • commands; functions; matrix expressions
  • graphs and data visualisation
  • data filtering; function Subtotal
  • goal seeking; Solver
Last update: Bernhauerová Veronika, Mgr., Ph.D. (14.02.2025)
Learning resources - Czech

https://intranet.faf.cuni.cz/Studijni-materialy/KBFCH/?path=výpočetní+technika

Last update: Duintjer Tebbens Erik Jurjen, doc. Dipl.-Math., Ph.D. (11.10.2021)
 
Charles University | Information system of Charles University | http://www.cuni.cz/UKEN-329.html