BA_AS Application Software

University of Finance and Administration
Summer 2022
Extent and Intensity
0/2/0. 3 credit(s). Recommended Type of Completion: z (credit). Other types of completion: zk (examination).
Teacher(s)
PaedDr. Renata Majovská, PhD. (seminar tutor)
Guaranteed by
PaedDr. Renata Majovská, PhD.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková
Timetable of Seminar Groups
BA_AS/cMCPH: Wed 10:30–11:14 E303PC, Wed 11:15–12:00 E303PC, except Wed 27. 4. ; and Wed 27. 4. 10:30–12:00 ONLINE, R. Majovská
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
After completing the course, a student will be able to:
- orientate in the information system,
- use basic functions, formulas and graphs in MS Excel,
- analyze and interpret data, use pivot table,
- copy objects between MS Office applications,
- create presentations in MS PowerPoint.
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 - Data interpretation.
    7. MS Excel – Databases.
    8. MS Excel – Pivot tables.
    9. MS Excel - Large tables print.
    10. MS Office – Copying object between MS Office applications.
    11. MS PowerPoint – Creating a presentation.
    12. MS PowerPoint - Animation in MS PowerPoint.
Literature
    required literature
  • • Conner, N., Mc Donald, M.: Office 2010: The Missing Manual. Microsoft, 2011.
  • http://office.microsoft.com
    recommended literature
  • • Cox,J.; Lamber, J; Frye, C. D.: Microsoft® Office Home & Student 2010. Step by Step. Microsoft, 2010.
Teaching methods
Seminars in full-time study, tutorials in part-time study, compulsory seminar participation is 75 % in full-time study, compulsory tutorial participation is 50 % in part-time study.
Students with ISP have the same duties. Compulsory attendance is not required.The teacher verifies the authenticity of the submitted tasks.
Assessment methods
Full-time study: Students solve 11 tasks in seminars and submit them into IS VSFŠ for verification. Credit will be given for correctly solved tasks from seminars.
Part-time study: Students solve 11 tasks at home and submit them into IS VŠFS for verification. The teacher verifies the authenticity of the submitted tasks.
Students with ISP have the same duties. Compulsory attendance is not required. The teacher verifies the authenticity of the submitted tasks.
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, Summer 2020, Winter 2020, Summer 2021, Winter 2021, Winter 2022, Summer 2023, Winter 2023, Summer 2024.
  • Enrolment Statistics (Summer 2022, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2022/BA_AS