Basics of IT - EAP0101250

• Title: Basics of IT
• Guaranteed by: Centre for Information Technology (14-172)
• Faculty: Faculty of Medicine in Pilsen
• Actual: from 2021
• Semester: winter
• Points: 1
• E-Credits: 1
• Examination process: winter s.:
• Hours per week, examination: winter s.:0/6, C [HS]
• Capacity: unknown / unlimited (unknown)
• Min. number of students: unlimited
• 4EU+: no
• Virtual mobility / capacity: no
• State of the course: taught
• Language: English
• Teaching methods: full-time
• Teaching methods: full-time
• Additional information: https://lms.lfp.cuni.cz/course/view.php?id=517
• Guarantor: Mgr. Martin Navrátil; Ing. Bc. Milan Dvořák
• Teacher(s): Mgr. Martin Navrátil
• Interchangeability : EA0101501

Course completion requirements

English

Credit conditions:

Assignment MS Word

Assignment MS Excel

Quiz - LMS Moodle and Security Internet and Cloud computing

Last update: Dvořák Milan, Ing. Bc. (16.12.2022)

Syllabus

English

Charles University Information system applications
- login to CAS, account information, reset forgotten password
- verify e-mail address, change password
- eduroam - how to connect (access data)

Learning resources and LFP systems
- Benefits of e-Learning
- LMS Moodle, Students in Moodle
- SIS (study information system)
- Mefanet portal

MS Word
- Styles in MS Word
- Automatic Table of Contents
- Captions
- Automatic Table of Figures
- Page Header and Footer
- Sections

MS Excel
- Basic Layout of Excel, Working with Sheets, Active Cell
- Moving Around the Table, Basic Settings of Columns and Rows
- Cell Format – Numbers, Date, Time, Copying Cells, Number Serie
- Basic Mathematical Operations
- Creating Formulas, Relative and Absolute Addressing
- Basic Functions in Excel – SUM, AVERAGE
- Charts

Security Internet and Cloud computing
- Social Networks – Dangers
- Protection of PC and Other Devices
- Secure Data Deletion
- Copyright Laws Protecting Materials on the Internet
- Cloud computing (technology, advantages/disadvantages, useful cloud services)

Last update: Dvořák Milan, Ing. Bc. (16.12.2022)

Course completion requirements

English

Credit conditions:

Assignment MS Word

Assignment MS Excel

Quiz - LMS Moodle and Security Internet and Cloud computing

Last update: Dvořák Milan, Ing. Bc. (16.12.2022)