|
Lecturer(s)
|
-
Havlíček Libor, Ing. Ph.D.
-
Javůrek Milan, doc. Ing. CSc.
-
Škrabánek Pavel, Ing. Ph.D.
|
|
Course content
|
Word - the use and creation of styles, templates, outline. The meaning and use partitions. Indexing, content, using automated tools. Creating bookmarks, cross, hyperlinks. Mail merge. Creating and integrating of macros. Excel - database tasks with text data, creation and use of summaries, sorting, filtering. Contingency tables, merging and reports, sensitivity analysis, scenario. Solver. Creating database forms (locking cells, sheets, links between sheets, conditional formatting, data control). Calculations using Excel, evaluation of experimental data (basic statistics, nonlinear equations, solving systems of linear equations, matrices, regression analysis). Optimization calculations, linear programming. Superequations. Creation of test forms. Import and export data.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Demonstration, Projection, Skills training
|
|
Learning outcomes
|
To improve the application of the text editor so that the student was able to independently generate extensive technical documents (bachelor's, master's thesis) conform to the relevant standards and contain all relevant structures. To improve the application of the spreadsheet for processing and evaluation of experimental data using various kinds of tools offered by MS Excel.
Students will obtain knowledge and skills when working with a text editor, can effectively use, especially editing (warp, bookmarks, links, ...), proofreading and automatic options making some structures (contents, index, lists of images ...) when processing complex document type theses.
|
|
Prerequisites
|
Student must have good basic knowledge about text and tabular editors gained in previous studio.
|
|
Assessment methods and criteria
|
Oral examination, Home assignment evaluation
Participation in seminars and lectures is mandatory. Written verification of knowledge of the subject matter is a test in the 9th and 13 week of the semester. Reviews written tests must be at least 60% of the total. In the case of excused absence, the student will write alternative test. Minimum success of this test shall be 50%. In the case of non-compliance for credit must complete a written test with a minimum success rate of 50%.
|
|
Recommended literature
|
-
Brož, M. Microsoft Office Excel 2007, Podrobná uživatelská příručka, Computer Press, 408 stran.. Computer Press, 2007. ISBN 9788025118221.
-
KRÁL, M., MAGERA, I. PowerPoint 2007. Brno, Computer Press, 2007. ISBN 978-80-251-1619-7.
-
PECINOVSKÝ, J. Word 2007 Grada Publishing s.r.o.,123 stran. Praha: Grada Publishing.
-
Walkenbach, John. 222 tipů a triků pro Microsoft Office Excel 2007. Brno: Computer Press, 2008. ISBN 978-80-251-2206-8.
|