TE1MP_TAB Tables for advanced

Faculty of Education
Spring 2011
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á
Prerequisites (in Czech)
TE1MP_TPZ Electronic presentation && TE1MP_ATI AT-Internet and communication && TE1MP_ATT AT - Text and tables
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
At the end of this course the student will be able to: understand the advanced features of spreadsheet editors; independently handle tables and graphs with regard to teaching at the elementary school; prepare award for teaching spreadsheet programs at elementary schools;
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
Teaching methods
independent work by award
Assessment methods
Elaboration of seminary work. The work is preparation for teaching in the area covered by the subject and using the applications discussed.
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 2009, Spring 2010.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/ped/spring2011/TE1MP_TAB