*Conducted in terms:*2019L, 2020Z

*Erasmus code:*14.3

*ISCED code:*0311

*ECTS credits:*3

*Language:*Polish

*Organized by:*Faculty of Economic Sciences

# IT Tools in Economics 2400-PP1NI

1) Introduction to performing economic calculations with the use of IT tools. Getting to know Excel: sorting and filtering data, relative and absolute addressing, creating and using calculation formulas.

2) Creating charts using Excel. Formatting spreadsheet cells.

3) Importing and exporting data from various sources (text files, data from the Internet, data from databases). Preparation of sheets for presentation and publishing.

4) Advanced Excel functions. Combining data sets, lookup functions, counting functions.

5) Analyzing the time series: graphical analysis of the series, growth rates calculations.

6) Fixed-base and chain indexes. Index conversion.

7) Basic operations on matrices, solving systems of equations.Pseudo-random numbers and simulations in Excel.

8) Introduction to R environment and RStudio editor - native environment and integrated development environment for R, code management, scripting and code editing, built-in functions.

9) Data types and types of objects in R, creating vectors, using functions that operate on vectors.

10) Operators for generating a sequence of values. Creating matrices, using functions that operate on matrices.

11) Data frames - working with data in the form of a two-dimensional table, indexing, selecting subsets of observations and calculating basic variable statistics.

12) Graphic functions, generating function graphs in a given range and editing the graph area.

13) Processing and data analysis in R, import and export of data in various formats, installation of packages useful in the analysis of various types of data.

14) Creating and defining functions in R, nesting functions, conditional operators and logical tests.

## Type of course

## Prerequisites (description)

## Course coordinators

Term 2019L: | Term 2020Z: |

## Mode

## Learning outcomes

After completing the course the student will be able to:

- Assess the possibility of using a specific mathematical method to solve a specific problem in the field of economics and finance;

- Choose an appropriate IT tool (Excel, R) for practical solution of a specific problem using a selected mathematical method and properly program this problem in the selected tool;

- Perform a series of operations in the selected IT tool that lead to the desired results;

- Analyze the obtained results, interpret their meaning and create a report on the performed analysis;

## Assessment criteria

There will be two tests, one in the middle of the semester and second at the end of the semester.

## Bibliography

Elements of Excel and R help systems

Smart M., Learn Excel Essential Skills, The Smart Method Ltd 2016

Kusleika R., Walkenbach J., Alexander M., Excel Bible, Wiley 2018

Leemis L., Learning Base R. Lightning Source 2016

Venables W., Smith D., An Introduction to R, Notes on R: A Programming Environment for Data Analysis and Graphics, R Core Team 2019

## 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:

- Economics, part-time, first cycle
- Economics, full time, first cycle
- Double Degree Program in Economics and Mathematics (first cycle)

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