B_AS_2 Application Software 2

University of Finance and Administration
Summer 2024
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: z (credit).
Guaranteed by
PaedDr. Renata Majovská, PhD.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková
Prerequisites
There are no prerequisites for this course.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
The student will be able to use advanced tools of MS PowerPoint, including template of slides, animations, sounds. Use macros, analysis tools and the Solver module in MS Excel when creating, editing and managing tables. They will get acquainted with MS Access.
Learning outcomes
After completing the course, the student will be able to:
Create a PowerPoint presentation, including animations and sound.
Insert data and perform calculations using MS Excel functions, format tables in MS Excel, use analytical tools.
Work with MS Access.
Syllabus
  • 1. MS PowerPoint - Working with a template, presentation template.
  • 2. MS PowerPoint - Animation settings, audio and video insertion.
  • 3. MS PowerPoint - Setting transitions between slides, automatic playback of the presentation.
  • 4. MS PowerPoint - Creating a complex presentation.
  • 5. MS Excel - Forms.
  • 6. MS Excel - Simple macros, macro recording.
  • 7. Basics of Visual Basic - Editing a recorded macro.
  • 8. MS Excel - Analytical tools, solution search, scenario manager.
  • 9. MS Excel - Solver.
  • 10. MS Access - Loading external data into DB, editing DB.
  • 11. MS Access - Working with views, creating simple filters.
  • 12. MS Access - Creating a form for entering data, creating a print report.
Literature
    required literature
  • Navarrů, M. Excel 2019: Podrobný průvodce uživatele. Grada, 2019. ISBN 978-80-247-2026-5.
  • 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
  • Foulkes, L. Learn Microsoft Office 2021. Packt Publishing, 2021. ISBN 978-1803239736.
    not specified
  • Master, H. Excel 2022. Independently published, 2022, ISBN-13 979-8442488708.
  • Alexander, M., Kusleika, D. Microsoft Excel 365 Bible. Wiley, 2022. ISBN 978-1119835103.
Teaching methods
Full-time study. Required participation is 75 %. Students who do not attend mandatory number of seminars may be given by additional study requirements.
Part-time study: compulsory tutorial participation is 50 %, the possible absence can be compensate by personal consultation.
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: Credit awarded after submission of all assignments processed in seminars, in case of absence or online teaching, missing assignments will be processed at home. Part-time study: Credit awarded after submission of all assignments processed in seminars, in case of absence or online teaching, missing assignments will be processed at home.
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 Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2025.
  • Enrolment Statistics (Summer 2024, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2024/B_AS_2