B_AS Application Software

University of Finance and Administration
Summer 2024
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: z (credit).
Teacher(s)
PaedDr. Renata Majovská, PhD. (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Ing. Václav Řezníček, Ph.D. (seminar tutor)
RNDr. Petr Tesař, Ph.D. (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/cMMO: each odd Monday 10:30–11:14 M11PC, each odd Monday 11:15–12:00 M11PC, each odd Monday 12:15–12:59 M11PC, each odd Monday 13:00–13:45 M11PC, V. Nulíček
B_AS/c1BSMO: each odd Tuesday 10:30–11:14 M11PC, each odd Tuesday 11:15–12:00 M11PC, each odd Tuesday 12:15–12:59 M11PC, each odd Tuesday 13:00–13:45 M11PC, V. Nulíček
B_AS/c1BSPH: 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, R. Majovská
B_AS/c1KKV: each odd Monday 10:30–11:14 KV305PC, each odd Monday 11:15–12:00 KV305PC, each odd Monday 12:15–12:59 KV305PC, each odd Monday 13:00–13:45 KV305PC, P. Tesař
B_AS/c1MPH: each even Tuesday 15:45–16:29 E303PC, each even Tuesday 16:30–17:15 E303PC, each even Tuesday 17:30–18:14 E303PC, each even Tuesday 18:15–19:00 E303PC, V. Nulíček
B_AS/c2BSMO: each odd Tuesday 14:00–14:44 M11PC, each odd Tuesday 14:45–15:30 M11PC, each odd Tuesday 15:45–16:29 M11PC, each odd Tuesday 16:30–17:15 M11PC, V. Nulíček
B_AS/c2BSPH: each even Thursday 14:00–14:44 S16PC, each even Thursday 14:45–15:30 S16PC, each even Thursday 15:45–16:29 S16PC, each even Thursday 16:30–17:15 S16PC, R. Majovská
B_AS/c2KKV: each odd Monday 14:00–14:44 KV305PC, each odd Monday 14:45–15:30 KV305PC, each odd Monday 15:45–16:29 KV305PC, each odd Monday 16:30–17:15 KV305PC, P. Tesař
B_AS/c2MPH: each odd Tuesday 8:45–9:29 E303PC, each odd Tuesday 9:30–10:15 E303PC, each odd Tuesday 10:30–11:14 E303PC, each odd Tuesday 11:15–12:00 E303PC, P. Tesař
B_AS/c3MPH: Wed 14:00–14:44 E303PC, Wed 14:45–15:30 E303PC, R. Majovská
B_AS/vBSKPH: Sat 24. 2. 9:45–11:15 E004, 11:30–13:00 E004, Sat 9. 3. 9:45–11:15 E004, 11:30–13:00 E004, Sat 13. 4. 9:45–11:15 E004, 11:30–13:00 E004, V. Řezníček
B_AS/vBSMO: Sat 3. 2. 11:30–13:00 M11PC, 14:00–15:30 M11PC, Sat 17. 2. 9:45–11:15 M11PC, 11:30–13:00 M11PC, Sat 6. 4. 9:45–11:15 M11PC, 11:30–13:00 M11PC, V. Nulíček
B_AS/vKKV: Fri 22. 3. 14:00–15:30 KV305PC, 15:45–17:15 KV305PC, Fri 12. 4. 14:00–15:30 KV305PC, 15:45–17:15 KV305PC, Sat 27. 4. 14:00–15:30 KV305PC, 15:45–17:15 KV305PC, P. Tesař
B_AS/1KPH: 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, R. Majovská
B_AS/2KPH: each odd Thursday 14:00–14:44 S16PC, each odd Thursday 14:45–15:30 S16PC, each odd Thursday 15:45–16:29 S16PC, each odd Thursday 16:30–17:15 S16PC, R. Majovská
B_AS/3KPH: each odd Tuesday 14:00–14:44 S16PC, each odd Tuesday 14:45–15:30 S16PC, each odd Tuesday 15:45–16:29 S16PC, each odd Tuesday 16:30–17:15 S16PC, P. Tesař
B_AS/4KPH: each odd Wednesday 14:00–14:44 S16PC, each odd Wednesday 14:45–15:30 S16PC, each odd Wednesday 15:45–16:29 S16PC, each odd Wednesday 16:30–17:15 S16PC, P. Tesař
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. Principles of work in the computer classroom, in the local network of VSFS, working with the school’s information system
    2. MS Excel – Common uses of Excel, data formats, simple formulas.
    3. MS Excel - Functions I (mathematical, statistical).
    4. MS Excel – Functions II (financial, search).
    5. MS Excel – Graphs.
    6. MS Excel - Pivot tables.
    7. MS Excel – Data interpretation.
    8. MS Excel – Databases.
    9. MS Excel - Printing of large tables.
    10. MS PowerPoint – Creating a presentation.
    11. MS PowerPoint - Animation in MS PowerPoint.
    12. MS Office – Copying objects between MS Office applications.
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
  • NAVARRŮ, Miroslav. Excel 2019: podrobný průvodce uživatele. Praha: Grada Publishing, 2019. Průvodce. ISBN 978-80-247-2026-5.
    recommended literature
  • 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.
  • KLATOVSKÝ, Karel. Microsoft® PowerPoint® 2016 nejen pro školy. Prostějov: Computer Media, 2016. ISBN 978-80-7402-251-7.
  • PECINOVSKÝ, Josef. Microsoft Office 2013: podrobná uživatelská příručka. Brno: Computer Press, 2013. ISBN 978-80-251-4102-1.
  • LAMBERT, Joan. Microsoft PowerPoint 2016 step by step. Step by step (Redmond, Wash.). ISBN 9780735697799.
  • KOPECKÝ, Ladislav. Prezentace v marketingové komunikaci. Praha: Grada, 2010. ISBN 978-80-247-3123-0.
  • PECINOVSKÝ, Josef a Rudolf PECINOVSKÝ. Office 2016: průvodce uživatele. Praha: Grada, 2016. Průvodce (Grada). ISBN 978-80-247-5691-2.
  • LAMBERT, Joan a Curtis FRYE. Microsoft Office 2016 step by step. Step by step (Redmond, Wash.). ISBN 0735699232.
  • 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.
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. Compulsory attendance is not required.The teacher verifies the authenticity of the submitted tasks.
Assessment methods
The course is completed with a credit.
Full-time study: Students solve 11 tasks in seminars and submit them into IS VSFŠ for verification. Assignments, including help to solve them, are in IS. Credit will be given for correctly solved tasks from seminars.
Part-time study: Students solve 11 tasks and submit them into IS VŠFS for verification (they complete part of the tasks at home). The teacher verifies the authenticity of the submitted tasks.
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, Winter 2018, Summer 2019, Winter 2019, Summer 2020, Winter 2020, Summer 2021, Winter 2021, Summer 2022, Winter 2022, Summer 2023, Winter 2023, Winter 2024.
  • Enrolment Statistics (Summer 2024, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2024/B_AS