VSFS:B_AS Application Software - Course Information
B_AS Application Software
University of Finance and AdministrationSummer 2018
- Extent and Intensity
- 0/2/0. 3 credit(s). Type of Completion: z (credit).
- Teacher(s)
- 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. 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/vBSKPH: Fri 16. 2. 17:30–19:00 E303PC, Fri 16. 3. 14:00–15:30 E303PC, R. Majovská
B_AS/vKMO: Sat 10. 2. 11:30–13:00 M11PC, Sat 10. 3. 11:30–13:00 M11PC, V. Nulíček
B_AS/vKVKV: Sat 17. 2. 14:00–15:30 KV305PC, Sat 17. 3. 14:00–15:30 KV305PC, R. Majovská
B_AS/vPPPH: Fri 16. 2. 19:15–20:45 E307, Fri 6. 4. 17:30–19:00 E307, J. Zumr
B_AS/vVPH: Fri 16. 2. 17:30–19:00 E307, Fri 6. 4. 15:45–17:15 E307, J. Zumr
B_AS/1BSKV: each odd Wednesday 14:00–14:44 KV305PC, each odd Wednesday 14:45–15:30 KV305PC, each odd Wednesday 15:45–16:29 KV305PC, each odd Wednesday 16:30–17:15 KV305PC, R. Majovská
B_AS/1BSPH: Wed 8:45–9:29 E307, Wed 9:30–10:15 E307, J. Zumr
B_AS/1KKV: each odd Wednesday 10:30–11:14 KV305PC, each odd Wednesday 11:15–12:00 KV305PC, each odd Wednesday 12:15–12:59 KV305PC, each odd Wednesday 13:00–13:45 KV305PC, R. Majovská
B_AS/1KMO: Wed 10:30–11:14 M11PC, Wed 11:15–12:00 M11PC, V. Nulíček
B_AS/1KPH: Wed 15:45–16:29 E307, Wed 16:30–17:15 E307, S. Mildeová
B_AS/1PPPVPH: Thu 10:30–11:14 E307, Thu 11:15–12:00 E307, J. Lánský
B_AS/1VMO: Wed 12:15–12:59 M11PC, Wed 13:00–13:45 M11PC, V. Nulíček
B_AS/2KPH: Wed 14:00–14:44 E307, Wed 14:45–15:30 E307, J. Zumr
B_AS/3KPH: Wed 10:30–11:14 E307, Wed 11:15–12:00 E307, J. Zumr - 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
- 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
- LAMBERT, Joan a Curtis FRYE. Microsoft Office 2016 step by step. Step by step (Redmond, Wash.). ISBN 0735699232.
- ZAPAWA, Timothy. Microsoft Excel: získávání, analýza a prezentace dat. Brno: Computer Press, 2007. ISBN 978-80-251-1535-0.
- PECINOVSKÝ, Josef. Microsoft Office 2013: podrobná uživatelská příručka. Brno: Computer Press, 2013. ISBN 978-80-251-4102-1.
- PECINOVSKÝ, Josef a Rudolf PECINOVSKÝ. Office 2016: průvodce uživatele. Praha: Grada, 2016. Průvodce (Grada). ISBN 978-80-247-5691-2.
- 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.
- 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.
- MYŠÁK, Milan. Kontingenční tabulky a grafy: výukový průvodce. Brno: Computer Press, 2013. ISBN 978-80-251-4113-7.
- NAVARRŮ, Miroslav. Excel 2016: podrobný průvodce uživatele. Praha: Grada, 2016. Průvodce (Grada). ISBN 978-80-271-0193-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. Microsoft PowerPoint 2016 step by step. Step by step (Redmond, Wash.). ISBN 9780735697799.
- KLATOVSKÝ, Karel. Microsoft® PowerPoint® 2016 nejen pro školy. Prostějov: Computer Media, 2016. ISBN 978-80-7402-251-7.
- COX, Joyce a Joan LAMBERT. Microsoft PowerPoint 2010: step by step. Redmond, WA: Microsoft Press, 2010. ISBN 978-0-7356-2691-1.
- 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.
- Enrolment Statistics (Summer 2018, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/summer2018/B_AS