Conversational English focused on education topics – for future teachers who want to strengthen their language skills at level B2+.
PROCESSING TEXT AND DATA
Learn to work effectively with texts and data – from document formatting, to spreadsheet analysis.
1. Basic typographic rules in text documents
2. Document template and styles.
3. Non-text elements in text documents (graphs, diagrams, images, etc.).
4. Automatic elements in text documents (citations, footnotes, index, headers and footers, references in the document, table of contents, and subtitles).
5. Collaboration of multiple authors in creating a text document and working in the cloud.
6. Finalizing a text document before printing.
7. Forms and their creation with direct connection to spreadsheets and calculators.
8. File formats of tabular data, import and export of tabular data. Options and methods of displaying, formatting, and conditional formatting of tabular data.
9. Sorting, filtering, and summarizing tabular data. Addressing, numerical operations, formulas, mathematical functions, generating values.
10. Functions for operations with text values in tables. Functions for searching tabular data.
11. Working with date and time.
12. Graphical (re)presentation of tabular data, types of charts, and principles for their use.
13. Pivot tables and pivot charts.
AIM OF THE SUBJECT:
The aim of the course is to equip students with the skills to effectively process large text documents with non-text additions, and with the skills to process data using software tools known as spreadsheets or spreadsheet calculators.
STUDENT ENTRY REQUIREMENTS:
The student should be able to work with a basic text editor, including simple editing and formatting of text. Basic knowledge of a spreadsheet, the ability to perform simple calculations and edit tables is also expected. The student should be able to work with files and perform basic operations with them, such as creating, copying, and renaming.
CONDITIONS FOR GRADUATING:
- Credits: To obtain credit, active participation in seminars is required, which consists of solving practical examples that can be used in teaching various educational areas. Furthermore, the preparation of seminar assignments and, last but not least, the completion of practical tests are required.
GUARANTORS AND TEACHERS:
- GUARANTOR: Dr. Lenka Benediktová, Ph.D., Mgr.(100%)
- LECTURER(S): Dr. Lenka Benediktová, Ph.D., Mgr.(100%), Jan Král, Mgr.
- TRAINER(S): Jan Král, Mgr. (50%), Viola Vrbová, Mgr. (100%)
LEARNING OUTCOMES:
After completing the course, the student demonstrates knowledge and skills in the field of processing and appropriate formatting of text in a text editor, including working with non-text elements, and using automation functions. He/she masters commonly used typographic principles, and knows where to find the necessary information, where required. He/she also understands the principles of obtaining, viewing, organizing, formatting, analysing, representing, and storing tabular data in one commercial, and several freely available, software tools.
TEACHING METHODS USED TO ACHIEVE PROFESSIONAL KNOWLEDGE:
Lecture with demonstration,
E-learning,
Self-study,
Problem solving,
Discussion.
CATEGORY
ORGANISER:
Faculty of Education
SUBJECT ABBREVIATION:
KVD/ZPTD
REGISTRATION DEADLINE:
From 15. 6. 2025 to 31. 8. 2025
DATE(S):
Winter semester 2025/2026
SUBJECT SCHEDULE/TIMETABLE:
Lecture – Room KL 228
Monday 6:30 p.m. – 7:15 p.m.
Seminar – Room KL 206
Wednesday 12:05 p.m. – 2:40 p.m.
FPE Building, Klatovská třída 51, Plzeň
17. 9. 2025 – 15. 12. 2025
FORM OF STUDY:
Contact teaching: 52 hours
Preparation for partial test: 20 hours
E-learning: 30 hours
Preparation for comprehensive test: 30 hours
HOW IT ENDS:
- Credits
5 CREDITS
PRICE: CZK 4,500
After logging in, you will be redirected to the e-application form, where you must complete the registration.
ADRESS
Klatovská tř. 1736/51, Pilsen
RECOMMENDED COURSES
- Academic year 2025/2026
- Art and Crafts
- Chemistry
- Czech language
- English language
- Geography
- German language
- Hobbies and free time activities
- Information Technology
- Law
- Music
- Physical education
- Physics
- Programming
- Psychology
- Russian language
- Secondary school students
- Upskilling
In this course, students will learn about mathematical procedures in financial mathematics and life insurance, such as interest rates, cash...
The STAV course introduces students to the graphical processing and presentation of statistical data using specialized software. The course also...