Course Information

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2025

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Prerequisites

There are no prerequisites for this course.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

The student will be able to use advanced tools of MS PowerPoint, including template of slides, animations, sounds. Use macros, analysis tools and the Solver module in MS Excel when creating, editing and managing tables. They will get acquainted with MS Access.

Learning outcomes

After completing the course, the student will be able to:
Create a PowerPoint presentation, including animations and sound.
Insert data and perform calculations using MS Excel functions, format tables in MS Excel, use analytical tools.
Work with MS Access.

Syllabus

1. MS PowerPoint - Working with a template, presentation template.
2. MS PowerPoint - Animation settings, audio and video insertion.
3. MS PowerPoint - Setting transitions between slides, automatic playback of the presentation.
4. MS PowerPoint - Creating a complex presentation.
5. MS Excel - Forms.
6. MS Excel - Simple macros, macro recording.
7. Basics of Visual Basic - Editing a recorded macro.
8. MS Excel - Analytical tools, solution search, scenario manager.
9. MS Excel - Solver.
10. MS Access - Loading external data into DB, editing DB.
11. MS Access - Working with views, creating simple filters.
12. MS Access - Creating a form for entering data, creating a print report.

Literature

required literature

Navarrů, M. Excel 2019: Podrobný průvodce uživatele. Grada, 2019. ISBN 978-80-247-2026-5.
NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Foulkes, L. Learn Microsoft Office 2021. Packt Publishing, 2021. ISBN 978-1803239736.

not specified

Alexander, M., Kusleika, D. Microsoft Excel 365 Bible. Wiley, 2022. ISBN 978-1119835103.
Master, H. Excel 2022. Independently published, 2022, ISBN-13 979-8442488708.

Teaching methods

Full-time study. Required participation is 75 %. Students who do not attend mandatory number of seminars may be given by additional study requirements.
Part-time study: compulsory tutorial participation is 50 %, the possible absence can be compensate by personal consultation.
Students with ISP have the same duties. Compulsory attendance is not required.The teacher verifies the authenticity of the submitted tasks.

Assessment methods

The course is completed with a credit.
Full-time study: Credit awarded after submission of all assignments processed in seminars, in case of absence or online teaching, missing assignments will be processed at home. Part-time study: Credit awarded after submission of all assignments processed in seminars, in case of absence or online teaching, missing assignments will be processed at home.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2024

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Guaranteed by

PaedDr. Renata Majovská, PhD.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Prerequisites

There are no prerequisites for this course.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes

Syllabus

1. MS PowerPoint - Working with a template, presentation template.
2. MS PowerPoint - Animation settings, audio and video insertion.
3. MS PowerPoint - Setting transitions between slides, automatic playback of the presentation.
4. MS PowerPoint - Creating a complex presentation.
5. MS Excel - Forms.
6. MS Excel - Simple macros, macro recording.
7. Basics of Visual Basic - Editing a recorded macro.
8. MS Excel - Analytical tools, solution search, scenario manager.
9. MS Excel - Solver.
10. MS Access - Loading external data into DB, editing DB.
11. MS Access - Working with views, creating simple filters.
12. MS Access - Creating a form for entering data, creating a print report.

Literature

required literature

Navarrů, M. Excel 2019: Podrobný průvodce uživatele. Grada, 2019. ISBN 978-80-247-2026-5.
NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Foulkes, L. Learn Microsoft Office 2021. Packt Publishing, 2021. ISBN 978-1803239736.

not specified

Alexander, M., Kusleika, D. Microsoft Excel 365 Bible. Wiley, 2022. ISBN 978-1119835103.
Master, H. Excel 2022. Independently published, 2022, ISBN-13 979-8442488708.

Teaching methods

Assessment methods

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2023

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Guaranteed by

PaedDr. Renata Majovská, PhD.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Prerequisites

There are no prerequisites for this course.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes

Syllabus

1. MS PowerPoint - Working with a template, presentation template.
2. MS PowerPoint - Animation settings, audio and video insertion.
3. MS PowerPoint - Setting transitions between slides, automatic playback of the presentation.
4. MS PowerPoint - Creating a complex presentation.
5. MS Excel - Forms.
6. MS Excel - Simple macros, macro recording.
7. Basics of Visual Basic - Editing a recorded macro.
8. MS Excel - Analytical tools, solution search, scenario manager.
9. MS Excel - Solver.
10. MS Access - Loading external data into DB, editing DB.
11. MS Access - Working with views, creating simple filters.
12. MS Access - Creating a form for entering data, creating a print report.

Literature

required literature

Navarrů, M. Excel 2019: Podrobný průvodce uživatele. Grada, 2019. ISBN 978-80-247-2026-5.
NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Foulkes, L. Learn Microsoft Office 2021. Packt Publishing, 2021. ISBN 978-1803239736.

not specified

Alexander, M., Kusleika, D. Microsoft Excel 365 Bible. Wiley, 2022. ISBN 978-1119835103.
Master, H. Excel 2022. Independently published, 2022, ISBN-13 979-8442488708.

Teaching methods

Assessment methods

Full-time study: Credit awarded after submission of all assignments processed in seminars, in case of absence or online teaching, missing assignments will be processed at home. Part-time study: Credit awarded after submission of all assignments processed in seminars, in case of absence or online teaching, missing assignments will be processed at home.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2022

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

PaedDr. Renata Majovská, PhD.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_AS_2/cAPH: Wed 12:15–12:59 S16PC, Wed 13:00–13:45 S16PC, V. Nulíček

Prerequisites

There are no prerequisites for this course.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes

Syllabus

1. MS PowerPoint - Working with a template, presentation template.
2. MS PowerPoint - Animation settings, audio and video insertion.
3. MS PowerPoint - Setting transitions between slides, automatic playback of the presentation.
4. MS PowerPoint - Creating a complex presentation.
5. MS Excel - Forms.
6. MS Excel - Simple macros, macro recording.
7. Basics of Visual Basic - Editing a recorded macro.
8. MS Excel - Analytical tools, solution search, scenario manager.
9. MS Excel - Solver.
10. MS Access - Loading external data into DB, editing DB.
11. MS Access - Working with views, creating simple filters.
12. MS Access - Creating a form for entering data, creating a print report.

Literature

required literature

Navarrů, M. Excel 2019: Podrobný průvodce uživatele. Grada, 2019. ISBN 978-80-247-2026-5.
NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Foulkes, L. Learn Microsoft Office 2021. Packt Publishing, 2021. ISBN 978-1803239736.

not specified

Alexander, M., Kusleika, D. Microsoft Excel 365 Bible. Wiley, 2022. ISBN 978-1119835103.
Master, H. Excel 2022. Independently published, 2022, ISBN-13 979-8442488708.

Teaching methods

Assessment methods

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2021

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

PaedDr. Renata Majovská, PhD.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_AS_2/vAPH: Fri 26. 2. 14:00–15:30 S16PC, 15:45–17:15 S16PC, 17:30–19:00 S16PC, Fri 26. 3. 14:00–15:30 S16PC, 15:45–17:15 S16PC, 17:30–19:00 S16PC, V. Nulíček

Prerequisites

There are no prerequisites for this course.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes

Syllabus

1. MS PowerPoint - Working with a template, presentation template.
2. MS PowerPoint - Animation settings, audio and video insertion.
3. MS PowerPoint - Setting transitions between slides, automatic playback of the presentation.
4. MS PowerPoint - Creating a complex presentation.
5. MS Excel - Forms.
6. MS Excel - Simple macros, macro recording.
7. Basics of Visual Basic - Editing a recorded macro.
8. MS Excel - Analytical tools, solution search, scenario manager.
9. MS Excel - Solver.
10. MS Access - Loading external data into DB, editing DB.
11. MS Access - Working with views, creating simple filters.
12. MS Access - Creating a form for entering data, creating a print report.

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS
Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011

Teaching methods

Assessment methods

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2020

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

PaedDr. Renata Majovská, PhD.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_AS_2/cAPH: Tue 15:45–16:29 S16PC, Tue 16:30–17:15 S16PC, V. Nulíček

Prerequisites

There are no prerequisites for this course.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

At the end of the course students should be able to apply advanced tools used in MS Word to manage long documents, the teamwork and protecting documents. To apply tools in MS Excel to create, edit and manage tables.

Learning outcomes

After completing the course, a student will be able to edit large documents in MS Word 2010, create a form, work with templates in MS Word 2010, enter data into tables, calculate using formulas in MS Excel 2010, format tables in MS Excel 2010, use analysis tools, create Pivot table in MS Excel 2010, work with mail merge in MS Word 2010.

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers).
2. MS Word – creating a form, inserting various types of form fields, document protection.
3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison.
4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references.
5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete).
6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions.
7. MS Excel – conditional formatting. More complex chart editing.
8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing.
9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals.
10. MS Excel – databases - PivotTable
11. MS Word – mail merge.
12. Practical exercise in MS Word and MS Excel.

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS

Teaching methods

Full-time study - seminares. Required participation is 75 %. Students who do not attend mandatory number of seminars may be given by additional study requirements. Part-time: compulsory tutorial participation is 50 %, the possible absence can be compensate by personal consultation with a tutor.

Assessment methods

Full-time study: credit test, students edit MS Word document according to instructions and create and modify tables in MS Excel in credit test. Part-time study: students work out separately four POT’s and write the same credit test as full-time students. The results of students must demonstrate sufficient knowledge of the tools of both programs.

Language of instruction

Czech

Further comments (probably available only in Czech)

Information on completion of the course: ISP
The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

Teacher's information

The course builds on the subject of Application Software 1. Assumed knowledge of techniques and tools work programs MS Word 2010 and MS PowerPoint 2010 at the level of the course curriculum.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2019

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Guaranteed by

PaedDr. Renata Majovská, PhD.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Prerequisites

The course builds on the subject of Application Software from 1st year. Assumed knowledge of techniques and tools work programs MS Word 2010 and MS PowerPoint 2010 at the level of the course curriculum.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

At the end of the course students should be able to:
- apply advanced tools used in MS Word to manage long documents, the teamwork and protecting documents.
- apply tools in MS Excel to create, edit and manage tables.

Learning outcomes

After completing the course, a student will be able to:
- edit large documents in MS Word 2010;
- create a form, work with templates in MS Word 2010;
- enter any data into tables, calculate using formulas in MS Excel 2010;
- format tables in MS Excel 2010;
- use analysis tools, create Pivot table in MS Excel 2010;
- work with mail merge in MS Word 2010;

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers)
2. MS Word – creating a form, inserting various types of form fields, document protection.
3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison
4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references
5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete).
6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions.
7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and
8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing.
9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals
10. MS Excel – databases - PivotTable
11. MS Word – mail merge
12. Credit exercise – practical exercise in MS Word and MS Excel.

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS
Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011

Teaching methods

Full-time study - managed seminares. Required participation - 75%. At the end of the semester students who do not attend mandatory number of seminars may be given additional study requirements that will demonstrate academic achievement and acquired competencies necessary for successful completion of the course. Combined Studies - distance form. Students have compulsory one directed group consultation. The possible absence can be compensate by personal consultation with a tutor.

Assessment methods

Course completion: Full-time studies: credit. Students edit MS Word document according to instructions and create and modify tables in MS Excel. Combined studies: students work out separately four POT’s and write the same full time final test as full-time students. The results of students must demonstrate sufficient knowledge of the tools of both programs.

Language of instruction

Czech

Further comments (probably available only in Czech)

Information on completion of the course: ISP
The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2018

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Prerequisites

The course builds on the subject of Application Software 1 of winter semester 1st year. Assumed knowledge of techniques and tools work programs MS Word 2010 and MS PowerPoint 2010 at the level of the course curriculum.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers)
2. MS Word – creating a form, inserting various types of form fields, document protection.
3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison
4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references
5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete).
6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions.
7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and
8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing.
9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals
10. MS Excel – databases - PivotTable
11. MS Word – mail merge
12. Credit exercise – practical exercise in MS Word and MS Excel.

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS

Teaching methods

full-time study - managed seminares. Required participation - 75%. At the end of the semester students who do not attend mandatory number of seminars may be given additional study requirements that will demonstrate academic achievement and acquired competencies necessary for successful completion of the course. Combined Studies - distance forma. Students have compulsory one directed group consultation. The possible absence can be compensate by personal consultation with a tutor.

Assessment methods

Course completion: Full-time studies: credit. Students smart up MS Word document according to instructions and create and modify tables in MS Excel. Combined studies: students work out separately four POT’s, and the same full time final test as full-time students. The results of students must demonstrate sufficient knowledge of the tools of both programs

Language of instruction

Czech

Further comments (probably available only in Czech)

Information on completion of the course: ISP
The course can also be completed outside the examination period.
Note related to how often the course is taught: Kombinace 2 hod. prezenční a 10 hod. distanční výuky.
General note: Aa0.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2016

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ing. Barbora Ptáčková

Prerequisites

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers)
2. MS Word – creating a form, inserting various types of form fields, document protection.
3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison
4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references
5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete).
6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions.
7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and
8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing.
9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals
10. MS Excel – databases - PivotTable
11. MS Word – mail merge
12. Credit exercise – practical exercise in MS Word and MS Excel.

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS

Teaching methods

Assessment methods

Language of instruction

Czech

Further comments (probably available only in Czech)

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2015

Extent and Intensity

0/2. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Hana Hoffmannová (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Tamara Urbánková

Prerequisites

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers)
2. MS Word – creating a form, inserting various types of form fields, document protection.
3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison
4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references
5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete).
6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions.
7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and
8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing.
9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals
10. MS Excel – databases - PivotTable
11. MS Word – mail merge
12. Credit exercise – practical exercise in MS Word and MS Excel.

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS

Teaching methods

Assessment methods

Language of instruction

Czech

Further comments (probably available only in Czech)

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2014

Extent and Intensity

0/2. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

prof. Ing. Petr Berka, CSc. (seminar tutor)
Ing. Hana Hoffmannová (seminar tutor)
Ing. David Chudán, Ph.D. (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Dagmar Medová, DiS.

Timetable of Seminar Groups

B_AS_2/Repetenti_1: No timetable has been entered into IS. A. Nováková
B_AS_2/uMPH: Tue 25. 3. 14:00–15:30 E303PC, A. Nováková
B_AS_2/uM11KL: Tue 1. 4. 15:45–17:15 K213PC, M. Kučera
B_AS_2/uR11KL: Tue 25. 3. 15:45–17:15 K212, M. Kučera
B_AS_2/uR11PH: Tue 1. 4. 15:45–17:15 E303PC, A. Nováková
B_AS_2/vBP21PH: Fri 4. 4. 12:00–13:30 E303PC, J. Lánský
B_AS_2/vBP22PH: Fri 21. 3. 15:30–17:00 E303PC, J. Lánský
B_AS_2/vM21PH: Fri 7. 3. 12:00–13:30 DELL ROOM E302PC, A. Nováková
B_AS_2/vM22PH: Fri 7. 3. 13:45–15:15 DELL ROOM E302PC, A. Nováková
B_AS_2/vPPV21PH: Fri 21. 3. 13:45–15:15 DELL ROOM E302PC, A. Nováková
B_AS_2/vPPV22PH: Fri 21. 3. 13:45–15:15 E303PC, M. Kučera
B_AS_2/vR21PH: Fri 21. 3. 15:30–17:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/vR22PH: Fri 21. 3. 12:00–13:30 DELL ROOM E302PC, V. Nulíček
B_AS_2/v1RMO: Fri 14. 3. 12:00–13:30 M11PC, H. Hoffmannová
B_AS_2/v2VMO: Sat 15. 3. 8:00–9:30 M11PC, H. Hoffmannová
B_AS_2/v3MMO: Sat 15. 3. 9:45–11:15 M11PC, H. Hoffmannová
B_AS_2/1BPH: Wed 14:00–14:44 E303PC, Wed 14:45–15:30 E303PC, J. Lánský
B_AS_2/1MPH: Thu 10:30–11:14 DELL ROOM E302PC, Thu 11:15–12:00 DELL ROOM E302PC, J. Lánský
B_AS_2/1MVMO: Tue 10:30–11:14 M11PC, Tue 11:15–12:00 M11PC, H. Hoffmannová
B_AS_2/1PPPVVPH: Thu 8:45–9:29 E303PC, Thu 9:30–10:15 E303PC, V. Nulíček
B_AS_2/1RPH: Tue 10:30–11:14 DELL ROOM E302PC, Tue 11:15–12:00 DELL ROOM E302PC, A. Nováková
B_AS_2/2BPH: Wed 14:00–14:44 DELL ROOM E302PC, Wed 14:45–15:30 DELL ROOM E302PC, J. Lokoč
B_AS_2/2MMO: Wed 10:30–11:14 M11PC, Wed 11:15–12:00 M11PC, H. Hoffmannová
B_AS_2/2MPH: Thu 10:30–11:14 E303PC, Thu 11:15–12:00 E303PC, V. Nulíček
B_AS_2/2PPSPPH: Tue 8:45–10:15 E303PC, A. Nováková
B_AS_2/2PVVPH: Thu 8:45–9:29 DELL ROOM E302PC, Thu 9:30–10:15 DELL ROOM E302PC, J. Lánský
B_AS_2/2RPH: Tue 10:30–11:14 E303PC, Tue 11:15–12:00 E303PC, V. Nulíček
B_AS_2/3MPH: Wed 15:45–16:29 E303PC, Wed 16:30–17:15 E303PC, J. Lánský
B_AS_2/3RPH: Tue 12:15–12:59 DELL ROOM E302PC, Tue 13:00–13:45 DELL ROOM E302PC, A. Nováková
B_AS_2/3RVMO: Tue 12:15–12:59 M11PC, Tue 13:00–13:45 M11PC, H. Hoffmannová
B_AS_2/4MPH: Wed 15:45–16:29 DELL ROOM E302PC, Wed 16:30–17:15 DELL ROOM E302PC, J. Lokoč
B_AS_2/4RMO: Wed 12:15–12:59 M11PC, Wed 13:00–13:45 M11PC, H. Hoffmannová
B_AS_2/4RPH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, V. Nulíček
B_AS_2/5MPH: Mon 12:15–12:59 E303PC, Mon 13:00–13:45 E303PC, A. Nováková
B_AS_2/5RPH: Mon 8:45–9:29 E303PC, Mon 9:30–10:15 E303PC, A. Nováková
B_AS_2/6MPH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, V. Nulíček
B_AS_2/6RPH: Mon 12:15–12:59 DELL ROOM E302PC, Mon 13:00–13:45 DELL ROOM E302PC, V. Nulíček
B_AS_2/7MPH: Mon 14:00–14:44 E303PC, Mon 14:45–15:30 E303PC, A. Nováková
B_AS_2/8MPH: Mon 14:00–14:44 DELL ROOM E302PC, Mon 14:45–15:30 DELL ROOM E302PC, V. Nulíček

Prerequisites

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers)
2. MS Word – creating a form, inserting various types of form fields, document protection.
3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison
4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references
5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete).
6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions.
7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and
8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing.
9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals
10. MS Excel – databases - PivotTable
11. MS Word – mail merge
12. Credit exercise – practical exercise in MS Word and MS Excel.

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS

Teaching methods

Assessment methods

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
General note: Aa0.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2013

Extent and Intensity

0/2. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

prof. Ing. Petr Berka, CSc. (seminar tutor)
Ing. Hana Hoffmannová (seminar tutor)
Ing. David Chudán, Ph.D. (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Bc. Josef Mšal (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Mgr. Pavel Vávra (seminar tutor)

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Dagmar Medová, DiS.

Timetable of Seminar Groups

B_AS_2/Repetenti_1: No timetable has been entered into IS. V. Nulíček
B_AS_2/Repetenti_2: No timetable has been entered into IS. A. Nováková
B_AS_2/Repetenti_3: No timetable has been entered into IS. H. Hoffmannová
B_AS_2/uMKL: Tue 12. 3. 17:30–19:00 K213PC, M. Kučera
B_AS_2/uM11PH: Tue 12. 3. 15:45–17:15 E303PC, V. Nulíček
B_AS_2/uM12PH: Tue 12. 3. 15:45–17:15 DELL ROOM E302PC, A. Nováková
B_AS_2/uRKL: Tue 12. 3. 15:45–17:15 K213PC, M. Kučera
B_AS_2/uR11PH: Tue 19. 3. 14:00–15:30 E303PC, M. Kučera
B_AS_2/uR12PH: Tue 19. 3. 14:00–15:30 DELL ROOM E302PC, D. Chudán
B_AS_2/vBP21PH: Fri 15. 3. 13:45–15:15 E303PC, J. Lánský
B_AS_2/vBP22PH: Fri 15. 3. 13:45–15:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/vM21PH: Fri 1. 3. 12:00–13:30 E303PC, J. Lánský
B_AS_2/vM22PH: Fri 1. 3. 17:15–18:45 E303PC, V. Nulíček
B_AS_2/vM23PH: Fri 1. 3. 15:30–17:00 DELL ROOM E302PC, H. Hoffmannová
B_AS_2/vM24PH: Fri 1. 3. 15:30–17:00 E303PC, V. Nulíček
B_AS_2/vPPR21PH: Fri 15. 3. 12:00–13:30 DELL ROOM E302PC, A. Nováková
B_AS_2/vPPR22PH: Fri 15. 3. 17:15–18:45 E303PC, A. Nováková
B_AS_2/vPPR23PH: Fri 15. 3. 12:00–13:30 E303PC, J. Lánský
B_AS_2/vV21PH: Fri 15. 3. 19:00–20:30 E303PC, A. Nováková
B_AS_2/v1AMRVMO: Fri 8. 3. 13:45–15:15 M11PC, H. Hoffmannová
B_AS_2/v2AMRMO: Fri 8. 3. 17:15–18:45 M11PC, H. Hoffmannová
B_AS_2/v6AVMO: Fri 8. 3. 15:30–17:00 M11PC, H. Hoffmannová
B_AS_2/v7NMRVMO: Fri 8. 3. 13:45–15:15 M12KL, J. Mšal
B_AS_2/1AMMO: Thu 11:15–12:00 M11PC, Thu 12:15–12:59 M11PC, H. Hoffmannová
B_AS_2/1BPH: Mon 14:00–14:44 DELL ROOM E302PC, Mon 14:45–15:30 DELL ROOM E302PC, V. Nulíček
B_AS_2/1MPH: Wed 10:30–11:14 E303PC, Wed 11:15–12:00 E303PC, J. Lánský
B_AS_2/1NPH: Mon 16:30–17:15 DELL ROOM E302PC, Mon 17:30–18:14 DELL ROOM E302PC, D. Chudán
B_AS_2/1PPPVVPH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, J. Lánský
B_AS_2/1RPH: Tue 10:30–11:14 DELL ROOM E302PC, Tue 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/1SPH: Thu 8:45–9:29 E303PC, Thu 9:30–10:15 E303PC, A. Nováková
B_AS_2/2AMMO: Thu 13:00–13:45 M11PC, Thu 14:00–14:44 M11PC, H. Hoffmannová
B_AS_2/2BPH: Mon 14:00–14:44 E303PC, Mon 14:45–15:30 E303PC, A. Nováková
B_AS_2/2MPH: Wed 8:45–9:29 E303PC, Wed 9:30–10:15 E303PC, J. Lokoč
B_AS_2/2PPPH: Mon 8:45–9:29 DELL ROOM E302PC, Mon 9:30–10:15 DELL ROOM E302PC, P. Berka
B_AS_2/2PVVPH: Thu 10:30–11:14 DELL ROOM E302PC, Thu 11:15–12:00 DELL ROOM E302PC, J. Lokoč
B_AS_2/2RPH: Tue 10:30–11:14 E303PC, Tue 11:15–12:00 E303PC, A. Nováková
B_AS_2/3ARVMO: Thu 8:00–8:44 M11PC, Thu 8:45–9:29 M11PC, H. Hoffmannová
B_AS_2/3MPH: Tue 12:15–12:59 DELL ROOM E302PC, Tue 13:00–13:45 DELL ROOM E302PC, V. Nulíček
B_AS_2/3RPH: Wed 10:30–11:14 DELL ROOM E302PC, Wed 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/4ARMO: Wed 8:45–9:29 M11PC, Wed 9:30–10:15 M11PC, H. Hoffmannová
B_AS_2/4MPH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, M. Kučera
B_AS_2/4RPH: Tue 8:45–9:29 E303PC, Tue 9:30–10:15 E303PC, A. Nováková
B_AS_2/5MPH: Thu 8:45–9:29 DELL ROOM E302PC, Thu 9:30–10:15 DELL ROOM E302PC, J. Lokoč
B_AS_2/5RPH: Mon 12:15–12:59 DELL ROOM E302PC, Mon 13:00–13:45 DELL ROOM E302PC, V. Nulíček
B_AS_2/6AVMO: Tue 14:00–14:44 M12KL, Tue 14:45–15:30 M12KL, J. Mšal
B_AS_2/6MPH: Wed 8:45–9:29 DELL ROOM E302PC, Wed 9:30–10:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/6RPH: Mon 12:15–12:59 E303PC, Mon 13:00–13:45 E303PC, A. Nováková
B_AS_2/7NMRVMO: Thu 9:30–10:15 M11PC, Thu 10:30–11:14 M11PC, H. Hoffmannová
B_AS_2/7RPH: Thu 10:30–11:14 E303PC, Thu 11:15–12:00 E303PC, A. Nováková
B_AS_2/8RPH: Thu 14:00–14:44 E303PC, Thu 14:45–15:30 E303PC, A. Nováková

Prerequisites

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers)
2. MS Word – creating a form, inserting various types of form fields, document protection.
3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison
4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references
5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete).
6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions.
7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and
8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing.
9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals
10. MS Excel – databases - PivotTable
11. MS Word – mail merge
12. Credit exercise – practical exercise in MS Word and MS Excel.

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info

recommended literature

Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS
Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010

Teaching methods

Assessment methods

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
General note: Aa0.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Winter 2012

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Dagmar Medová, DiS.

Timetable of Seminar Groups

B_AS_2/1: No timetable has been entered into IS.
B_AS_2/2: No timetable has been entered into IS.

Prerequisites

Application Software 1

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

The objective of the course is to enhance students’ knowledge in basic application software with a focus on the software included in the MS Office 2010 suite. This primarily includes more advanced working techniques in MS Excel 2010 and MS Word 2010.

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers) 2. MS Word – creating a form, inserting various types of form fields, document protection. 3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison 4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references 5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete). 6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions. 7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and 8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing. 9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals 10. MS Excel – databases - PivotTable 11. MS Word – mail merge 12. Credit exercise – practical exercise in MS Word and MS Excel.

Teaching methods

full-time study mode: managed seminares combined form: distance study mode

Assessment methods

Course completion: credit test

Language of instruction

Czech

Further comments (probably available only in Czech)

Information on completion of the course: ISP
The course can also be completed outside the examination period.
General note: 0.
Information on the extent and intensity of the course: 6 hodin/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
summer 2012

Extent and Intensity

0/2. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Mgr. Eva Čermáková (seminar tutor)
Ing. Hana Hoffmannová (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Bc. Josef Mšal (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Mgr. Pavel Vávra (seminar tutor)
PhDr. Jan Rytina, CSc. (assistant)

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_AS_2/REPETENT: No timetable has been entered into IS. A. Nováková
B_AS_2/sMKL: Wed 14. 3. 14:00–15:30 K213PC, E. Čermáková
B_AS_2/sM11PH: Wed 21. 3. 15:45–17:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/sM12PH: Wed 21. 3. 15:45–17:15 E303PC, A. Nováková
B_AS_2/sNJPH: Wed 21. 3. 14:00–15:30 DELL ROOM E302PC, J. Lánský
B_AS_2/sRKL: Wed 21. 3. 14:00–15:30 K213PC, M. Kučera
B_AS_2/sR11PH: Wed 21. 3. 14:00–15:30 E303PC, V. Nulíček
B_AS_2/sR12PH: Wed 21. 3. 17:30–19:00 E303PC, A. Nováková
B_AS_2/sVKL: Wed 21. 3. 15:45–17:15 K213PC, M. Kučera
B_AS_2/vBP21PH: Fri 16. 3. 13:45–15:15 E303PC, J. Lánský
B_AS_2/vBP22PH: Fri 16. 3. 17:15–18:45 DELL ROOM E302PC, P. Vávra
B_AS_2/vM21PH: Fri 30. 3. 17:15–18:45 E303PC, V. Nulíček
B_AS_2/vM22PH: Fri 30. 3. 17:15–18:45 DELL ROOM E302PC, P. Vávra
B_AS_2/vM23PH: Fri 16. 3. 15:30–17:00 E303PC, J. Lokoč
B_AS_2/vPP21PH: Fri 30. 3. 12:00–13:30 DELL ROOM E302PC, A. Nováková
B_AS_2/vR21PH: Fri 16. 3. 12:00–13:30 E303PC, A. Nováková
B_AS_2/vR22PH: Fri 16. 3. 12:00–13:30 DELL ROOM E302PC, J. Lánský
B_AS_2/vV21PH: Fri 30. 3. 13:45–15:15 E303PC, A. Nováková
B_AS_2/v1AMMO: Sat 17. 3. 14:00–15:30 M11PC, H. Hoffmannová
B_AS_2/v2AMMO: Sat 17. 3. 14:00–15:30 M12KL, M. Kučera
B_AS_2/v3ARMO: Sat 17. 3. 11:30–13:00 M11PC, H. Hoffmannová
B_AS_2/v5AVMO: Sat 17. 3. 9:45–11:15 M11PC, H. Hoffmannová
B_AS_2/v7NMRVMO: Sat 17. 3. 11:30–13:00 M12KL, M. Kučera
B_AS_2/1AMMO: Wed 13:00–13:45 M11PC, Wed 14:00–14:44 M11PC, H. Hoffmannová
B_AS_2/1BPH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, A. Nováková
B_AS_2/1MPH: Wed 8:45–9:29 E303PC, Wed 9:30–10:15 E303PC, A. Nováková
B_AS_2/1PVPH: Tue 8:45–9:29 DELL ROOM E302PC, Tue 9:30–10:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/1RPH: Thu 8:45–9:29 DELL ROOM E302PC, Thu 9:30–10:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/1SVPH: Wed 10:30–11:14 DELL ROOM E302PC, Wed 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/2AMMO: Thu 14:00–14:44 M12KL, Thu 14:45–15:30 M12KL, J. Mšal
B_AS_2/2MPH: Wed 8:45–9:29 DELL ROOM E302PC, Wed 9:30–10:15 DELL ROOM E302PC, J. Lokoč
B_AS_2/2RPH: Thu 8:45–9:29 E303PC, Thu 9:30–10:15 E303PC, A. Nováková
B_AS_2/3ARMO: Wed 11:15–12:00 M11PC, Wed 12:15–12:59 M11PC, H. Hoffmannová
B_AS_2/3MPH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, M. Kučera
B_AS_2/3RPH: Thu 10:30–11:14 DELL ROOM E302PC, Thu 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/4ARMO: Wed 9:30–10:15 M11PC, Wed 10:30–11:14 M11PC, H. Hoffmannová
B_AS_2/4MPH: Tue 12:15–12:59 DELL ROOM E302PC, Tue 13:00–13:45 DELL ROOM E302PC, J. Lokoč
B_AS_2/4RPH: Thu 10:30–11:14 E303PC, Thu 11:15–12:00 E303PC, A. Nováková
B_AS_2/5AVMO: Mon 9:30–10:15 M11PC, Mon 10:30–11:14 M11PC, H. Hoffmannová
B_AS_2/5MPH: Tue 15:45–16:29 E303PC, Tue 16:30–17:15 E303PC, M. Kučera
B_AS_2/5RPH: Wed 12:15–12:59 E303PC, Wed 13:00–13:45 E303PC, A. Nováková
B_AS_2/6AVMO: Thu 8:45–9:29 M12KL, Thu 9:30–10:15 M12KL, J. Mšal
B_AS_2/6MPH: Tue 15:45–16:29 DELL ROOM E302PC, Tue 16:30–17:15 DELL ROOM E302PC, J. Lánský
B_AS_2/6RPH: Wed 12:15–12:59 DELL ROOM E302PC, Wed 13:00–13:45 DELL ROOM E302PC, V. Nulíček
B_AS_2/7MPH: Tue 14:00–14:44 E303PC, Tue 14:45–15:30 E303PC, M. Kučera
B_AS_2/7NMRVMO: Thu 14:00–14:44 M11PC, Thu 14:45–15:30 M11PC, H. Hoffmannová
B_AS_2/7RPH: Tue 10:30–11:14 DELL ROOM E302PC, Tue 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/8MPH: Tue 14:00–14:44 DELL ROOM E302PC, Tue 14:45–15:30 DELL ROOM E302PC, J. Lánský
B_AS_2/8RPH: Wed 10:30–11:14 E303PC, Wed 11:15–12:00 E303PC, A. Nováková

Prerequisites

Application Software 1

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives (in Czech)

Naučit se používat pokročilé nástroje programu MS Word používané při správě dlouhých dokumentů, při týmové práci a při ochraně dokumentů. Zvládnout nástroje používané v prostředí programu MS Excel při vytváření, úpravě a správě tabulek.

Syllabus

1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers) 2. MS Word – creating a form, inserting various types of form fields, document protection. 3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison 4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references 5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete). 6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions. 7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and 8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing. 9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals 10. MS Excel – databases - PivotTable 11. MS Word – mail merge 12. Credit exercise – practical exercise in MS Word and MS Excel.

Teaching methods (in Czech)

prezenční studium - řízené semináře kombinované studium - distanční forma

Assessment methods

credit test

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Winter 2011

Extent and Intensity: 0/2. 3 credit(s). Type of Completion: z (credit).
Teacher(s): prof. Ing. Petr Berka, CSc. (seminar tutor)
Mgr. Eva Čermáková (seminar tutor)
Ing. David Chudán, Ph.D. (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Bc. Josef Mšal (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Mgr. Lucie Pelikánová (seminar tutor)
Ing. Jan Smolík (seminar tutor)
Mgr. Pavel Vávra (seminar tutor)
Ing. Hana Hoffmannová (assistant)
Mgr. Martin Mikuláš (assistant)
Ing. Vladimír Nulíček, CSc. (assistant)
Mgr. Lenka Omelková (assistant)
PhDr. Jan Rytina, CSc. (assistant)
Guaranteed by: Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková
Course Enrolment Limitations: The course is offered to students of any study field.
Language of instruction: Czech
Further comments (probably available only in Czech): Information on completion of the course: ISP
The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2011

Extent and Intensity

0/2. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

prof. Ing. Petr Berka, CSc. (seminar tutor)
Mgr. Eva Čermáková (seminar tutor)
Ing. David Chudán, Ph.D. (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Bc. Josef Mšal (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Mgr. Lucie Pelikánová (seminar tutor)
Ing. Jan Smolík (seminar tutor)
Mgr. Pavel Vávra (seminar tutor)
Ing. Hana Hoffmannová (assistant)
Mgr. Martin Mikuláš (assistant)
Ing. Vladimír Nulíček, CSc. (assistant)
Mgr. Lenka Omelková (assistant)
PhDr. Jan Rytina, CSc. (assistant)

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_AS_2/opakujici: No timetable has been entered into IS.
B_AS_2/uMKL_EQUIP: Tue 15. 2. 15:45–17:15 K213PC, Tue 22. 3. 15:45–17:15 K213PC, Tue 12. 4. 19:15–20:45 K213PC, M. Kučera
B_AS_2/uM11PH_E: Tue 8. 2. 15:45–17:15 E303PC, Tue 8. 3. 15:45–17:15 E303PC, Tue 12. 4. 15:45–17:15 E303PC, A. Nováková
B_AS_2/uM12PH_E: Tue 8. 2. 14:00–15:30 E303PC, Tue 8. 3. 14:00–15:30 E303PC, Tue 12. 4. 14:00–15:30 E303PC, M. Kučera
B_AS_2/uRKL_EQUIP: Tue 8. 3. 19:15–20:45 K213PC, Tue 29. 3. 19:15–20:45 K213PC, Tue 19. 4. 19:15–20:45 K213PC, M. Kučera
B_AS_2/uRV11PH_E: Tue 22. 2. 14:00–15:30 E303PC, Tue 15. 3. 14:00–15:30 E303PC, Tue 5. 4. 14:00–15:30 E303PC, V. Nulíček
B_AS_2/uRV12PH_E: Tue 22. 2. 15:45–17:15 E303PC, Tue 15. 3. 15:45–17:15 E303PC, Tue 5. 4. 15:45–17:15 E303PC, M. Kučera
B_AS_2/uRV13PH_E: Tue 22. 2. 15:45–17:15 DELL ROOM E302PC, Tue 15. 3. 15:45–17:15 DELL ROOM E302PC, Tue 5. 4. 15:45–17:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/uVKL_EQUIP: Tue 1. 3. 15:45–17:15 K213PC, Tue 15. 3. 14:00–15:30 K213PC, Tue 12. 4. 15:45–17:15 K213PC, E. Čermáková
B_AS_2/uV11PH_E: Tue 22. 2. 17:30–19:00 E303PC, Tue 15. 3. 17:30–19:00 E303PC, Tue 5. 4. 17:30–19:00 E303PC, J. Smolík
B_AS_2/vBP21PH_E: Fri 18. 2. 12:00–13:30 DELL ROOM E302PC, Fri 18. 3. 12:00–13:30 DELL ROOM E302PC, Fri 15. 4. 12:00–13:30 DELL ROOM E302PC, J. Lánský
B_AS_2/vBP22PH_E: Fri 18. 2. 17:15–18:45 Z12PC, Fri 18. 3. 17:15–18:45 Z12PC, Fri 15. 4. 17:15–18:45 Z12PC, D. Chudán
B_AS_2/vM21PH_E: Sat 5. 3. 9:45–11:15 E303PC, Sat 2. 4. 9:45–11:15 E303PC, Sat 7. 5. 15:45–17:15 E303PC, P. Vávra
B_AS_2/vM22PH_E: Sat 5. 3. 9:45–11:15 DELL ROOM E302PC, Sat 2. 4. 9:45–11:15 DELL ROOM E302PC, Sat 7. 5. 15:45–17:15 DELL ROOM E302PC, A. Nováková
B_AS_2/vM23PH_E: Sat 5. 3. 11:30–13:00 E303PC, Sat 2. 4. 11:30–13:00 E303PC, Sat 7. 5. 14:00–15:30 E303PC, P. Vávra
B_AS_2/vM24PH_E: Sat 5. 3. 11:30–13:00 DELL ROOM E302PC, Sat 2. 4. 11:30–13:00 DELL ROOM E302PC, Sat 7. 5. 14:00–15:30 DELL ROOM E302PC, A. Nováková
B_AS_2/vR21PH_E: Fri 18. 2. 13:45–15:15 DELL ROOM E302PC, Fri 18. 3. 13:45–15:15 DELL ROOM E302PC, Fri 15. 4. 13:45–15:15 DELL ROOM E302PC, J. Lánský
B_AS_2/vR22PH_E: Fri 18. 2. 12:00–13:30 E303PC, Fri 18. 3. 12:00–13:30 E303PC, Fri 15. 4. 12:00–13:30 E303PC, V. Nulíček
B_AS_2/v1AMMO_E: Sat 19. 2. 8:00–9:30 M11PC, Sat 19. 3. 8:00–9:30 M11PC, Sat 16. 4. 8:00–9:30 M11PC, H. Hoffmannová
B_AS_2/v2AMMO_E: Sat 19. 2. 8:00–9:30 M12KL, Sat 19. 3. 8:00–9:30 M12KL, Sat 16. 4. 8:00–9:30 M12KL, J. Mšal
B_AS_2/v3ARMO_E: Sat 19. 2. 9:45–11:15 M11PC, Sat 19. 3. 9:45–11:15 M11PC, Sat 16. 4. 9:45–11:15 M11PC, H. Hoffmannová
B_AS_2/v4ARMO_E: Sat 19. 2. 9:45–11:15 M12KL, Sat 19. 3. 9:45–11:15 M12KL, Sat 16. 4. 9:45–11:15 M12KL, J. Mšal
B_AS_2/v5AVMO_E: Fri 18. 2. 15:30–17:00 M11PC, Fri 18. 3. 15:30–17:00 M11PC, Fri 15. 4. 15:30–17:00 M11PC, H. Hoffmannová
B_AS_2/v6AVMO_E: Fri 18. 2. 17:15–18:45 M11PC, Fri 18. 3. 17:15–18:45 M11PC, Fri 15. 4. 17:15–18:45 M11PC, J. Mšal
B_AS_2/v7NRVMO_E: Sat 5. 3. 11:30–13:00 M11PC, Sat 19. 3. 11:30–13:00 M11PC, Fri 6. 5. 17:15–18:45 M11PC, H. Hoffmannová
B_AS_2/1AMMO: Tue 8:45–9:29 M11PC, Tue 9:30–10:15 M11PC, H. Hoffmannová
B_AS_2/1NPH: Wed 12:15–12:59 DELL ROOM E302PC, Wed 13:00–13:45 DELL ROOM E302PC, V. Nulíček
B_AS_2/10APH: Wed 8:45–9:29 E303PC, Wed 9:30–10:15 E303PC, A. Nováková
B_AS_2/11APH: Thu 14:00–14:44 E303PC, Thu 14:45–15:30 E303PC, V. Nulíček
B_AS_2/12APH: Wed 8:45–9:29 DELL ROOM E302PC, Wed 9:30–10:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/13APH: Wed 8:45–9:29 E027, Wed 9:30–10:15 E027, J. Lokoč
B_AS_2/14APH: Thu 12:15–12:59 DELL ROOM E302PC, Thu 13:00–13:45 DELL ROOM E302PC, J. Lánský
B_AS_2/15APH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, D. Chudán
B_AS_2/16APH: Tue 8:45–9:29 E303PC, Tue 9:30–10:15 E303PC, V. Nulíček
B_AS_2/17APH: Thu 15:45–16:29 E303PC, Thu 16:30–17:15 E303PC, V. Nulíček
B_AS_2/18APH: Mon 8:45–9:29 E303PC, Mon 9:30–10:15 E303PC, A. Nováková
B_AS_2/19APH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, M. Kučera
B_AS_2/2AMMO: Tue 14:00–14:44 M11PC, Tue 14:45–15:30 M11PC, H. Hoffmannová
B_AS_2/20APH: Mon 8:45–9:29 DELL ROOM E302PC, Mon 9:30–10:15 DELL ROOM E302PC, P. Berka
B_AS_2/21APH: Mon 12:15–12:59 E303PC, Mon 13:00–13:45 E303PC, A. Nováková
B_AS_2/3AMMO: Mon 15:45–16:29 M11PC, Mon 16:30–17:15 M11PC, J. Mšal
B_AS_2/3APH: Wed 10:30–11:14 DELL ROOM E302PC, Wed 11:15–12:00 DELL ROOM E302PC, A. Nováková
B_AS_2/4APH: Wed 10:30–11:14 E027, Wed 11:15–12:00 E027, V. Nulíček
B_AS_2/4ARMO: Thu 10:30–11:14 M11PC, Thu 11:15–12:00 M11PC, H. Hoffmannová
B_AS_2/5APH: Wed 12:15–12:59 E303PC, Wed 13:00–13:45 E303PC, A. Nováková
B_AS_2/5ARMO: Thu 10:30–11:14 M12KL, Thu 11:15–12:00 M12KL, J. Mšal
B_AS_2/6APH: Thu 12:15–12:59 E027, Thu 13:00–13:45 E027, V. Nulíček
B_AS_2/6AVMO: Thu 14:00–14:44 M11PC, Thu 14:45–15:30 M11PC, H. Hoffmannová
B_AS_2/7APH: Mon 14:00–14:44 E303PC, Mon 14:45–15:30 E303PC, A. Nováková
B_AS_2/7AVMO: Thu 15:45–16:29 M11PC, Thu 16:30–17:15 M11PC, H. Hoffmannová
B_AS_2/8APH: Tue 10:30–11:14 DELL ROOM E302PC, Tue 11:15–12:00 DELL ROOM E302PC, J. Smolík
B_AS_2/8NRMO: each odd Thursday 15:45–17:15 M12KL and each even Thursday 12:15–13:45 M12KL, J. Mšal
B_AS_2/9APH: Tue 10:30–11:14 E303PC, Tue 11:15–12:00 E303PC, M. Kučera
B_AS_2/9NVMO: Thu 14:00–14:44 M12KL, Thu 14:45–15:30 M12KL, J. Mšal

Prerequisites (in Czech)

Navazuje na předmět Aplikační software 1 ze zimního semestru 1.ročníku - student by měl zvládat základní techniky práce s aplikacemi MS Office Word 2007, MS Office PowerPoint 2007 a MS Office Excel 2007 na úrovni osnovy tohoto předmětu.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives (in Czech)

Tato osnova je určena studentům prezenčního studium, průběh výuky pro kombinované studium je dán osnovou distančního studia předmětu AS_2. 1. Opakovací cvičení – zopakování práce se styly, číslování nadpisů, vytváření poznámek pod čarou a obsahu. Opakování použití různých typů adres ve výpočtech v tabulkách programu MS Excel 2. MS Word – číslování vložených objektů, vytváření seznamů objektů, křížové odkazy, rejstřík 3. MS Word – editace rozsáhlých dokumentů – rozdělení dokumentu na oddíly (orientace strany, svislé zarovnání strany, různá záhlaví a zápatí, číslování stran) 4. MS Word – elektronický formulář – vložení a úprava ovládacích prvků, ovládací prvky na vložené titulní straně, příprava formuláře k vyplnění, ochrana dokumentu 5. MS Word – práce se šablonami – použití standardních šablon nabízených programem, vytvoření vlastní šablony (např. hlavičkový papír firmy). Revize dokumentu, vkládání komentářů, porovnání dokumentů 6. MS Excel – složitější výpočty v tabulkách s použitím různých typů adres (event. názvů), aplikace složitějších funkcí (finanční, textové aj.), vnořování funkcí 7. MS Excel – použití dalších funkcí (logické, vyhledávací). Podmíněný formát. 8. MS Excel – práce s listy (vložení, přejmenování, odstranění, kopírování, práce s více listy současně). Externí odkazy - výpočty s odkazy na jiné listy event. sešity. Tisk rozsáhlých tabulek – záhlaví a zápatí, opakování hlavičky tabulky, oblast tisku, úprava měřítka pro tisk 9. MS Excel – analytické nástroje (hledání řešení, správce scénářů, tabulka dat) 10. MS Excel – databáze – řazení, filtr, souhrny, kontingenční tabulky a grafy 11. MS Word – hromadná korespondence 12. Zápočtové cvičení – zpracování praktického příkladu z aplikací MS Word a MS Excel

Literature

required literature

NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 1. díl (MS Office 2007 – MS Word). 1st ed. Praha: VŠFS, 2008, 117 pp. ISBN 978-80-7408-010-4. info
NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2.díl (MS Office 2007 – MS Excel, MS PowerPoint). 1st ed. Praha: VŠFS, 2008, 131 pp. ISBN 978-80-7408-011-1. info

recommended literature

Pecinovský J.: Word 2007 – podrobný průvodce. Grada 2007. ISBN: 978-80-247-1959-7
Brož M: MS Excel 2007 – podrobná uživatelská příručka. Computerpress 2007. ISBN: 978-80-251-1822-1
Pírková K.: MS Word 2007 - podrobná uživatelská příručka. Computerpress 2007. ISBN: 978-80-251-1571-8
Bříza V.: Excel 2007 – podrobný průvodce. Grada 2007. ISBN: 978-80-247-1965-8

Teaching methods (in Czech)

Typ výuky: řízený seminář

Assessment methods (in Czech)

Způsob zakončení předmětu: zápočet. K udělení zápočtu musí mít student splněny tyto studijní povinnosti: 1. 75% účast na cvičeních, studenti KS 50%. Studentům, kteří nesplní povinný rozsah účasti, mohou být v průběhu semestru zadány dodatečné studijní povinnosti (v míře, která umožní prokázat studijní výsledky a získané kompetence nezbytné pro úspěšné zakončení předmětu). 2. zpracování zadaných domácích úloh podle pokynů vyučujícího 3. zpracování zápočtové práce s výsledkem min. 80% 4. zápočet z předmětu AS_1

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2010

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

prof. Ing. Petr Berka, CSc. (seminar tutor)
Ing. Hana Hoffmannová (seminar tutor)
Ing. David Chudán, Ph.D. (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Bc. Josef Mšal (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Mgr. Lucie Pelikánová (seminar tutor)
Ing. Jan Smolík (seminar tutor)
Mgr. Martin Mikuláš (assistant)
Mgr. Lenka Omelková (assistant)
PhDr. Jan Rytina, CSc. (assistant)

Guaranteed by

Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Lenka Bažantová

Timetable of Seminar Groups

B_AS_2/cMKL: Wed 10:30–11:14 K213PC, Wed 11:15–12:00 K213PC, M. Kučera
B_AS_2/cVKL: each even Tuesday 11:15–12:00 K213PC, each even Tuesday 12:15–12:59 K213PC and each odd Wednesday 12:15–12:59 K213PC, each odd Wednesday 13:00–13:45 K213PC, M. Kučera
B_AS_2/sM11KL: Wed 7. 4. 14:00–15:30 K213PC, 15:45–17:15 K213PC, Wed 21. 4. 15:45–17:15 K213PC, M. Kučera
B_AS_2/sM11PH: Wed 3. 3. 17:30–19:00 E303PC, Wed 24. 3. 14:00–15:30 E303PC, Wed 14. 4. 17:30–19:00 E303PC, D. Chudán
B_AS_2/sM12PH: Wed 3. 3. 15:45–17:15 E303PC, Wed 24. 3. 15:45–17:15 E303PC, Wed 14. 4. 14:00–15:30 E303PC, D. Chudán
B_AS_2/sM13PH: Wed 3. 3. 14:00–15:30 E303PC, Wed 24. 3. 17:30–19:00 E303PC, Wed 14. 4. 15:45–17:15 E303PC, D. Chudán
B_AS_2/sM14PH: Wed 3. 3. 14:00–15:30 DELL ROOM E302PC, Wed 24. 3. 14:00–15:30 DELL ROOM E302PC, Wed 14. 4. 17:30–19:00 DELL ROOM E302PC, J. Smolík
B_AS_2/sRV12PH: Wed 24. 2. 15:45–17:15 DELL ROOM E302PC, Wed 17. 3. 15:45–17:15 DELL ROOM E302PC, Wed 7. 4. 15:45–17:15 DELL ROOM E302PC, A. Nováková
B_AS_2/sRV13PH: Wed 24. 2. 17:30–19:00 DELL ROOM E302PC, Wed 17. 3. 17:30–19:00 DELL ROOM E302PC, Wed 7. 4. 17:30–19:00 DELL ROOM E302PC, A. Nováková
B_AS_2/sR11KL: Wed 24. 2. 15:45–17:15 K213PC, Wed 3. 3. 19:15–20:45 K213PC, Wed 10. 3. 14:00–15:30 K213PC, M. Kučera
B_AS_2/sR11PH: Wed 24. 2. 14:00–15:30 DELL ROOM E302PC, Wed 17. 3. 14:00–15:30 DELL ROOM E302PC, Wed 7. 4. 14:00–15:30 DELL ROOM E302PC, A. Nováková
B_AS_2/sV11PH: Wed 24. 2. 17:30–19:00 E303PC, Wed 17. 3. 14:00–15:30 E303PC, Wed 7. 4. 17:30–19:00 E303PC, D. Chudán
B_AS_2/vBV23PH: Fri 12. 2. 13:45–15:15 Z12PC, Fri 12. 3. 13:45–15:15 Z12PC, Fri 16. 4. 13:45–15:15 Z12PC, A. Nováková
B_AS_2/vB21PH: Fri 12. 2. 15:30–17:00 Z12PC, Fri 12. 3. 15:30–17:00 Z12PC, Fri 16. 4. 15:30–17:00 Z12PC, A. Nováková
B_AS_2/vM21PH: Sat 13. 2. 9:45–11:15 DELL ROOM E302PC, Sat 13. 3. 9:45–11:15 DELL ROOM E302PC, Sat 17. 4. 9:45–11:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/vM22PH: Fri 26. 2. 17:15–18:45 E303PC, Sat 13. 3. 9:45–11:15 E303PC, Sat 17. 4. 9:45–11:15 E303PC, L. Pelikánová
B_AS_2/vM23PH: Sat 13. 3. 11:30–13:00 E303PC, Sat 17. 4. 11:30–13:00 E303PC, Fri 30. 4. 17:16–18:45 E303PC, L. Pelikánová
B_AS_2/vM24PH: Sat 13. 2. 14:00–15:30 DELL ROOM E302PC, 15:45–17:15 DELL ROOM E302PC, Sat 13. 3. 14:00–15:30 DELL ROOM E302PC, J. Smolík
B_AS_2/vP21PH: Fri 26. 2. 12:00–13:30 E303PC, Fri 12. 3. 13:45–15:15 Z22PC, Fri 16. 4. 13:45–15:15 Z22PC, L. Pelikánová
B_AS_2/vR21PH: Fri 26. 2. 15:30–17:00 Z12PC, Fri 26. 3. 15:30–17:00 Z12PC, Fri 30. 4. 15:30–17:00 Z12PC, A. Nováková
B_AS_2/vR22PH: Fri 26. 2. 15:30–17:00 Z22PC, Fri 26. 3. 15:30–17:00 Z22PC, Fri 16. 4. 12:00–13:30 E303PC, V. Nulíček
B_AS_2/vR23PH: Fri 26. 2. 13:45–15:15 Z22PC, Fri 26. 3. 13:45–15:15 Z22PC, Fri 7. 5. 12:00–13:30 E303PC, V. Nulíček
B_AS_2/vR24PH: Fri 26. 2. 13:45–15:15 Z12PC, Fri 26. 3. 13:45–15:15 Z12PC, Fri 30. 4. 13:45–15:15 Z12PC, A. Nováková
B_AS_2/vV21PH: Fri 12. 3. 15:30–17:00 Z22PC, Fri 16. 4. 15:30–17:00 Z22PC, Fri 30. 4. 15:30–17:15 E303PC, L. Pelikánová
B_AS_2/v1AMMO: Fri 12. 2. 19:00–20:30 M11PC, Sat 27. 2. 11:30–13:00 M11PC, Fri 7. 5. 19:00–20:30 M11PC, H. Hoffmannová
B_AS_2/v2AMMO: Sat 13. 2. 11:30–13:00 M11PC, 14:00–15:30 M11PC, Fri 26. 2. 19:00–20:30 M11PC, H. Hoffmannová
B_AS_2/v3ARMO: Sat 13. 3. 14:00–15:30 M11PC, 15:45–17:15 M11PC, Fri 7. 5. 13:45–15:15 M11PC, H. Hoffmannová
B_AS_2/v4ARMO: Sat 27. 2. 14:00–15:30 M11PC, 15:45–17:15 M11PC, Fri 7. 5. 15:30–17:00 M11PC, H. Hoffmannová
B_AS_2/v5AVMO: Sat 27. 2. 11:30–13:00 M12KL, 14:00–15:30 M12KL, Sat 27. 3. 8:00–9:30 M11PC, J. Mšal
B_AS_2/v6AVMO: Sat 13. 2. 14:00–15:30 M12KL, 15:45–17:15 M12KL, Sat 17. 4. 14:00–15:30 M12KL, J. Mšal
B_AS_2/v7NRMO: Sat 17. 4. 14:00–15:30 M11PC, 15:45–17:15 M11PC, Fri 7. 5. 17:15–18:45 M11PC, H. Hoffmannová
B_AS_2/v8NVMO: Sat 13. 3. 14:00–15:30 M12KL, 15:45–17:15 M12KL, Sat 27. 3. 14:00–15:30 M11PC, J. Mšal
B_AS_2/1AMMO: each even Wednesday 12:15–12:59 M11PC, each even Wednesday 13:00–13:45 M11PC, each even Wednesday 14:00–14:44 M11PC, each even Wednesday 14:45–15:30 M11PC, H. Hoffmannová
B_AS_2/1NPH: Thu 12:15–12:59 E027, Thu 13:00–13:45 E027, J. Lokoč
B_AS_2/10APH: Tue 14:00–14:44 E303PC, Tue 14:45–15:30 E303PC, V. Nulíček
B_AS_2/10NVMO: Mon 12:15–12:59 M12KL, Mon 13:00–13:45 M12KL, J. Mšal
B_AS_2/11APH: Tue 14:00–14:44 DELL ROOM E302PC, Tue 14:45–15:30 DELL ROOM E302PC, A. Nováková
B_AS_2/12APH: Thu 8:45–9:29 E303PC, Thu 9:30–10:15 E303PC, V. Nulíček
B_AS_2/13APH: Wed 12:15–12:59 DELL ROOM E302PC, Wed 13:00–13:45 DELL ROOM E302PC, V. Nulíček
B_AS_2/14APH: Wed 12:15–12:59 E303PC, Wed 13:00–13:45 E303PC, J. Smolík
B_AS_2/15APH: Wed 10:30–11:14 DELL ROOM E302PC, Wed 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/16APH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, V. Nulíček
B_AS_2/17APH: Thu 14:00–14:44 E027, Thu 14:45–15:30 E027, J. Lokoč
B_AS_2/18APH: Thu 10:30–11:14 DELL ROOM E302PC, Thu 11:15–12:00 DELL ROOM E302PC, J. Lokoč
B_AS_2/2AMMO: Tue 12:15–12:59 M11PC, Tue 13:00–13:45 M11PC, H. Hoffmannová
B_AS_2/2APH: Mon 12:15–12:59 DELL ROOM E302PC, Mon 13:00–13:45 DELL ROOM E302PC, A. Nováková
B_AS_2/20APH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, V. Nulíček
B_AS_2/21APH: Wed 10:30–12:00 E027, D. Chudán
B_AS_2/3AMMO: each even Tuesday 10:30–11:14 M11PC, each even Tuesday 11:15–12:00 M11PC and each odd Wednesday 15:45–16:29 M11PC, each odd Wednesday 16:30–17:15 M11PC, H. Hoffmannová
B_AS_2/3APH: Mon 8:45–9:29 DELL ROOM E302PC, Mon 9:30–10:15 DELL ROOM E302PC, P. Berka
B_AS_2/4APH: Thu 10:30–11:14 E303PC, Thu 11:15–12:00 E303PC, A. Nováková
B_AS_2/4ARMO: Tue 15:45–16:29 M11PC, Tue 16:30–17:15 M11PC, H. Hoffmannová
B_AS_2/5APH: Thu 15:45–16:29 DELL ROOM E302PC, Thu 16:30–17:15 DELL ROOM E302PC, J. Lokoč
B_AS_2/5ARMO: Tue 14:00–14:44 M11PC, Tue 14:45–15:30 M11PC, H. Hoffmannová
B_AS_2/6APH: Tue 8:45–9:29 DELL ROOM E302PC, Tue 9:30–10:15 DELL ROOM E302PC, V. Nulíček
B_AS_2/6AVMO: Thu 10:30–11:14 M11PC, Thu 11:15–12:00 M11PC, J. Mšal
B_AS_2/7APH: Tue 12:15–12:59 DELL ROOM E302PC, Tue 13:00–13:45 DELL ROOM E302PC, A. Nováková
B_AS_2/7AVMO: Mon 15:45–16:29 M12KL, Mon 16:30–17:15 M12KL, J. Mšal
B_AS_2/8APH: Tue 10:30–11:14 DELL ROOM E302PC, Tue 11:15–12:00 DELL ROOM E302PC, A. Nováková
B_AS_2/8NRMO: Thu 14:00–14:44 M11PC, Thu 14:45–15:30 M11PC, J. Mšal
B_AS_2/9AMMO: Thu 12:15–12:59 M11PC, Thu 13:00–13:45 M11PC, J. Mšal
B_AS_2/9APH: Thu 8:45–9:29 E027, Thu 9:30–10:15 E027, A. Nováková

Prerequisites (in Czech)

Navazuje na předmět Aplikační software 1 ze zimního semestru 1.ročníku - student by měl zvládat základní techniky práce s aplikacemi MS Office Word 2007 a MS Office Excel 2007 na úrovni osnovy tohoto předmětu.

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

there are 10 fields of study the course is directly associated with, display

Course objectives (in Czech)

Cílem předmětu je rozšířit znalosti studentů v základním aplikačním softwaru se zaměřením na software zařazený do balíku MS Office 2007. Jedná se zejména o pokročilejší techniky práce v aplikacích MS Excel 2007 a MS Word 2007, event. o některé další aplikace.

Syllabus (in Czech)

Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu /ML/
1. Opakovací cvičení – samostatná práce studentů, zopakování látky z aplikací Word a Excel z AS1.
2. MS Word – práce se šablonami, stažení šablony z webu Office, vytvoření vlastní šablony (např. hlavičkový papír firmy)
3. MS Word – vytvoření formuláře, příprava formuláře k vyplnění, ochrana dokumentu.
4. MS Word – revize dokumentu, sdílení dokumentů s jinými uživateli, vkládání komentářů, porovnání dokumentů.
5. MS Word – editace rozsáhlých dokumentů, vytváření rejstříků a seznamů, rozdělení dokumentu na oddíly (různý vzhled stránky, různá záhlaví a zápatí), křížové odkazy.
6. MS Word – hromadná korespondence, export dat z jiných aplikací (Excel, Outlook, event. Access).
7. MS Excel – složitější výpočty v tabulkách s použitím různých typů adres (event. názvů), aplikace složitějších funkcí (finanční, textové aj.), vnořování funkcí.
8. MS Excel – práce s listy (vložení, přejmenování, odstranění, kopírování, práce s více listy současně), výpočty s odkazy na jiné listy event. sešity. Úpravy a tisk rozsáhlejších tabulek, záhlaví a zápatí, opakování hlavičky tabulky, oblast tisku, úprava velikosti pro tisk.
9. MS Excel – podmíněné formátování, použití dalších funkcí (logické, vyhledávací). Složitější úpravy grafů (vedlejší osa, přidání dat, změna orientace dat, speciální funkce.
10. MS Excel – analytické nástroje (hledání řešení, správce scénářů, datová tabulka).
11. MS Excel – databáze - řazení, filtrování, souhrny, kontingenční tabulky a grafy.
12. Zápočtové cvičení – zpracování praktického příkladu z aplikací MS Word a MS Excel.

Literature

Povinná literatura
Nováková A., Nulíček V.: Aplikační software 1, 2. Eupress 2008 (skripta)
Doporučená literatura
Pecinovský J.: Word 2007 – podrobný průvodce. Grada 2007.
Bříza V.: Excel 2007 – podrobný průvodce. Grada 2007.
Pírková K.: MS Office Word 2007: Podrobná uživatelská příručka. Computerpress 2007
Brož M.: MS Office Excel 2007: Podrobná uživatelská příručka. Computerpress 2007
Grover C.: Word 2007: The Missing Manual by Matthew MacDonald, O'Reilly Med. Inc. 2006
Mac Donald M: Excel 2007: The Missing Manual by Matthew MacDonald, O'Reilly Med. Inc. 2008
Další zdroje
www.vsfs.cz/knihovna
www.knihovna.vsfs.cz/info/volne_eiz.html
IS VŠFS → osobní administrativa → ProQuest
http://vnulicek.ic.cz

Teaching methods (in Czech)

Typ výuky: řízený seminář

Assessment methods (in Czech)

Způsob zakončení předmětu: zápočet
K udělení zápočtu musí mít student splněny tyto studijní povinnosti:
1. 80% účast na cvičeních. Studentům, kteří nesplní povinný rozsah účasti, mohou být v průběhu semestru zadány dodatečné studijní povinnosti (v míře, která umožní prokázat studijní výsledky a získané kompetence nezbytné pro úspěšné zakončení předmětu).
2. zpracování zadaných domácích úloh podle pokynů vyučujícího
3. zpracování zápočtové práce s výsledkem min. 80%

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6hodin/semestr.

Teacher's information

http://vnulicek.ic.cz

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Winter 2009

Extent and Intensity: 0/2/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s): Mgr. Miroslav Kučera (seminar tutor)
Ing. Bc. Josef Mšal (seminar tutor)
Mgr. Lucie Pelikánová (seminar tutor)
Guaranteed by: Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Lenka Bažantová
Course Enrolment Limitations: The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with: there are 10 fields of study the course is directly associated with, display
Language of instruction: Czech
Further comments (probably available only in Czech): The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6hodin/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2009

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

prof. Ing. Petr Berka, CSc. (seminar tutor)
Ing. Hana Hoffmannová (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Bc. Josef Mšal (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Mgr. Lucie Pelikánová (seminar tutor)
Ing. Jan Smolík (seminar tutor)
Ing. Jana Spilková (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Lenka Bažantová

Timetable of Seminar Groups

B_AS_2/cMKL: each even Monday 12:15–12:59 K213PC, each even Monday 13:00–13:45 K213PC, each even Monday 14:00–14:44 K213PC, each even Monday 14:45–15:30 K213PC, M. Kučera
B_AS_2/cMKLks: Thu 9. 4. 15:45–17:15 K213PC, 17:30–19:00 K213PC, Thu 16. 4. 14:00–15:30 K213PC, M. Kučera
B_AS_2/cRKL: each odd Monday 10:30–11:14 K213PC, each odd Monday 11:15–12:00 K213PC and each even Monday 10:30–11:14 K213PC, each even Monday 11:15–12:00 K213PC, M. Kučera
B_AS_2/cRKLks: Thu 2. 4. 19:15–20:45 K213PC, Thu 23. 4. 15:45–17:15 K213PC, 17:30–19:00 K213PC, M. Kučera
B_AS_2/cVKL: Tue 10:30–11:14 K213PC, Tue 11:15–12:00 K213PC, M. Kučera
B_AS_2/cVKLks: Thu 2. 4. 14:00–15:30 K213PC, Thu 16. 4. 17:30–19:00 K213PC, Thu 30. 4. 17:30–19:00 K213PC, M. Kučera
B_AS_2/uM11PH: Tue 17. 2. 17:30–19:00 DELL ROOM E302PC, Tue 3. 3. 17:30–19:00 DELL ROOM E302PC, Tue 24. 3. 17:30–19:00 DELL ROOM E302PC, J. Lokoč
B_AS_2/uM12PH: Tue 17. 2. 17:30–19:00 E303PC, Tue 3. 3. 17:30–19:00 E303PC, Tue 24. 3. 17:30–19:00 E303PC, J. Spilková
B_AS_2/uM13PH: Tue 10. 2. 15:45–17:15 E303PC, Tue 24. 2. 15:45–17:15 E303PC, Tue 17. 3. 15:45–17:15 E303PC, V. Nulíček
B_AS_2/uM14PH: Tue 10. 2. 15:45–17:15 DELL ROOM E302PC, Tue 24. 2. 15:45–17:15 DELL ROOM E302PC, Tue 17. 3. 15:45–17:15 DELL ROOM E302PC, A. Nováková
B_AS_2/uRV13PH: Tue 24. 2. 17:30–19:00 E303PC, Tue 17. 3. 17:30–19:00 E303PC, Tue 7. 4. 17:30–19:00 E303PC, V. Nulíček
B_AS_2/uR11PH: Tue 24. 2. 14:00–15:30 E303PC, Tue 17. 3. 14:00–15:30 E303PC, Tue 7. 4. 14:00–15:30 E303PC, V. Nulíček
B_AS_2/uR12PH: Tue 24. 2. 17:30–19:00 DELL ROOM E302PC, Tue 17. 3. 17:30–19:00 DELL ROOM E302PC, Tue 7. 4. 17:30–19:00 DELL ROOM E302PC, J. Lokoč
B_AS_2/uV11PH: Tue 17. 3. 14:00–15:30 DELL ROOM E302PC, Tue 31. 3. 14:00–15:30 DELL ROOM E302PC, Tue 7. 4. 14:00–15:30 DELL ROOM E302PC, J. Smolík
B_AS_2/uV12PH: Tue 3. 3. 19:15–20:45 DELL ROOM E302PC, Tue 17. 3. 19:15–20:45 DELL ROOM E302PC, Tue 7. 4. 15:45–17:15 DELL ROOM E302PC, J. Spilková
B_AS_2/vFPV23PH: Fri 13. 2. 17:15–18:45 Z12PC, Fri 13. 3. 17:15–18:45 Z12PC, Fri 24. 4. 17:15–18:45 Z12PC, J. Spilková
B_AS_2/vF21PH: Fri 24. 4. 13:45–15:15 Z22PC, Fri 22. 5. 15:30–17:00 E303PC, V. Nulíček
B_AS_2/vF22PH: Fri 24. 4. 15:30–17:00 Z12PC, Fri 15. 5. 17:15–18:45 E303PC, 19:00–20:30 E303PC, V. Nulíček
B_AS_2/vM21PH: Sat 28. 3. 14:00–15:30 DELL ROOM E302PC, 15:45–17:15 DELL ROOM E302PC, Sat 16. 5. 14:00–15:30 S16PC, L. Pelikánová
B_AS_2/vM22PH: Sat 28. 3. 14:00–15:30 E303PC, 15:45–17:15 E303PC, Sat 16. 5. 14:00–15:30 E303PC, J. Spilková
B_AS_2/vM23PH: Sat 28. 3. 11:30–13:00 E303PC, Sat 16. 5. 9:45–11:15 E303PC, 11:30–13:00 E303PC, J. Spilková
B_AS_2/vM24PH: Sat 28. 3. 11:30–13:00 DELL ROOM E302PC, Sat 16. 5. 9:45–11:15 S16PC, 11:30–13:00 S16PC, L. Pelikánová
B_AS_2/vM25PH: Sat 28. 3. 8:00–9:30 E303PC, 9:45–11:15 E303PC, Sat 16. 5. 15:45–17:15 E303PC, J. Spilková
B_AS_2/vM26PH: Sat 28. 2. 9:45–11:15 DELL ROOM E302PC, Sat 28. 3. 8:00–9:30 DELL ROOM E302PC, 9:45–11:15 DELL ROOM E302PC, J. Smolík
B_AS_2/vP21PH: Fri 13. 2. 12:00–13:30 Z12PC, Fri 13. 3. 12:00–13:30 Z12PC, Fri 24. 4. 12:00–13:30 Z12PC, A. Nováková
B_AS_2/vR21PH: Fri 27. 3. 15:30–17:00 Z12PC, 17:15–18:45 Z12PC, Fri 15. 5. 15:30–17:00 Z12PC, J. Spilková
B_AS_2/vR22PH: Fri 27. 2. 15:30–17:00 Z22PC, Fri 27. 3. 15:30–17:00 Z22PC, Fri 15. 5. 15:30–17:00 Z22PC, L. Pelikánová
B_AS_2/vR23PH: Fri 27. 2. 13:45–15:15 Z12PC, Fri 27. 3. 13:45–15:15 Z12PC, Fri 15. 5. 13:45–15:15 Z12PC, V. Nulíček
B_AS_2/vR24PH: Fri 27. 2. 13:45–15:15 Z22PC, Fri 27. 3. 13:45–15:15 Z22PC, Fri 15. 5. 13:45–15:15 Z22PC, L. Pelikánová
B_AS_2/vR25PH: Fri 27. 2. 12:00–13:30 Z12PC, Fri 27. 3. 12:00–13:30 Z12PC, Fri 15. 5. 12:00–13:30 Z12PC, V. Nulíček
B_AS_2/vV21PH: Fri 13. 2. 12:00–13:30 Z22PC, Fri 13. 3. 12:00–13:30 Z22PC, Fri 24. 4. 12:00–13:30 Z22PC, J. Lokoč
B_AS_2/v1AMMO: Fri 27. 2. 19:00–20:30 M11PC, Sat 28. 2. 14:00–15:30 M11PC, 15:45–17:15 M11PC, H. Hoffmannová
B_AS_2/v2AMMO: Sat 14. 2. 14:00–15:30 M12KL, 15:45–17:15 M12KL, Sat 28. 2. 14:00–15:30 M12KL, J. Mšal
B_AS_2/v3ARMO: Sat 14. 3. 11:30–13:00 M11PC, 14:00–15:30 M11PC, Fri 24. 4. 17:15–18:45 M11PC, H. Hoffmannová
B_AS_2/v4ARMO: Sat 14. 3. 11:30–13:00 M12KL, 14:00–15:30 M12KL, Fri 27. 3. 19:00–20:30 M12KL, J. Mšal
B_AS_2/v5AVMO: Sat 25. 4. 8:00–9:30 M11PC, 9:45–11:15 M11PC, Sat 16. 5. 14:00–15:30 M11PC, H. Hoffmannová
B_AS_2/v6AVMO: Sat 25. 4. 8:00–9:30 M12KL, 9:45–11:15 M12KL, Sat 16. 5. 14:00–15:30 M12KL, J. Mšal
B_AS_2/v7NRMO: Sat 25. 4. 14:00–15:30 M11PC, Sat 16. 5. 8:00–9:30 M11PC, 9:45–11:15 M11PC, H. Hoffmannová
B_AS_2/v8NVMO: Fri 13. 3. 15:30–17:00 M11PC, 17:15–18:45 M11PC, Fri 24. 4. 12:00–13:30 M11PC, H. Hoffmannová
B_AS_2/1AMMO: Tue 14:00–14:44 M11PC, Tue 14:45–15:30 M11PC, H. Hoffmannová
B_AS_2/1NPH: Wed 15:45–16:29 DELL ROOM E302PC, Wed 16:30–17:15 DELL ROOM E302PC, J. Smolík
B_AS_2/10APH: Wed 14:00–14:44 DELL ROOM E302PC, Wed 14:45–15:30 DELL ROOM E302PC, V. Nulíček
B_AS_2/11APH: Mon 15:45–16:29 E303PC, Mon 16:30–17:15 E303PC, A. Nováková
B_AS_2/12APH: Thu 14:00–14:44 DELL ROOM E302PC, Thu 14:45–15:30 DELL ROOM E302PC, J. Lokoč
B_AS_2/13APH: Mon 12:15–12:59 E303PC, Mon 13:00–13:45 E303PC, V. Nulíček
B_AS_2/14APH: Wed 12:15–12:59 DELL ROOM E302PC, Wed 13:00–13:45 DELL ROOM E302PC, A. Nováková
B_AS_2/15APH: Wed 10:30–11:14 DELL ROOM E302PC, Wed 11:15–12:00 DELL ROOM E302PC, A. Nováková
B_AS_2/16APH: Wed 12:15–12:59 E303PC, Wed 13:00–13:45 E303PC, V. Nulíček
B_AS_2/17APH: Wed 8:45–9:29 DELL ROOM E302PC, Wed 9:30–10:15 DELL ROOM E302PC, A. Nováková
B_AS_2/18APH: each even Wednesday 14:00–15:30 E303PC, each even Wednesday 15:45–17:15 E303PC, A. Nováková
B_AS_2/19APH: Mon 14:00–14:44 DELL ROOM E302PC, Mon 14:45–15:30 DELL ROOM E302PC, V. Nulíček
B_AS_2/2AMMO: Mon 14:00–14:44 M11PC, Mon 14:45–15:30 M11PC, J. Mšal
B_AS_2/2APH: Thu 10:30–11:14 E303PC, Thu 11:15–12:00 E303PC, P. Berka
B_AS_2/2NPH: Mon 10:30–11:14 DELL ROOM E302PC, Mon 11:15–12:00 DELL ROOM E302PC, A. Nováková
B_AS_2/20APH: Mon 12:15–12:59 DELL ROOM E302PC, Mon 13:00–13:45 DELL ROOM E302PC, A. Nováková
B_AS_2/3APH: Thu 15:45–16:29 E303PC, Thu 16:30–17:15 E303PC, J. Lokoč
B_AS_2/3ARMO: each even Monday 15:45–16:29 M11PC, each even Monday 16:30–17:15 M11PC, each even Monday 17:30–18:14 M11PC, each even Monday 18:15–19:00 M11PC, J. Mšal
B_AS_2/4APH: Thu 12:15–12:59 DELL ROOM E302PC, Thu 13:00–13:45 DELL ROOM E302PC, J. Lokoč
B_AS_2/4ARMO: each odd Tuesday 12:15–12:59 M11PC, each odd Tuesday 13:00–13:45 M11PC, each odd Thursday 8:45–9:29 M11PC, each odd Thursday 9:30–10:15 M11PC, H. Hoffmannová
B_AS_2/5APH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, V. Nulíček
B_AS_2/5AVMO: Wed 15:45–16:29 M11PC, Wed 16:30–17:15 M11PC, H. Hoffmannová
B_AS_2/6APH: Wed 8:45–9:29 E303PC, Wed 9:30–10:15 E303PC, V. Nulíček
B_AS_2/6AVMO: Wed 15:45–16:29 M12KL, Wed 16:30–17:15 M12KL, J. Mšal
B_AS_2/7APH: Mon 16:30–17:15 DELL ROOM E302PC, Mon 17:30–18:14 DELL ROOM E302PC, J. Smolík
B_AS_2/8APH: Thu 14:00–14:44 E303PC, Thu 14:45–15:30 E303PC, V. Nulíček
B_AS_2/8NRVMO: Thu 12:15–12:59 M11PC, Thu 13:00–13:45 M11PC, H. Hoffmannová
B_AS_2/9AMMO: Wed 14:00–14:44 M11PC, Wed 14:45–15:30 M11PC, H. Hoffmannová
B_AS_2/9APH: Tue 8:45–9:29 E303PC, Tue 9:30–10:15 E303PC, A. Nováková

Prerequisites (in Czech)

Navazuje na předmět Aplikační software 1 - student by měl mít zvládnuty techniky práce s aplikacemi MS Word a MS Excel na úrovni tohoto předmětu.

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

there are 10 fields of study the course is directly associated with, display

Course objectives (in Czech)

Tento předmět přímo navazuje na předmět „Aplikační software 1“. Studenti by měli mít zvládnuty postupy práce s aplikacemi MS Word 2007 a MS Excel 2007 probírané v tomto předmětu. Cílem předmětu je rozšířit znalosti studentů v základním aplikačním softwaru se zaměřením na software zařazený do balíku MS Office 2007. Jedná se zejména o pokročilejší techniky práce v aplikacích MS Excel 2007 a MS Word 2007, event. o některé další aplikace.

Syllabus (in Czech)

Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu /ML/ 1. Opakovací cvičení – samostatná práce studentů, zopakování látky z aplikací Word a Excel z AS1. 2. MS Word – práce se šablonami, stažení šablony z webu Office, vytvoření vlastní šablony (např. hlavičkový papír firmy) 3. MS Word – vytvoření formuláře, příprava formuláře k vyplnění, ochrana dokumentu. 4. MS Word – revize dokumentu, sdílení dokumentů s jinými uživateli, vkládání komentářů, porovnání dokumentů. 5. MS Word – editace rozsáhlých dokumentů, vytváření rejstříků a seznamů, rozdělení dokumentu na oddíly (různý vzhled stránky, různá záhlaví a zápatí), křížové odkazy. 6. MS Word – hromadná korespondence, export dat z jiných aplikací (Excel, Outlook, event. Access) 7. MS Excel – složitější výpočty v tabulkách s použitím různých typů adres (event. názvů), aplikace složitějších funkcí (finanční, textové aj.), vnořování funkcí. 8. MS Excel – práce s listy (vložení, přejmenování, odstranění, kopírování, práce s více listy současně), výpočty s odkazy na jiné listy event. sešity. Úpravy a tisk rozsáhlejších tabulek, záhlaví a zápatí, opakování hlavičky tabulky, oblast tisku, úprava velikosti pro tisk. 9. MS Excel – podmíněné formátování, použití dalších funkcí (logické, vyhledávací). Složitější úpravy grafů (vedlejší osa, přidání dat, změna orientace dat, speciální funkce) 10. MS Excel – analytické nástroje (hledání řešení, správce scénářů, datová tabulka) 11. MS Excel – databáze - řazení, filtrování, souhrny, kontingenční tabulky a grafy 12. Zápočtové cvičení – zpracování praktického příkladu z aplikací MS Word a MS Excel.

Literature

Nováková A., Nulíček V.: Aplikační software 1, 2. Eupress 2008 (skripta)
Pecinovský J.: Word 2007 – podrobný průvodce. Grada 2007.
Bříza V.: Excel 2007 – podrobný průvodce. Grada 2007.

Assessment methods (in Czech)

Vyučující metody: řízený seminář Metody hodnocení: zápočet Ukončení předmětu: Podmínky pro udělení zápočtu: 80% účast na cvičeních (event. možno nahradit samostatnou prací podle pokynů cvičícího) zpracování úloh, které se budou společně tvořit na cvičeních, event. zadaných domácích prací. zpracování zápočtové práce s výsledkem min. 80%

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6hodin/semestr.

The course is also listed under the following terms Summer 2008, Winter 2008, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Winter 2008

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Markéta Aubrechtová (seminar tutor)
Ing. Hana Hoffmannová (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Bc. Josef Mšal (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Mgr. Lucie Pelikánová (seminar tutor)
Ing. Jana Spilková (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Lenka Bažantová

Prerequisites (in Czech)

Navazuje na předmět Aplikační software 1 - student by měl mít zvládnuty techniky práce s aplikacemi MS Word a MS Excel na úrovni tohoto předmětu.

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

there are 10 fields of study the course is directly associated with, display

Course objectives (in Czech)

Syllabus (in Czech)

Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu /ML/ 1. Opakovací cvičení – samostatná práce studentů, zopakování látky z aplikací Word a Excel z AS1. 2. MS Word – práce se šablonami, stažení šablony z webu Office, vytvoření vlastní šablony (např. hlavičkový papír firmy) 3. MS Word – vytvoření formuláře, příprava formuláře k vyplnění, ochrana dokumentu. 4. MS Word – revize dokumentu, sdílení dokumentů s jinými uživateli, vkládání komentářů, porovnání dokumentů. 5. MS Word – editace rozsáhlých dokumentů, vytváření rejstříků a seznamů, rozdělení dokumentu na oddíly (různý vzhled stránky, různá záhlaví a zápatí), křížové odkazy. 6. MS Word – hromadná korespondence, export dat z jiných aplikací (Excel, Outlook, event. Access) 7. MS Excel – složitější výpočty v tabulkách s použitím různých typů adres (event. názvů), aplikace složitějších funkcí (finanční, textové aj.), vnořování funkcí. 8. MS Excel – práce s listy (vložení, přejmenování, odstranění, kopírování, práce s více listy současně), výpočty s odkazy na jiné listy event. sešity. Úpravy a tisk rozsáhlejších tabulek, záhlaví a zápatí, opakování hlavičky tabulky, oblast tisku, úprava velikosti pro tisk. 9. MS Excel – podmíněné formátování, použití dalších funkcí (logické, vyhledávací). Složitější úpravy grafů (vedlejší osa, přidání dat, změna orientace dat, speciální funkce) 10. MS Excel – analytické nástroje (hledání řešení, správce scénářů, datová tabulka) 11. MS Excel – databáze - řazení, filtrování, souhrny, kontingenční tabulky a grafy 12. Zápočtové cvičení – zpracování praktického příkladu z aplikací MS Word a MS Excel.

Literature

Nováková A., Nulíček V.: Aplikační software 1, 2. Eupress 2008 (skripta)
Pecinovský J.: Word 2007 – podrobný průvodce. Grada 2007.
Bříza V.: Excel 2007 – podrobný průvodce. Grada 2007.

Assessment methods (in Czech)

Language of instruction

Czech

Further comments (probably available only in Czech)

Information on the extent and intensity of the course: 6hodin/semestr.

The course is also listed under the following terms Summer 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

B_AS_2 Application Software 2

University of Finance and Administration
Summer 2008

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Lenka Bažantová

Timetable of Seminar Groups

B_AS_2/cMKL: each even Wednesday 8:45–9:29 K213PC, each even Wednesday 9:30–10:15 K213PC, each even Wednesday 10:30–11:14 K213PC, each even Wednesday 11:15–12:00 K213PC, M. Kučera
B_AS_2/cRKL: each even Thursday 8:45–9:29 K213PC, each even Thursday 9:30–10:15 K213PC, each even Thursday 10:30–11:14 K213PC, each even Thursday 11:15–12:00 K213PC, M. Kučera
B_AS_2/cVKL: Thu 12:15–12:59 K213PC, Thu 13:00–13:45 K213PC, M. Kučera
B_AS_2/sM11PH: Wed 19. 3. 17:30–19:00 E303PC, Wed 2. 4. 17:30–19:00 E303PC, Wed 23. 4. 17:30–19:00 E303PC, J. Lokoč
B_AS_2/sM12PH: Wed 19. 3. 19:15–20:45 E303PC, Wed 2. 4. 19:15–20:45 E303PC, Wed 23. 4. 19:15–20:45 E303PC, J. Lokoč
B_AS_2/sM13PH: Wed 19. 3. 17:30–19:00 DELL ROOM E302PC, Wed 2. 4. 19:15–20:45 DELL ROOM E302PC, Wed 23. 4. 17:30–19:00 DELL ROOM E302PC, J. Spilková
B_AS_2/sM14PH: Wed 19. 3. 19:15–20:45 DELL ROOM E302PC, Wed 2. 4. 17:30–19:00 DELL ROOM E302PC, Wed 23. 4. 19:15–20:45 DELL ROOM E302PC, J. Spilková
B_AS_2/sRV11PH: Wed 5. 3. 15:45–17:15 E303PC, Wed 26. 3. 17:30–19:00 E303PC, Wed 9. 4. 17:30–19:00 E303PC, J. Spilková
B_AS_2/sRV12PH: Wed 5. 3. 17:30–19:00 DELL ROOM E302PC, Wed 26. 3. 15:45–17:15 DELL ROOM E302PC, Wed 9. 4. 17:30–19:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/sRV13PH: Wed 5. 3. 17:30–19:00 E303PC, Wed 26. 3. 19:15–20:45 E303PC, Wed 9. 4. 15:45–17:15 E303PC, J. Spilková
B_AS_2/sRV14PH: Wed 5. 3. 14:00–15:30 DELL ROOM E302PC, Wed 26. 3. 14:00–15:30 DELL ROOM E302PC, Wed 9. 4. 14:00–15:30 DELL ROOM E302PC, A. Nováková
B_AS_2/sRV15PH: Wed 5. 3. 19:15–20:45 E303PC, Wed 26. 3. 15:45–17:15 E303PC, Wed 9. 4. 19:15–20:45 E303PC, J. Spilková
B_AS_2/uMKL: Tue 12. 2. 19:15–20:45 K213PC, Tue 4. 3. 17:30–19:00 K213PC, Tue 11. 3. 15:45–17:15 K213PC, M. Kučera
B_AS_2/uRKL: Tue 12. 2. 15:45–17:15 K213PC, Tue 19. 2. 17:30–19:00 K213PC, Tue 26. 2. 15:45–17:15 K213PC, M. Kučera
B_AS_2/uVKL: Tue 25. 3. 15:45–17:15 K213PC, Tue 22. 4. 14:00–15:30 K213PC, 15:45–17:15 K213PC, M. Kučera
B_AS_2/vFPV23PH: Fri 7. 3. 13:45–15:15 Z22PC, Fri 11. 4. 15:30–17:00 Z22PC, Fri 9. 5. 12:00–13:30 Z22PC, V. Nulíček
B_AS_2/vFP21PH: Fri 7. 3. 12:00–13:30 Z12PC, Fri 11. 4. 12:00–13:30 Z12PC, Fri 9. 5. 12:00–13:30 Z12PC, A. Nováková
B_AS_2/vFP22PH: Fri 7. 3. 13:45–15:15 Z12PC, Fri 11. 4. 13:45–15:15 Z12PC, Fri 9. 5. 13:45–15:15 Z12PC, A. Nováková
B_AS_2/vFP24PH: Fri 7. 3. 12:00–13:30 Z22PC, Fri 11. 4. 13:45–15:15 Z22PC, Fri 9. 5. 15:30–17:00 Z22PC, V. Nulíček
B_AS_2/vM21MO: Fri 7. 3. 19:00–20:30 M11PC, Fri 28. 3. 19:00–20:30 M11PC, Fri 11. 4. 19:00–20:30 M11PC, M. Aubrechtová
B_AS_2/vM21PH: Sat 8. 3. 14:00–15:30 E303PC, Sat 12. 4. 11:30–13:00 E303PC, Sat 10. 5. 14:00–15:30 E303PC, J. Spilková
B_AS_2/vM22MO: Fri 25. 4. 19:00–20:30 M11PC, Sat 26. 4. 14:00–15:30 M11PC, 15:45–17:15 M11PC, M. Aubrechtová
B_AS_2/vM22PH: Sat 8. 3. 15:45–17:15 E303PC, Sat 12. 4. 9:45–11:15 E303PC, Sat 10. 5. 15:45–17:15 E303PC, J. Spilková
B_AS_2/vM23PH: Sat 8. 3. 11:30–13:00 E303PC, Sat 12. 4. 14:00–15:30 E303PC, Sat 10. 5. 11:30–13:00 E303PC, J. Spilková
B_AS_2/vM24PH: Sat 8. 3. 9:45–11:15 E303PC, Sat 12. 4. 15:45–17:15 E303PC, Sat 10. 5. 9:45–11:15 E303PC, V. Nulíček
B_AS_2/vR21MO: Fri 28. 3. 17:15–18:45 M12KL, 19:00–20:30 M12KL, Fri 11. 4. 17:15–18:45 M11PC, H. Hoffmannová
B_AS_2/vR21PH: Fri 22. 2. 12:00–13:30 Z12PC, Fri 28. 3. 13:45–15:15 Z12PC, Fri 25. 4. 15:30–17:00 Z12PC, L. Pelikánová
B_AS_2/vR22MO: Fri 22. 2. 17:15–18:45 M11PC, 19:00–20:30 M11PC, Sat 29. 3. 15:45–17:15 M11PC, J. Mšal
B_AS_2/vR22PH: Fri 22. 2. 13:45–15:15 Z22PC, Fri 28. 3. 13:45–15:15 Z22PC, Fri 25. 4. 13:45–15:15 Z22PC, V. Nulíček
B_AS_2/vR23PH: Fri 22. 2. 13:45–15:15 Z12PC, Fri 28. 3. 15:30–17:00 Z12PC, Fri 25. 4. 12:00–13:30 Z12PC, L. Pelikánová
B_AS_2/vR24PH: Fri 22. 2. 15:30–17:00 Z12PC, Fri 28. 3. 12:00–13:30 Z12PC, Fri 25. 4. 13:45–15:15 Z12PC, L. Pelikánová
B_AS_2/vV21MO: Sat 8. 3. 14:00–15:30 M11PC, Sat 29. 3. 11:30–13:00 M12KL, 14:00–15:30 M12KL, M. Aubrechtová
B_AS_2/vV21PH: Fri 7. 3. 15:30–17:00 Z22PC, Fri 11. 4. 12:00–13:30 Z22PC, Fri 9. 5. 13:45–15:15 Z22PC, V. Nulíček
B_AS_2/vV22MO: Sat 23. 2. 15:45–17:15 M11PC, Fri 11. 4. 17:15–18:45 M12KL, Fri 25. 4. 17:15–18:45 M11PC, J. Mšal
B_AS_2/vV22PH: Fri 11. 4. 15:30–17:00 Z12PC, 17:15–18:45 Z12PC, Fri 9. 5. 15:30–17:00 Z12PC, L. Pelikánová
B_AS_2/vV23MO: Sat 12. 4. 11:30–13:00 M11PC, 14:00–15:30 M11PC, Sat 26. 4. 11:30–13:00 M11PC, M. Aubrechtová
B_AS_2/1AMO: Mon 14:00–14:44 M12KL, Mon 14:45–15:30 M12KL, J. Mšal
B_AS_2/1NPH: Thu 10:30–11:14 DELL ROOM E302PC, Thu 11:15–12:00 DELL ROOM E302PC, A. Nováková
B_AS_2/11APH: Tue 17:30–18:14 E303PC, Tue 18:15–19:00 E303PC, J. Spilková
B_AS_2/12APH: Mon 12:15–12:59 E303PC, Mon 13:00–13:45 E303PC, V. Nulíček
B_AS_2/13APH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, V. Nulíček
B_AS_2/14APH: Wed 12:15–12:59 DELL ROOM E302PC, Wed 13:00–13:45 DELL ROOM E302PC, A. Nováková
B_AS_2/15APH: Thu 14:00–14:44 E303PC, Thu 14:45–15:30 E303PC, V. Nulíček
B_AS_2/16APH: Thu 15:45–16:29 DELL ROOM E302PC, Thu 16:30–17:15 DELL ROOM E302PC, A. Nováková
B_AS_2/17APH: Mon 10:30–11:14 DELL ROOM E302PC, Mon 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_AS_2/18APH: Wed 10:30–11:14 DELL ROOM E302PC, Wed 11:15–12:00 DELL ROOM E302PC, A. Nováková
B_AS_2/19APH: Thu 12:15–12:59 DELL ROOM E302PC, Thu 13:00–13:45 DELL ROOM E302PC, A. Nováková
B_AS_2/2AMO: Wed 14:00–14:44 M11PC, Wed 14:45–15:30 M11PC, J. Mšal
B_AS_2/2APH: Tue 15:45–16:29 E303PC, Tue 16:30–17:15 E303PC, J. Spilková
B_AS_2/2NPH: Thu 8:45–9:29 DELL ROOM E302PC, Thu 9:30–10:15 DELL ROOM E302PC, A. Nováková
B_AS_2/20APH: Mon 14:00–14:44 E303PC, Mon 14:45–15:30 E303PC, V. Nulíček
B_AS_2/3AMO: Tue 16:30–17:15 M11PC, Tue 17:30–18:14 M11PC, J. Mšal
B_AS_2/4APH: Wed 12:15–12:59 E303PC, Wed 13:00–13:45 E303PC, V. Nulíček
B_AS_2/4NMO: each odd Wednesday 15:45–16:30 M11PC, each odd Wednesday 16:30–17:15 M11PC and each even Thursday 14:00–14:45 M11PC, each even Thursday 14:45–15:30 M11PC, H. Hoffmannová
B_AS_2/5AMO: Wed 14:00–14:44 M12KL, Wed 14:45–15:30 M12KL, H. Hoffmannová
B_AS_2/5APH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, A. Nováková
B_AS_2/6AMO: Thu 8:45–9:30 M11PC, Thu 9:30–10:15 M11PC, H. Hoffmannová
B_AS_2/6APH: Wed 8:45–9:29 E303PC, Wed 9:30–10:15 E303PC, J. Lokoč
B_AS_2/7APH: Wed 8:45–9:29 DELL ROOM E302PC, Wed 9:30–10:15 DELL ROOM E302PC, A. Nováková
B_AS_2/8APH: Thu 8:45–9:29 E303PC, Thu 9:30–10:15 E303PC, V. Nulíček

Prerequisites (in Czech)

Navazuje na předmět Aplikační software 1 - student by měl mít zvládnuty techniky práce s aplikacemi MS Word a MS Excel na úrovni tohoto předmětu.

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

there are 10 fields of study the course is directly associated with, display

Course objectives (in Czech)

Anotace je stejná pro obě formy studiaTento předmět je určen pro všechny studenty 1.ročníku bakalářského studia mimo obor „Aplikovaná informatika“. Navazuje na látku probranou v předmětu „Aplikační software 1“ Cílem předmětu je prohloubit znalosti a dovednosti studentů v používání základního aplikačního softwaru, který je součástí softwarového balíku MS Office 2003. Jedná se především o pokročilejší techniky v aplikacích MS Excel a MS Word a o tvorbu prezentací v aplikaci MS Powerpoint.

Syllabus (in Czech)

Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu /ML/ 1. Opakovací cvičení (zopakování nejdůležitějších témat z předmětu ZI) 2. MS Word – tvorba formulářů, ochrana dokumentu. 3. MS Word – revize dokumentu, sdílení dokumentů s jinými uživateli 4. MS Word – editace rozsáhlých dokumentů, vytváření rejstříků a seznamů, oddíly 5. MS Word – hromadná korespondence, export dat z jiných aplikací (Excel, Outlook, event. Access) 6. MS Excel – použití složitějších funkcí (finanční, vyhledávací, databázové, textové) 7. MS Excel – analytické nástroje (hledání řešení, správce scénářů, datová tabulka) 8. MS Excel – databáze, řazení, filtrování, 9. MS Excel – databázové souhrny, kontingenční tabulky a grafy. 10. MS Powerpoint – základní seznámení s aplikací, jednoduchý příklad na vytvoření různých typů snímků (texty, obrázky, tabulky, grafy, org. diagramy apod.), práce s předlohou snímku. 11. MS Powerpoint – pokročilejší techniky, přechody snímků, animace, nastavení prezentace k promítání apod. 12. Zápočtové cvičení

Assessment methods (in Czech)

Vyučující metody Metody hodnocení Ukončení předmětu Formou zápočtu (bez klasifikace) s těmito podmínkami: 80% účast na cvičeních (event. možno nahradit samostatnou prací podle pokynů cvičícího) zpracování úloh, které se budou společně tvořit na cvičeních, event. zadaných domácích prací. zpracování zápočtové práce s výsledkem min. 80%

Language of instruction

Czech

Further comments (probably available only in Czech)

Information on the extent and intensity of the course: 6hodin/semestr.

The course is also listed under the following terms Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.

Enrolment Statistics (recent)

Course Information

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

B_AS_2 Application Software 2

Other applications