VSFS:BA_AS Application Software - Course Information
BA_AS Application Software
University of Finance and AdministrationSummer 2022
- Extent and Intensity
- 0/2/0. 3 credit(s). Recommended Type of Completion: z (credit). Other types of completion: zk (examination).
- Teacher(s)
- PaedDr. Renata Majovská, PhD. (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
- BA_AS/cMCPH: Wed 10:30–11:14 E303PC, Wed 11:15–12:00 E303PC, except Wed 27. 4. ; and Wed 27. 4. 10:30–12:00 ONLINE, R. Majovská
- Prerequisites
- Basic knowledge of MS Windows and Internet is assumed.
- Course Enrolment Limitations
- The course is offered to students of any study field.
- Course objectives
- The objective of the course is to enhance students’ knowledge of MS Excell and PowerPoint 2010 by using practical examples. After completing the course students will be able to use these applications on a more advanced user level.
- 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 - Data interpretation.
7. MS Excel – Databases.
8. MS Excel – Pivot tables.
9. MS Excel - Large tables print.
10. MS Office – Copying object between MS Office applications.
11. MS PowerPoint – Creating a presentation.
12. MS PowerPoint - Animation in MS PowerPoint.
- 1. Principles of work in the computer classroom, in the local network of VSFS, working with the school’s information system
- Literature
- required literature
- • Conner, N., Mc Donald, M.: Office 2010: The Missing Manual. Microsoft, 2011.
- http://office.microsoft.com
- recommended literature
- • Cox,J.; Lamber, J; Frye, C. D.: Microsoft® Office Home & Student 2010. Step by Step. Microsoft, 2010.
- 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
- 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. The teacher verifies the authenticity of the submitted tasks.
Students with ISP have the same duties. Compulsory attendance is not required. The teacher verifies the authenticity of the submitted tasks. - Language of instruction
- English
- 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 2022, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/summer2022/BA_AS