IT Tools in Economics 2400-FIM1NI

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.