B_AS Application Software

University of Finance and Administration
Winter 2018
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Luboš Dobda, Ph.D. (seminar tutor)
doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
PaedDr. Renata Majovská, PhD. (seminar tutor)
doc. Ing. Stanislava Mildeová, CSc. (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Ing. Václav Řezníček, Ph.D. (seminar tutor)
Ing. Jiří Zumr (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/vM1PH: Fri 12. 10. 19:15–20:45 E303PC, Fri 23. 11. 14:00–15:30 E303PC, V. Řezníček
B_AS/vM2PH: Sat 27. 10. 9:45–11:15 E303PC, Sat 8. 12. 14:00–15:30 E303PC, V. Řezníček
B_AS/vRMO: Fri 16. 11. 15:45–17:15 M11PC, Fri 30. 11. 17:30–19:00 M11PC, L. Dobda
B_AS/vRPH: Fri 12. 10. 17:30–19:00 E303PC, Sat 10. 11. 14:00–15:30 E303PC, V. Řezníček
B_AS/1BPH: each even Thursday 8:45–9:29 S16PC, each even Thursday 9:30–10:15 S16PC, each even Thursday 10:30–11:14 S16PC, each even Thursday 11:15–12:00 S16PC, except Thu 29. 11. ; and Thu 6. 12. 8:45–10:15 S16PC, 10:30–12:00 S16PC, J. Lánský
B_AS/1MMO: each odd Wednesday 14:00–14:44 M11PC, each odd Wednesday 14:45–15:30 M11PC, each odd Wednesday 15:45–16:29 M11PC, each odd Wednesday 16:30–17:15 M11PC, V. Nulíček
B_AS/1MPH: each even Thursday 17:30–18:14 DELL ROOM E302PC, each even Thursday 18:15–19:00 DELL ROOM E302PC, each even Thursday 19:15–19:59 DELL ROOM E302PC, each even Thursday 20:00–20:45 DELL ROOM E302PC, except Thu 18. 10. ; and Tue 30. 10. 17:30–19:00 E303PC, 19:15–20:45 E303PC, L. Dobda
B_AS/1RKV: Thu 14:00–14:44 KV305PC, Thu 14:45–15:30 KV305PC, except Thu 18. 10., except Thu 15. 11. ; and Thu 18. 10. 14:00–14:44 KV305PC, Thu 25. 10. 15:45–16:30 KV305PC, Thu 8. 11. 15:45–17:15 KV305PC, R. Majovská
B_AS/1RPH: each odd Thursday 8:45–9:29 S16PC, each odd Thursday 9:30–10:15 S16PC, each odd Thursday 10:30–11:14 S16PC, each odd Thursday 11:15–12:00 S16PC, J. Lánský
B_AS/2MPH: each odd Thursday 17:30–18:14 DELL ROOM E302PC, each odd Thursday 18:15–19:00 DELL ROOM E302PC, each odd Thursday 19:15–19:59 DELL ROOM E302PC, each odd Thursday 20:00–20:45 DELL ROOM E302PC, L. Dobda
B_AS/2RPH: Mon 17:30–18:14 E303PC, Mon 18:15–19:00 E303PC, except Mon 15. 10. ; and Mon 8. 10. 19:15–20:45 E303PC, L. Dobda
B_AS/3MPH: Mon 15:45–16:29 E303PC, Mon 16:30–17:15 E303PC, S. Mildeová
B_AS/3RPH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, J. Zumr
B_AS/4MPH: each odd Tuesday 17:30–18:14 E303PC, each odd Tuesday 18:15–19:00 E303PC, each odd Tuesday 19:15–19:59 E303PC, each odd Tuesday 20:00–20:45 E303PC, L. Dobda
B_AS/4RPH: Thu 15:45–16:29 E303PC, Thu 16:30–17:15 E303PC, V. Řezníček
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 the improvement of practical knowledge of 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.
Learning outcomes
After completing the course, a student will be able to:
- orientate in the information system;
- use basic functions, formulas and graphs in MS Excel;
- analyze and interpret data, use pivot table;
- copy objects between MS Office applications;
- create presentations in MS PowerPoint;
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
  • 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
  • HOFFMANNOVÁ, Hana and Jan LÁNSKÝ. Sbírka řešených příkladů pro Aplikační software 2. Praha: Vysoká škola finanční a správní, o.p.s., 2013, 84 pp. Eupress. ISBN 978-80-7408-073-9. info
  • NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software I (MS Office 2010). 1. vydání. Praha: Vysoká škola finanční a správní, o.p.s., 2011. EUPRESS. ISBN 978-80-7408-052-4. info
  • 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
    recommended literature
  • BARILLA, Jiří, Pavel SIMR a Květuše SÝKOROVÁ. Microsoft Excel 2016: podrobná uživatelská příručka. Brno: Computer Press, 2016. Podrobná uživatelská příručka. ISBN 978-80-251-4838-9.
  • COX, Joyce a Joan LAMBERT. Microsoft PowerPoint 2010: step by step. Redmond, WA: Microsoft Press, 2010. ISBN 978-0-7356-2691-1.
  • KOPECKÝ, Ladislav. Prezentace v marketingové komunikaci. Praha: Grada, 2010. ISBN 978-80-247-3123-0.
  • COX, Joyce, Joan LAMBERT a Curtis FRYE. Microsoft Office Home and Student 2010: step by step. Redmond, WA: Microsoft Press, 2010. ISBN 978-0-7356-2721-5.
  • ZAPAWA, Timothy. Microsoft Excel: získávání, analýza a prezentace dat. Brno: Computer Press, 2007. ISBN 978-80-251-1535-0.
  • MYŠÁK, Milan. Kontingenční tabulky a grafy: výukový průvodce. Brno: Computer Press, 2013. ISBN 978-80-251-4113-7.
  • KLATOVSKÝ, Karel. Microsoft® PowerPoint® 2016 nejen pro školy. Prostějov: Computer Media, 2016. ISBN 978-80-7402-251-7.
  • PECINOVSKÝ, Josef a Rudolf PECINOVSKÝ. Office 2016: průvodce uživatele. Praha: Grada, 2016. Průvodce (Grada). ISBN 978-80-247-5691-2.
  • PECINOVSKÝ, Josef. Microsoft Office 2013: podrobná uživatelská příručka. Brno: Computer Press, 2013. ISBN 978-80-251-4102-1.
  • PECINOVSKÝ, Josef. 333 tipů a triků pro Microsoft Excel 2013: [sbírka nejužitečnějších postupů a řešení]. Brno: Computer Press, 2014. ISBN 978-80-251-4130-4.
  • LAMBERT, Joan a Curtis FRYE. Microsoft Office 2016 step by step. Step by step (Redmond, Wash.). ISBN 0735699232.
  • LAMBERT, Joan. Microsoft PowerPoint 2016 step by step. Step by step (Redmond, Wash.). ISBN 9780735697799.
  • NAVARRŮ, Miroslav. Excel 2016: podrobný průvodce uživatele. Praha: Grada, 2016. Průvodce (Grada). ISBN 978-80-271-0193-1.
Teaching methods
Fulltime study is taught by controlled seminars. Students work under the guidance of a teacher. Combined study is held by distance using prepared DSO. Minimal required attendance for fulltime students is 75%. Required attendance for non fulltime students is 50%. Students with ISP have the same duties, however they need not to keep the required attendance.
Assessment methods
Course completion: Credit Fulltime study: Students will solve 11 tasks in 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, Summer 2016, Winter 2016, Summer 2017, Winter 2017, Summer 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 (Winter 2018, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/winter2018/B_AS