BA_AS Application Software

Vysoká škola finanční a správní
zima 2021
Rozsah
0/2/0. 12 hodin KS/semestr. 3 kr. Doporučované ukončení: z. Jiná možná ukončení: zk.
Vyučující
Ing. Luboš Dobda, Ph.D. (cvičící)
Garance
PaedDr. Renata Majovská, PhD.
Katedra informatiky a matematiky (FES, KIM) – Katedry – Vysoká škola finanční a správní
Kontaktní osoba: Ivana Plačková
Rozvrh seminárních/paralelních skupin
BA_AS/cECPH: každé liché pondělí 17:30–18:14 E303PC, každé liché pondělí 18:15–19:00 E303PC, každé liché pondělí 19:15–19:59 E303PC, každé liché pondělí 20:00–20:45 E303PC, kromě Po 22. 11., kromě Po 6. 12. ; a St 15. 12. 10:30–12:00 S16PC, 12:15–13:45 S16PC, St 5. 1. 9:00–10:30 E303PC, 10:45–12:15 E303PC, L. Dobda
Předpoklady
Basic knowledge of MS Windows and Internet is assumed.
Omezení zápisu do předmětu
Předmět je otevřen studentům libovolného oboru.
Cíle předmětu
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.
Výstupy z učení
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.
Osnova
  • 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.
Literatura
    povinná literatura
  • http://office.microsoft.com
  • • Conner, N., Mc Donald, M.: Office 2010: The Missing Manual. Microsoft, 2011.
    doporučená literatura
  • • Cox,J.; Lamber, J; Frye, C. D.: Microsoft® Office Home & Student 2010. Step by Step. Microsoft, 2010.
Výukové metody
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.
Metody hodnocení
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.
Vyučovací jazyk
Angličtina
Další komentáře
Předmět je dovoleno ukončit i mimo zkouškové období.
Předmět je zařazen také v obdobích zima 2014, léto 2015, zima 2015, léto 2016, zima 2016, léto 2017, zima 2017, léto 2018, zima 2018, léto 2019, zima 2019, léto 2020, zima 2020, léto 2021, léto 2022, zima 2022, léto 2023, zima 2023, léto 2024, zima 2024.