Applications of Computer Technology
| Type of study | Bachelor |
|---|---|
| Language of instruction | Czech |
| Code | 545-0198/01 |
| Abbreviation | AVT |
| Course title | Applications of Computer Technology |
| Credits | 3 |
| Coordinating department | Department of Economics and Control Systems |
| Course coordinator | RNDr. Radmila Sousedíková, Ph.D. |
Subject syllabus
1. Creating and editing graphs of technical and production indicators in
the raw materials industry
2. Analyzing trends in technical and production indicators
3. Financial analysis – horizontal and vertical analysis
4. financial analysis – calculating ratios and their graphical
representation
5. Evaluating the effectiveness of investment in the raw
materials industry
6. Calculating the net present value of an investment
7. Calculating the payback period and discounted payback period of an
investment
8. Calculating the internal rate of return
9. Calculating the balance of the earmarked reserve account
10. Calculating the installment of an investment loan
11. compiling an amortization plan
12. Equalizing the share price and its graphical representation
13. Final test
the raw materials industry
2. Analyzing trends in technical and production indicators
3. Financial analysis – horizontal and vertical analysis
4. financial analysis – calculating ratios and their graphical
representation
5. Evaluating the effectiveness of investment in the raw
materials industry
6. Calculating the net present value of an investment
7. Calculating the payback period and discounted payback period of an
investment
8. Calculating the internal rate of return
9. Calculating the balance of the earmarked reserve account
10. Calculating the installment of an investment loan
11. compiling an amortization plan
12. Equalizing the share price and its graphical representation
13. Final test
E-learning
For communication beyond in-person lectures and exercises, the Moodle learning management system (lms.vsb.cz) is used. This platform facilitates communication not only between the instructor and students but also among students themselves.
Literature
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. [Upper Saddle River]: Pearson Education, [2019]. ISBN 978-0-7897-5958-0.
MAYES, Timothy R. Financial analysis with Microsoft Excel 2019. 9th edition. Boston: Cengage, 2021. ISBN 978-0357-44205-0.
IBARRA, Luis Fernando. Simulation and statistics with Excel: an introduction to business students. Boca Raton: CRC Press, Taylor & Francis Group, 2024. ISBN 978-1-032-69876-2.
WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. New York: Pearson Education, 2019. ISBN 978-1-5093-0588-9.
MAYES, Timothy R. Financial analysis with Microsoft Excel 2019. 9th edition. Boston: Cengage, 2021. ISBN 978-0357-44205-0.
IBARRA, Luis Fernando. Simulation and statistics with Excel: an introduction to business students. Boca Raton: CRC Press, Taylor & Francis Group, 2024. ISBN 978-1-032-69876-2.
WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. New York: Pearson Education, 2019. ISBN 978-1-5093-0588-9.
Advised literature
WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. [New York]: Pearson Education, [2019]. ISBN 978-1-5093-0588-9.
LAMBERT, Joan; FRYE, Curtis. Microsoft Excel Step by Step (Office 2021 and Microsoft 365). Microsoft Press, 2021. ISBN 9780137564354 .
HOLDEN, Craig W. Excel Modeling in Corporate Finance. 5th edition. Pearson, 2014. ISBN 9780205987252 .
CARLBERG, Conrad George. Predictive analytics: Microsoft Excel. Second edition. Indiana: Que, 2018. ISBN 978-0-7897-5835-4.
LAMBERT, Joan; FRYE, Curtis. Microsoft Excel Step by Step (Office 2021 and Microsoft 365). Microsoft Press, 2021. ISBN 9780137564354 .
HOLDEN, Craig W. Excel Modeling in Corporate Finance. 5th edition. Pearson, 2014. ISBN 9780205987252 .
CARLBERG, Conrad George. Predictive analytics: Microsoft Excel. Second edition. Indiana: Que, 2018. ISBN 978-0-7897-5835-4.