The aim of studying and bibliography

The main aim of study:

The general information about the module: The aim of the course is to provide advanced tools of spreadsheet: Solver applied for optimization problems, sorting and filtering, charts and formatting, PivotTable and PivotChart, mail merge, simple databases.

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

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	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/	.

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 OEK
01	She/He can determine the optimal solution of linear programming problems: continuous, discrete and binary optimization, transportation problem and allocation problem	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+	X2A_W02 X2A_W03 X2A_W04 X2A_W05 X2A_U02 X2A_U04 X2A_U06 X2A_U07 X2A_K01 X2A_K02 X2A_K05 X2A_K06 X2A_K07
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+	X2A_W03 X2A_W04 X2A_W05 X2A_U02 X2A_U04 X2A_U06 X2A_U07 X2A_K01 X2A_K02 X2A_K05 X2A_K06 X2A_K07
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++	X2A_W03 X2A_W04 X2A_W05 X2A_U02 X2A_U04 X2A_U06 X2A_U07 X2A_K01
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++	X2A_U02 X2A_U04 X2A_U06 X2A_U07 X2A_K01 X2A_K02 X2A_K05 X2A_K06 X2A_K07
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+	X2A_U07 X2A_K01 X2A_K02 X2A_K05 X2A_K06 X2A_K07
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+	X2A_U02 X2A_U04 X2A_U06 X2A_U07 X2A_K01 X2A_K02 X2A_K05 X2A_K06 X2A_K07
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+	X2A_U07 X2A_K01 X2A_K02 X2A_K05 X2A_K06 X2A_K07
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+	X2A_W04 X2A_W05 X2A_U02 X2A_U04 X2A_U06 X2A_U07 X2A_K01 X2A_K02 X2A_K03 X2A_K04 X2A_K05 X2A_K06 X2A_K07

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 Solver:continuous, 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 in the spreadsheet: sorting and filtering data (standard, auto-filtering, advanced). Import data, protection and sharing sheet.	W07-W08, C07-C08	MEK04
3	TK04	Creating and formatting charts, types of charts, a series of data, filtering data in a chart.	W09, C09	MEK05
3	TK05	Pivot tables and pivot charts: creation and modification, calculated fields, sorting pivot table and retrieve data from a pivot table.	W10-W11, C10-C11	MEK06
3	TK06	Mail merge, creation and modification.	W12, C12	MEK07
3	TK07	Variant analysis with use of scripts scenario, analysis of data using histograms and the correlation coefficient.	W13-W15, C13-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: 30.00 hours/sem.	Finishing/Studying tasks: 12.00 hours/sem.
Advice (sem. 3)
Credit (sem. 3)

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