B_AS_2 Application Software 2

University of Finance and Administration
Winter 2012
Extent and Intensity
0/2. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Guaranteed by
Mgr. Anna Nováková
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Dagmar Medová, DiS.
Timetable of Seminar Groups
B_AS_2/1: No timetable has been entered into IS.
B_AS_2/2: No timetable has been entered into IS.
Prerequisites
Application Software 1
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
The objective of the course is to enhance students’ knowledge in basic application software with a focus on the software included in the MS Office 2010 suite. This primarily includes more advanced working techniques in MS Excel 2010 and 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 (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.
Teaching methods
full-time study mode: managed seminares combined form: distance study mode
Assessment methods
Course completion: credit test
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.
General note: 0.
Information on the extent and intensity of the course: 6 hodin/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, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Winter 2012, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/winter2012/B_AS_2