*Conducted in term:*2019L

*Erasmus code:*14.3

*ISCED code:*0311

*ECTS credits:*3

*Language:*English

*Organized by:*Faculty of Economic Sciences

*Related to study programmes:*

# IT Tools in Economics 2400-PP1NIa

1) Introduction to performing advanced economic computations with help od IT tools

2) Extending Excel knowledge: loading data from external sources, data sorting and filtering, relative and absolute cells addressing, application of computational formulas and use of pivot tables and charts

3) Finding roots of nonlinear equations of one variable:

4) Using macros

5) Introduction to Mathematica - using expressions and matrices, access to help system, access to external data sources

6) Introduction to Matlab - using expressions and matrices, access to help system, access to external data sources

7) Graphics functions, reports generation, storing results of computations in Mathematica and Matlab

8) Computing limits of sequences and examining asymptotic characteristic of series

9) Symbolic matrix transformations - computing determinant, inverse, eigenvalues and eigenvectors of a matrix. solving systems of linear equations

10) Symbolic computations of derivatives and integrals of univariate and multivariate functions

11) Mid-term test

12) Numerical matrix transformations - computing determinant, inverse, eigenvalues and eigenvectors of a matrix, solving systems of linear equations; Comparing results with symbolic computations

13) Numerical derivatives computation (backward and forward differences method) and integral computation (trapezoid method and Simpson method)

14) Gradient constrained and unconstrained optimization methods of uni- and multivariate functions

## Type of course

## Prerequisites (description)

## Learning outcomes

Upon completion of this course student will be able to:

- Assess purposefulness of particular mathematical schema application for solving certain problem from domain of economics

- Choose appropriate IT tool (Excel, Mathematica, Matlab) to apply selected mathematical schema for solving the problem in practice and represent appropriately this problem in selected tool

- Perform sequence of operations aimed at gaining valid results

- Conduct analysis of achieved results and interpret its economic meaning

KU03

## Assessment criteria

Knowledge and skills of students participating in this course will be assessed during

- Mid-term test organized after completion of Excel and Mathematica modules

- Final test

The main goal of the mid-term test will be to assess knowledge and skills of students achieved in the first part of the course during modules held with Excel and Mathematica. Second aim of this test will be to show students possible fields of improvements before final test. Mid-term test will consist of two problems embracing topics covered by the lecturer during the first part of the course. Problems are supposed to be solved with help of a computer with appropriate software. Main criteria for the assessment will be correctness and conciseness of the solution.

Final test will comprise of 4 problems, which are supposed to be solved with help of Excel, Mathematica and Matlab in the front of a computer.

## Bibliography

Elements of Mathematica and Matlab help systems

Abell M., Braselton J., Mathematica by Example, 4th Edition, Elsevier, 2009

Dodge M., Stinson C., Running Microsoft Excel 2000, Microsoft Press, 1999

Gilat A., MATLAB: An Introduction with Applications, Willey, 2008

Peal D., Excel 2003, Top 100 Simplified, Willey, 2003

Walkenbach J., Excel 2003 Bible, Willey, 2003

## Additional information

Information on *level* of this course, *year of study* and semester when the course
unit is delivered, types and amount of *class hours* - can be found in course structure
diagrams of apropriate study programmes. This course is related to
the following study programmes:

Additional information (*registration* calendar, class conductors,
*localization and schedules* of classes), might be available in the USOSweb system: