VSFS:B_AS_2 Application Software 2 - Course Information
B_AS_2 Application Software 2
University of Finance and AdministrationSummer 2021
- Extent and Intensity
- 0/2/0. 3 credit(s). Type of Completion: z (credit).
- Teacher(s)
- 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_2/vAPH: Fri 26. 2. 14:00–15:30 S16PC, 15:45–17:15 S16PC, 17:30–19:00 S16PC, Fri 26. 3. 14:00–15:30 S16PC, 15:45–17:15 S16PC, 17:30–19:00 S16PC, V. Nulíček
- 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
- 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
- Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
- BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS
- Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
- 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.
- Assessment methods
- 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.
- Enrolment Statistics (Summer 2021, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/summer2021/B_AS_2