VSFS:BA_AS Application Software - Informace o předmětu

BA_AS Application Software

Rozsah

0/2/0. 12 hodin KS/semestr. 3 kr. Doporučované ukončení: z. Jiná možná ukončení: zk.

Vyučující

PaedDr. Renata Majovská, PhD. (cvičící)

Garance

PaedDr. Renata Majovská, PhD.
Katedra informatiky a matematiky (FES, KIM) – Katedry – Vysoká škola finanční a správní
Kontaktní osoba: Dita Egertová

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 Excel and PowerPoint 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 - Pivot tables.
  7. MS Excel – Data interpretation.
  8. MS Excel – Databases.
  9. MS Excel - Large tables printing.
  10. MS PowerPoint – Creating a presentation.
  11. MS PowerPoint – Animation in MS PowerPoint.
  12. MS PowerPoint - Copying object between MS Office applications.

Literatura

povinná literatura
• http://office.microsoft.com
• Kumar, Bittu. Mastering MS Office. V&S Publishers, 2017. ISBN 978-9350578780.

doporučená literatura
• Master, Harrison. Excel 2022. Independently published, 2022, ISBN-13 979-8442488708.
• Foulkes, L. Learn Microsoft Office 2021. Packt Publishing, 2021. ISBN 978-1803239736.
• Alexander, M., Kusleika, D. Microsoft Excel 365 Bible. Wiley, 2022. ISBN 978-1119835103.

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í

The course is completed with a credit.
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 and submit them into IS VŠFS for verification (they complete part of the tasks at home). 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í.

• Statistika zápisu (nejnovější)
  
• Permalink: https://is.vsfs.cz/predmet/vsfs/zima2024/BA_AS