TE1MP_TAB Tables for advanced

Faculty of Education
Spring 2009
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Martin Dosedla, Ph.D. (seminar tutor)
Guaranteed by
Ing. Martin Dosedla, Ph.D.
Department of Technical Education and Information Science – Faculty of Education
Contact Person: Ing. Gabriela Štěpánová
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 14 student(s).
Current registration and enrolment status: enrolled: 0/14, only registered: 0/14, only registered with preference (fields directly associated with the programme): 0/14
fields of study / plans the course is directly associated with
Course objectives
The aim of the course is to acquire advanced knowledge and skills related to the work   tables and graphs. Content is the introduction to the table   editors, the expanded functions, conditional formatting, other integrated functions table editors, including connections and export to other formats.   Work with charts.
Syllabus
  • 1st Basic operations   cells. (The types of cells, and cells for movement of data entry, graphic design cells ...)
  • 2nd Format Cells. (Text, financial, time, number, etc. format cells, parameters ...)
  • 3rd Formula. (Rules governing the work of the formula, parentheses, operators, mathematical registration, definitions ...)
  • 4th Features (1). (Basic functions SUM, AVERAGE, MIN, MAX, today, the argument functions, the selection of cells ...)
  • 5th Features (2) (More complex functions, IF condition, folding / combination / formulas and functions, change ...)
  • 6th Charts. (Creation of the chart, the definition and treatment of individual items chart, rename the series, color ...)
  • 7th Absolute and relative address of the cell. (Absolute and relative addressing, change of address cells, naming cells, the importance of ...)
  • 8th Conditional Formatting. (Setting conditions for the conditional formatting, the importance and practical use, formát ...)
  • 9th Working with   sheets. (Inserting, lubrication and moving sheets in the   one or more plates, renaming ...)
  • 10th Filters. (Working with   filters, the importance and use, automatic filter, the definition of choice, settings ...)
  • 11th The definition of a series. (Pre-series, a series of self-definition, filling loop, meaning, function and use ...)
  • 12th Finishing tables and graphs. (Adjustment of the chart and table., The print settings, the location of the chart, links to other documents   ...)
Literature
  • MACDONALD, Matthew. Excel 2007 : chybějící manuál. 1. vyd. Praha: Grada, 2008, 826 s. ISBN 9788024721958. info
  • SCHELS, Ignatz. Excel 2007 : vzorce a funkce. 1. vyd. Praha: Grada, 2008, 507 s. ISBN 9788024720746. info
  • DODGE, Mark. Mistrovství v Microsoft Office Excel 2007. Vyd. 1. Brno: Computer Press, 2008, 936 s. ISBN 9788025119808. info
  • BŘÍZA, Vladimír. Excel 2007 : podrobný průvodce. 1. vyd. Praha: Grada, 2007, 232 s. ISBN 9788024719658. URL info
  • MATĚJŮ, Petr. Microsoft Office Excel 2007 : rychle hotovo! Vyd. 1. Brno: Computer Press, 2007, 209 s. ISBN 9788025115725. info
Assessment methods
lectures, homeworks, final projects
Language of instruction
Czech
Further comments (probably available only in Czech)
Note related to how often the course is taught: výuka probíhá konzultačně.
Teacher's information
http://www.ped.muni.cz/wtech/index.php?pg=03_studium&sec=nssp
The course is also listed under the following terms Spring 2007, Spring 2008, Spring 2010, Spring 2011.
  • Enrolment Statistics (Spring 2009, recent)
  • Permalink: https://is.muni.cz/course/ped/spring2009/TE1MP_TAB