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.
MS Office
| Language of instruction | čeština |
|---|---|
| Code | 545-0197 |
| Abbreviation | MSOF |
| Course title | MS Office |
| Coordinating department | Department of Economics and Control Systems |
| Course coordinator | RNDr. Radmila Sousedíková, Ph.D. |
Summary
The course provides students with knowledge and practical skills in the area of advanced use of Microsoft Office applications in processing professional, statistical and economic tasks. Emphasis is placed on the effective use of MS Word, MS Excel and MS PowerPoint programs in creating professional documents, processing and analyzing data and their illustrative graphic presentation.
After completing the course, the student will achieve the following learning outcomes:
Knowledge: the student characterizes the possibilities of using sections, styles, automated content, lists of images and tables and cross-references, describes the principles of working with citations, explains the principles of data analysis using pivot tables and database tools, describes the principles of statistical and analytical tools of MS Excel, including regression analysis and trend functions, describes the principles of creating professional presentations in MS PowerPoint using templates, colour schemes, interactive elements and animations.
Skills: the student will prepare a professional document using sections, styles, automatic content, lists of images and tables and cross-references, create a professional document with correctly inserted citations and bibliographical sources; create and use a pivot table for data analysis, perform simple statistical analysis using regression analysis and trend analysis; prepare a professional presentation in MS PowerPoint using an appropriate template and colour scheme, interactive elements and animations.
General competencies: the student will independently select a suitable program and workflow for solving a specific professional task, assess the suitability of the tool used, effectively connect individual MS Office applications when solving complex tasks, defend the selected processing procedure and solution to the assigned task.
After completing the course, the student will achieve the following learning outcomes:
Knowledge: the student characterizes the possibilities of using sections, styles, automated content, lists of images and tables and cross-references, describes the principles of working with citations, explains the principles of data analysis using pivot tables and database tools, describes the principles of statistical and analytical tools of MS Excel, including regression analysis and trend functions, describes the principles of creating professional presentations in MS PowerPoint using templates, colour schemes, interactive elements and animations.
Skills: the student will prepare a professional document using sections, styles, automatic content, lists of images and tables and cross-references, create a professional document with correctly inserted citations and bibliographical sources; create and use a pivot table for data analysis, perform simple statistical analysis using regression analysis and trend analysis; prepare a professional presentation in MS PowerPoint using an appropriate template and colour scheme, interactive elements and animations.
General competencies: the student will independently select a suitable program and workflow for solving a specific professional task, assess the suitability of the tool used, effectively connect individual MS Office applications when solving complex tasks, defend the selected processing procedure and solution to the assigned task.
Literature
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.