VSFS:B_AS Application Software - Course Information
B_AS Application Software
University of Finance and AdministrationWinter 2020
- Extent and Intensity
- 0/2/0. 3 credit(s). Type of Completion: z (credit).
- Teacher(s)
- Ing. Renata Janošcová, Ph.D. (seminar tutor)
doc. Ing. Stanislava Mildeová, CSc. (seminar tutor)
Ing. Vladimír Nulíček, CSc. (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/vEKFPH: Sat 24. 10. 9:45–11:15 E230, 11:30–13:00 E230, Sat 7. 11. 9:45–11:15 E230, 11:30–13:00 E230, Fri 11. 12. 17:30–19:00 E230, 19:15–20:45 E230, V. Nulíček
B_AS/1EKKV: each odd Wednesday 10:30–11:14 KV206, each odd Wednesday 11:15–12:00 KV206, each odd Wednesday 12:15–12:59 KV206, each odd Wednesday 13:00–13:45 KV206, V. Nulíček
B_AS/1EKPH: each odd Thursday 14:00–14:44 E303PC, each odd Thursday 14:45–15:30 E303PC, each odd Thursday 15:45–16:29 E303PC, each odd Thursday 16:30–17:15 E303PC, R. Janošcová
B_AS/1FPH: Thu 12:15–12:59 E303PC, Thu 13:00–13:45 E303PC, R. Janošcová
B_AS/1PPKV: each even Wednesday 10:30–11:14 KV211, each even Wednesday 11:15–12:00 KV211, each even Wednesday 12:15–12:59 KV211, each even Wednesday 13:00–13:45 KV211, V. Nulíček
B_AS/1PPPH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, V. Nulíček
B_AS/2EKPH: each even Thursday 14:00–14:44 E303PC, each even Thursday 14:45–15:30 E303PC, each even Thursday 15:45–16:29 E303PC, each even Thursday 16:30–17:15 E303PC, R. Janošcová - 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 (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. Objects in MS PowerPoint.
- 11. Animation in MS PowerPoint.
- 12. Object copying between MS Office apps.
- 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
- 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. 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.
- 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.
- KLATOVSKÝ, Karel. Microsoft® PowerPoint® 2016 nejen pro školy. Prostějov: Computer Media, 2016. ISBN 978-80-7402-251-7.
- LAMBERT, Joan. Microsoft PowerPoint 2016 step by step. Step by step (Redmond, Wash.). ISBN 9780735697799.
- PECINOVSKÝ, Josef. Microsoft Office 2013: podrobná uživatelská příručka. Brno: Computer Press, 2013. ISBN 978-80-251-4102-1.
- 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.
- KOPECKÝ, Ladislav. Prezentace v marketingové komunikaci. Praha: Grada, 2010. ISBN 978-80-247-3123-0.
- NAVARRŮ, Miroslav. Excel 2016: podrobný průvodce uživatele. Praha: Grada, 2016. Průvodce (Grada). ISBN 978-80-271-0193-1.
- LAMBERT, Joan a Curtis FRYE. Microsoft Office 2016 step by step. Step by step (Redmond, Wash.). ISBN 0735699232.
- Teaching methods
- Seminars in full-time study, tutorials in part-time study, compulsory seminar participation is 75 % in full-time study, compulsory tutorial participation is 50 % in part-time study. Students with ISP have the same duties, however they need not to keep the required attendance.
- Assessment methods
- Credit: Full-time study: Students solve 11 tasks in seminars and submit them into IS VSFŠ for verification. Credit will be given for correctly solved tasks from seminars. Part-time study: Students solve 11 tasks at home and submit them into IS VŠFS for verification. Oral credit: basic knowledge is verified, a student must reach at least 75 % of max. points to confirm basic knowlwdge.
- 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 (Winter 2020, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/winter2020/B_AS