B_AS_2 Application Software 2

University of Finance and Administration
Summer 2018
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: z (credit).
Guaranteed by
Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková
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)
Information on completion of the course: ISP
The course can also be completed outside the examination period.
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: 6 hodin KS/semestr.
The course is also listed under the following terms Summer 2008, Winter 2008, Summer 2009, Winter 2009, Summer 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Summer 2018, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2018/B_AS_2