B_AS_2 Application Software 2

University of Finance and Administration
Summer 2020
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Vladimír Nulíček, CSc. (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
B_AS_2/cAPH: Tue 15:45–16:29 S16PC, Tue 16:30–17:15 S16PC, V. Nulíček
Prerequisites
There are no prerequisites for this course.
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. To apply tools in MS Excel to create, edit and manage tables.
Learning outcomes
After completing the course, a student will be able to edit large documents in MS Word 2010, create a form, work with templates in MS Word 2010, enter data into tables, calculate using formulas in MS Excel 2010, format tables in MS Excel 2010, use analysis tools, create Pivot table in MS Excel 2010, work with mail merge in MS Word 2010.
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.
  • 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. 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
  • Pecinovský J., Pecinovský R.: Word 2010 – podrobný průvodce, Grada 2010
  • Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS 2011
  • BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. COMPUTER PRESS
Teaching methods
Full-time study - seminares. Required participation is 75 %. Students who do not attend mandatory number of seminars may be given by additional study requirements. Part-time: compulsory tutorial participation is 50 %, the possible absence can be compensate by personal consultation with a tutor.
Assessment methods
Full-time study: credit test, students edit MS Word document according to instructions and create and modify tables in MS Excel in credit test. Part-time study: students work out separately four POT’s and write the same credit 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.
Information on the extent and intensity of the course: 6 hodin KS/semestr.
Teacher's information
The course builds on the subject of Application Software 1. Assumed knowledge of techniques and tools work programs MS Word 2010 and MS PowerPoint 2010 at the level of the course curriculum.
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 2018, Summer 2019, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Summer 2020, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2020/B_AS_2