|
|
Podpora rozhodování s využitím tabulkového kalkulátoru
Michal, Tomáš
This thesis deals with decision theory and decision support systems. It examines particularly the criteria of supplier choice, methods of establishing the criteria weights and a scoring model as an effective way to perform multicriteria rating of suppliers. The thesis also deals with spreadsheet applications as one of the means for decision support realization. In the following chapter the design of a system for decision support for buying goods in small to middle sized companies using the spreadsheet application is discussed and an example of the system usage is shown. The last chapter summarizes the results achieved and evaluation of real-world usage of the designed system is made.
|
|
|
MS Excel spreadsheet in mathematics education at primary schools
SVOBODOVÁ, Denisa
The aim of the thesis is to create a set of examples from mathematics using MS Excel spreadsheet, which could be used for teaching mathematics in primary schools. Pupils practice their work from this spreadsheet calculator and also enrich their knowledge of mathematics for its practical use. This set will be used to practice graphs, functions, financial mathematics, patterns, probability, and another. All these examples will be tested in educational practice.
|
|
|
Educational materials - gathering and processing data in a spreadsheet
FARKA, František
The aim of my thesis is to create a teaching material which will introduce the secondary school students to the issue of getting and processing information and data, as well as their consequent practical usage. My thesis has the form of an analysis of the subject matter, includes a suggestion and possible application of the teaching material with the focus on maximum usage of pupil?s individual work, research methods and project teaching. This teaching material will be aimed at pupils between 12 and 16 years of age and it can be used during optional lessons or in various IT hobby clubs for teenagers.
|
|
|
Task automation in spreadsheet program with the assistance of VBA
MACHÁČEK, Jan
My thesis primarily deals with a part of spreadsheet program - their macro language - Visual Basic for Application {--} VBA. The work describes the structure, features and characteristics of the language. It also brings a procedure enabeling to create macro without the knowledge of programming, as well as the procedure how to create one´s own functions and procedures or their part. The work also includes a source code of my own application that is used in practice. At present there are more instruments on the market, not just one. However, all my thesis (except the final evaluation) concentrates on one particular variation of this particular spreadsheet program {--} Excel, which is a part of Microsoft Office Professional Version 2002 (XP). The reason I chose this product simply comes from the fact that it is my daily work tool in my job. In the final part of my thesis I compare the chosen software with another alternative software.
|
guest ::
