VSFS:B_AS_2 Application Software 2 - Course Information
B_AS_2 Application Software 2
University of Finance and AdministrationWinter 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.
- Enrolment Statistics (Winter 2012, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/winter2012/B_AS_2