BA_AS Application Software

University of Finance and Administration
Summer 2017
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: Wed 8:45–9:29 E303PC, Wed 9:30–10:15 E303PC, J. Zumr
BA_AS/2MCPH: Wed 14:00–14:44 E303PC, Wed 14:45–15:30 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.
Literature
    recommended literature
  • • Cox,J.; Lamber, J; Frye, C. D.: Microsoft® Office Home & Student 2010. Step by Step. Microsoft, 2010.
  • http://office.microsoft.com
  • • 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. EVERYBODY HAS TO DELIVER HIS OWN WORK, BREAKING THIS RULE WILL RESULT IN NOT GETTING THE "z" GRADE.
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.
The course is also listed under the following terms Winter 2014, Summer 2015, Winter 2015, Summer 2016, Winter 2016, Winter 2017, Summer 2018, Winter 2018, Summer 2019, Winter 2019, Summer 2020, Winter 2020, Summer 2021, Winter 2021, Summer 2022, Winter 2022, Summer 2023, Winter 2023, Summer 2024.
  • Enrolment Statistics (Summer 2017, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2017/BA_AS