BA_AS Application Software

University of Finance and Administration
Summer 2020
Extent and Intensity
0/2/0. 3 credit(s). Recommended Type of Completion: z (credit). Other types of completion: zk (examination).
Teacher(s)
Ing. Luboš Dobda, Ph.D. (seminar tutor)
Guaranteed by
prof. Ing. Petr Berka, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková
Timetable of Seminar Groups
BA_AS/cMCPH: each even Wednesday 17:30–18:14 E303PC, each even Wednesday 18:15–19:00 E303PC, each even Wednesday 19:15–19:59 E303PC, each even Wednesday 20:00–20:45 E303PC, except Wed 18. 3., except ; and Wed 11. 3. 17:30–19:00 E303PC, 19:15–20:45 E303PC, L. Dobda
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.
Learning outcomes
Upon successful completion of this course, students will be able to: * to use functions in Excel * to use graphs in Excel * to use contingency tables in Excel * to use database operations in Excel * to create PowerPoint presentations
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
  • http://office.microsoft.com
  • • Conner, N., Mc Donald, M.: Office 2010: The Missing Manual. Microsoft, 2011.
  • • Cox,J.; Lamber, J; Frye, C. D.: Microsoft® Office Home & Student 2010. Step by Step. Microsoft, 2010.
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: 12 hodin KS/semestr.
The course is also listed under the following terms Winter 2014, Summer 2015, Winter 2015, Summer 2016, Winter 2016, Summer 2017, Winter 2017, Summer 2018, Winter 2018, Summer 2019, Winter 2019, Winter 2020, Summer 2021, Winter 2021, Summer 2022, Winter 2022, Summer 2023, Winter 2023, Summer 2024, Winter 2024.
  • Enrolment Statistics (Summer 2020, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2020/BA_AS