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.
  • Enrolment Statistics (summer 2012, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2012/B_AS_2