Applied Computer Technology - GF392
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 2025
Semester: summer
Points: 0
E-Credits: 2
Examination process: summer s.:
Hours per week, examination: summer s.:0/21, C [HS]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
Key competences:  
State of the course: taught
Language: Czech
Teaching methods: full-time
Level:  
Note: course can be enrolled in outside the study plan
enabled for web enrollment
Guarantor: Mgr. Veronika Bernhauerová, Ph.D.
Comes under: 1.ročník 2025/26 Farmacie volitelné
Co-requisite : GF425
Interchangeability : GF131
Is interchangeable with: GF131
Examination dates   
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á:

  • Klemera, Petr. Výpočetní technika (PC, WINDOWS, WORD, EXCEL). Hradec Králové: , 2006, s. ISBN .

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

Students work on PCs under the guidance of a teacher.

Consultations are available upon personal or email request.

Last update: Bernhauerová Veronika, Mgr., Ph.D. (03.09.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 -

https://intranet.faf.cuni.cz/Study-materials/KBFCH/?path=applied+computer+technology

Last update: Bernhauerová Veronika, Mgr., Ph.D. (03.09.2025)
Learning outcomes -

The subject Applied Computer Technology builds on the knowledge and skills acquired in the subject Mathematics in the form of practical exercises in the spreadsheet editor MS Excel. Additionally, new skills are acquired through practical exercises in the text processor MS Word.

Upon completion of the course, students will understand and be able to work with the following terms in the MS Word environment: principles of document development; fonts, paragraphs, and page layout formatting; tables; mathematical expression editor; styles; templates; references (headings, cross-references, citations, table of contents).

Upon completion of the course, students will understand and be able to work with the following terms in MS Excel: cell formatting; calculation commands; use of functions; matrix expressions; graph generation and modification; data filtering and use of Subtotal functions; goal seek (What-If Analysis); Solver module; Data Analysis module

 

Learning Outcomes:

Based on the knowledge and skills acquired, students will:

  • define the importance of computing as a discipline that is essential for processing and evaluating data in biomedicine and pharmacy;
  • learn the principles of document development in MS Word text processor and formatting and defining mathematical and statistical formulas in MS Excel spreadsheet;
  • prepare and test texts using appropriate font and paragraph formatting in MS Word and data files using calculation commands and functions in MS Excel;
  • perform text formatting using the appropriate styles, templates and tables in the MS Word environment and visualization of data using charts in MS Excel;
  • will use examples to explain the principles of inserting headings, cross-references, citations and tables of contents in MS Word and advanced methods of data analysis using filtering and goal seek function in MS Excel;
  • evaluate and interpret various formatting methods in MS Word and the results of data analysis in MS Excel;
  • design an appropriate text formatting procedure in MS Word environment and an analysis procedure for evaluating data files in MS Excel environment.
Last update: Bernhauerová Veronika, Mgr., Ph.D. (03.09.2025)