- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
Modeling and Analysis of Economic Data in Excel (Online Course) 2600-MADEE-OG
Detailed course topics:
1. Basic concepts of data analysis and statistics:
- grouping and subtotals,
- sorting and filtering data,
- text, date and time, conditional formulas,
- summaries and multi-condition searches (aggregated columns),
- array functions,
- statistical distributions: probability density function,
- types of distributions: Gauss, Poisson, others.
2. Basics of descriptive statistics:
- statistical series,
- histograms and diagrams of empirical distributions,
- average measures - classic and positional,
- dispersion measures,
- measures of asymmetry.
3. Basics of mathematical statistics:
- empirical and theoretical distributions,
- parametric estimation,
- verification of hypotheses,
- correlation and regression,
- trend and periodic fluctuations.
4. Estimating basic econometric models:
- formulating a research hypothesis,
- selection of a functional form,
- data collection,
- estimation,
- verification,
- application.
As part of the course, participants receive a set of course materials with solutions.
Type of course
Mode
Prerequisites (description)
Course coordinators
Learning outcomes
Thanks to the course, participants will:
- use Excel tools to solve statistical problems and conduct analyses,
- use selected methods of descriptive statistics and mathematical statistics,
- present research results in the form of charts,
- interpret the obtained results,
- conclude and forecast based on the solutions received.
Assessment criteria
The final grade consists of:
- homework for 10 points (final design using the presented tools),
- activity during classes.
Punctation:
Score Points
[0-5) 2
[5-6) 3
[6-7) 3,5
[7-8) 4
[8-9) 4,5
[9-10] 5
above 10 5!
Bibliography
- Own materials,
- Michael Alexander, Richard Kusleika, John Walkenbach, 2019, Excel 2019 PL. Biblia, Helion, Warszawa,
John Walkenbach, 2014, Excel 2013. 101 porad i sztuczek, które oszczędzą Twój czas, Helion, Warszawa.
Notes
|
Term 2023Z:
Access to a computer with Microsoft Excel software (in any version, on any operating system: Windows, Mac OS). Classes on the course will be conducted in the Microsoft Office 2021 software version. Dates of classes: 10 meetings of 3 teaching hours, including 2 synchronous meetings (6 teaching hours in total) and 8 asynchronous meetings (24 teaching hours in total). |
Term 2023L:
Access to a computer with Microsoft Excel software (in any version, on any operating system: Windows, Mac OS). Classes on the course will be conducted in the Microsoft Office 2021 software version. Dates of classes: 10 meetings of 3 teaching hours, including 2 synchronous meetings (6 teaching hours in total) and 8 asynchronous meetings (24 teaching hours in total). |
Term 2024L:
Access to a computer with Microsoft Excel software (in any version, on any operating system: Windows, Mac OS). Classes on the course will be conducted in the Microsoft Office 2021 software version. Dates of classes: |
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:
- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: