VSFS:BA_AS Application Software - Course Information
BA_AS Application Software
University of Finance and AdministrationSummer 2016
- Extent and Intensity
- 0/2. 3 credit(s). Type of Completion: z (credit).
- Teacher(s)
- prof. Ing. Petr Berka, CSc. (seminar tutor)
Ing. Jiří Zumr (seminar tutor) - Guaranteed by
- prof. Ing. Petr Berka, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ing. Barbora Ptáčková - Timetable of Seminar Groups
- BA_AS/1MCPH: Tue 8:45–9:29 E303PC, Tue 9:30–10:15 E303PC, except Tue 9. 2. ; and Tue 23. 2. 14:00–15:30 E303PC, P. Berka
BA_AS/2MCPH: Tue 10:30–11:14 E303PC, Tue 11:15–12:00 E303PC, except Tue 9. 2. ; and Thu 18. 2. 8:45–10:15 E303PC, P. Berka - Prerequisites
- There are no prerequisites for this course.
- 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.
- 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 – Contingency tables.
7. MS Excel – Data interpretation.
8. MS Excel - Databases.
9. MS Excel – Printing large tables.
10. MS PowerPoint – Creating a presentation.
11. MS Office – Copying object between MS Office applications.
- 1. Principles of work in the computer classroom, in the local network of VSFS, working with the school’s information system
- Literature
- recommended literature
- http://office.microsoft.com
- • Cox,J.; Lamber, J; Frye, C. D.: Microsoft® Office Home & Student 2010. Step by Step. Microsoft, 2010.
- • Conner, N., Mc Donald, M.: Office 2010: The Missing Manual. Microsoft, 2011.
- Teaching methods
- The subject is delivered in full-time study by 12 seminars. Compulsory seminar participation is 75% in full-time study. An assignment will be done each class, the working files can be found in the Study Materials folder of the subject.
- Assessment methods
- Completion of assignments that are practiced each class. All the class assignments are put week by week in the Study Materials folder.
- 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: 6 hodin KS/semestr.
- Enrolment Statistics (Summer 2016, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/summer2016/BA_AS