MS Office
| Type of study | Bachelor |
|---|---|
| Language of instruction | Czech |
| Code | 545-0197/02 |
| Abbreviation | MSOF |
| Course title | MS Office |
| Credits | 4 |
| Coordinating department | Department of Economics and Control Systems |
| Course coordinator | RNDr. Radmila Sousedíková, Ph.D. |
Osnova předmětu
1. MS Word - creating professional documents, working with sections and styles.
2. MS Word - automating the content, lists of images and tables, cross-references.
3. MS Word - working with citations and bibliographic sources, exporting to PDF format.
4. MS Word - advanced formatting of tables and graphs in a document.
5. MS Excel - advanced functions for working with data (search functions, logical operators).
6. MS Excel - analyzing data using pivot tables.
7. MS Excel - data visualization, advanced graphs (waterfall graphs, maps).
8. MS Excel - statistical and analytical tools (regression analysis, trend functions).
9. MS Excel - working with databases (data import, filtering, summaries).
10. MS Excel - basics of macros and automation of repetitive tasks.
11. MS PowerPoint - designing professional templates and color schemes.
12. MS PowerPoint - interactive elements in presentations, advanced animations.
13. Final project - complex application of advanced functions in MS Office to a real task.
2. MS Word - automating the content, lists of images and tables, cross-references.
3. MS Word - working with citations and bibliographic sources, exporting to PDF format.
4. MS Word - advanced formatting of tables and graphs in a document.
5. MS Excel - advanced functions for working with data (search functions, logical operators).
6. MS Excel - analyzing data using pivot tables.
7. MS Excel - data visualization, advanced graphs (waterfall graphs, maps).
8. MS Excel - statistical and analytical tools (regression analysis, trend functions).
9. MS Excel - working with databases (data import, filtering, summaries).
10. MS Excel - basics of macros and automation of repetitive tasks.
11. MS PowerPoint - designing professional templates and color schemes.
12. MS PowerPoint - interactive elements in presentations, advanced animations.
13. Final project - complex application of advanced functions in MS Office to a real task.
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.
Povinná literatura
LAMBERT, Joan; FRYE, Curtis. Microsoft Excel Step by Step (Office 2021 and Microsoft 365). Microsoft Press, 2021.ISBN 9780137564354 .
LAMBERT, Joan. Microsoft Word Step by Step (Office 2021 and Microsoft 365). Pearson Education, 2023.ISBN 978-0-13-752272-9 .
LAMBERT, Joan. Microsoft PowerPoint 2016 Step by Step. Microsoft press, 2015. ISBN 978-0735697799 .
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2023. ISBN 978-0-7897-5958-0.
LAMBERT, Joan. Microsoft Word Step by Step (Office 2021 and Microsoft 365). Pearson Education, 2023.ISBN 978-0-13-752272-9 .
LAMBERT, Joan. Microsoft PowerPoint 2016 Step by Step. Microsoft press, 2015. ISBN 978-0735697799 .
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2023. ISBN 978-0-7897-5958-0.
Doporučená literatura
WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. New York: Pearson Education, 2019. ISBN 978-1-5093-0588-9.
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.
MUIR, Nancy. Microsoft PowerPoint 2013 Plain & Simple. Microsoft Press, 2013.ISBN 978-0735669369 .
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2019. ISBN 978-0-7897-5958-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.
MUIR, Nancy. Microsoft PowerPoint 2013 Plain & Simple. Microsoft Press, 2013.ISBN 978-0735669369 .
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2019. ISBN 978-0-7897-5958-0.