BA_AS Application Software

University of Finance and Administration
Winter 2017
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: Ivana Plačková
Timetable of Seminar Groups
BA_AS/1BMPH: Mon 10:30–11:14 E307, Mon 11:15–12:00 E307, P. Berka
BA_AS/1MCPH: Thu 12:15–12:59 E307, Thu 13:00–13:45 E307, J. Zumr
BA_AS/2BMPH: Thu 8:45–9:29 E307, Thu 9:30–10:15 E307, J. Zumr
BA_AS/2MCPH: each even Friday 8:45–9:29 E307, each even Friday 9:30–10:15 E307, each even Friday 10:30–11:14 E307, each even Friday 11:15–12:00 E307, 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.
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. 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.
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. 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, Summer 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 (Winter 2017, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/winter2017/BA_AS