The aim of studying and bibliography

The main aim of study: Expanding knowledge in the practical applications of mathematics and data analysis.

The general information about the module: The aim of the lectures is to present advanced spreadsheet tools and R-language codes in mathematics and data analysis, including: optimization, import, sorting and filtering data, creating charts and formatting them, creating pivot tables, mail merge and more.

Bibliography required to complete the module

Bibliography used during lectures

1	P. McFedries	Microsotf Excel 2007 PL. Formuły i funkcje	Wyd. Helion Gliwice.	2008
2	T. Szapiro (ed.)	Decyzje menedżerskie z Excelem	PWE Warszawa.	2000
3	M. Kopertowska	Zaawansowane możliwości arkusza Excel 2000 PL. Ćwiczenia	Wyd. Mikom, Warszawa.	2000
4	D. Etheridge	Excel 2007 PL. Analiza danych, wykresy, tabele przestawne	Wyd. Helion, Gliwice.	2009
5	M. Gągolewski	Programowanie w języku R	PWN, Warszawa.	2016
6		https://cran.r-project.org/manuals.html	.
7		http://www.tutorialspoint.com/r/r_tutorial.pdf	.
8		http://adv-r.had.co.nz/	.

Bibliography used during classes/laboratories/others

1	Z. Jędrzejczyk, J. Skrzypek, K. Kukuła (ed.), A. Walkosz	Badania operacyjne w przykładach i zadaniach	PWN Warszawa.	2002
2	P. Biecek	Przewodnik po pakiecie R	GiS, Wrocław.	2017
3	Dodatkowo literatura obowiązująca na wykładzie		.

Bibliography to self-study

1		https://support.office.com/pl-pl/excel	.
2		http://www.officeblog.pl/category/excel/	.
3		http://www.poradykomputerowe.pl/excel-i-aplikacje-biurowe/	.
4		https://cran.r-project.org/doc/FAQ/R-FAQ.html	.

Basic requirements in category knowledge/skills/social competences

Formal requirements: Requirements accordant with Rules and Regulations of studies

Basic requirements in category knowledge: Knowledge of the subjects related to the basics of financial mathematics and the theory of linear optimization

Basic requirements in category skills: Ability to work under MS Windows, use MS Office

Basic requirements in category social competences: Ability to work in a group

Module outcomes

MEK	The student who completed the module	Types of classes / teaching methods leading to achieving a given outcome of teaching	Methods of verifying every mentioned outcome of teaching	Relationships with KEK	Relationships with PRK
01	She/He can determine the optimal solution of linear programming problems: continuous, discrete and binary optimization, transportation problem and allocation problem, multicriterion problems ang set programing	lectures, exercises in a computer lab	observation of tasks execution, practical tests, project presentation	K_W04+ K_W07+ K_W08++ K_W11+ K_U20++ K_U21++ K_K01+ K_K03+	P7S_KK P7S_KO P7S_KR P7S_UW P7S_WG
02	She/He knows basic financial functions of spreadsheet	lectures, exercises in a computer lab	observation of tasks execution, practical tests, project presentation	K_W08++ K_W10++ K_U19++ K_K01+ K_K03+	P7S_KK P7S_KO P7S_KR P7S_UW P7S_WG
03	She/He knows and is able to use text and logical functions, search functions as well as data and time functions	lectures, exercises in a computer lab	observation of tasks execution, practical tests	K_W08+ K_W12++ K_U19++ K_K01++	P7S_KK P7S_UW P7S_WG
04	She/He can sort and filter the data in the tables; knows the rules of data security as well as is able to protect sheets.	lectures, exercises in a computer lab	observation of tasks execution, practical tests, project presentation	K_U20+ K_K01+ K_K03++	P7S_KK P7S_KO P7S_KR P7S_UW
05	She/He can create and format a chart, change the type and design of a chart as well as remove the series of data from the chart	lectures, exercises in a computer lab	observation of tasks execution, practical tests, project presentation	K_K01+ K_K03+	P7S_KK P7S_KO P7S_KR
06	She/He can create a pivot table and pivot chart as well as modify the arrangement of pivot table	lectures, exercises in a computer lab	observation of tasks execution, practical tests, project presentation	K_U19+ K_K01+ K_K03+	P7S_KK P7S_KO P7S_KR P7S_UW
07	She/He can can create and mail merge	lectures, exercises in a computer lab	observation of tasks execution, practical tests, project presentation	K_K01+ K_K03+	P7S_KK P7S_KO P7S_KR
08	She/He can use analysis of variants, manager of scripts and data analysis based on histogram and correlation	lectures, exercises in a computer lab	observation of tasks execution, practical tests	K_W12+ K_U19+ K_U20+ K_K01+ K_K02+ K_K03+ K_K04+	P7S_KK P7S_KO P7S_KR P7S_UW P7S_WG

Attention: Depending on the epidemic situation, verification of the achieved learning outcomes specified in the study program, in particular credits and examinations at the end of specific classes, can be implemented remotely (real-time meetings).

The syllabus of the module

Sem.	TK	The content	realized in	MEK
3	TK01	Linear optimization, discrete and binary optimization, transportation problem and the problem of allocation, network programming, multi-criteria optimization	W01-W04, C01-C04	MEK01
3	TK02	Financial functions of spreadsheet. Text functions, logical and search functions as well as data and time functions.	W05-W06, C05-C06	MEK02 MEK03
3	TK03	Organization of the data: sorting and filtering data (standard, auto-filtering, advanced). Import data. Data protection.	W07-W09, C07-C08	MEK04
3	TK04	Creating and formatting charts, types of charts, a series of data, filtering data in a chart.	W10, C09-C10	MEK05
3	TK05	Pivot tables and pivot charts: creation and modification, calculated fields, sorting pivot table and retrieve data from a pivot table.	W11, C11-C12	MEK06
3	TK06	Mail merge, creation and modification.	W12-W13, C13	MEK07
3	TK07	Variant analysis with use of scripts scenario, analysis of data using histograms and the correlation coefficient.	W14-W15, C14-C15	MEK08

The student's effort

The type of classes	The work before classes	The participation in classes	The work after classes
Lecture (sem. 3)		contact hours: 30.00 hours/sem.	complementing/reading through notes: 12.00 hours/sem. Studying the recommended bibliography: 5.00 hours/sem.
Class (sem. 3)	The preparation for a Class: 12.00 hours/sem. The preparation for a test: 5.00 hours/sem.	contact hours: 45.00 hours/sem.	Finishing/Studying tasks: 8.00 hours/sem.
Advice (sem. 3)
Credit (sem. 3)		The written credit: 2.00 hours/sem.

The way of giving the component module grades and the final grade

The type of classes	The way of giving the final grade
Lecture	Presence at the lectures
Class	Activity during exercises in a computer lab (independent and group work on solving problems); results of test and project
The final grade	Final evaluation is based on a presence at the lectures, activity during exercises in a computer lab and the results of test and project.

Sample problems

Required during the exam/when receiving the credit
(-)

Realized during classes/laboratories/projects
(-)

Others
(-)

Can a student use any teaching aids during the exam/when receiving the credit : no

The contents of the module are associated with the research profile: no