B_AS Application Software 2

University of Finance and Administration
Winter 2013
Extent and Intensity
1/1. 3 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Hana Hoffmannová (seminar tutor)
Mgr. Miroslav Kučera (seminar tutor)
doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
Mgr. Anna Nováková (seminar tutor)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Guaranteed by
Ing. Hana Hoffmannová
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Dagmar Medová, DiS.
Prerequisites
The course builds on the subject of Application Software 1 of winter semester 1st year. Assumed knowledge of techniques and tools work programs MS Word 2010 and MS PowerPoint 2010 at the level of the course curriculum.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
At the end of the course students should be able to:
- apply advanced tools used in MS Word to manage long documents, the teamwork and protecting documents.
- apply tools in MS Excel to create, edit and manage tables.
Syllabus
  • 1. MS Word – editing large documents - dividing the document into sections (varied page setups, varied headers and footers)
  • 2. MS Word – creating a form, inserting various types of form fields, document protection.
  • 3. MS Word – working with templates, downloading a template from the MS Office website, creating a custom template. Document revision, sharing documents with other users, addition of comments, document comparison
  • 4. MS Excel – entering any data into tables, calculations using formulas, numeric formats, more complex calculations in tables using various types of references
  • 5. MS Excel - formal editing tables (manual formatting or use Gallery), work sheets (insert, delete, rename, copy), work with rows and columns (insert, delete).
  • 6. MS Excel – application of more complex functions (financial, text, etc.), nesting functions within functions.
  • 7. MS Excel – conditional formatting. More complex chart editing (secondary axis, adding data, data direction change,...). Modifications and
  • 8. MS Excel - working with worksheets. Calculations with references to other worksheets or workbooks. Printing of larger tables, header and footer, repeating a table heading on subsequent pages, print area, size adjustment before printing.
  • 9. MS Excel – analysis tools (Goal Seek), databases – sorting, filtering, subtotals
  • 10. MS Excel – databases - PivotTable
  • 11. MS Word – mail merge
  • 12. Credit exercise – practical exercise in MS Word and MS Excel.
Literature
    required literature
  • NOVÁKOVÁ, Anna and Vladimír NULÍČEK. Aplikační software 2 (MS Office 2010). Praha: Vysoká škola finanční a správní, o.p.s., 2012, 128 pp. ISBN 978-80-7408-064-7. info
  • HOFFMANNOVÁ, Hana. Sbírka řešených příkladů pro aplikační software. Praha: Vysoká škola finanční a správní, o.p.s., 2012, 62 pp. ISBN 978-80-7408-066-1. info
    recommended literature
  • BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS
  • Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
  • Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
Teaching methods
full-time study - managed seminares. Required participation - 75%. At the end of the semester students who do not attend mandatory number of seminars may be given additional study requirements that will demonstrate academic achievement and acquired competencies necessary for successful completion of the course. Combined Studies - distance forma. Students have compulsory one directed group consultation. The possible absence can be compensate by personal consultation with a tutor.
Assessment methods
Course completion: Full-time studies: credit. Students smart up MS Word document according to instructions and create and modify tables in MS Excel. Combined studies: students work out separately four POT’s, and the same full time final test as full-time students. The results of students must demonstrate sufficient knowledge of the tools of both programs
Language of instruction
Czech
Further comments (probably available only in Czech)
Note related to how often the course is taught: Kombinace 2 hod. prezenční a 10 hod. distanční výuky.
General note: Aa0.
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, Summer 2022, Winter 2022, Summer 2023, Winter 2023, Summer 2024.
  • Enrolment Statistics (Winter 2013, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/winter2013/B_AS