| Course Unit Code | 545-0291/07 |
|---|
| Number of ECTS Credits Allocated | 6 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Third Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| SOU70 | RNDr. Radmila Sousedíková, Ph.D. |
| ROL74 | Ing. Markéta Laštůvková, Ph.D. |
| Summary |
|---|
| The subject concerns modern working processes in Microsoft Office and their application to written outputs of research, presentation and economic analysis with spreadsheet. |
| Learning Outcomes of the Course Unit |
|---|
| Generating knowledge concerning modern working processes in Microsoft Office, application to written outputs of research, simple economic analysis with spread sheet and and results presentation with PowerPoint. |
| Course Contents |
|---|
1) Word, principles of text document writing, advanced methods (working with sections and styles)
2) Word, working with tables, graphical modification, figure inserting and modification, equations writing
3) Word, advanced methods (captions of tables and figures, footnotes, cross-reference captions, creating a table of content and figures)
4) Word, mail merge, use of database record
5) Instructions for Bachelor's thesis writing, bibliographic citation
6) Excel, advanced methods, spread sheet use in economic practice (graph creation and modification , trend analysis
7) Excel, working with databases (creating tables, filters, creating subtotals and totals)
8) Financial analysis with Excel
9) Investment project efficiency with Excel
10) Debt amortization with Excel
11) Smoothing of stock prices time series with excel
12) Presentation with PowerPoint
13) Web page creating
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| BUCKI, Lisa et al. Learning Microsoft Office 2010. Upper Saddle River, N.J.: Pearson/Prentice Hall, 2011. ISBN 978-0135108383 |
PÍRKOVÁ, Kateřina. Microsoft Word 2010: podrobná uživatelská příručka. Brno: Computer Press, 2010. ISBN: 978-80-251-3033-9.
BARILLA, Jiří, Pavel SIMR a Květuše SÝKOROVÁ. Microsoft Excel 2010: podrobná uživatelská příručka. Brno: Computer Press, 2010. ISBN: 978-80-251-3031-5.
ANDRÝSKOVÁ, Jana. Microsoft PowerPoint 2010: podrobná uživatelská příručka. Brno: Computer Press, 2010. ISBN: 978-80-251-3076-6.
|
| Recommended Reading: |
|---|
SHELLY Gary and Misty VERMAAT. Microsoft Office 2010: Introductory. Andover: Cengage Learning, 2010.ISBN 9781439078389.
|
| Kolektiv autorů. Microsoft Office 2010: podrobná uživatelská příručka. Brno: Computer Press, 2010. ISBN 978-80-251-3222-7. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit and Examination | Credit and Examination | 100 (100) | 51 |
| Credit | Credit | 30 (30) | 17 |
| semestrální projekt | Semestral project | 16 | 9 |
| semestrální projekt | Semestral project | 14 | 8 |
| Examination | Examination | 70 (70) | 34 |
| písemná zkouška | Written examination | 70 | 34 |