VSFS:B_AS_2 Application Software 2 - Course Information

B_AS_2 Application Software 2

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

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

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.

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

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)

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.

• Enrolment Statistics (Summer 2013, recent)
  
• Permalink: https://is.vsfs.cz/course/vsfs/summer2013/B_AS_2