PředmětyPředměty(verze: 901)
Předmět, akademický rok 2022/2023
  
Advanced Data Analysis in MS Excel - JEB111
Anglický název: Advanced Data Analysis in MS Excel
Zajišťuje: Institut ekonomických studií (23-IES)
Fakulta: Fakulta sociálních věd
Platnost: od 2021
Semestr: oba
E-Kredity: 3
Rozsah, examinace: 0/2 Zk [hodiny/týden]
Počet míst: zimní:neurčen / 40 (70)
letní:neurčen / neurčen (70)
Minimální obsazenost: neomezen
Virtuální mobilita / počet míst: ne
Stav předmětu: vyučován
Jazyk výuky: angličtina
Způsob výuky: prezenční
Poznámka: předmět je možno zapsat mimo plán
povolen pro zápis po webu
při zápisu přednost, je-li ve stud. plánu
předmět lze zapsat v ZS i LS
Garant: Mgr. Petr Polák, M.Sc., Ph.D.
Vyučující: Mgr. Dominika Ehrenbergerová
Mgr. Roman Kalabiška
Mgr. Petr Polák, M.Sc., Ph.D.
Mgr. Nikol Poláková
Třída: Courses for incoming students
Je prerekvizitou pro: JEB128
Termíny zkoušek   Rozvrh   Nástěnka   
Anotace
Poslední úprava: PhDr. Petr Bednařík, Ph.D. (15.02.2020)
This course is aimed to provide the students with proper tools and knowledge to handle various types of data while struggling with their homework or theses, which is done on a commonly available platform of MS Excel.
After a general short repetition (depending on the current knowledge of the attendants) of basic excel features and functions we torn to more sophisticated data analysis, searching tools, filtering and advanced formatting. Should there be any specific needs resulting from the other courses’ tasks, this course will definitely address them. In a nutshell, the course should serve to strengthen and deepen the knowledge of MSExcel which should help the students to make their work on projects quicker and more efficient as well as enhance their position in possible job interviews with a useful skill.
Cíl předmětu -
Poslední úprava: Mgr. Petr Polák, M.Sc., Ph.D. (14.02.2022)

This course is aimed to provide the students with proper tools and knowledge to handle various types of data while struggling with their homework or theses, which is done on a commonly available platform of MS Excel.
After a general short repetition (depending on the current knowledge of the attendants) of basic excel features and functions we torn to more sophisticated data analysis, searching tools, filtering and advanced formatting. Should there be any specific needs resulting from the other courses’ tasks, this course will definitely address them. In a nutshell, the course should serve to strengthen and deepen the knowledge of MSExcel which should help the students to make their work on projects quicker and more efficient as well as enhance their position in possible job interviews with a useful skill.

Entry survey for Summer 2021/2022:

https://forms.gle/ZnursGVPFhSA2mkx6

Literatura -
Poslední úprava: Ing. Monika Hollmannová (29.10.2019)

Any handbook will do. No book is required.

Metody výuky -
Poslední úprava: Mgr. Petr Polák, M.Sc., Ph.D. (14.02.2022)

UPDATED in September 2021:

- Recorded classes, through Loom, available in MS Teams

- Each week using probably hybrid form - in class and online via MS Teams (see the introduction presentation for joining details)  

Software: Microsoft Office 2016 (365 available via University license for your device as well)

Code to join us on MS Teams: "fw285s5" or link:

https://teams.microsoft.com/l/team/19%3avh32XOILC2beW8720GC6fbwSZUUe6rqNEOoIpZwJrzg1%40thread.tacv2/conversations?groupId=34586303-edd7-46e3-831a-dad4e36b9d84&tenantId=e09276da-f934-4086-bf08-8816a20414a2

 

Požadavky ke zkoušce -
Poslední úprava: Ing. Monika Hollmannová (29.10.2019)

Please register for your project on webpage:

https://docs.google.com/spreadsheets/d/1wlicTA7B5OQ6g3GbXE5ZM-0r0aGCAAXOxrwFocgZ1nk/edit?usp=sharing

Exam conditions:

Students can bring their own notebook to the exam. However, if any technical issue concerning their notebooks should prevent them from sitting for the exam, they will be asked to use the computers in the lab.
Students can use MS Office help (offline and online), own notes, google, etc. But any form of external communication or help provided by someone else is not allowed.
Students have to register via SIS for the exam.

Grading:

Test (60% weight). graded on scale 0-100 points.
Project (35% weight), graded on scale 0-35 points.
Homework (5% weigth), graded on scale 0-5 points.
Overall score is therefore 0.6 * Test + Homework + Project => between 0 and 100 points.

A: 90+ to 100
B: 80+ to 90
C: 70+ to 80
D: 60+ to 70
E: 50+ to 60
F: 50 or less

Sylabus -
Poslední úprava: Ing. Monika Hollmannová (29.10.2019)

Content:

Introduction to excel, logical functions
Mathematical functions
Lookup and reference functions
Information/Error functions
Text functions
Date and time functions
Conditional formating
Sorting, Filters, Pivot table
Pivot table, Goalseek
Charts
Introduction to Macros

 
Univerzita Karlova | Informační systém UK