Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024

Basic Work with PC

Login to KOS for course enrollment Display time-table
Code Completion Credits Range
16ZPSP Z 2 0+2
Garant předmětu:
Kamil Augsten
Lecturer:
Tutor:
Kamil Augsten
Supervisor:
Department of Dosimetry and Application of Ionizing Radiation
Synopsis:

The aim of the course is to acquaint students with the basic skills related to working on a personal computer. The introductory part of the course is devoted to information systems and resources available at the CTU in Prague and the FNSPE. Emphasis is placed on effective handling of work with office productivity software (text editor, spreadsheet and presentation software) with exercises in MS Office. The practical content focuses mainly on further use during studies (laboratory reports, research work, bachelor's and diploma theses) and in specific practice (hospitals, state administration, companies). Other sections summarize basic information about computer hardware, software, and security. Completion of independent home exercises and participation in exercises above 60% is a necessary condition for passing the course.

Requirements:

There are no prerequisities.

Syllabus of lectures:
Syllabus of tutorials:

1. Introduction to Computer Science, Information Technology at CTU. Office productivity software

2. Word Processing I - The philosophy and basic functions

3. Word Processing II. - Formatting templates

4. Word Processing III. - Advanced features, major projects (basic rules for DTP)

5. Spreadsheet I - The philosophy and basic functions

6. Spreadsheet II. - Formulas, built-in functions, formatting

7. Spreadsheet III. - Advanced function, accessories, solver

8. Spreadsheet IV. - Examples from practice, exercises

9. Presentation tools I. - An overview of key features (principles of formatting)

10. Presentation tools II. - Presentation principles + exercises, creation of other documents (posters, etc.),

11. Hardware (general principles, knowledge for the selection of PCs) and software (sorting, summary, licenses and basic functions of OS)

12. IT security (viruses, firewalls, spyware, phishing, certificates, encryption)

13. Practicing and individual consultations (if required by students)

Study Objective:

Knowledge:

Basic IT knowledge in hardware and software, computer security and safe work with data. Overview and control of IT resources available at CTU. Good knowledge of MS Office and awareness of alternatives.

Skills:

Work with office productivity software (Word, Excel, PowerPoint) with an emphasis on future application during studies and in practice. Searching in electronic resources and working with a bibliography.

Study materials:

Key references:

[1] Materials on the server https://behounek.fjfi.cvut.cz

[2] Microsoft 365 Training, https://support.microsoft.com/en-us/training

Recommended references:

[3] Klatovský K., Microsoft Office 365 - Podrobný průvodce, Grada, 2023.

[4] Fox, R., Information Technology, Routledge, 2020.

Note:
Further information:
https://behounek.fjfi.cvut.cz/course/view.php?id=83
Time-table for winter semester 2023/2024:
Time-table is not available yet
Time-table for summer semester 2023/2024:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2024-07-23
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet1283806.html