VSFS:BA_AS Application Software - Course Information
BA_AS Application Software
University of Finance and AdministrationWinter 2016
- Extent and Intensity
- 0/2/0. 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/1BMPH: Wed 8:45–9:29 DELL ROOM E302PC, Wed 9:30–10:15 DELL ROOM E302PC, P. Berka
BA_AS/2BMPH: Tue 14:00–14:44 E303PC, Tue 14:45–15:30 E303PC, J. Zumr - 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.
- 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. Midterm work.
7. MS Excel – Data interpretation.
8. MS Excel – Contingency tables.
9. MS Excel - Databases.
10. MS Office – Copying object between MS Office applications. 11. MS PowerPoint – Creating a presentation.
- 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 (Winter 2016, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/winter2016/BA_AS