Informatics

Code	Completion	Credits	Range	Language
32BE-P-INFO-01	Z,ZK	6	0P+4C	English

Garant předmětu:

Pavel Andres

Lecturer:

Pavel Andres

Tutor:

Pavel Andres

Supervisor:

Institute of Economic Studies

Synopsis:

In the digitized world of the 21st century, it should be a matter of course that the student is able to search, sort and critically evaluate information. He or she needs to be able to take advantage of the opportunities of the digital environment, which in the current environment can be included in the cross-cutting professional competencies needed for the performance of work, which are not exclusively related to a particular profession.

Requirements:

Attendance

Homework from each exercise

Tests based on the assignments - solving practical tasks on the computer

Seminar work: practical solution of the assigned topic

Syllabus of lectures:

Syllabus of tutorials:

• Management and sharing files within the cloud storage (MS OneDrive)

• Effective communication via e-mail, incl. mailbox management, defining rules, working with the calendar, contact

management (MS Outlook)

• Effective communication through MS Teams (Team administration, channels, online meetings, MS Teams Apps)

• Definition of tasks, delegation (assignment to team members), monitoring of task progress (MS Planner, To Do)

• Processing and editign text, incl. work with bibliographic citations, subtitles, indexes, lists, work with styles,

templates (MS Word, Zotero)

• Manipulation with data, incl. advanced financial analysis, creation of reports to support managerial decision-making

(MS Excel)

• Presentation of information in an efficient way, using diagrams, graphs, audio / video sequences, animations, slide

transitions (MS PowerPoint)

• Keeping structured notes (MS OneNote)

• Effective communicationwithin teams, incl. data sharing, group definition and permissions within the organization

(MS SharePoint)

• Definition of the structure of a relational database, create a simple database, sort and filter data, create input / output

forms, enter queries (MS Access)

• Creation of a structured list, creation of views, definition of permissions (MS Lists)

Study Objective:

The study objective of the course of Informatics is to equip students with a sufficient set of transferable digital competencies, with emphasis on the main principles of digital technologies, the use of effective applications of digital technologies to obtain relevant information needed in all areas of training future economists.

Study materials:

MOS Study Guide

In-depth exam prep, practice, and review to help advance proficiency with Microsoft Office—and earn Microsoft Office Specialist (MOS) certification credentials.

The MOS Study Guide is designed to help readers practice and prepare for the skills and knowledge measured by the MOS certification exams. These books divide exam coverage into chapters representing groups of core, related skill sets that correspond to MOS exam objectives.

• Full objective-by-objective review.

• Detailed procedures to help build the skills measured by the exam.

• Hands-on tasks to practice what you've learned.

• Ready-made, downloadable practice files.

- MOS Study Guide for Microsoft Word Exam MO-100. By Joan Lambert. ISBN-10: 0-13-662804-4 | ISBN-13: 978-

- MOS Study Guide for Microsoft Word Expert Exam MO-101. By Paul McFedries. ISBN-10: 0-13-662837-0 |

- MOS Study Guide for Microsoft PowerPoint Exam MO-300. By Joan Lambert. ISBN-10: 0-13-662810-9 | ISBN-

- MOS Study Guide for Microsoft Outlook Exam MO-400. By Joan Lambert. ISBN-10: 0-13-662863-X | ISBN-13:

- e-learning via LMS Moodle

Note:

Further information:

https://moodle-vyuka.cvut.cz/course/view.php?id=11372

Time-table for winter semester 2023/2024:

Time-table is not available yet

Time-table for summer semester 2023/2024:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Wed	roomDEJ:423 10:45–14:00 (parallel nr.101) Dejvice PC Lab
Thu
Fri

The course is a part of the following study plans: