VSFS:BA_AS Application Software - Course Information
BA_AS Application Software
University of Finance and AdministrationWinter 2014
- Extent and Intensity
- 0/2. 3 credit(s). Type of Completion: z (credit).
- Teacher(s)
- prof. Ing. Petr Berka, CSc. (seminar tutor)
- Guaranteed by
- prof. Ing. Petr Berka, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Tamara Urbánková - Timetable of Seminar Groups
- BA_AS/1BMPH: Mon 10:30–11:14 DELL ROOM E302PC, Mon 11:15–12:00 DELL ROOM E302PC, P. Berka
- 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. 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
- • 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.
- http://office.microsoft.com
- 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.
General note: b0.
Information on the extent and intensity of the course: 6 hodin KS/semestr.
- Enrolment Statistics (Winter 2014, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/winter2014/BA_AS