B_AS Application Software

University of Finance and Administration
Summer 2016
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Hana Hoffmannová (seminar tutor)
doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
RNDr. Michal Žemlička, Ph.D. (seminar tutor)
Guaranteed by
Ing. Hana Hoffmannová
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ing. Barbora Ptáčková
Timetable of Seminar Groups
B_AS/vBSPH: Fri 19. 2. 15:30–17:00 DELL ROOM E302PC, Fri 18. 3. 15:30–17:00 DELL ROOM E302PC, V. Nulíček
B_AS/vKMO: Sat 13. 2. 8:00–9:30 M11PC, Fri 11. 3. 15:30–17:00 M11PC, H. Hoffmannová
B_AS/vKPH: Fri 19. 2. 15:30–17:00 E303PC, Fri 18. 3. 15:30–17:00 E303PC, H. Hoffmannová
B_AS/vMMO: Fri 12. 2. 12:00–13:30 M11PC, Fri 11. 3. 13:45–15:15 M11PC, H. Hoffmannová
B_AS/vM11PH: Fri 19. 2. 12:00–13:30 E303PC, Fri 18. 3. 12:00–13:30 E303PC, H. Hoffmannová
B_AS/vM12PH: Fri 19. 2. 17:15–18:45 E303PC, Fri 18. 3. 17:15–18:45 E303PC, H. Hoffmannová
B_AS/vPPPH: Fri 19. 2. 13:45–15:15 DELL ROOM E302PC, Fri 18. 3. 13:45–15:15 DELL ROOM E302PC, A. Nováková
B_AS/vVPH: Fri 19. 2. 13:45–15:15 E303PC, Fri 18. 3. 13:45–15:15 E303PC, H. Hoffmannová
B_AS/1KMO: Thu 14:00–14:44 M11PC, Thu 14:45–15:30 M11PC, H. Hoffmannová
B_AS/1KPH: Thu 12:15–12:59 DELL ROOM E302PC, Thu 13:00–13:45 DELL ROOM E302PC, J. Lánský
B_AS/1MMO: Thu 12:15–12:59 M11PC, Thu 13:00–13:45 M11PC, H. Hoffmannová
B_AS/1MPH: Wed 10:30–11:14 E303PC, Wed 11:15–12:00 E303PC, J. Lánský
B_AS/1PPPH: Wed 10:30–11:14 DELL ROOM E302PC, Wed 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_AS/1PVPH: Thu 8:45–9:29 DELL ROOM E302PC, Thu 9:30–10:15 DELL ROOM E302PC, J. Lánský
B_AS/1VMO: Mon 10:30–11:14 M11PC, Mon 11:15–12:00 M11PC, H. Hoffmannová
B_AS/2KPH: Mon 12:15–12:59 E303PC, Mon 13:00–13:45 E303PC, except Mon 8. 2. ; and Mon 15. 2. 14:00–15:30 E303PC, V. Nulíček
B_AS/2MPH: Wed 12:15–12:59 DELL ROOM E302PC, Wed 13:00–13:45 DELL ROOM E302PC, V. Nulíček
B_AS/2PPPH: Wed 14:00–14:44 DELL ROOM E302PC, Wed 14:45–15:30 DELL ROOM E302PC, V. Nulíček
B_AS/3MPH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, V. Nulíček
B_AS/4MPH: each odd Tuesday 12:15–12:59 DELL ROOM E302PC, each odd Tuesday 13:00–13:45 DELL ROOM E302PC, each odd Tuesday 14:00–14:44 DELL ROOM E302PC, each odd Tuesday 14:45–15:30 DELL ROOM E302PC, H. Hoffmannová
Prerequisites
There are no prerequisites for this course.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
Goal of this subject is improvement of practical knowledge MS Office 2010 (MS Excel, MS PowerPoint). Students will be able to handle basic work in MS Excel, advanced techniques in MS PowerPoint after finishing this course.
Syllabus
  • 1. Familiarization with IS VSFS, distance learning guide.
  • 2. Data format, simple formulas.
  • 3. Functions in Excel 1 (mathematical, statistical).
  • 4. Functions in Excel 2 (financial, search).
  • 5. Graphs.
  • 6. Data interpretation.
  • 7. Exercise with databases.
  • 8. Pivot tables.
  • 9. Large tables print.
  • 10. Object copying between MS Office apps.
  • 11. Objects in MS PowerPoint.
  • 12. Animation in MS PowerPoint.
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
Fulltime study is taught by controlled seminars. Students work under the guidance of a teacher. Combined study takes place by distance from using prepared DSO. Minimal required attendance for fulltime students is 75%. Required attendance for non fulltime students is 50%.
Assessment methods
Course completion: Credit Fulltime study: Students will solve 11 tasks on lessons and will submit them into IS VSFŠ to be checked. Credit will be given for correctly solved tasks from lessons. Combined study: Students will solve 4 POTs and submit them into IS VŠFS to be checked. Credit will be given for correctly solved all POTs.
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 Winter 2013, Winter 2014, Summer 2015, Winter 2015, Winter 2016, Summer 2017, Winter 2017, Summer 2018, Winter 2018, Summer 2019, Winter 2019, Summer 2020, Winter 2020, Summer 2021, Winter 2021, Summer 2022, Winter 2022, Summer 2023, Winter 2023, Summer 2024.
  • Enrolment Statistics (Summer 2016, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2016/B_AS